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 -- users(a)ovirt.org > To unsubscribe send an email to users-leave(a)ovirt.org > 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/users@ovirt.org/message/XKWXHNHJV3S... >

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 <gregor_forum(a)catrix.at&gt; 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 -- users(a)ovirt.org >>> To unsubscribe send an email to users-leave(a)ovirt.org >>> 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/users@ovirt.org/message/XKWXHNHJV3S... >>> >> _______________________________________________ >> Users mailing list -- users(a)ovirt.org >> To unsubscribe send an email to users-leave(a)ovirt.org >> 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/users@ovirt.org/message/FUPCDPQCGRV... > > 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 >