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

Ladislav Humenik ladislav.humenik at 1und1.de
Wed Feb 21 14:07:00 UTC 2018


Hi, yes, destroy is also not working and throwing SQL exception

detailed logs from engine by doing destroy in attachment

thank you in advance
ladislav

On 21.02.2018 15:01, Eyal Shenitzky wrote:
> Note that destroy and remove are two different operations.
>
> Did you try both?
>
> On Wed, Feb 21, 2018 at 3:17 PM, Ladislav Humenik 
> <ladislav.humenik at 1und1.de <mailto:ladislav.humenik at 1und1.de>> wrote:
>
>     Hi, of course i did. I put these domain's first in to maintenance,
>     then Detached it from the datacenter.
>
>     The last step is destroy or remove "just name it" and this last
>     step is mysteriously not working.
>
>
>
>     and throwing sql exception which I attached before.
>
>     Thank you in advance
>     ladislav
>
>     On 21.02.2018 14:03, Eyal Shenitzky wrote:
>>     Did you manage to set the domain to maintenance?
>>
>>     If so you can try to 'Destroy' the domain.
>>
>>     On Wed, Feb 21, 2018 at 2:57 PM, Ladislav Humenik
>>     <ladislav.humenik at 1und1.de <mailto:ladislav.humenik at 1und1.de>> wrote:
>>
>>         Hi, no
>>
>>
>>         this table "STORAGE_DOMAIN_MAP_TABLE" is not present at any
>>         of our ovirt's and
>>
>>         based on link
>>         <http://?ui=2&ik=0712e9a1b3&view=fimg&th=161b8714ec199ae3&attid=0.1.1&disp=emb&attbid=ANGjdJ9PPOWU6bxvze9lPAM_2gBE-uu8fFppbzl2kuXMhSwyKx4QWo0sFYbLjNBgMhB0RdoOM_e16gleR75ZmUYnx3ndhB0CgYgXtvtBs7wNxOYf-o9rWv42duaUwsw&sz=s0-l75-ft&ats=1519218030205&rm=161b8714ec199ae3&zw&atsh=0>
>>         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
>>         <https://maps.google.com/?q=Ernst-Frey-Str.+5+%7C+76135+Karlsruhe+%7C+Germany&entry=gmail&source=g>
>>         Phone:+49 721 91374-8361 <tel:+49%20721%20913748361>
>>         E-Mail:ladislav.humenik at 1und1.de <mailto:ladislav.humenik at 1und1.de>  | Web:www.1und1.de <http://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.
>>
>>
>>
>>
>>     -- 
>>     Regards,
>>     Eyal Shenitzky
>
>     -- 
>     Ladislav Humenik
>
>     System administrator / VI
>     IT Operations Hosting Infrastructure
>
>     1&1 Internet SE |Ernst-Frey-Str. 5 | 76135 Karlsruhe | Germany
>     <https://maps.google.com/?q=Ernst-Frey-Str.+5+%7C+76135+Karlsruhe+%7C+Germany&entry=gmail&source=g>
>     Phone:+49 721 91374-8361 <tel:+49%20721%20913748361>
>     E-Mail:ladislav.humenik at 1und1.de <mailto:ladislav.humenik at 1und1.de>  | Web:www.1und1.de <http://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.
>
>
>
>
> -- 
> 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/fd556564/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gpnbnncpehjpckhg.png
Type: image/png
Size: 10782 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180221/fd556564/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: destroy.log
Type: text/x-log
Size: 8425 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180221/fd556564/attachment.bin>


More information about the Users mailing list