DataAccessResourceFailureException from one to to the next

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

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@ovirt.org To unsubscribe send an email to users-leave@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/XKWXHNHJV3SA7F...

On February 11, 2020 9:24:40 PM GMT+02:00, gregor <gregor_forum@catrix.at> 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@ovirt.org To unsubscribe send an email to users-leave@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/XKWXHNHJV3SA7F...
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/FUPCDPQCGRVPY3...
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

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@catrix.at> 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@ovirt.org To unsubscribe send an email to users-leave@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/XKWXHNHJV3SA7F...
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/FUPCDPQCGRVPY3...
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
participants (2)
-
gregor
-
Strahil Nikolov