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

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:

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

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

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

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

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

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

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

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

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 >

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

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

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

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