[Users] Cannot add Host. Host with the same address already exists.

[Eli Mesika]

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