On Thu, Jun 11, 2020 at 6:55 AM Strahil Nikolov via Users <users@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