Bug 1433101
| Summary: | Can not sample data, oVirt Engine is not updating the statistics | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Koutuk Shukla <kshukla> |
| Component: | ovirt-engine | Assignee: | Nobody <nobody> |
| Status: | CLOSED DUPLICATE | QA Contact: | meital avital <mavital> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 4.0.6 | CC: | lsurette, rbalakri, Rhev-m-bugs, sradco, srevivo, tjelinek, ykaul |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2017-03-19 15:37:20 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Metrics | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
*** This bug has been marked as a duplicate of bug 1371111 *** |
Description of problem: Rhevm reports errors "ETL service sampling has encountered an error. Please consult the service log for more details" Version-Release number of selected component (if applicable): rhevm-4.0.6.3-0.1.el7ev.noarch ovirt-engine-dwh-4.0.6-1.el7ev.noarch ovirt-engine-dwh-setup-4.0.6-1.el7ev.noarch Actual results: 2017-01-14 14:43:05|TMkTqM|ePMtqm|FTCMiX|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCInput_5|org.postgresql.util.PSQLException:ERROR: smallint out of range|1 Exception in component tJDBCInput_18 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:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283) at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync.tJDBCInput_18Process(StatisticsSync.java:13089) at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$7.run(StatisticsSync.java:16163) 2017-01-14 14:43:05|TMkTqM|ePMtqm|FTCMiX|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCInput_18|org.postgresql.util.PSQLException:ERROR: current transaction is aborted, commands ignored until end of transaction block|1 Exception in component tJDBCInput_12 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:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283) at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:11111) at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$6.run(StatisticsSync.java:16117) 2017-01-14 14:43:05|FTCMiX|ePMtqm|lE2N4t|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_0.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:6067) at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5809) at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4444) at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4319) at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4188) at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3593) at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2977) at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2295) at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1649) at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:11361) 2017-01-17 16:30:43|ETL Service Stopped 2017-01-17 16:31:33|ETL Service Started 2017-03-03 09:21:03|T4CEVH|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 2017-03-03 09:21:38|pJa9wA|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 2017-03-03 09:22:18|1vFSmu|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 2017-03-03 09:23:03|rmYAU5|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 2017-03-03 09:23:53|TR8EDO|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 2017-03-03 09:38:53|qEPlN4|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 Expected results: sample time keeping runs with no issues. Additional info: -- Created this new bug as per https://bugzilla.redhat.com/show_bug.cgi?id=1402471#c10 -- Below services were restarted to check if issue is resolved, but the issue persists. # service ovirt-engine stop # service ovirt-engine-dwhd stop # service postgresql restart # service ovirt-engine start # service ovirt-engine-dwhd start