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

21 Jun 2015


      ----- Original Message -----
...
From: "Юрий Полторацкий" <y.poltoratskiy@gmail.com>
To: "Alon Bar-Lev" <alonbl@redhat.com>
Cc: users@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@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@ohnewald.net
To: users@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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________
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

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

Eli Mesika