From one day to another the oVirt Management Webinterface broke with the Exception:
org.springframework.dao.DataAccessResourceFailureException:Error retrieving database metadata; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.postgresql.util.PSQLException: This connection has been closed.
After investigating the log file I found in “/var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log” the following error:
org.postgresql.util.PSQLException: ERROR: right sibling's left-link
doesn't match: block 2 links to 1 instead of expected 4 in index
"idx_vm_device_history_vm_id_type"
Solution
Thanks to Strahil N., who gave me a hint in the ovirt maillinglist this points to a broken “history” table.
This are the steps to fix the database without data losing
- SSH to the engine
- run
engine-setup –offline
- Don’t perform vaccum on the database because it’s broken and so the setup will stop
- After the setup completed your system should be up and running