<div dir="ltr">Hi,<div><br></div><div>Please check now again if you see <span style="font-size:12.8px">data from recent days in table "host_hourly_history".</span></div><div style="font-size:12.8px">What reports are you running and for which period?</div><div style="font-size:12.8px">Are all reports related to host empty? Can you please attach screenshots?</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">Best regards,</div><div style="font-size:12.8px">Shirly Radco</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 8:55 PM, Fernando Fuentes <span dir="ltr"><<a href="mailto:ffuentes@darktcp.net" target="_blank">ffuentes@darktcp.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Didi,<br>
<br>
Yes. I still get empty reports. :(<br>
<span class="im HOEnZb"><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>
</span><div class="HOEnZb"><div class="h5">On Wed, Apr 6, 2016, at 02:08 AM, Yedidyah Bar David wrote:<br>
> 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>
> The log, posted earlier in this thread, seems to show it's actually<br>
> running:<br>
><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>
> The end of it looked like this:<br>
><br>
> 2015-11-01<br>
> 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<br>
> errors.<br>
><br>
> Fernando: Do you still only get empty reports?<br>
><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>
> --<br>
> Didi<br>
</div></div></blockquote></div><br></div>