12:21 p.m.
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(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users