Hi,

I was unable to view your log file. But if its indeed an the issue please run:

systemctl stop ovirt-engine-dwhd

ovirt_engine_history=# UPDATE history_configuration set var_datetime = date_trunc('hour', now())- interval '2 hour' WHERE var_name = 'lastHourAggr';
ovirt_engine_history=# UPDATE history_configuration set var_datetime = date_trunc('hour', now())- interval '1 day' WHERE var_name = 'lastDayAggr';

systemctl restart ovirt-engine-dwhd

If you would like me to review the errors please attach the dwh log file.

Best regards,
--
Shirly Radco
BI Principal Software Engineer
Red Hat


On Fri, Jun 26, 2020 at 10:28 PM Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk> wrote:


















Hello Ayansh,


                        It looks like the lastHourAgg is wrong is should be 2 hours before the runTime but is 1:30 hours before runtime.



















Try











systemctl stop ovirt-engine-dwhd



in ovirt_engine_history database


UPDATE history_configuration set var_datetime = var_datetime - interval '24 hour' WHERE var_name = 'lastHourAggr';


UPDATE history_configuration set var_datetime = var_datetime - interval '1 day' WHERE var_name = 'lastDayAggr';







systemctl stop ovirt-engine-dwhd




























Regards,




















Paul Staniforth 









School of Built Environment Engineering and Computing.







Leeds Beckett University









Networked Systems Analyst, Research and Engineering Support.


Technical Lead Architect IMS and oVirt Virtualization









tel: +44 (0)113 28123754






























From: Ayansh Rocks <shashank123rastogi@gmail.com>

Sent: 26 June 2020 17:10

To: Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk>; users <users@ovirt.org>; devel@ovirt.org <devel@ovirt.org>

Subject: Re: [ovirt-users] Re: ETL service aggregation error

 






Caution External Mail: Do not click any links or open any attachments unless you trust the sender and know that the content is safe.




Can we fix this any how guys.






On Thu, Jun 25, 2020 at 5:53 PM Ayansh Rocks <shashank123rastogi@gmail.com> wrote:






Is it a bug ?












On Thu, Jun 25, 2020 at 4:11 PM Ayansh Rocks <shashank123rastogi@gmail.com> wrote:






See below as well if it helps -






[root@iondelvm149 ~]# date

Thu Jun 25 16:09:45 IST 2020

[root@iondelvm149 ~]# psql -h localhost -U  ovirt_engine_history  -d ovirt_engine_history

Password for user ovirt_engine_history:

psql (9.2.24, server 10.6)

WARNING: psql version 9.2, server version 10.0.

         Some psql features might not work.

Type "help" for help.



ovirt_engine_history=> select * from  history_configuration;

     var_name      | var_value |      var_datetime

-------------------+-----------+------------------------

 default_language  | en_US     |

 firstSync         | false     | 2018-03-23 12:27:00-04

 lastHourAggr      |           | 2020-06-25 05:00:00-04

 HourlyAggFailed   | false     |

 lastDayAggr       |           | 2020-06-24 01:00:00-04

 MinimalETLVersion | 4.3.0     |

(6 rows)



ovirt_engine_history=>










On Thu, Jun 25, 2020 at 4:06 PM Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk> wrote:








Hello 
Shashank,


                           is it on the hour? it sounds like it got a problem aggregating the samples to create the hourly samples.







I had to update the java memory usage as it was running out of heap memory.







The defaults are







DWH_HEAP_MIN=1g



DWH_HEAP_MAX=1g







see 




/usr/share/ovirt-engine-dwh/services/ovirt-engine-dwhd/ovirt-engine-dwhd.conf









for settings.







Regards,


              Paul S.




















From: Ayansh Rocks <shashank123rastogi@gmail.com>

Sent: 25 June 2020 10:40

To: Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk>; users <users@ovirt.org>

Subject: Re: [ovirt-users] Re: ETL service aggregation error

 






Caution External Mail: Do not click any links or open any attachments unless you trust the sender and know that the content is safe.




Hi Paul,






Yes i am able to connect to the database from ovirt engine machine. 







port is already open. what could be issue, i am getting this error in every hour.







Thanks








On Wed, Jun 24, 2020 at 6:30 PM Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk> wrote:









Hello 
Shashank,



                               it looks like it's had a problem for over 2 years, is the Data Warehouse database local or remote? is there a firewall port open?









Can you connect to the database from the engine machine?









The credentials should be in /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf











as your using 4.3 the version of postgresql is 10 and using scl









scl enable rh-postgresql10 "psql  -h localhost -U  ovirt_engine_history  -d ovirt_engine_history"












if it's using the standard user, database and is local.















Regards,



                Paul S.




.





















From: Ayansh Rocks <shashank123rastogi@gmail.com>

Sent: 24 June 2020 12:47

To: Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk>; users <users@ovirt.org>

Subject: Re: [ovirt-users] Re: ETL service aggregation error

 






Caution External Mail: Do not click any links or open any attachments unless you trust the sender and know that the content is safe.




Please find the attached error logs.






On Thu, Jun 4, 2020 at 8:17 PM Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk> wrote:









Hello 
Shashank,



                                I can't see any of your images and also it would be better to have the log file as text.









Regards,



                 Paul S.


































From: Ayansh Rocks <shashank123rastogi@gmail.com>

Sent: 04 June 2020 15:16

To: users <users@ovirt.org>

Subject: [ovirt-users] Re: ETL service aggregation error

 






Caution External Mail: Do not click any links or open any attachments unless you trust the sender and know that the content is safe.




Any update on this ?








On Tue, May 26, 2020 at 1:41 PM Ayansh Rocks <shashank123rastogi@gmail.com> wrote:






  Hi, 







I am using  4.3.7 self hosted engine. From Few days i am getting regular below error messages :-




image.png











Logs in /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log




image.png











What could be the reason for this?







Thanks


Shashank













To view the terms under which this email is distributed, please go to:- 

http://leedsbeckett.ac.uk/disclaimer/email/












To view the terms under which this email is distributed, please go to:- 

http://leedsbeckett.ac.uk/disclaimer/email/












To view the terms under which this email is distributed, please go to:- 

http://leedsbeckett.ac.uk/disclaimer/email/




















To view the terms under which this email is distributed, please go to:- 

http://leedsbeckett.ac.uk/disclaimer/email/





_______________________________________________

Users mailing list -- users@ovirt.org

To unsubscribe send an email to users-leave@ovirt.org

Privacy Statement: https://www.ovirt.org/privacy-policy.html

oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/

List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/BCU7ZTSVHZR7PM2R2B3ETYLVSOWQK3Q4/