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.ghela...@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:sra...@redhat.com] > *Sent:* Thursday, December 8, 2016 10:22 AM > *To:* Andrea Ghelardi <a.ghela...@iontrading.com> > *Cc:* users <users@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.ghela...@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 > > >
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users