8:42 p.m.
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@redhat.com]
Sent: Tuesday, June 6, 2017 10:36 AM
To: Anthony.Fillmore <Anthony.Fillmore(a)target.com>
Cc: users(a)ovirt.org; Brandon.Markgraf <Brandon.Markgraf(a)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@redhat.com]
Sent: Tuesday, June 6, 2017 9:29 AM
To: users(a)ovirt.org
Cc: Brandon.Markgraf <Brandon.Markgraf(a)target.com>; Anthony.Fillmore
<Anthony.Fillmore(a)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.