<div dir="ltr"><div><div>Hi,<br><br>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.<br><br></div>I need to check the logs later on, if I find something I will post it!<br>
<br></div>Thanks!<br><br>Cheers,<br><br>Matt<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014/1/5 Gilad Chaplik <span dir="ltr"><<a href="mailto:gchaplik@redhat.com" target="_blank">gchaplik@redhat.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Matt,<br>
<br>
connect to DB and run:<br>
select vds_id from vds_static where host_name = 'HOST_NAME';<br>
I guess these 3 delete queries will cover it:<br>
delete from vds_statistics where vds_id = 'id';<br>
delete from vds_dynamic where vds_id = 'id';<br>
delete from from vds_static where vds_id = 'id';<br>
<br>
Can you please provide the engine logs that we'll find out what went wrong?<br>
<br>
Thanks,<br>
Gilad.<br>
<div><div class="h5"><br>
----- Original Message -----<br>
> From: "Matt ." <<a href="mailto:yamakasi.014@gmail.com">yamakasi.014@gmail.com</a>><br>
> To: "users" <<a href="mailto:users@ovirt.org">users@ovirt.org</a>><br>
> Sent: Sunday, January 5, 2014 8:09:05 PM<br>
> Subject: [Users] Cannot add Host. Host with the same address already exists.<br>
><br>
> Hi All,<br>
><br>
> Ovirt 3.3.3<br>
><br>
> I have removed a host from the gui and want to re-add it, there was something<br>
> wrong with the installation of this host.<br>
><br>
> When adding the host I get: "Error while executing action: Cannot add Host.<br>
> Host with the same address already exists."<br>
><br>
> It seems that the host is still in the DB somewhere and it is, I see some<br>
> NULL columns for that host because it's actually not really "there" anymore<br>
> and stuff like statics are not updated.<br>
><br>
> I need to clean this one out, how can I accomplish this without getting a<br>
> "dirty" DB ?<br>
><br>
> Thanks!<br>
><br>
> Cheers,<br>
><br>
> Matt<br>
><br>
</div></div>> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
><br>
</blockquote></div><br></div>