----- Original Message -----
From: "Christopher Cox" <ccox(a)endlessnow.com>
Cc: users(a)ovirt.org
Sent: Saturday, December 5, 2015 8:44:20 AM
Subject: Re: [ovirt-users] Need to clear domain Export already exists in an ovirt (3.5)
On 12/03/2015 08:55 AM, Eli Mesika wrote:
>
>
> ----- Original Message -----
>> From: ccox(a)endlessnow.com
>> To: users(a)ovirt.org
>> Sent: Wednesday, December 2, 2015 11:02:25 PM
>> Subject: [ovirt-users] Need to clear domain Export already exists in an
>> ovirt (3.5)
>>
>> Our ovirt 3.5 host thinks it has an export domain, but it's not visible
>> anywhere, but it's keeping us from importing a domain from a different
>> datacenter. What database update do I need to issue to clear the bad
>> state from the ovirt 3.5 we are trying to Import into?
>
> Hi
>
> Can you please provide the result of the following query
>
> select * from storage_domain_static where storage_domain_type = 3;
>
> Is that the storage domain you wish to remove ?
Correct.
engine=> select * from storage_domain_static where storage_domain_type = 3;
id | storage
|
storage_name | storage_domain_type | storage_type | storage_domain_format_typ
e | _create_date | _update_date | recoverable |
last_time_used_as_master | storage_description | storage_comment
--------------------------------------+--------------------------------------+--------------+---------------------+--------------+--------------------------
--+-------------------------------+--------------+-------------+--------------------------+---------------------+-----------------
57fdd1c6-5c76-4174-8df7-50dbe82bc957 | d0eebb52-b9f6-4b11-8bc1-f100880519dd
|
Export | 3 | 1 | 0
| 2015-12-02 13:57:10.111442-06 | | t |
0 | |
c29afe14-0bc5-4fde-ab15-3f98f1ef9ed0 | 2e0bb17a-5f0c-4a24-9ab7-312de3f718be
|
MoveIt | 3 | 1 | 0
| 2014-09-24 15:36:03.066565-05 | | t |
0 | |
(2 rows)
These don't exist on the datacenter.
Please follow :
1) Use engine-backup to backup your database
2) To delete a storage domain from the database you should run from the psql prompt
select Deletestorage_domain_static(<id>) ;
where id is '57fdd1c6-5c76-4174-8df7-50dbe82bc957' or
'c29afe14-0bc5-4fde-ab15-3f98f1ef9ed0' depends on the one you want to delete
Please do not perform any operation before having a valid fresh backup of your database
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users