----- Original Message ----- > From: "Gilad Chaplik" <[email protected]> > To: "Matt ." <[email protected]> > Cc: "users" <[email protected]> > 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 ." <[email protected]> > > To: "users" <[email protected]> > > 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 > > [email protected] > > http://lists.ovirt.org/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.ovirt.org/mailman/listinfo/users > _______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
