[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

Sorry was looking at the engine database, rather than ovirt_engine_history database. When running SELECT fn_db_change_column_type('vm_interface_daily_history', 'history_id', 'integer', 'bigint'); I get ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view v4_1_statistics_vms_ interfaces_resources_usage_daily depends on column "history_id" CONTEXT: SQL statement "ALTER TABLE vm_interface_daily_history ALTER COLUMN history_id TYPE bigint" PL/pgSQL function fn_db_change_column_type(character varying,character varying,character varying,character varying) line 9 at EXECUTE statement Thanks, Paul S. ------------------------------ *From:* Staniforth, Paul *Sent:* 06 June 2018 09:57 *To:* Shirly Radco *Cc:* users(a)ovirt.org *Subject:* Re: [ovirt-users] oVirt 4.1 ETL service sampling has encounterd an error 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 <sradco(a)redhat.com&gt; *Sent:* 05 June 2018 14:52 *To:* Staniforth, Paul *Cc:* users(a)ovirt.org *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://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul < P.Staniforth(a)leedsbeckett.ac.uk&gt; 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.SampleTimeKeepingJ > ob.tRunJob_1Process(SampleTimeKeepingJob.java:6067) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ > ob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5809) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ > ob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4444) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ > ob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4319) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ > ob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4188) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ > ob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3593) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ > ob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2977) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ > ob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2295) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ > ob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1649) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ > ob$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_versio > n,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(a)ovirt.org > To unsubscribe send an email to users-leave(a)ovirt.org > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ > oVirt Code of Conduct: https://www.ovirt.org/communit > y/about/community-guidelines/ > List Archives: https://lists.ovirt.org/archiv > es/list/users(a)ovirt.org/message/C6MLPVLJDKQ7AQLSPJ7Q3QVDAAFDZWUA/ > > To view the terms under which this email is distributed, please go to:- http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html