[ovirt-users] Re: Regenerate DWH ovirt_engine_history

Hello, I reinstalled the hosted-engine (see https://lists.ovirt.org/archives/list/users@ovirt.org/thread/QOJYO43SVOMC...) 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 are: 1. a complain of the ovirt event view: 17 feb 2176, 08:47:17 ETL service sampling has encountered an error. Please consult the service log for more details. 17 feb 2176, 08:47:06 VDSM ovirt-node3.ovirt command Get Host Statistics failed: Connection timeout for host 'ovirt-node3.ovirt', last response arrived 1004236 ms ago. the dashboard was presenting no data so I checked the engine db: dwhHostname ovirt-engine.ovirt dwhUuid 93c4fc7f-74ef-43af-8529-3de33f2f763d lastOsinfoSync 2023-01-19 12:49:10.762 +0100 lastErrorSent 2176-02-17 08:47:17.126 +0100 DwhCurrentlyRunning 1 lastSync 2023-01-19 13:01:01.000 +0100 lastSampling 2177-03-03 22:11:13.023 +0100 lastOsinfoUpdate 2023-01-19 13:21:50.839 +0100 lastFullHostCheck 2023-01-19 12:56:01.000 +0100 timesFailed 129 heartBeat 2023-01-20 14:29:57.401 +0100 changing the errata entries (year>2176) I solved the problem: dwhHostname ovirt-engine.ovirt dwhUuid 93c4fc7f-74ef-43af-8529-3de33f2f763d NULL lastOsinfoSync NULL 2023-01-19 13:21:50.839 +0100 lastFullHostCheck NULL 2023-01-20 14:35:17.000 +0100 lastSync NUL 2023-01-20 14:57:17.000 +0100 DwhCurrentlyRunning 1 NULL lastOsinfoUpdate NULL 2023-01-19 13:21:50.839 +0100 timesFailed 0 NULL lastSampling 2023-01-20 14:58:17.300 +0100 heartBeat 2023-01-20 14:58:28.506 +0100 lastErrorSent NULL NULL what infos you need? Diego