
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