Didi, Yes. I still get empty reports. :(
-- Fernando Fuentes ffuen...@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 <sra...@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 <ffuen...@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 > >> ffuen...@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 > >> ffuen...@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 <d...@redhat.com> > >> wrote: > >> > >> On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes <ffuen...@darktcp.net> > >> wrote: > >> > Didi, > >> > > >> > As requested. > >> > > >> > > >> > [root@ovirt-dev ~]# service ovirt-engine-dwhd status > >> > ovirt-engine-dwhd (pid 32410) is running... > >> > [root@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@ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > >> > >> > >> > >> _______________________________________________ > >> Users mailing list > >> Users@ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > >> > > > > > > -- > Didi _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users