<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Hello all,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">The issue has been resolved using the following approach:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Connect to the database:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"># su – postgres<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">-bash-4.2$ psql -U postgres ovirt_engine_history<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">### Listed table before editing ###<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">ovirt_engine_history=# SELECT var_datetime FROM history_configuration;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> var_datetime<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">------------------------<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">2017-01-23 01:00:00+00<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">2016-10-03 12:43:20+00<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">2017-01-23 11:00:00+00<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">(6 rows)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">###<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">### Editing table ###<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">ovirt_engine_history=# UPDATE history_configuration set var_datetime =<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">ovirt_engine_history-# date_trunc('hour', now())- interval '24 hour' WHERE var_name = 'lastHourAggr';<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">UPDATE 1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">ovirt_engine_history=# UPDATE history_configuration set var_datetime =<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">ovirt_engine_history-# cast(now() as date)- interval '1 day' WHERE var_name = 'lastDayAggr';<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">UPDATE 1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">###<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">## Listing table values again (after update) ###<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">ovirt_engine_history=# SELECT var_datetime FROM history_configuration;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> var_datetime<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">------------------------<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">2016-10-03 12:43:20+00<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">2017-01-22 00:00:00+00<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">2017-01-22 09:00:00+00<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">(6 rows)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">###<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">A few hours after applying above commands, usage graphs appeared on the dashboard.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Thanks all<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Andrea<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Shirly Radco [mailto:sradco@redhat.com]
<br>
<b>Sent:</b> Tuesday, January 17, 2017 9:44 PM<br>
<b>To:</b> Andrea Ghelardi <a.ghelardi@iontrading.com><br>
<b>Cc:</b> Liron Aravot <laravot@redhat.com>; Tal Nisan <tnisan@redhat.com>; users <users@ovirt.org><br>
<b>Subject:</b> Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working.<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Andrea,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I believe that dwh not working is unrelated to what Liron mentioned.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Please open a bug on ovirt-dwh and attach the dwh log and ovirt_engine_dwh db dump, dashboard screenshot.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I will check what is the reason that data is not collected.<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<pre><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#500050">Best regards,</span><span style="color:#500050"><o:p></o:p></span></pre>
<pre style="white-space:pre-wrap"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#500050">Shirly Radco</span><span style="color:#500050"><o:p></o:p></span></pre>
<pre style="white-space:pre-wrap"><span style="font-family:"Arial",sans-serif;color:#500050">BI Software Engineer<o:p></o:p></span></pre>
<pre><span style="font-family:"Arial",sans-serif;color:#500050">Red Hat Israel Ltd.<o:p></o:p></span></pre>
<pre><span style="font-family:"Arial",sans-serif;color:#500050">34 Jerusalem Road<o:p></o:p></span></pre>
<pre><span style="font-family:"Arial",sans-serif;color:#500050">Building A, 4th floor<o:p></o:p></span></pre>
<pre><span style="font-family:"Arial",sans-serif;color:#500050">Ra'anana, Israel 4350109</span><span style="color:#500050"><o:p></o:p></span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Tue, Jan 17, 2017 at 6:21 PM, Andrea Ghelardi <<a href="mailto:a.ghelardi@iontrading.com" target="_blank">a.ghelardi@iontrading.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<p class="MsoNormal" style="margin-bottom:12.0pt">Hello Liron,<br>
Thank you for your reply.<br>
<br>
So basically our DWH is not creating reports because vdsm is too slow in collecting results?<br>
I understand the message logged in engine is informational instead of warning, but still DWH is not working.<br>
Do you have any additional hint about what to check?<br>
<br>
Cheers<br>
AG<br>
<br>
-----Original Message-----<br>
From: Liron Aravot [mailto:<a href="mailto:laravot@redhat.com">laravot@redhat.com</a>]<br>
Sent: Tuesday, January 17, 2017 2:30 PM<br>
To: Tal Nisan <<a href="mailto:tnisan@redhat.com">tnisan@redhat.com</a>><br>
Cc: Shirly Radco <<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>>; users <<a href="mailto:users@ovirt.org">users@ovirt.org</a>>; Andrea Ghelardi <<a href="mailto:a.ghelardi@iontrading.com">a.ghelardi@iontrading.com</a>><br>
Subject: Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working.<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">When a host is "connected" to a storage pool it monitors the active pool domains. When the domain monitoring results are reported back from the host, the first monitor run may haven't finished yet. In that case the returned status from
vdsm is a dummy status and not an actual result - when getting such a status the engine logs it.<br>
We should change that log print to INFO rather then WARN.<br>
<br>
On Tue, Dec 20, 2016 at 12:17 PM, Tal Nisan <<a href="mailto:tnisan@redhat.com">tnisan@redhat.com</a>> wrote:<br>
> Liron, can you please check why does this "report isn't an actual<br>
> report" is appearing in the log?<br>
><br>
> On Mon, Dec 19, 2016 at 10:33 AM, Andrea Ghelardi<br>
> <<a href="mailto:a.ghelardi@iontrading.com">a.ghelardi@iontrading.com</a>> wrote:<br>
>><br>
>> Hello Shirly,<br>
>><br>
>> I restarted dwh service as per your suggestion with no success.<br>
>><br>
>><br>
>><br>
>> Here a sample of DWH log:<br>
>><br>
>> 2016-12-14<br>
>> 12:31:55|kdcGa9|GCXnuH|PIv06L|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|D<br>
>> efault|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not<br>
>> updating the statistics. Please check your oVirt Engine status.|9704<br>
>><br>
>> 2016-12-14<br>
>> 12:32:20|ncjn2O|GCXnuH|PIv06L|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|D<br>
>> efault|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not<br>
>> updating the statistics. Please check your oVirt Engine status.|9704<br>
>><br>
>> 2016-12-14<br>
>> 15:52:37|Xx2zzb|GCXnuH|PIv06L|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|D<br>
>> efault|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not<br>
>> updating the statistics. Please check your oVirt Engine status.|9704<br>
>><br>
>> 2016-12-16 17:39:13|ETL Service Stopped<br>
>><br>
>> 2016-12-16 17:39:14|ETL Service Started<br>
>><br>
>> ovirtEngineDbDriverClass|org.postgresql.Driver<br>
>><br>
>><br>
>> ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/o<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">>> ovirtEngineHistoryDbJdbcConnection|virt_engine_history?sslfactory=org<br>
>> ovirtEngineHistoryDbJdbcConnection|.postgresql.ssl.NonValidatingFacto<br>
>> ovirtEngineHistoryDbJdbcConnection|ry<br>
>><br>
>> hoursToKeepDaily|0<br>
>><br>
>> hoursToKeepHourly|720<br>
>><br>
>> ovirtEngineDbPassword|**********************<br>
>><br>
>> runDeleteTime|3<br>
>><br>
>><br>
>> ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?s<br>
>> ovirtEngineDbJdbcConnection|slfactory=org.postgresql.ssl.NonValidatin<br>
>> ovirtEngineDbJdbcConnection|gFactory<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">>><br>
>> runInterleave|20<br>
>><br>
>> limitRows|limit 1000<br>
>><br>
>> ovirtEngineHistoryDbUser|ovirt_engine_history<br>
>><br>
>> ovirtEngineDbUser|engine<br>
>><br>
>> deleteIncrement|10<br>
>><br>
>> timeBetweenErrorEvents|300000<br>
>><br>
>> hoursToKeepSamples|24<br>
>><br>
>> deleteMultiplier|1000<br>
>><br>
>> lastErrorSent|2011-07-03 12:46:47.000000<br>
>><br>
>> etlVersion|4.0.5<br>
>><br>
>> dwhAggregationDebug|false<br>
>><br>
>> dwhUuid|a18846e6-d188-4170-8549-aeb1c54fa390<br>
>><br>
>> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver<br>
>><br>
>> ovirtEngineHistoryDbPassword|**********************<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> And here a sample of Engine.log<br>
>><br>
>><br>
>><br>
>> 2016-12-19 04:32:05,939 WARN<br>
>> [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxyData]<br>
>> (DefaultQuartzScheduler5) [53791585] Domain<br>
>> '05c01989-18a1-4a45-9ed6-76c6badc728a:intel2-dstore04' report isn't<br>
>> an actual report<br>
>><br>
>> 2016-12-19 04:32:05,939 WARN<br>
>> [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxyData]<br>
>> (DefaultQuartzScheduler5) [53791585] Domain<br>
>> 'f0d8ea03-17ab-4feb-bbf8-408e0550fc29:boole2-dstore1' report isn't an<br>
>> actual report<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> So apparently DWH is working, but that “report isn't an actual<br>
>> report” is quite obscure to me.<br>
>><br>
>> I need to clarify that (almost) all these storages are iscsi SAN<br>
>> hosted and have been detached from Ovirt3 installation and IMPORTED into Ovirt4.<br>
>><br>
>><br>
>><br>
>> Could you suggest for next step?<br>
>><br>
>> Thanks<br>
>><br>
>> Andrea<br>
>><br>
>><br>
>><br>
>> From: Shirly Radco [mailto:<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>]<br>
>> Sent: Thursday, December 8, 2016 10:22 AM<br>
>> To: Andrea Ghelardi <<a href="mailto:a.ghelardi@iontrading.com">a.ghelardi@iontrading.com</a>><br>
>> Cc: users <<a href="mailto:users@ovirt.org">users@ovirt.org</a>><br>
>> Subject: Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working.<br>
>><br>
>><br>
>><br>
>> Hi Andrea,<br>
>><br>
>><br>
>><br>
>> Please try to restart the dwh service.<br>
>><br>
>> It is the service that collects the samples data from the engine<br>
>> database to a data warehouse, ovirt_engine_history.<br>
>><br>
>> run:<br>
>><br>
>><br>
>><br>
>> service ovirt-engine-dwhd restart<br>
>><br>
>><br>
>><br>
>> and send me the log again.<br>
>><br>
>><br>
>><br>
>> If data is still not collected to ovirt_engine_history db I'll need<br>
>> you to open a bug so we can follow on this there.<br>
>><br>
>><br>
>> Best regards,<br>
>><br>
>> Shirly Radco<br>
>><br>
>> BI Software Engineer<br>
>><br>
>> Red Hat Israel Ltd.<br>
>><br>
>> 34 Jerusalem Road<br>
>><br>
>> Building A, 4th floor<br>
>><br>
>> Ra'anana, Israel 4350109<br>
>><br>
>><br>
>><br>
>> On Wed, Dec 7, 2016 at 5:43 PM, Andrea Ghelardi<br>
>> <<a href="mailto:a.ghelardi@iontrading.com">a.ghelardi@iontrading.com</a>> wrote:<br>
>><br>
>> Hello group,<br>
>><br>
>> I noticed that my dashboard does not show little colored “cubes”<br>
>> which show storage CPU and RAM usage history status.<br>
>><br>
>> Attached an image and logs from<br>
>> /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log<br>
>><br>
>> Here’s an extract:<br>
>><br>
>><br>
>><br>
>> Exception in component tJDBCInput_5<br>
>><br>
>> org.postgresql.util.PSQLException: ERROR: smallint out of range<br>
>><br>
>> at<br>
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx<br>
>> ecutorImpl.java:2157)<br>
>><br>
>> at<br>
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor<br>
>> Impl.java:1886)<br>
>><br>
>> at<br>
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja<br>
>> va:255)<br>
>><br>
>> at<br>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat<br>
>> ement.java:555)<br>
>><br>
>> at<br>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract<br>
>> Jdbc2Statement.java:403)<br>
>><br>
>> at<br>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc<br>
>> 2Statement.java:283)<br>
>><br>
>> at<br>
>> ovirt_engine_dwh.statisticssync_4_0.StatisticsSync.tJDBCInput_5Proces<br>
>> s(StatisticsSync.java:4056)<br>
>><br>
>> at<br>
>> ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$3.run(StatisticsSy<br>
>> nc.java:15979)<br>
>><br>
>> Exception in component tJDBCInput_8<br>
>><br>
>> org.postgresql.util.PSQLException: ERROR: current transaction is<br>
>> aborted, commands ignored until end of transaction block<br>
>><br>
>> at<br>
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx<br>
>> ecutorImpl.java:2157)<br>
>><br>
>> at<br>
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor<br>
>> Impl.java:1886)<br>
>><br>
>> at<br>
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja<br>
>> va:255)<br>
>><br>
>> at<br>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat<br>
>> ement.java:555)<br>
>><br>
>> at<br>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract<br>
>> Jdbc2Statement.java:403)<br>
>><br>
>> at<br>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc<br>
>> 2Statement.java:283)<br>
>><br>
>> at<br>
>> ovirt_engine_dwh.statisticssync_4_0.StatisticsSync.tJDBCInput_8Proces<br>
>> s(StatisticsSync.java:5991)<br>
>><br>
>> at<br>
>> ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$4.run(StatisticsSy<br>
>> nc.java:16025)<br>
>><br>
>> 2016-11-27<br>
>> 14:27:40|tm1tT6|GCXnuH|0jajaj|OVIRT_ENGINE_DWH|StatisticsSync|Default<br>
>> |6|Java<br>
>> Exception|tJDBCInput_5|org.postgresql.util.PSQLException:ERROR:<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">>> Exception|smallint out<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">>> of range|1<br>
>><br>
>><br>
>><br>
>> This is a quite fresh new installation, and restarting engine VM<br>
>> (hosted-engine –vm-stop + hosted-engine –vm-start) does not fix the problem.<br>
>><br>
>> Ovirt is behaving normally.<br>
>><br>
>><br>
>><br>
>> Any clue?<br>
>><br>
>> Cheers<br>
>><br>
>> Andrea<br>
>><br>
>><br>
>><br>
>><br>
>> _______________________________________________<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" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
>><br>
>><br>
>><br>
>><br>
>> _______________________________________________<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" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
>><br>
><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>