Index "pk_vm_icon_defaults" is not a btree

[jeffcpullen]

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"