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