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

[Alexander Wels]

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.