[Users] Last removed host from DC cannot be installed again
On 06/05/2013 05:16 AM, MEP wrote:
Hi guys! I'm running ovirt 3.2 in Fed 18 with about 100 vm in 3 DC and fc/sw storage. Yesterday I've removeded 1 DC. It's seems impossible to reuse the last host removed from the DC in another DC. The Status says "Install Failed" and in the log I find this error : duplicate key value violates unique constraint "vds_static_vds_name_unique". I afraid to corrupt SPM/db and I have not modified the relative record in the db. Changing name/ip of the server or recreating the unique id doesn't fix it. Any ideas? Is it a bug?
did you remove the host first? did you try to register same host in another name? (btw, you don't need to remove the host at all, you can just move it between clusters, even in different DCs)
Il 05. 06. 13 09:12, Itamar Heim ha scritto:
On 06/05/2013 05:16 AM, MEP wrote:
Hi guys! I'm running ovirt 3.2 in Fed 18 with about 100 vm in 3 DC and fc/sw storage. Yesterday I've removeded 1 DC. It's seems impossible to reuse the last host removed from the DC in another DC. The Status says "Install Failed" and in the log I find this error : duplicate key value violates unique constraint "vds_static_vds_name_unique". I afraid to corrupt SPM/db and I have not modified the relative record in the db. Changing name/ip of the server or recreating the unique id doesn't fix it. Any ideas? Is it a bug?
did you remove the host first? yes
did you try to register same host in another name? yes and I try to change ipaddress too.
(btw, you don't need to remove the host at all, you can just move it between clusters, even in different DCs)
I know but we have had some problems with this node and I reinstalled it. I have created the vdms.id # mkdir /etc/vdsm; cp /proc/sys/kernel/random/uuid /etc/vdsm/vdsm.id bus same result. :(
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. Noam. ----- Original Message ----- From: "MEP" <palazzot@fedoraproject.org> To: "Itamar Heim" <iheim@redhat.com> Cc: users@ovirt.org Sent: Wednesday, June 5, 2013 11:25:21 AM Subject: Re: [Users] Last removed host from DC cannot be installed again Il 05. 06. 13 09:12, Itamar Heim ha scritto:
On 06/05/2013 05:16 AM, MEP wrote:
Hi guys! I'm running ovirt 3.2 in Fed 18 with about 100 vm in 3 DC and fc/sw storage. Yesterday I've removeded 1 DC. It's seems impossible to reuse the last host removed from the DC in another DC. The Status says "Install Failed" and in the log I find this error : duplicate key value violates unique constraint "vds_static_vds_name_unique". I afraid to corrupt SPM/db and I have not modified the relative record in the db. Changing name/ip of the server or recreating the unique id doesn't fix it. Any ideas? Is it a bug?
did you remove the host first? yes
did you try to register same host in another name? yes and I try to change ipaddress too.
(btw, you don't need to remove the host at all, you can just move it between clusters, even in different DCs)
I know but we have had some problems with this node and I reinstalled it. I have created the vdms.id # mkdir /etc/vdsm; cp /proc/sys/kernel/random/uuid /etc/vdsm/vdsm.id bus same result. :( _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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.
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?
Noam.
----- Original Message ----- From: "MEP" <palazzot@fedoraproject.org> To: "Itamar Heim" <iheim@redhat.com> Cc: users@ovirt.org Sent: Wednesday, June 5, 2013 11:25:21 AM Subject: Re: [Users] Last removed host from DC cannot be installed again
Il 05. 06. 13 09:12, Itamar Heim ha scritto:
On 06/05/2013 05:16 AM, MEP wrote:
Hi guys! I'm running ovirt 3.2 in Fed 18 with about 100 vm in 3 DC and fc/sw storage. Yesterday I've removeded 1 DC. It's seems impossible to reuse the last host removed from the DC in another DC. The Status says "Install Failed" and in the log I find this error : duplicate key value violates unique constraint "vds_static_vds_name_unique". I afraid to corrupt SPM/db and I have not modified the relative record in the db. Changing name/ip of the server or recreating the unique id doesn't fix it. Any ideas? Is it a bug?
did you remove the host first? yes
did you try to register same host in another name? yes and I try to change ipaddress too.
(btw, you don't need to remove the host at all, you can just move it between clusters, even in different DCs)
I know but we have had some problems with this node and I reinstalled it.
I have created the vdms.id # mkdir /etc/vdsm; cp /proc/sys/kernel/random/uuid /etc/vdsm/vdsm.id
bus same result. :(
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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
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
participants (3)
-
Itamar Heim -
MEP -
Noam Slomianko