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?

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@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,
 
 
 
On Tue, Apr 5, 2016, at 10:23 AM, Fernando Fuentes wrote:
As requested all dumps and info are at:
 
 
All systems are running the guest agent.
 
Regards,
 
 
 
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@redhat.com> wrote:
On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes <ffuentes@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.
 
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 mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users