2:12 a.m.
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)
3:25 a.m.
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. :(
2:53 a.m.
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(a)fedoraproject.org>
To: "Itamar Heim" <iheim(a)redhat.com>
Cc: users(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
4:36 a.m.
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(a)fedoraproject.org>
To: "Itamar Heim" <iheim(a)redhat.com>
Cc: users(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
6:07 a.m.
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
6:12 a.m.
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
3971
days inactive
3976
days old
6 comments
3 participants
participants (3)
-
Itamar Heim -
MEP -
Noam Slomianko