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(a)gmail.com>
Sent: 25 June 2020 10:40
To: Staniforth, Paul <P.Staniforth(a)leedsbeckett.ac.uk>; users
<users(a)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<mailto: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<mailto:shashank123rastogi@gmail.com>>
Sent: 24 June 2020 12:47
To: Staniforth, Paul
<P.Staniforth@leedsbeckett.ac.uk<mailto:P.Staniforth@leedsbeckett.ac.uk>>;
users <users@ovirt.org<mailto: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<mailto: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<mailto:shashank123rastogi@gmail.com>>
Sent: 04 June 2020 15:16
To: users <users@ovirt.org<mailto: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<mailto: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/<https://eur02.safelinks.pr...
To view the terms under which this email is distributed, please go to:-
http://leedsbeckett.ac.uk/disclaimer/email/<https://eur02.safelinks.pr...
To view the terms under which this email is distributed, please go to:-
http://leedsbeckett.ac.uk/disclaimer/email/