Hi, This was fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1541924 in version 4.2.2.
I believe you can update manually the history_id field in tables - vm_interface_daily_history, vm_interface_hourly_history, vm_interface_samples_history from integer to bigint and it should fix the issue, but I did not test on 4.1. like in: https://gerrit.ovirt.org/#/c/87139/4/packaging/dbscripts/upgrade/04_02_0020__updated_vm_interface_history_id_to_bigint.sql Best, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul < p.stanifo...@leedsbeckett.ac.uk> wrote: > Hello, > > > our oVirt 4.1 system has had a DWH error since around 4am this morning, > > > It comes up with the error > > > ETL service sampling has encountered an error. Please consult the service > log for more details > > > in the ovirt-engine-dwh.log > > > 2018-06-05 > 12:00:18|QXiOTi|gAp8Q4|Cz1F21|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java > Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1 > Exception in component tRunJob_1 > java.lang.RuntimeException: Child job running failed > at ovirt_engine_dwh.sampletimekeepingjob_4_1. > SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:6067) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCInput_2Process(SampleTimeKeepingJob.java:5809) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCConnection_1Process(SampleTimeKeepingJob.java:4444) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCConnection_2Process(SampleTimeKeepingJob.java:4319) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tRowGenerator_2Process(SampleTimeKeepingJob.java:4188) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCInput_3Process(SampleTimeKeepingJob.java:3593) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCInput_5Process(SampleTimeKeepingJob.java:2977) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCInput_4Process(SampleTimeKeepingJob.java:2295) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCConnection_3Process(SampleTimeKeepingJob.java:1649) > at ovirt_engine_dwh.sampletimekeepingjob_4_1. > SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:11363) > > > and in the postgres log there is > > > ERROR: integer out of range > STATEMENT: INSERT INTO vm_interface_samples_history (history_datetime,vm_ > interface_id,receive_rate_percent,transmit_rate_percent, > vm_interface_configuration_version,received_total_byte,transmitted_total_byte) > VALUES ($1,$2,$3,$4,$5,$6,$7) > ERROR: current transaction is aborted, commands ignored until end of > transaction block > > > Thanks, > > Paul S. > To view the terms under which this email is distributed, please go to:- > http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html > > > _______________________________________________ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ > oVirt Code of Conduct: https://www.ovirt.org/community/about/community- > guidelines/ > List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/ > message/C6MLPVLJDKQ7AQLSPJ7Q3QVDAAFDZWUA/ > >
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/RJDTXECMC6NWYMK7LWGL3CV4T2QGKKDU/
