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

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(a)1und1.de&gt; 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(a)1und1.de&gt; 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(a)1und1.de&gt; 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(a)ovirt.org >>> 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+Germ... >> Phone: +49 721 91374-8361 <+49%20721%20913748361> >> E-Mail: ladislav.humenik(a)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. >> >> > > > -- > 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+Germ... > Phone: +49 721 91374-8361 <+49%20721%20913748361> > E-Mail: ladislav.humenik(a)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. > > -- Regards, Eyal Shenitzky