<p>This conversation is fine but if I want to force remove no matter what I should be able to from the GUI. The nodes are no longer available I want to get rid of them ovirt does not let me. I can delete from database but why not from the GUI? I am sure others may run into this problem as well.</p>
<p>Dominic</p>
<div class="gmail_quote">On Sep 22, 2012 4:19 PM, "Eli Mesika" <<a href="mailto:emesika@redhat.com">emesika@redhat.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
----- Original Message -----<br>
> From: "Douglas Landgraf" <<a href="mailto:dougsland@redhat.com">dougsland@redhat.com</a>><br>
> To: "Dominic Kaiser" <<a href="mailto:dominic@bostonvineyard.org">dominic@bostonvineyard.org</a>><br>
> Cc: "Eli Mesika" <<a href="mailto:emesika@redhat.com">emesika@redhat.com</a>>, <a href="mailto:users@ovirt.org">users@ovirt.org</a>, "Robert Middleswarth" <<a href="mailto:robert@middleswarth.net">robert@middleswarth.net</a>><br>
> Sent: Friday, September 21, 2012 8:12:27 PM<br>
> Subject: Re: [Users] Is there a way to force remove a host?<br>
><br>
> Hi Dominic,<br>
><br>
> On 09/20/2012 12:11 PM, Dominic Kaiser wrote:<br>
> > Sorry I did not explain.<br>
> ><br>
> > I had tried to remove the host and had not luck troubleshooting it.<br>
> > I<br>
> > then had removed it and used it for a storage unit reinstalling<br>
> > fedora<br>
> > 17. I foolishly thought that I could just remove the host<br>
> > manually.<br>
> > It physically is not there. (My fault I know) Is there a way that<br>
> > you know of to remove a host brute force.<br>
> ><br>
> > dk<br>
><br>
> Fell free to try the below script (not part of official project) for<br>
> brute force:<br>
><br>
> (from the engine side)<br>
> # yum install python-psycopg2 -y<br>
> # wget<br>
> <a href="https://raw.github.com/dougsland/misc-rhev/master/engine_force_remove_Host.py" target="_blank">https://raw.github.com/dougsland/misc-rhev/master/engine_force_remove_Host.py</a><br>
> # (edit the file and change the db password)<br>
> # python ./engine_force_remove_Host.py<br>
<br>
Hi , had looked in the Python script you had provided:<br>
First, I must say that handling the database directly may leave DB in inconsistent state, therefore, if there is no other option, the database should be backed up prior to this operation.<br>
In addition, I do not like the execution of the SQL statements in the script.<br>
There is a SP called DeleteVds(v_vds_id UUID) and you should use that since it encapsulates all details.<br>
For example, your script does not handle permission clean-up as the SP does and therefore leaves garbage in the database.<br>
In addition, a failure in your script may leave database in inconsistent state while the SP is executed in one transaction and will leave DB consistent.<br>
So, in short I would prefer in this case that the relevant SP will do the clean-up since this is the one that is used by the code and that insures (at least I hope so) , that all related entities are removed as well.<br>
<br>
<br>
><br>
> Thanks<br>
><br>
> --<br>
> Cheers<br>
> Douglas<br>
><br>
><br>
</blockquote></div>