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 <shashank123rast...@gmail.com> > *Sent:* 27 June 2020 06:42 > *To:* Staniforth, Paul <p.stanifo...@leedsbeckett.ac.uk> > *Cc:* users <users@ovirt.org>; de...@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. > 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&data=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621954992&sdata=PpKab8YJ8VrvRzh3P0GlFZ8bwFs6obiXAOyT0cnbbQI%3D&reserved=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&data=02%7C01%7CP.Staniforth%40leedsbeckett.ac.uk%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621964991&sdata=VPc3w63Gqk5wARiercvicUnW1YTpk5%2FUhohNA9cOOwY%3D&reserved=0> > > ------------------------------ > *From:* Ayansh Rocks <shashank123rast...@gmail.com> > *Sent:* 26 June 2020 17:10 > *To:* Staniforth, Paul <p.stanifo...@leedsbeckett.ac.uk>; users < > users@ovirt.org>; de...@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 <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%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621964991&sdata=lTSgvY%2FSk1rowXPCfFZx1XwKfoYhU5A5%2BajX0mwcJCk%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%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621974982&sdata=%2BtNU9xdyHJjs7yr80zhJrPSVFinXuFYy%2FYE61s1Lp20%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%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621974982&sdata=%2BtNU9xdyHJjs7yr80zhJrPSVFinXuFYy%2FYE61s1Lp20%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%7Cead865ad9c8c417a4fb708d81a5ce72c%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C0%7C637288333621984985&sdata=p3OfSi9rHb1aOt8gxCnDjjy2EC8157BjP9kForsS33U%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/M22GQINIZCKS4PYDHJYIW3JLWIQ5QENO/