Re: [ovirt-users] Need to clear domain Export already exists in an ovirt (3.5)

6 Dec 2015

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