[Users] Cannot add Host. Host with the same address already exists.
Hi All, Ovirt 3.3.3 I have removed a host from the gui and want to re-add it, there was something wrong with the installation of this host. When adding the host I get: "Error while executing action: Cannot add Host. Host with the same address already exists." It seems that the host is still in the DB somewhere and it is, I see some NULL columns for that host because it's actually not really "there" anymore and stuff like statics are not updated. I need to clean this one out, how can I accomplish this without getting a "dirty" DB ? Thanks! Cheers, Matt
Hi Matt, connect to DB and run: select vds_id from vds_static where host_name = 'HOST_NAME'; I guess these 3 delete queries will cover it: delete from vds_statistics where vds_id = 'id'; delete from vds_dynamic where vds_id = 'id'; delete from from vds_static where vds_id = 'id'; Can you please provide the engine logs that we'll find out what went wrong? Thanks, Gilad. ----- Original Message -----
From: "Matt ." <yamakasi.014@gmail.com> To: "users" <users@ovirt.org> Sent: Sunday, January 5, 2014 8:09:05 PM Subject: [Users] Cannot add Host. Host with the same address already exists.
Hi All,
Ovirt 3.3.3
I have removed a host from the gui and want to re-add it, there was something wrong with the installation of this host.
When adding the host I get: "Error while executing action: Cannot add Host. Host with the same address already exists."
It seems that the host is still in the DB somewhere and it is, I see some NULL columns for that host because it's actually not really "there" anymore and stuff like statics are not updated.
I need to clean this one out, how can I accomplish this without getting a "dirty" DB ?
Thanks!
Cheers,
Matt
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Hi, Thanks, I saw this information indeed in the views and the tables you have me, I was not 100% sure if everything was in it. I need to check the logs later on, if I find something I will post it! Thanks! Cheers, Matt 2014/1/5 Gilad Chaplik <gchaplik@redhat.com>
Hi Matt,
connect to DB and run: select vds_id from vds_static where host_name = 'HOST_NAME'; I guess these 3 delete queries will cover it: delete from vds_statistics where vds_id = 'id'; delete from vds_dynamic where vds_id = 'id'; delete from from vds_static where vds_id = 'id';
Can you please provide the engine logs that we'll find out what went wrong?
Thanks, Gilad.
----- Original Message -----
From: "Matt ." <yamakasi.014@gmail.com> To: "users" <users@ovirt.org> Sent: Sunday, January 5, 2014 8:09:05 PM Subject: [Users] Cannot add Host. Host with the same address already exists.
Hi All,
Ovirt 3.3.3
I have removed a host from the gui and want to re-add it, there was something wrong with the installation of this host.
When adding the host I get: "Error while executing action: Cannot add Host. Host with the same address already exists."
It seems that the host is still in the DB somewhere and it is, I see some NULL columns for that host because it's actually not really "there" anymore and stuff like statics are not updated.
I need to clean this one out, how can I accomplish this without getting a "dirty" DB ?
Thanks!
Cheers,
Matt
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
----- Original Message -----
From: "Gilad Chaplik" <gchaplik@redhat.com> To: "Matt ." <yamakasi.014@gmail.com> Cc: "users" <users@ovirt.org> Sent: Sunday, January 5, 2014 8:37:48 PM Subject: Re: [Users] Cannot add Host. Host with the same address already exists.
Hi Matt,
connect to DB and run: select vds_id from vds_static where host_name = 'HOST_NAME'; I guess these 3 delete queries will cover it: delete from vds_statistics where vds_id = 'id'; delete from vds_dynamic where vds_id = 'id'; delete from from vds_static where vds_id = 'id';
It is always safer to use the SP that is actually called by the DAO when we do that : DeleteVds(v_vds_id UUID) This will clean also permissions and other stuff ...
Can you please provide the engine logs that we'll find out what went wrong?
Thanks, Gilad.
----- Original Message -----
From: "Matt ." <yamakasi.014@gmail.com> To: "users" <users@ovirt.org> Sent: Sunday, January 5, 2014 8:09:05 PM Subject: [Users] Cannot add Host. Host with the same address already exists.
Hi All,
Ovirt 3.3.3
I have removed a host from the gui and want to re-add it, there was something wrong with the installation of this host.
When adding the host I get: "Error while executing action: Cannot add Host. Host with the same address already exists."
It seems that the host is still in the DB somewhere and it is, I see some NULL columns for that host because it's actually not really "there" anymore and stuff like statics are not updated.
I need to clean this one out, how can I accomplish this without getting a "dirty" DB ?
Thanks!
Cheers,
Matt
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (3)
-
Eli Mesika -
Gilad Chaplik -
Matt .