Hide Forgot
Description of problem: ovirt-engine-dwhd service fails to collect data for reports and shows the following errors in its logfile: Exception in component tJDBCOutput_5 org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) at ovirt_engine_dwh.statisticssync_3_1.StatisticsSync.tJDBCInput_10Process(StatisticsSync.java:9488) at ovirt_engine_dwh.statisticssync_3_1.StatisticsSync$5.run(StatisticsSync.java:15855) 2013-07-22 03:50:15|DuRjz3|hNfoOb|4UrZPi|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCOutput_5|org.postgresql.util.PSQLException:ERROR: value too long for type character varying(255)|1 Exception in component tJDBCOutput_6 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:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) at ovirt_engine_dwh.statisticssync_3_1.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:11518) at ovirt_engine_dwh.statisticssync_3_1.StatisticsSync$6.run(StatisticsSync.java:15894) 2013-07-22 03:50:15|DuRjz3|hNfoOb|4UrZPi|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCOutput_6|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_3_1.SampleRunJobs.tRunJob_5Process(SampleRunJobs.java:1150) at ovirt_engine_dwh.samplerunjobs_3_1.SampleRunJobs.tRunJob_6Process(SampleRunJobs.java:1007) at ovirt_engine_dwh.samplerunjobs_3_1.SampleRunJobs.tRunJob_1Process(SampleRunJobs.java:834) at ovirt_engine_dwh.samplerunjobs_3_1.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:655) at ovirt_engine_dwh.samplerunjobs_3_1.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:557) at ovirt_engine_dwh.samplerunjobs_3_1.SampleRunJobs$1.run(SampleRunJobs.java:2038) 2013-07-22 03:50:15|4UrZPi|hNfoOb|z1kEVA|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_3_1.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:2422) at ovirt_engine_dwh.sampletimekeepingjob_3_1.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:2265) at ovirt_engine_dwh.sampletimekeepingjob_3_1.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:1437) at ovirt_engine_dwh.sampletimekeepingjob_3_1.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:1339) at ovirt_engine_dwh.sampletimekeepingjob_3_1.SampleTimeKeepingJob.tJava_3Process(SampleTimeKeepingJob.java:1247) at ovirt_engine_dwh.sampletimekeepingjob_3_1.SampleTimeKeepingJob.tJava_1Process(SampleTimeKeepingJob.java:1152) at ovirt_engine_dwh.sampletimekeepingjob_3_1.SampleTimeKeepingJob$1.run(SampleTimeKeepingJob.java:4242) Version-Release number of selected component (if applicable): rhevm-dwh-3.2.1-2.el6ev How reproducible: Problem began on August 5th (most recent data in reports is from August 5th). Steps to Reproduce: 1. Unknown. 2. 3. Actual results: No new data is being collected in reports database. Expected results: New data is collected in reports database. Additional info:
Are you sure it's rhevm-dwh-3.2.1-2.el6ev ? And that setup was run post yun update? This looks like the BZ #953148 and it was fixed in 3.2. Yaniv
Please reopen if needed. Yaniv