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

[Anthony.Fillmore]

Awesome, this is exactly what I was looking for!  Thank you!  

One last thing - Is there a data dictionary available somewhere for the Ovirt Postgresql DB tables and views?  Some way I can view the full schema and understand what data is located where?  Documentation online seems very scarce in this regard.

Thanks again, I truly appreciate the help!

Tony

-----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.