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_... 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.Staniforth@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-leave@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/