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?
----- Original Message -----
From: ccox@endlessnow.com To: users@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 ?
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
On 12/03/2015 08:55 AM, Eli Mesika wrote:
----- Original Message -----
From: ccox@endlessnow.com To: users@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.
----- Original Message -----
From: "Christopher Cox" <ccox@endlessnow.com> Cc: users@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@endlessnow.com To: users@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (3)
-
ccox＠endlessnow.com -
Christopher Cox
-
Eli Mesika