----- Original Message ----- > From: "Christopher Cox" <c...@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: c...@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 > _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users