On February 11, 2020 9:24:40 PM GMT+02:00, gregor <[email protected]> wrote: >I found the following in this log file: >/var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log > >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" > >regards >gregor > >On 11.02.20 19:51, gregor wrote: >> After one day I'm not able to login to the ovirt-engine webinterface >> with the following error message: >> >> "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." >> >> Things I tried which didn't help: >> - engine: check if the database is up >> - eninge: reboot >> - hosts: reboot >> - engine: xfs_repair >> >> Any ideas? >> >> regards >> gregor >> _______________________________________________ >> Users mailing list -- [email protected] >> To unsubscribe send an email to [email protected] >> Privacy Statement: https://www.ovirt.org/site/privacy-policy/ >> oVirt Code of Conduct: >https://www.ovirt.org/community/about/community-guidelines/ >> List Archives: >https://lists.ovirt.org/archives/list/[email protected]/message/XKWXHNHJV3SA7F46XSSCFCUGEOP53LCC/ >> >_______________________________________________ >Users mailing list -- [email protected] >To unsubscribe send an email to [email protected] >Privacy Statement: https://www.ovirt.org/site/privacy-policy/ >oVirt Code of Conduct: >https://www.ovirt.org/community/about/community-guidelines/ >List Archives: >https://lists.ovirt.org/archives/list/[email protected]/message/FUPCDPQCGRVPY3ZB4JARWNU4WWFBQPMS/
Do you have a backup made by 'engine-backup' ? If not, most probably (I have never done it and this is a long shot) you can purge the data in dwh via 'engine-setup'. As far as I understand , dwh data is more a 'history' data -> but don't take my words for granted. As I'm using Gluster, I use gluster snapshots to create a point-in-time states for restoration of the engine. Best Regards, Strahil Nikolov _______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/[email protected]/message/537GQUPNFIQILYFXC3MSI64N4VQSOXWD/
