subject:"\[ovirt\-users\] Unable to remove storage domain's"

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

2018-02-21 Thread Ladislav Humenik

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@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 > 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
> 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
> wrote:

Hi, no

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

based on link

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,

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

2018-02-21 Thread Eyal Shenitzky

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  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
>>> 
>>> 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

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

2018-02-21 Thread Ladislav Humenik

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 
> 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
> wrote:

Hi, no

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

based on link

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
> 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

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

2018-02-21 Thread Eyal Shenitzky

Note that destroy and remove are two different operations.

Did you try both?

On Wed, Feb 21, 2018 at 3:17 PM, Ladislav Humenik  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
>> 
>> 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 
>> 
>> 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

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

2018-02-21 Thread Ladislav Humenik

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 
> wrote:

Hi, no

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

based on link

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
> 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
Phone:+49 721 91374-8361 
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

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

2018-02-21 Thread Eyal Shenitzky

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  wrote:

> Hi, no
>
>
> this table "STORAGE_DOMAIN_MAP_TABLE" is not present at any of our ovirt's
> and
>
> based on link
> 
> 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
> 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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

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

2018-02-21 Thread Eyal Shenitzky

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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

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

2018-02-21 Thread Ladislav Humenik


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

2018-02-21 09:50:02,484+01 INFO  
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default 
task-154) [8badc63f-80cf-4211-b98f-a37604642251] Lock Acquired to object 
'EngineLock:{exclusiveLocks='[f5efd264-045b-48d5-b35c-661a30461de5=STORAGE]', 
sharedLocks=''}'
2018-02-21 09:50:02,509+01 INFO  
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default 
task-154) [8badc63f-80cf-4211-b98f-a37604642251] 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-21 09:50:02,527+01 INFO  
[org.ovirt.engine.core.utils.transaction.TransactionSupport] (default task-154) 
[8badc63f-80cf-4211-b98f-a37604642251] transaction rolled back
2018-02-21 09:50:02,529+01 ERROR 
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default 
task-154) [8badc63f-80cf-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
  Where: SQL statement "TRUNCATE TABLE STORAGE_DOMAIN_MAP_TABLE"
PL/pgSQL function remove_entities_from_storage_domain(uuid) line 21 at SQL 
statement
SQL statement "SELECT Remove_Entities_From_storage_domain(v_storage_domain_id)"
PL/pgSQL function force_delete_storage_domain(uuid) line 3 at PERFORM
2018-02-21 09:50:02,530+01 ERROR 
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default 
task-154) [8badc63f-80cf-4211-b98f-a37604642251] Exception: 
org.springframework.jdbc.BadSqlGrammarException: 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
  Where: SQL statement "TRUNCATE TABLE STORAGE_DOMAIN_MAP_TABLE"
PL/pgSQL function remove_entities_from_storage_domain(uuid) line 21 at SQL 
statement
SQL statement "SELECT Remove_Entities_From_storage_domain(v_storage_domain_id)"
PL/pgSQL function force_delete_storage_domain(uuid) line 3 at PERFORM
at 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
 [spring-jdbc.jar:4.2.4.RELEASE]
at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
 [spring-jdbc.jar:4.2.4.RELEASE]
at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1094) 
[spring-jdbc.jar:4.2.4.RELEASE]
at 
org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1130) 
[spring-jdbc.jar:4.2.4.RELEASE]
at 
org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:405)
 [spring-jdbc.jar:4.2.4.RELEASE]
at 
org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:365)
 [spring-jdbc.jar:4.2.4.RELEASE]
at 
org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:198)
 [spring-jdbc.jar:4.2.4.RELEASE]
at

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

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

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

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

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

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

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

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

8 matches

Site Navigation

Mail list logo

Footer information