Index "pk_vm_icon_defaults" is not a btree
jeffcpullen opened this issue · 0 comments
jeffcpullen commented
Affected version
4.5.4-1
- oVirt Engine: ovirt-engine-4.5.4-1.el8.noarch
- Host OS Variant: oVirt Node 4.4.10
- VDSM version: vdsm-4.40.100.2-1.el8.x86_64
- Additional relevant package versions: CentOS Stream 8
Describe the bug
Unable to run the engine-setup command with the error: index "pk_vm_icon_defaults" is not a btree
Failed to execute stage 'Setup validation': Failed checking Engine database: an exception occurred while validating the Engine database, index "pk_vm_icon_defaults" is not a btree
To reproduce
Not sure, may have been related to the bad postresql-jdbc package #322 that was installed to this system and then downgraded previously.
Expected behavior
Engine-setup completes as expected
Additional context
I'm not sure if this is a bug, or just a random data corruption issue. Putting this here for the next person because Google turned up nothing. Probably a one-off issue.
Running the following command fixed the issue and allowed engine-setup to complete.
/usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "reindex table vm_icon_defaults"