[ovirt-users] Re: ETL service aggregation error
Thanks Paul. On Sat, Jun 27, 2020, 1:19 PM Staniforth, Paul < p.stanifo...@leedsbeckett.ac.uk> wrote: > Hi Ayansh, > as it's only changing the history database there isn't > a high risk and you can run it while your system is being used, > For piece of mind you can do a full backup before, or just backup the Data > Warehouse. > > > https://www.ovirt.org/documentation/administration_guide/#chap-Backups_and_Migration > > Regards, > Paul S. > > -- > *From:* Ayansh Rocks > *Sent:* 27 June 2020 06:42 > *To:* Staniforth, Paul > *Cc:* users ; de...@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, > > Thanks, is it safe to run this update command. I am getting this issue on > my production environment. > > On Sat, Jun 27, 2020, 12:51 AM Staniforth, Paul < > p.stanifo...@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 > > > see https://www.mail-archive.com/users@ovirt.org/msg53055.html > <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mail-archive.com%2Fusers%40ovirt.org%2Fmsg53055.html=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621954992=PpKab8YJ8VrvRzh3P0GlFZ8bwFs6obiXAOyT0cnbbQI%3D=0> > > > 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 > email: p.stanifo...@leedsbeckett.ac.uk > > > <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.gofundme.com%2Ff%2Fbytes-for-heroes=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621964991=VPc3w63Gqk5wARiercvicUnW1YTpk5%2FUhohNA9cOOwY%3D=0> > > -- > *From:* Ayansh Rocks > *Sent:* 26 June 2020 17:10 > *To:* Staniforth, Paul ; users < > users@ovirt.org>; de...@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 > wrote: > > Is it a bug ? > > > On Thu, Jun 25, 2020 at 4:11 PM Ayansh Rocks > 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.
[ovirt-users] Re: ETL service aggregation error
Hi Ayansh, as it's only changing the history database there isn't a high risk and you can run it while your system is being used, For piece of mind you can do a full backup before, or just backup the Data Warehouse. https://www.ovirt.org/documentation/administration_guide/#chap-Backups_and_Migration Regards, Paul S. From: Ayansh Rocks Sent: 27 June 2020 06:42 To: Staniforth, Paul Cc: users ; de...@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, Thanks, is it safe to run this update command. I am getting this issue on my production environment. On Sat, Jun 27, 2020, 12:51 AM Staniforth, Paul mailto:p.stanifo...@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 see https://www.mail-archive.com/users@ovirt.org/msg53055.html<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mail-archive.com%2Fusers%40ovirt.org%2Fmsg53055.html=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621954992=PpKab8YJ8VrvRzh3P0GlFZ8bwFs6obiXAOyT0cnbbQI%3D=0> 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 email: p.stanifo...@leedsbeckett.ac.uk<mailto:p.stanifo...@leedsbeckett.ac.uk> [cid:c3da2131-c76e-4ed8-980a-c590881cfc00]<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.gofundme.com%2Ff%2Fbytes-for-heroes=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621964991=VPc3w63Gqk5wARiercvicUnW1YTpk5%2FUhohNA9cOOwY%3D=0> From: Ayansh Rocks mailto:shashank123rast...@gmail.com>> Sent: 26 June 2020 17:10 To: Staniforth, Paul mailto:p.stanifo...@leedsbeckett.ac.uk>>; users mailto:users@ovirt.org>>; de...@ovirt.org<mailto:de...@ovirt.org> mailto:de...@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 mailto:shashank123rast...@gmail.com>> wrote: Is it a bug ? On Thu, Jun 25, 2020 at 4:11 PM Ayansh Rocks mailto: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 mailto: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 mailto:shashank123rast...@gmail.com>> Sent: 25 June 2020 10:40 To: Staniforth, Paul mailto:p.stanifo...@leedsbeckett.ac.uk>>; users 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 conten
[ovirt-users] Re: ETL service aggregation error
Can we fix this any how guys. On Thu, Jun 25, 2020 at 5:53 PM Ayansh Rocks wrote: > Is it a bug ? > > > On Thu, Jun 25, 2020 at 4:11 PM Ayansh Rocks > 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 >>> *Sent:* 25 June 2020 10:40 >>> *To:* Staniforth, Paul ; 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 >>> *Sent:* 24 June 2020 12:47 >>> *To:* Staniforth, Paul ; 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 >>> *Sent:* 04 June 2020 15:16 >>> *To:* users >>> *Subject:* [ovirt-users] Re: ETL service aggregation error >>
[ovirt-users] Re: ETL service aggregation error
Is it a bug ? On Thu, Jun 25, 2020 at 4:11 PM Ayansh Rocks 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 >> *Sent:* 25 June 2020 10:40 >> *To:* Staniforth, Paul ; 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 >> *Sent:* 24 June 2020 12:47 >> *To:* Staniforth, Paul ; 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 >> *Sent:* 04 June 2020 15:16 >> *To:* users >> *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]
[ovirt-users] Re: ETL service aggregation error
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 Sent: 25 June 2020 10:40 To: Staniforth, Paul ; users 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 mailto: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 mailto:shashank123rast...@gmail.com>> Sent: 24 June 2020 12:47 To: Staniforth, Paul mailto:p.stanifo...@leedsbeckett.ac.uk>>; users 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 mailto: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 mailto:shashank123rast...@gmail.com>> Sent: 04 June 2020 15:16 To: users 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 mailto: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.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.protection.outlook.com/?url=http%3A%2F%2Fleedsbeckett.ac.uk%2Fdisclaimer%2Femail%2F=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7C1304ff42a20641e21cf308d818ebdd55%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637286748591305475=4Kx8pXFhOx%2FNo4Je1LcBpxjnWiPea%2B7pm5UT8jSWD%2B8%3D=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=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7C1304ff42a20641e21cf308d818ebdd55%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637286748591315470=iHE91%2FK%2FG%2FyJLBeuX9scmWjoPRHAEC7MtTOThBm%2BVSY%3D=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/B5AOMBWIURX7VT2LQJV5HUEO5BHHATHL/
[ovirt-users] Re: ETL service aggregation error
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 > *Sent:* 24 June 2020 12:47 > *To:* Staniforth, Paul ; 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 > *Sent:* 04 June 2020 15:16 > *To:* users > *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 > 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=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7C46326c8b39fa44de761e08d818346c4e%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637285960758658560=EaujZd0yZJmDmJ%2FiSSVgQvIfubHBcroFRX%2FF3rjcvSg%3D=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/AFG7PEJEHTRZWCUH4LIUTQGIWO4GNUTC/
[ovirt-users] Re: ETL service aggregation error
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 Sent: 24 June 2020 12:47 To: Staniforth, Paul ; users 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 mailto: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 mailto:shashank123rast...@gmail.com>> Sent: 04 June 2020 15:16 To: users 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 mailto: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.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.protection.outlook.com/?url=http%3A%2F%2Fleedsbeckett.ac.uk%2Fdisclaimer%2Femail%2F=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7C46326c8b39fa44de761e08d818346c4e%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637285960758658560=EaujZd0yZJmDmJ%2FiSSVgQvIfubHBcroFRX%2FF3rjcvSg%3D=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/RNVVASBIQW3XQHO7SKM3BPQGVZSIE4LA/
[ovirt-users] Re: ETL service aggregation error
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 Sent: 04 June 2020 15:16 To: users 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 mailto: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.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/ ___ 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/OVYILQFH7ULDCQBE42OKAITDVZMRZ4RO/
[ovirt-users] Re: ETL service aggregation error
Any update on this ? On Tue, May 26, 2020 at 1:41 PM Ayansh Rocks 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 > ___ 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/2MPC623C6LM7Z3JXW4NPY23JUBTVJJNP/