Hi Shirly, Thanks for the answer. El 2019-06-06 16:22, Shirly Radco escribió: https://bugzilla.redhat.com/show_bug.cgi?id=1718165 Feel free to change anything that is not correctly set. Not that I know, this started all of sudden. Thanks. > Best regards, > > -- > > Shirly Radco > > BI Senior Software Engineer > > Red Hat [5] > > [5] > > On Thu, Jun 6, 2019 at 3:44 PM <nicolas(a)devels.es&gt; wrote: > >> Hi, >> >> We're running oVirt 4.1.9 (cannot upgrade yet until [1] is >> released). >> Since a few days ago our event list if full of lines like this: >> >>    ETL service sampling has encountered an error. Please consult >> the >> service log for more details. >> >> Having a look at the log I see events like: >> >> 2019-06-06 >> > 13:37:11|NJ4C8T|TOlL8U|FdlWtU|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java >> >> Exception|tJDBCOutput_7|org.postgresql.util.PSQLException:ERROR: >> current >> transaction is aborted, commands ignored until end of transaction >> block|1 >> 2019-06-06 >> > 13:37:11|NJ4C8T|TOlL8U|FdlWtU|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java >> >> Exception|tJDBCOutput_4|org.postgresql.util.PSQLException:ERROR: >> current >> transaction is aborted, commands ignored until end of transaction >> block|1 >> Exception in component tJDBCOutput_5 >> org.postgresql.util.PSQLException: ERROR: current transaction is >> aborted, commands ignored until end of transaction block >>          at >> > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) >>          at >> > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) >>          at >> > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) >>          at >> > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) >>          at >> > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) >>          at >> > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) >>          at >> > ovirt_engine_dwh.statisticssync_4_1.StatisticsSync.tJDBCInput_10Process(StatisticsSync.java:9030) >>          at >> > ovirt_engine_dwh.statisticssync_4_1.StatisticsSync$5.run(StatisticsSync.java:16071) >> 2019-06-06 >> > 13:37:11|NJ4C8T|TOlL8U|FdlWtU|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java >> >> Exception|tJDBCOutput_5|org.postgresql.util.PSQLException:ERROR: >> current >> transaction is aborted, commands ignored until end of transaction >> block|1 >> Exception in component tRunJob_5 >> java.lang.RuntimeException: Child job running failed >>          at >> > ovirt_engine_dwh.samplerunjobs_4_1.SampleRunJobs.tRunJob_5Process(SampleRunJobs.java:1654) >>          at >> > ovirt_engine_dwh.samplerunjobs_4_1.SampleRunJobs.tRunJob_6Process(SampleRunJobs.java:1456) >>          at >> > ovirt_engine_dwh.samplerunjobs_4_1.SampleRunJobs.tRunJob_1Process(SampleRunJobs.java:1228) >>          at >> > ovirt_engine_dwh.samplerunjobs_4_1.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:1000) >>          at >> > ovirt_engine_dwh.samplerunjobs_4_1.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:767) >>          at >> > ovirt_engine_dwh.samplerunjobs_4_1.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:642) >>          at >> > ovirt_engine_dwh.samplerunjobs_4_1.SampleRunJobs$2.run(SampleRunJobs.java:2683) >> 2019-06-06 >> > 13:37:11|FdlWtU|TOlL8U|KNLNa4|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) >> >> Can someone tell me how to fix it? I already restarted >> ovirt-engine, >> ovirt-engine-dwhd, postgresql and the three at a time and still >> didn't >> fix the issue. Currently the DWHD data is empty in the Dashboard. >> >> Thanks! >> >>    [1]: https://github.com/oVirt/ovirt-web-ui/issues/490 [1] >> _______________________________________________ >> 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/ [2] >> oVirt Code of Conduct: >> https://www.ovirt.org/community/about/community-guidelines/ [3] >> List Archives: >> > https://lists.ovirt.org/archives/list/users@ovirt.org/message/PXMHT5K6ZBF... >> [4] > > > Links: > ------ > [1] https://github.com/oVirt/ovirt-web-ui/issues/490 > [2] https://www.ovirt.org/site/privacy-policy/ > [3] https://www.ovirt.org/community/about/community-guidelines/ > [4] > https://lists.ovirt.org/archives/list/users@ovirt.org/message/PXMHT5K6ZBF... > [5] https://www.redhat.com/