[ovirt-users] Unable to remove storage domain's
Ladislav Humenik
ladislav.humenik at 1und1.de
Thu Feb 22 07:50:14 UTC 2018
Hello again,
the result is: ERROR: permission denied to create temporary tables in
database "engine"
- I forgot to mention we do not run the DB on localhost, but on
dedicated server which is managed by DB-admins. After granting the
necessary TEMPORARY privileges:
engine-log:
2018-02-22 08:47:57,678+01 INFO
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand]
(default task-13) [6f250dbf-40d2-4017-861a-ae410fc382f5] Lock Acquired
to object
'EngineLock:{exclusiveLocks='[f5efd264-045b-48d5-b35c-661a30461de5=STORAGE]',
sharedLocks=''}'
2018-02-22 08:47:57,694+01 INFO
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand]
(default task-13) [6f250dbf-40d2-4017-861a-ae410fc382f5] Running
command: RemoveStorageDomainCommand internal: false. Entities affected
: ID: f5efd264-045b-48d5-b35c-661a30461de5 Type: StorageAction group
DELETE_STORAGE_DOMAIN with role type ADMIN
2018-02-22 08:47:57,877+01 INFO
[org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
(default task-13) [6f250dbf-40d2-4017-861a-ae410fc382f5] EVENT_ID:
USER_REMOVE_STORAGE_DOMAIN(960), Correlation ID:
6f250dbf-40d2-4017-861a-ae410fc382f5, Job ID:
d825643c-3f2e-449c-a19d-dc55af74d153, Call Stack: null, Custom ID: null,
Custom Event ID: -1, Message: Storage Domain bs09aF2C9kvm was removed by
admin at internal
2018-02-22 08:47:57,881+01 INFO
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand]
(default task-13) [6f250dbf-40d2-4017-861a-ae410fc382f5] Lock freed to
object
'EngineLock:{exclusiveLocks='[f5efd264-045b-48d5-b35c-661a30461de5=STORAGE]',
sharedLocks=''}'
Thank you for your help,
Ladislav
On 22.02.2018 06:11, Eyal Shenitzky wrote:
> 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_TABLEAS SELECT image_guidAS image_id,
> disk_id
> FROM memory_and_disk_images_storage_domain_view
> WHERE storage_id = v_storage_domain_id
>
> EXCEPT SELECT image_guidAS image_id,
> disk_id
> FROM memory_and_disk_images_storage_domain_view
> WHERE storage_id != v_storage_domain_id;
>
> exception when othersthen TRUNCATETABLE STORAGE_DOMAIN_MAP_TABLE;
>
> INSERT INTO STORAGE_DOMAIN_MAP_TABLE
> SELECT image_guidAS image_id,
> disk_id
> FROM memory_and_disk_images_storage_domain_view
> WHERE storage_id = v_storage_domain_id
>
> EXCEPT SELECT image_guidAS 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 <eshenitz at redhat.com
> <mailto:eshenitz at 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.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
>
>
>
>
> --
> 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/20180222/d271d21b/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/20180222/d271d21b/attachment.png>
More information about the Users
mailing list