----- Original Message -----
From: "Gilad Chaplik" <gchaplik(a)redhat.com>
To: "Matt ." <yamakasi.014(a)gmail.com>
Cc: "users" <users(a)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(a)gmail.com>
> To: "users" <users(a)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(a)ovirt.org
>
http://lists.ovirt.org/mailman/listinfo/users
>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users