[ovirt-users] Re: Regenerate DWH ovirt_engine_history
Hi,
On Sun, Jan 1, 2023 at 10:19 PM Diego Ercolani <diego.ercolani(a)ssis.sm> 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 to "False"
OVESETUP_DWH_CORE/enable=bool:True
OVESETUP_GRAFANA_CORE/enable=bool:True
in /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf
(obviously all in "Global Maintenance")
currently I have a system where I have an initialized ovirt_engine_history but no engine
is writing in it.
It's not the engine that is writing there, it's dwhd. The engine only
reads. Did you check /var/log/ovirt-engine-dwh/ ?
I tried to follow (in some manner):
https://www.ovirt.org/documentation/data_warehouse_guide/
In the ovirt engine's log there is no exception... so I cannot address the issue.
I need help to reinitialize the db... I don't need the history.. only from now on.
What you did might be enough, in principle, but we do not have it
documented/tested, IIRC.
How did you remove ovirt_engine_history? Did you remove both db and
user? And lines from pghba.conf?
You might need to remove also
/etc/ovirt-engine/engine.conf.d/10-setup-dwh-database.conf , before
running engine-setup. That's the file the engine uses to get
credentials for the dwh db.
Good luck and best regards,
--
Didi