Thanks Shirly,
unfortunately Microsoft sent your reply to my Junk Email
folder so I have only noticed it today.
Is there any instructions on how to run the script? I can't find any tables or
views with the vm_interface_daily_history, etc columns.
I'm not a database expert.
Regards,
Paul S.
________________________________
From: Shirly Radco <[email protected]>
Sent: 05 June 2018 14:52
To: Staniforth, Paul
Cc: [email protected]
Subject: Re: [ovirt-users] oVirt 4.1 ETL service sampling has encounterd an
error
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://www.redhat.com/files/brand/email/sig-redhat.png]<https://red.ht/sig>
TRIED. TESTED. TRUSTED.<https://redhat.com/trusted>
On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul
<[email protected]<mailto:[email protected]>> 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 -- [email protected]<mailto:[email protected]>
To unsubscribe send an email to
[email protected]<mailto:[email protected]>
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/[email protected]/message/C6MLPVLJDKQ7AQLSPJ7Q3QVDAAFDZWUA/
To view the terms under which this email is distributed, please go to:-
http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
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/[email protected]/message/VB36WDHZRYFLPDS4JJVJITXYCDLVG5UF/
