[ovirt-users] Error while executing action: Cannot add Host. Host with the same UUID already exists.

[Eli Mesika]

----- Original Message -----
> From: "Юрий Полторацкий" <y.poltoratskiy at gmail.com>
> To: "Alon Bar-Lev" <alonbl at redhat.com>
> Cc: users at ovirt.org
> Sent: Thursday, June 18, 2015 4:05:18 PM
> Subject: Re: [ovirt-users] Error while executing action: Cannot add Host. Host with the same UUID already exists.
> 
> Hi,
> 
> I have resolved this in such way.
> 
> On the engine host connect to db:
> su postgres
> psql -s engine
> 
> Then delete host from db manualy:
> select vds_id from vds_static where host_name = 'HOST_NAME';
> delete from vds_statistics where vds_id = 'id';
> delete from vds_dynamic where vds_id = 'id';
> delete from vds_static where vds_id = 'id';

this is only part of the work, now you have junk in some of your table 

The right way is to call 

SELECT DeleteVds(<uuid>);

the body of this SP is :

---Start---
UPDATE vm_static
      SET dedicated_vm_for_vds = null
      WHERE dedicated_vm_for_vds = v_vds_id;
      DELETE FROM tags_vds_map
      WHERE vds_id = v_vds_id;
   -- Delete all Vds Alerts from the database
      PERFORM DeleteAuditLogAlertsByVdsID(v_vds_id);
      DELETE FROM vds_statistics WHERE vds_id = v_vds_id;
      DELETE FROM vds_dynamic WHERE vds_id = v_vds_id;
      DELETE FROM vds_static WHERE vds_id = v_vds_id;
      DELETE FROM permissions where object_id = v_vds_id;
--- end ---

Please verify that you complete the missing operations manually and consult with us in future before doing anything directly on the database 

Thanks


> 
> 2015-06-18 16:04 GMT+03:00 Alon Bar-Lev < alonbl at redhat.com > :
> 
> 
> 
> A log will be nice.
> However, can you please compare /etc/vdsm/ vdsm.id in both hosts?
> If not available at new host it might be a bios issue, try to uuidgen >
> /etc/vdsm/ vdsm.id and add host.
> 
> ----- Original Message -----
> > From: ml at ohnewald.net
> > To: users at ovirt.org
> > Sent: Thursday, June 18, 2015 3:54:25 PM
> > Subject: [ovirt-users] Error while executing action: Cannot add Host. Host
> > with the same UUID already exists.
> > 
> > Hello List,
> > 
> > i am using oVirt Engine Version: 3.5.2.1-1.el6.
> > 
> > I would like to remove a node from a GlusterFS Cluster and use it for
> > local storage.
> > 
> > So i put my node into maintance. Reinstalled it freshly with CentOS7.
> > 
> > Now i would like to add it to a New Cluster with local storage, but i get:
> > 
> > Error while executing action: Cannot add Host. Host with the same UUID
> > already exists.
> > 
> > 
> > 
> > How can i resolve this problem?
> > 
> > 
> > I can NOT remove my old host from the Gluster: Cannot remove Host.
> > Server having Gluster volume.
> > 
> > 
> > 
> > Thanks,
> > Mario
> > 
> > _______________________________________________
> > Users mailing list
> > Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> > 
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
> 
> 
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>