<div dir="ltr">I believe that dwh was killed and not stopped correctly by service stop, and therefore did not exit cleanly.<div>This is why it did not send an exit message to the log and did not update the engine that dwh is not running.</div><div><br></div><div>Best,</div><div>Shirly</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif">Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109</span></pre></div></div></div>
<br><div class="gmail_quote">On Wed, Apr 6, 2016 at 10:08 AM, Yedidyah Bar David <span dir="ltr"><<a href="mailto:didi@redhat.com" target="_blank">didi@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On Wed, Apr 6, 2016 at 9:51 AM, Shirly Radco <<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>> wrote:<br>
> Hi,<br>
><br>
> No. You don't need to reinstall.<br>
><br>
> There should be a cron job that restarts the dwh service after it is down<br>
> for an hour.<br>
> Didi, In what cases it will not start?<br>
<br>
</span>The log, posted earlier in this thread, seems to show it's actually running:<br>
<div><div class="h5"><br>
><br>
> Best regards,<br>
> Shirly<br>
><br>
> Shirly Radco<br>
> BI Software Engineer<br>
> Red Hat Israel Ltd.<br>
> 34 Jerusalem Road<br>
> Building A, 4th floor<br>
> Ra'anana, Israel 4350109<br>
><br>
><br>
> On Tue, Apr 5, 2016 at 6:49 PM, Fernando Fuentes <<a href="mailto:ffuentes@darktcp.net">ffuentes@darktcp.net</a>><br>
> wrote:<br>
>><br>
>> Team,<br>
>><br>
>> Digging deaper I found that I do have data and create reports up to Oct of<br>
>> 2015.... Somewhere in Nov 2015 it stop hence why I cant see recent data.<br>
>> A good note to the list is that November is right around the month I did<br>
>> the update to 3.5.4.2-1.el6<br>
>> Do I have to re-installovirt-engine-reports?<br>
>><br>
>> Regards,<br>
>><br>
>> --<br>
>> Fernando Fuentes<br>
>> <a href="mailto:ffuentes@txweather.org">ffuentes@txweather.org</a><br>
>> <a href="http://www.txweather.org" rel="noreferrer" target="_blank">http://www.txweather.org</a><br>
>><br>
>><br>
>><br>
>> On Tue, Apr 5, 2016, at 10:23 AM, Fernando Fuentes wrote:<br>
>><br>
>> As requested all dumps and info are at:<br>
>><br>
>> <a href="http://pastebin.com/RMSP8HFB" rel="noreferrer" target="_blank">http://pastebin.com/RMSP8HFB</a><br>
>><br>
>> All systems are running the guest agent.<br>
>><br>
>> Regards,<br>
>><br>
>> --<br>
>> Fernando Fuentes<br>
>> <a href="mailto:ffuentes@txweather.org">ffuentes@txweather.org</a><br>
>> <a href="http://www.txweather.org" rel="noreferrer" target="_blank">http://www.txweather.org</a><br>
>><br>
>><br>
>><br>
>> On Tue, Apr 5, 2016, at 03:38 AM, Shirly Radco wrote:<br>
>><br>
>> Hi Fernando,<br>
>><br>
>> Please check guest agent is running on all hosts.<br>
>> Please also check if you see data from recent days in table<br>
>> "host_hourly_history".<br>
>><br>
>> Best regards,<br>
>> Shirly Radco<br>
>><br>
>><br>
>><br>
>> Shirly Radco<br>
>> BI Software Engineer<br>
>> Red Hat Israel Ltd.<br>
>> 34 Jerusalem Road<br>
>> Building A, 4th floor<br>
>> Ra'anana, Israel 4350109<br>
>><br>
>><br>
>> On Tue, Apr 5, 2016 at 9:02 AM, Yedidyah Bar David <<a href="mailto:didi@redhat.com">didi@redhat.com</a>><br>
>> wrote:<br>
>><br>
>> On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes <<a href="mailto:ffuentes@darktcp.net">ffuentes@darktcp.net</a>><br>
>> wrote:<br>
>> > Didi,<br>
>> ><br>
>> > As requested.<br>
>> ><br>
>> ><br>
>> > [root@ovirt-dev ~]# service ovirt-engine-dwhd status<br>
>> > ovirt-engine-dwhd (pid 32410) is running...<br>
>> > [root@ovirt-dev ~]#<br>
>> ><br>
>> > The log is over at pastebin to prevent a huge email/<br>
>> ><br>
>> > <a href="http://pastebin.com/hPcYCKVE" rel="noreferrer" target="_blank">http://pastebin.com/hPcYCKVE</a><br>
>> ><br>
>> > Hope that is ok.<br>
>><br>
>> The log looks mostly ok to me.<br>
<br>
</div></div>The end of it looked like this:<br>
<br>
2015-11-01 02:00:29|YigZCz|UkJGNp|IMHBxO|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can<br>
not sample data, oVirt Engine is not updating the statistics. Please<br>
check your oVirt Engine status.|9704<br>
2016-04-03 14:57:41|ETL Service Stopped<br>
2016-04-03 15:12:41|ETL Service Started<br>
<br>
>From this, I understood that:<br>
1. Many months ago, either there was some problem (e.g. dwhd could not<br>
connect to engine db, or not see updates there, or whatever) or simply<br>
there was no new data (engine was down, or simply nothing changed (is<br>
this possible?)).<br>
2. Then things became ok for several months (or at least, nothing<br>
caused dwhd to say otherwise)<br>
3. Then dwhd was restarted, perhaps for an upgrade, and still no new errors.<br>
<br>
Fernando: Do you still only get empty reports?<br>
<div class="HOEnZb"><div class="h5"><br>
>><br>
>> Was this a normal, default setup?<br>
>><br>
>> Please post the output of:<br>
>><br>
>> su - postgres -c 'psql -c \\l'<br>
>><br>
>> su - postgres -c "psql -c 'SELECT pg_database.datname,<br>
>> pg_size_pretty(pg_database_size(pg_database.datname)) FROM<br>
>> pg_database'"<br>
>><br>
>> su - postgres -c "psql ovirt_engine_reports -c 'select<br>
>> connectionurl,username from jijdbcdatasource'"<br>
>><br>
>> grep DATABASE /etc/ovirt-engine/engine.conf.d/*<br>
>> /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/*<br>
>><br>
>> grep dbName /var/lib/ovirt-engine-reports/build-conf/master.properties<br>
>><br>
>> Adding Shirly.<br>
>> --<br>
>> Didi<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" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><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" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
>><br>
><br>
<br>
<br>
<br>
</div></div><span class="HOEnZb"><font color="#888888">--<br>
Didi<br>
</font></span></blockquote></div><br></div>