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

[Itamar Heim]

On 06/10/2013 02:07 PM, MEP wrote:
> 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 + "'"

strange, if the uniqueness violation is in vds static (below error), why 
did deleting it from vds_statistics solve the issue.

>
> 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
>