Can we fix this any how guys. On Thu, Jun 25, 2020 at 5:53 PM Ayansh Rocks <shashank123rast...@gmail.com> wrote:
> Is it a bug ? > > > On Thu, Jun 25, 2020 at 4:11 PM Ayansh Rocks <shashank123rast...@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.stanifo...@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 <shashank123rast...@gmail.com> >>> *Sent:* 25 June 2020 10:40 >>> *To:* Staniforth, Paul <p.stanifo...@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.stanifo...@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 <shashank123rast...@gmail.com> >>> *Sent:* 24 June 2020 12:47 >>> *To:* Staniforth, Paul <p.stanifo...@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.stanifo...@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 <shashank123rast...@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 < >>> shashank123rast...@gmail.com> 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 -- users@ovirt.org To unsubscribe send an email to users-le...@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/WFHOXRPUGFMJ7U52CCAMGAEG6XE4Q54I/