[ovirt-users] ovirt reports

Thu Apr 7 10:03:19 UTC 2016

Hi,

Please check now again if you see data from recent days in table
"host_hourly_history".
What reports are you running and for which period?
Are all reports related to host empty? Can you please attach screenshots?

Best regards,
Shirly Radco

Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109

On Wed, Apr 6, 2016 at 8:55 PM, Fernando Fuentes <ffuentes at darktcp.net>
wrote:

> Didi,
>
> Yes. I still get empty reports. :(
>
> --
> Fernando Fuentes
> ffuentes at txweather.org
> http://www.txweather.org
>
> On Wed, Apr 6, 2016, at 02:08 AM, Yedidyah Bar David wrote:
> > On Wed, Apr 6, 2016 at 9:51 AM, Shirly Radco <sradco at redhat.com> wrote:
> > > Hi,
> > >
> > > No. You don't need to reinstall.
> > >
> > > There should be a cron job that restarts the dwh service after it is
> down
> > > for an hour.
> > > Didi, In what cases it will not start?
> >
> > The log, posted earlier in this thread, seems to show it's actually
> > running:
> >
> > >
> > > Best regards,
> > > Shirly
> > >
> > > Shirly Radco
> > > BI Software Engineer
> > > Red Hat Israel Ltd.
> > > 34 Jerusalem Road
> > > Building A, 4th floor
> > > Ra'anana, Israel 4350109
> > >
> > >
> > > On Tue, Apr 5, 2016 at 6:49 PM, Fernando Fuentes <ffuentes at darktcp.net
> >
> > > wrote:
> > >>
> > >> Team,
> > >>
> > >> Digging deaper I found that I do have data and create reports up to
> Oct of
> > >> 2015.... Somewhere in Nov 2015 it stop hence why I cant see recent
> data.
> > >> A good note to the list is that November is right around the month I
> did
> > >> the update to 3.5.4.2-1.el6
> > >> Do I have to re-installovirt-engine-reports?
> > >>
> > >> Regards,
> > >>
> > >> --
> > >> Fernando Fuentes
> > >> ffuentes at txweather.org
> > >> http://www.txweather.org
> > >>
> > >>
> > >>
> > >> On Tue, Apr 5, 2016, at 10:23 AM, Fernando Fuentes wrote:
> > >>
> > >> As requested all dumps and info are at:
> > >>
> > >> http://pastebin.com/RMSP8HFB
> > >>
> > >> All systems are running the guest agent.
> > >>
> > >> Regards,
> > >>
> > >> --
> > >> Fernando Fuentes
> > >> ffuentes at txweather.org
> > >> http://www.txweather.org
> > >>
> > >>
> > >>
> > >> On Tue, Apr 5, 2016, at 03:38 AM, Shirly Radco wrote:
> > >>
> > >> Hi Fernando,
> > >>
> > >> Please check guest agent is running on all hosts.
> > >> Please also check if you see data from recent days in table
> > >> "host_hourly_history".
> > >>
> > >> Best regards,
> > >> Shirly Radco
> > >>
> > >>
> > >>
> > >> Shirly Radco
> > >> BI Software Engineer
> > >> Red Hat Israel Ltd.
> > >> 34 Jerusalem Road
> > >> Building A, 4th floor
> > >> Ra'anana, Israel 4350109
> > >>
> > >>
> > >> On Tue, Apr 5, 2016 at 9:02 AM, Yedidyah Bar David <didi at redhat.com>
> > >> wrote:
> > >>
> > >> On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes <
> ffuentes at darktcp.net>
> > >> wrote:
> > >> > Didi,
> > >> >
> > >> > As requested.
> > >> >
> > >> >
> > >> > [root at ovirt-dev ~]# service ovirt-engine-dwhd status
> > >> > ovirt-engine-dwhd (pid  32410) is running...
> > >> > [root at ovirt-dev ~]#
> > >> >
> > >> > The log is over at pastebin to prevent a huge email/
> > >> >
> > >> > http://pastebin.com/hPcYCKVE
> > >> >
> > >> > Hope that is ok.
> > >>
> > >> The log looks mostly ok to me.
> >
> > The end of it looked like this:
> >
> > 2015-11-01
> >
> 02:00:29|YigZCz|UkJGNp|IMHBxO|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-04-03 14:57:41|ETL Service Stopped
> > 2016-04-03 15:12:41|ETL Service Started
> >
> > From this, I understood that:
> > 1. Many months ago, either there was some problem (e.g. dwhd could not
> > connect to engine db, or not see updates there, or whatever) or simply
> > there was no new data (engine was down, or simply nothing changed (is
> > this possible?)).
> > 2. Then things became ok for several months (or at least, nothing
> > caused dwhd to say otherwise)
> > 3. Then dwhd was restarted, perhaps for an upgrade, and still no new
> > errors.
> >
> > Fernando: Do you still only get empty reports?
> >
> > >>
> > >> Was this a normal, default setup?
> > >>
> > >> Please post the output of:
> > >>
> > >> su - postgres -c 'psql -c \\l'
> > >>
> > >> su - postgres -c "psql -c 'SELECT pg_database.datname,
> > >> pg_size_pretty(pg_database_size(pg_database.datname)) FROM
> > >> pg_database'"
> > >>
> > >> su - postgres -c "psql ovirt_engine_reports -c 'select
> > >> connectionurl,username from jijdbcdatasource'"
> > >>
> > >> grep DATABASE /etc/ovirt-engine/engine.conf.d/*
> > >> /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/*
> > >>
> > >> grep dbName /var/lib/ovirt-engine-reports/build-conf/master.properties
> > >>
> > >> Adding Shirly.
> > >> --
> > >> Didi
> > >>
> > >>
> > >> _______________________________________________
> > >> Users mailing list
> > >> Users at ovirt.org
> > >> http://lists.ovirt.org/mailman/listinfo/users
> > >>
> > >>
> > >>
> > >> _______________________________________________
> > >> Users mailing list
> > >> Users at ovirt.org
> > >> http://lists.ovirt.org/mailman/listinfo/users
> > >>
> > >
> >
> >
> >
> > --
> > Didi
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160407/7d04768b/attachment-0001.html>