According to the logs, it seems like you somehow missing a table in the DB - STORAGE_DOMAIN_MAP_TABLE. 4211-b98f-a37604642251] Command 'org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand' failed: CallableStatementCallback; bad SQL grammar [{call force_delete_storage_domain(?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "storage_domain_map_table" does not exist Did you tryied to run some SQL query which cause that issue? On Wed, Feb 21, 2018 at 11:48 AM, Ladislav Humenik < ladislav.humenik@1und1.de> wrote:
Hello,
we can not remove old NFS-data storage domains, this 4 are already deactivated and unattached:
engine=> select id,storage_name from storage_domains where storage_name like 'bs09%'; id | storage_name --------------------------------------+--------------- 819b419e-638b-43c7-9189-b93c0314d38a | bs09aF2C10kvm 9a403356-f58a-4e80-9435-026e6f853a9b | bs09bF2C10kvm f5efd264-045b-48d5-b35c-661a30461de5 | bs09aF2C9kvm a0989c64-fc41-4a8b-8544-914137d7eae8 | bs09bF2C9kvm (4 rows)
The only images which still resides in DB are OVF_STORE templates:
engine=> select image_guid,storage_name,disk_description from images_storage_domain_view where storage_name like 'bs09%'; image_guid | storage_name | disk_description --------------------------------------+---------------+------------------ 6b72139d-a4b3-4e22-98e2-e8b1d64e8e50 | bs09bF2C9kvm | OVF_STORE 997fe5a6-9647-4d42-b074-27767984b7d2 | bs09bF2C9kvm | OVF_STORE 2b1884cb-eb37-475f-9c24-9638400f15af | bs09aF2C10kvm | OVF_STORE 85383ffe-68ba-4a82-a692-d93e38bf7f4c | bs09aF2C9kvm | OVF_STORE bca14796-aed1-4747-87c9-1b25861fad86 | bs09aF2C9kvm | OVF_STORE 797c27bf-7c2d-4363-96f9-565fa58d0a5e | bs09bF2C10kvm | OVF_STORE 5d092a1b-597c-48a3-8058-cbe40d39c2c9 | bs09bF2C10kvm | OVF_STORE dc61f42f-1330-4bfb-986a-d868c736da59 | bs09aF2C10kvm | OVF_STORE (8 rows)
Current oVirt Engine version: 4.1.8.2-1.el7.centos Exception logs from engine are in attachment
Do you have any magic sql statement to figure out what is causing this exception and how we can remove those storage domains without disruption ?
Thank you in advance
-- Ladislav Humenik
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Regards, Eyal Shenitzky