<div dir="ltr"><font color="#000000">Hi Andrea,</font><div><br></div><div>Please try to restart the dwh service. </div><div>It is the service that collects the samples data from the engine database to a data warehouse, ovirt_engine_history.</div><div>run:</div><div><br></div><div>service ovirt-engine-dwhd restart</div><div><br></div><div>and send me the log again.</div><div><br></div><div>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.</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px">Best regards,</span></pre><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px">Shirly Radco</span></pre><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif">BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109</span></pre></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Wed, Dec 7, 2016 at 5:43 PM, Andrea Ghelardi <span dir="ltr"><<a href="mailto:a.ghelardi@iontrading.com" target="_blank">a.ghelardi@iontrading.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_2877888725074612757WordSection1">
<p class="MsoNormal">Hello group,<u></u><u></u></p>
<p class="MsoNormal">I noticed that my dashboard does not show little colored “cubes” which show storage CPU and RAM usage history status.<u></u><u></u></p>
<p class="MsoNormal">Attached an image and logs from /var/log/ovirt-engine-dwh/<wbr>ovirt-engine-dwhd.log<u></u><u></u></p>
<p class="MsoNormal">Here’s an extract:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Exception in component tJDBCInput_5<u></u><u></u></p>
<p class="MsoNormal">org.postgresql.util.<wbr>PSQLException: ERROR: smallint out of range<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>receiveErrorResponse(<wbr>QueryExecutorImpl.java:2157)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>processResults(<wbr>QueryExecutorImpl.java:1886)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.execute(<wbr>QueryExecutorImpl.java:255)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>execute(<wbr>AbstractJdbc2Statement.java:<wbr>555)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeWithFlags(<wbr>AbstractJdbc2Statement.java:<wbr>403)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeQuery(<wbr>AbstractJdbc2Statement.java:<wbr>283)<u></u><u></u></p>
<p class="MsoNormal"> at ovirt_engine_dwh.<wbr>statisticssync_4_0.<wbr>StatisticsSync.tJDBCInput_<wbr>5Process(StatisticsSync.java:<wbr>4056)<u></u><u></u></p>
<p class="MsoNormal"> at ovirt_engine_dwh.<wbr>statisticssync_4_0.<wbr>StatisticsSync$3.run(<wbr>StatisticsSync.java:15979)<u></u><u></u></p>
<p class="MsoNormal">Exception in component tJDBCInput_8<u></u><u></u></p>
<p class="MsoNormal">org.postgresql.util.<wbr>PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>receiveErrorResponse(<wbr>QueryExecutorImpl.java:2157)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>processResults(<wbr>QueryExecutorImpl.java:1886)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.core.v3.<wbr>QueryExecutorImpl.execute(<wbr>QueryExecutorImpl.java:255)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>execute(<wbr>AbstractJdbc2Statement.java:<wbr>555)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeWithFlags(<wbr>AbstractJdbc2Statement.java:<wbr>403)<u></u><u></u></p>
<p class="MsoNormal"> at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeQuery(<wbr>AbstractJdbc2Statement.java:<wbr>283)<u></u><u></u></p>
<p class="MsoNormal"> at ovirt_engine_dwh.<wbr>statisticssync_4_0.<wbr>StatisticsSync.tJDBCInput_<wbr>8Process(StatisticsSync.java:<wbr>5991)<u></u><u></u></p>
<p class="MsoNormal"> at ovirt_engine_dwh.<wbr>statisticssync_4_0.<wbr>StatisticsSync$4.run(<wbr>StatisticsSync.java:16025)<u></u><u></u></p>
<p class="MsoNormal">2016-11-27 14:27:40|tm1tT6|GCXnuH|0jajaj|<wbr>OVIRT_ENGINE_DWH|<wbr>StatisticsSync|Default|6|Java Exception|tJDBCInput_5|org.<wbr>postgresql.util.PSQLException:<wbr>ERROR: smallint out of range|1<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">This is a quite fresh new installation, and restarting engine VM (hosted-engine –vm-stop + hosted-engine –vm-start) does not fix the problem.<u></u><u></u></p>
<p class="MsoNormal">Ovirt is behaving normally.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Any clue?<u></u><u></u></p>
<p class="MsoNormal">Cheers<span class="gmail-HOEnZb"><font color="#888888"><u></u><u></u></font></span></p><span class="gmail-HOEnZb"><font color="#888888">
<p class="MsoNormal">Andrea<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</font></span></div>
</div>
<br>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
<br></blockquote></div><br></div></div>