[ovirt-users] [EXTERNAL] Re: oVirt: Host Removal Question

[Anthony.Fillmore]

Ok - I was able to get taskcleaner.sh working.  I stopped ovirt-engine service, ran the script and cleared out active and zombie tasks.  Restarted the engine, put the host into maintenance mode and was FINALLY able to remove it.

Thanks a ton for your assistance, it is truly appreciated.

Thanks,
Tony

-----Original Message-----
From: Alexander Wels [mailto:awels at redhat.com] 
Sent: Wednesday, June 7, 2017 10:00 AM
To: Anthony.Fillmore <Anthony.Fillmore at target.com>
Cc: users at ovirt.org; Brandon.Markgraf <Brandon.Markgraf at target.com>
Subject: Re: [EXTERNAL] Re: [ovirt-users] oVirt: Host Removal Question

On Wednesday, June 7, 2017 10:50:56 AM EDT Anthony. Fillmore wrote:
> Hey Alexander,
> 
> The query pieces you gave me allowed me to successfully set the host in
> maintenance mode.   When I go to remove the host, I get the following
> error:  'Cannot remove host.  Related operation is currently in progress.' 
>  The host is not part of a datacenter, but is part of a cluster.  Any 
> other thoughts as to how to get this host removed?
> 
> Thanks,
> Tony
> 

If there is a task still running (well the database thinks a task is running as obviously the host is gone), you maybe be able to use the taskcleaner.sh utility to clear out the running task.

taskcleaner.sh -h will give you all the options.

it should be in /share/ovirt-engine/setup/dbutils/taskcleaner.sh

> -----Original Message-----
> From: Alexander Wels [mailto:awels at redhat.com]
> Sent: Tuesday, June 6, 2017 10:36 AM
> To: Anthony.Fillmore <Anthony.Fillmore at target.com>
> Cc: users at ovirt.org; Brandon.Markgraf <Brandon.Markgraf at target.com>
> Subject: Re: [EXTERNAL] Re: [ovirt-users] oVirt: Host Removal Question
> 
> On Tuesday, June 6, 2017 11:18:35 AM EDT Anthony. Fillmore wrote:
> > Hey Alexander,
> > 
> > I did those exact steps roughly two days ago...the host is still 
> > stuck in preparing for maintenance mode.  Confirming the host has 
> > been rebooted seems to have no effect.
> > 
> > Any other ideas?  Some way to hit the Ovirt Database and manipulate 
> > the value for what state the host is in?  Remove the host entirely 
> > from the back-end database?
> 
> That should have worked, but if all else fails you can always set the 
> host in maintaince in the database doing this in the engine database:
> 
> update vds_dynamic set status=2 where vds_id = <id_of_host>
> 
> you can figure out the id of the host by doing this
> 
> select vds_id from vds_static where vds_name='<name_of_host>'
> 
> If you are feeling brave you can combine the two into a single 
> statement, but I would be sure you have the right host before you do that.
> 
> Then once you have updated the status, you can refresh the webadmin 
> and the host should be in maintenaince mode and you should be able to 
> remove it normally. I would not attempt more manual manipulation of 
> the database than setting the status to 2 (which is maintenaince).
> > -----Original Message-----
> > From: Alexander Wels [mailto:awels at redhat.com]
> > Sent: Tuesday, June 6, 2017 9:29 AM
> > To: users at ovirt.org
> > Cc: Brandon.Markgraf <Brandon.Markgraf at target.com>; Anthony.Fillmore 
> > <Anthony.Fillmore at target.com> Subject: [EXTERNAL] Re: [ovirt-users] oVirt:
> > Host Removal Question
> > 
> > On Monday, June 5, 2017 4:10:54 PM EDT Brandon. Markgraf wrote:
> > > Hello oVirt Users,
> > > We have a cluster that has been decommissioned and we are trying 
> > > to remove the hosts from the oVirt Engine but one host is stuck in 
> > > "Preparing for Maintenance".  It's preventing me from removing 
> > > that host and the associated cluster.
> > > 
> > > The physical server has been shut down and is no longer accessible.
> > > What's the best way to take this server in oVirt Engine out of 
> > > this status so we can remove the host and the cluster from oVirt Engine?
> > > 
> > > Thanks so much in advance and please let me know if there are any 
> > > questions.
> > > 
> > > Brandon Markgraf | *Target |
> > 
> > IIRC when I had that issue (I removed the host physically before 
> > removing it from oVirt) I had to do the following:
> > 
> > - Right click in the grid on the host, and select confirm host has 
> > been rebooted (this is basically you telling oVirt the host has been 
> > fenced). - After a while the host should end up as down (or unknown 
> > state). - You should be able to select maintaince at that point, 
> > this might take a while (timeouts etc). - This should put the host 
> > in maintaince and you should be able to remove it then.