[ovirt-users] Re: DataAccessResourceFailureException from one to to the next
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>
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
>