[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-24 Thread Diego Ercolani
It's happened again there should be some glitch ___ 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/

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-20 Thread Diego Ercolani
Hello, I reinstalled the hosted-engine (see https://lists.ovirt.org/archives/list/users@ovirt.org/thread/QOJYO43SVOMCX6NHDP2N6PF3EIXDTRLP/) I found a "glitch" in the grafana, somehow navigating the grafana environment (brand new) have put in inconsistent state the ovirt_history_db. The symptoms

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Yedidyah Bar David
On Mon, Jan 2, 2023 at 2:33 PM Diego Ercolani wrote: > > Finally it worked: > After the step previous described: > 1. put cluster in global maintenance > 2. stop ovirt-engine and ovirt-engine-dwhd > 3. in the table dwh_history_timekeeping @enginedb I changed the dwhUuid > 4. launched engine-setup,

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Yedidyah Bar David
On Mon, Jan 2, 2023 at 1:38 PM Diego Ercolani wrote: > > I found the reference on that file: > https://github.com/oVirt/ovirt-dwh/blob/master/docs/Notes-about-single-dwhd I didn't remember I wrote it :-(. > > It's only to notice that I veryfied the contents of > dwh_history_timeskeeping table @e

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Diego Ercolani
Finally it worked: After the step previous described: 1. put cluster in global maintenance 2. stop ovirt-engine and ovirt-engine-dwhd 3. in the table dwh_history_timekeeping @enginedb I changed the dwhUuid 4. launched engine-setup, the engine-setup asked to disconnect a "fantomatic" DWH (I answere

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Diego Ercolani
I found the reference on that file: https://github.com/oVirt/ovirt-dwh/blob/master/docs/Notes-about-single-dwhd It's only to notice that I veryfied the contents of dwh_history_timeskeeping table @engine db and the dwhUuid it's consistent with the one in the 10-setup-uuid.conf file While ovirt-en

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Diego Ercolani
All the files seem to be correctly intializated. The only doubt is in the last directory you addressed: /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/ there is a file: [root@ovirt-engine ovirt-engine-dwhd.conf.d]# ls -ltr total 28 -rw-r--r--. 1 root root 223 Oct 5 09:17 README -rw---. 1 ov

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Yedidyah Bar David
On Mon, Jan 2, 2023 at 12:09 PM Diego Ercolani wrote: > > Thank you for your infos. > > It's not the engine that is writing there, it's dwhd. The engine only > > reads. Did you check /var/log/ovirt-engine-dwh/ ? > What is confusing me are these line in > /var/log/ovirt-engine-dwh/ovirt-engine-dw

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-02 Thread Diego Ercolani
Thank you for your infos. > It's not the engine that is writing there, it's dwhd. The engine only > reads. Did you check /var/log/ovirt-engine-dwh/ ? What is confusing me are these line in /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log lastErrorSent|2011-07-03 12:46:47.00 etlVersion|4.5.7 dw

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-01 Thread Yedidyah Bar David
Hi, On Sun, Jan 1, 2023 at 10:19 PM Diego Ercolani wrote: > > Hello to all and happy new year. > My question is "simple". > I need to "reset" the ovirt_engine_history database. > I tried to use: > engine-setup --reconfigure-optional-components > after removing: > - ovirt_engine_history > - set t

[ovirt-users] Re: Regenerate DWH ovirt_engine_history

2023-01-01 Thread Diego Ercolani
Sorry, some environment: - ovirt hosted-engine (self hosted) - [root@ovirt-engine ~]# rpm -qa | grep engine ovirt-engine-setup-plugin-ovirt-engine-4.5.4-1.el8.noarch ovirt-engine-extension-aaa-ldap-1.4.6-1.el8.noarch ovirt-engine-backend-4.5.4-1.el8.noarch python3-ovirt-engine-sdk4-4.6.0-1.el8.x86_