[ovirt-users] Unable to remove storage domain's

[Eyal Shenitzky]

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 at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>


-- 
Regards,
Eyal Shenitzky
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180221/327bf72c/attachment.html>