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

[Eli Mesika]

----- Original Message -----
> From: "Christopher Cox" <ccox at endlessnow.com>
> Cc: users at 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 at endlessnow.com
> >> To: users at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>