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

[Ladislav Humenik]

Hi, no


this table "STORAGE_DOMAIN_MAP_TABLE" is not present at any of our 
ovirt's and

based on link <cid:part1.0918F8E6.4389FAF5 at 1und1.de> this is just a 
temporary table. Can you point me to what query should I test?

thank you in advance

Ladislav


On 21.02.2018 12:50, Eyal Shenitzky wrote:
> 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 <mailto: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 <mailto:Users at ovirt.org>
>     http://lists.ovirt.org/mailman/listinfo/users
>     <http://lists.ovirt.org/mailman/listinfo/users>
>
>
>
>
> -- 
> Regards,
> Eyal Shenitzky

-- 
Ladislav Humenik

System administrator / VI
IT Operations Hosting Infrastructure

1&1 Internet SE | Ernst-Frey-Str. 5 | 76135 Karlsruhe | Germany
Phone: +49 721 91374-8361
E-Mail: ladislav.humenik at 1und1.de | Web: www.1und1.de

Hauptsitz Montabaur, Amtsgericht Montabaur, HRB 24498

Vorstand: Robert Hoffmann, Hans-Henning Kettler, Uwe Lamnek, Matthias Steinberg
Aufsichtsratsvorsitzender: René Obermann


Member of United Internet

Diese E-Mail kann vertrauliche und/oder gesetzlich geschützte Informationen enthalten. Wenn Sie nicht der bestimmungsgemäße Adressat sind oder diese E-Mail irrtümlich erhalten haben, unterrichten Sie bitte den Absender und vernichten Sie diese E-Mail. Anderen als dem bestimmungsgemäßen Adressaten ist untersagt, diese E-Mail zu speichern, weiterzuleiten oder ihren Inhalt auf welche Weise auch immer zu verwenden.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient of this e-mail, you are hereby notified that saving, distribution or use of the content of this e-mail in any way is prohibited. If you have received this e-mail in error, please notify the sender and delete the e-mail.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180221/d78aae94/attachment.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180221/d78aae94/attachment-0001.html>