Hi Andrea, Please try to restart the dwh service. It is the service that collects the samples data from the engine database to a data warehouse, ovirt_engine_history. run: service ovirt-engine-dwhd restart and send me the log again. If data is still not collected to ovirt_engine_history db I'll need you to open a bug so we can follow on this there. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Wed, Dec 7, 2016 at 5:43 PM, Andrea Ghelardi <a.ghelardi@iontrading.com> wrote:
Hello group,
I noticed that my dashboard does not show little colored “cubes” which show storage CPU and RAM usage history status.
Attached an image and logs from /var/log/ovirt-engine-dwh/ ovirt-engine-dwhd.log
Here’s an extract:
Exception in component tJDBCInput_5
org.postgresql.util.PSQLException: ERROR: smallint out of range
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_ 5Process(StatisticsSync.java:4056)
at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$3.run( StatisticsSync.java:15979)
Exception in component tJDBCInput_8
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_ 8Process(StatisticsSync.java:5991)
at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$4.run( StatisticsSync.java:16025)
2016-11-27 14:27:40|tm1tT6|GCXnuH|0jajaj|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCInput_5|org.postgresql.util.PSQLException:ERROR: smallint out of range|1
This is a quite fresh new installation, and restarting engine VM (hosted-engine –vm-stop + hosted-engine –vm-start) does not fix the problem.
Ovirt is behaving normally.
Any clue?
Cheers
Andrea
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users