[ovirt-users] Re: ovirt 4.3.10 Web UI constantly "finished activating host"
On Thu, Jun 11, 2020 at 6:55 AM Strahil Nikolov via Users
<users(a)ovirt.org> wrote:
I'm not sure if this one is related to "time shift" in the DB (as I found
that dwh_history_timekeeping had some entries 1 month ahead/ETL service issues also/, but
I keep getting spammed that the host has been activated.
Any hint ?
I'd start with:
1. Check (in /var/log) if you had a case of time moving forward and
than backward for some weird reason
2. Dump the entire db (engine, perhaps also dwh if you want) and
search for future dates. If you only find a few, it might be easier to
handle them one-by-one (hopefully by updating the relevant entity from
the UI, not directly in the db). If it's many, it might require
something more significant.
In 4.4, that's just:
su - postgres -c 'pg_dump engine' | less
In 4.3:
su - postgres -c 'scl enable rh-postgresql10 "pg_dump engine"' | less
Then search e.g. '2020-07', or '2020-06-2', etc.
Best regards,
--
Didi