[Users] Last removed host from DC cannot be installed again

[MEP]

Il 09. 06. 13 11:36, Itamar Heim ha scritto:
> On 06/09/2013 10:53 AM, Noam Slomianko wrote:
>> vds_name holds the name you give to the Host in the UI when you add it
>> to ovirt.
>> So make sure that you try and give it a new name when you add it in
>> the UI and that no other host has this name.
>>
>> If you enter in ovirt a new name that you have never used for any
>> other host and still get this message I believe that this is a bug and
>> that the error message is wrong somehow.
>> In that case please attach engine logs.
> 
Yes I tried with a new name/new mac/new ip/etc. too.
> 
> unique id isn't about the name, rather the host uuid as reported by the
> host.
> 
> MEP - did you remove the old host from the engine? do you have any other
> host in the engine?
> 

No I have other hosts in the engine but not in the same DC/cluster.
The only way I have found to solve the problem is  to connect to the db
and delete from vds_statistics where vds_id='" + vds_id + "'"

After I can add again the host in the other DC.

This is the error in the log.

2013-06-05 01:12:53,610 ERROR [org.ovirt.engine.core.bll.AddVdsCommand]
(ajp--12
7.0.0.1-8702-2) [16fab49f] Command
org.ovirt.engine.core.bll.AddVdsCommand throw
 exception: org.springframework.dao.DuplicateKeyException:
CallableStatementCall
back; SQL [{call insertvdsstatic(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?,
 ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; ERROR: duplicate key value violates
unique con
straint "vds_static_vds_name_unique"
  Detail: Key (vds_name)=(gauss) already exists.
  Where: SQL statement "INSERT INTO vds_static(vds_id,host_name, ip,
vds_unique_id, port, vds_group_id, vds_name, server_SSL_enabled,

vds_type,vds_strength,pm_type,pm_user,pm_password,pm_port,pm_options,pm_enabled,
                               pm_proxy_preferences, pm_secondary_ip,
pm_secondary_type, pm_secondary_user,
                               pm_secondary_password, pm_secondary_port,
pm_secondary_options, pm_secondary_concurrent,
                               vds_spm_priority, sshKeyFingerprint)
                        VALUES(v_vds_id,v_host_name, v_ip,
v_vds_unique_id, v_port, v_vds_group_id, v_vds_name, v_server_SSL_enabled,

vds_type,vds_strength,pm_type,pm_user,pm_password,pm_port,pm_options,pm_enabled,
                               pm_proxy_preferences, pm_secondary_ip,
pm_secondary_type, pm_secondary_user,
                               pm_secondary_password, pm_secondary_port,
pm_secondary_options, pm_secondary_concurrent,
                               vds_spm_priority, sshKeyFingerprint)
                        VALUES(v_vds_id,v_host_name, v_ip,
v_vds_unique_id, v_port, v_vds_group_id, v_vds_name, v_server_SSL_enabled,

v_vds_type,v_vds_strength,v_pm_type,v_pm_user,v_pm_password,v_pm_port,v_pm_options,v_pm_enabled,
                               v_pm_proxy_preferences,
v_pm_secondary_ip, v_pm_secondary_type, v_pm_secondary_user,
                               v_pm_secondary_password,
v_pm_secondary_port, v_pm_secondary_options, v_pm_secondary_concurrent,
                               v_vds_spm_priority, v_sshKeyFingerprint)"

If you want the entire log let me know where to send it.

Thx,
	MEP