So here is the Query:
BEGIN
-- Creating a temporary table which will give all the images and
the disks which resids on only the specified storage domain. (copied
template disks on multiple storage domains will not be part of this
table)
CREATE TEMPORARY TABLE STORAGE_DOMAIN_MAP_TABLE AS
SELECT image_guid AS image_id,
disk_id
FROM memory_and_disk_images_storage_domain_view
WHERE storage_id = v_storage_domain_id
EXCEPT
SELECT image_guid AS image_id,
disk_id
FROM memory_and_disk_images_storage_domain_view
WHERE storage_id != v_storage_domain_id;
exception when others then
TRUNCATE TABLE STORAGE_DOMAIN_MAP_TABLE;
INSERT INTO STORAGE_DOMAIN_MAP_TABLE
SELECT image_guid AS image_id,
disk_id
FROM memory_and_disk_images_storage_domain_view
WHERE storage_id = v_storage_domain_id
EXCEPT
SELECT image_guid AS image_id,
disk_id
FROM memory_and_disk_images_storage_domain_view
WHERE storage_id != v_storage_domain_id;
END;
Try to run it and share the results please.
On Wed, Feb 21, 2018 at 4:01 PM, Eyal Shenitzky <eshen...@redhat.com> 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.hume...@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.hume...@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.hume...@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
>>>
>>>
>>> --
>>> 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 <+49%20721%20913748361>
>>> E-Mail: ladislav.hume...@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+Germany&entry=gmail&source=g>
>> Phone: +49 721 91374-8361 <+49%20721%20913748361>
>> E-Mail: ladislav.hume...@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
>
--
Regards,
Eyal Shenitzky
_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
