| Summary: | value too long for type character varying(255) | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Julio Entrena Perez <jentrena> |
| Component: | ovirt-engine-dwh | Assignee: | Yaniv Lavi <ylavi> |
| Status: | CLOSED INSUFFICIENT_DATA | QA Contact: | Barak Dagan <bdagan> |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 3.2.0 | CC: | acathrow, bazulay, iheim, jentrena, pep, pstehlik, Rhev-m-bugs, sengork, yeylon |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | infra | ||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2013-09-08 14:26:41 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
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 |
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: