THANK YOU, this solved my problem. Solution: ssh to engine engine-setup --offline ... no vaccum, because this will break the setup ...
now the engine is back online regards gregor On 11.02.20 21:32, Strahil Nikolov wrote: > 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/HLF3GSAYJVCCDQQDMVBY4T2Z6D5U7CF5/
