[ovirt-users] Ovirt 4.0.5 reporting dashboard not working.

Shirly Radco sradco at redhat.com
Mon Dec 19 11:53:35 UTC 2016 

Best regards,

Shirly Radco

BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109


On Mon, Dec 19, 2016 at 10:33 AM, Andrea Ghelardi <a.ghelardi at iontrading.com
> wrote:

> Hello Shirly,
>
> I restarted dwh service as per your suggestion with no success.
>
>
>
> Here a sample of DWH log:
>
> 2016-12-14 12:31:55|kdcGa9|GCXnuH|PIv06L|OVIRT_ENGINE_DWH|
> SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt
> Engine is not updating the statistics. Please check your oVirt Engine
> status.|9704
>
> 2016-12-14 12:32:20|ncjn2O|GCXnuH|PIv06L|OVIRT_ENGINE_DWH|
> SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt
> Engine is not updating the statistics. Please check your oVirt Engine
> status.|9704
>
> 2016-12-14 15:52:37|Xx2zzb|GCXnuH|PIv06L|OVIRT_ENGINE_DWH|
> SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt
> Engine is not updating the statistics. Please check your oVirt Engine
> status.|9704
>
> 2016-12-16 17:39:13|ETL Service Stopped
>
> 2016-12-16 17:39:14|ETL Service Started
>
> ovirtEngineDbDriverClass|org.postgresql.Driver
>
> ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://
> localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.
> NonValidatingFactory
>
> hoursToKeepDaily|0
>
> hoursToKeepHourly|720
>
> ovirtEngineDbPassword|**********************
>
> runDeleteTime|3
>
> ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:
> 5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
>
> runInterleave|20
>
> limitRows|limit 1000
>
> ovirtEngineHistoryDbUser|ovirt_engine_history
>
> ovirtEngineDbUser|engine
>
> deleteIncrement|10
>
> timeBetweenErrorEvents|300000
>
> hoursToKeepSamples|24
>
> deleteMultiplier|1000
>
> lastErrorSent|2011-07-03 12:46:47.000000
>
> etlVersion|4.0.5
>
> dwhAggregationDebug|false
>
> dwhUuid|a18846e6-d188-4170-8549-aeb1c54fa390
>
> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
>
> ovirtEngineHistoryDbPassword|**********************
>
>
>
>
>
> And here a sample of Engine.log
>
>
>
> 2016-12-19 04:32:05,939 WARN  [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxyData]
> (DefaultQuartzScheduler5) [53791585] Domain '05c01989-18a1-4a45-9ed6-76c6badc728a:intel2-dstore04'
> report isn't an actual report
>
> 2016-12-19 04:32:05,939 WARN  [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxyData]
> (DefaultQuartzScheduler5) [53791585] Domain 'f0d8ea03-17ab-4feb-bbf8-408e0550fc29:boole2-dstore1'
> report isn't an actual report
>
>
Tal , Allon, Can you please update on what does this engine log error mean?


>
>
>
>
> So apparently DWH is working, but that “report isn't an actual report” is
> quite obscure to me.
>

Did you start seeing data in the dashboard?

I need to clarify that (almost) all these storages are iscsi SAN hosted and
> have been detached from Ovirt3 installation and IMPORTED into Ovirt4.
>
>
>
> Could you suggest for next step?
>
> Thanks
>
> Andrea
>
>
>
> *From:* Shirly Radco [mailto:sradco at redhat.com]
> *Sent:* Thursday, December 8, 2016 10:22 AM
> *To:* Andrea Ghelardi <a.ghelardi at iontrading.com>
> *Cc:* users <users at ovirt.org>
> *Subject:* Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working.
>
>
>
> 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 at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20161219/4f75859e/attachment.html>

More information about the Users mailing list