Is it a bug ?
On Thu, Jun 25, 2020 at 4:11 PM Ayansh Rocks <[email protected]> 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 < > [email protected]> 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 <[email protected]> >> *Sent:* 25 June 2020 10:40 >> *To:* Staniforth, Paul <[email protected]>; users < >> [email protected]> >> *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 < >> [email protected]> 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 <[email protected]> >> *Sent:* 24 June 2020 12:47 >> *To:* Staniforth, Paul <[email protected]>; users < >> [email protected]> >> *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 < >> [email protected]> 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 <[email protected]> >> *Sent:* 04 June 2020 15:16 >> *To:* users <[email protected]> >> *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 < >> [email protected]> wrote: >> >> Hi, >> >> I am using 4.3.7 self hosted engine. From Few days i am getting regular >> below error messages :- >> [image: image.png] >> >> Logs in /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log >> [image: 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.protection.outlook.com/?url=http%3A%2F%2Fleedsbeckett.ac.uk%2Fdisclaimer%2Femail%2F&data=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7C1304ff42a20641e21cf308d818ebdd55%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637286748591305475&sdata=4Kx8pXFhOx%2FNo4Je1LcBpxjnWiPea%2B7pm5UT8jSWD%2B8%3D&reserved=0> >> >> To view the terms under which this email is distributed, please go to:- >> http://leedsbeckett.ac.uk/disclaimer/email/ >> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fleedsbeckett.ac.uk%2Fdisclaimer%2Femail%2F&data=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7C1304ff42a20641e21cf308d818ebdd55%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637286748591315470&sdata=iHE91%2FK%2FG%2FyJLBeuX9scmWjoPRHAEC7MtTOThBm%2BVSY%3D&reserved=0> >> >> To view the terms under which this email is distributed, please go to:- >> http://leedsbeckett.ac.uk/disclaimer/email/ >> >>
_______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] 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/[email protected]/message/5VPRRVUXEYNAKO5FIWMZVEC46NC4CLI6/
