<div dir="auto"><div><br><div class="gmail_extra"><br><div class="gmail_quote">On Jun 7, 2017 18:14, "Anthony.Fillmore" <<a href="mailto:Anthony.Fillmore@target.com">Anthony.Fillmore@target.com</a>> wrote:<br type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Awesome, this is exactly what I was looking for! Thank you!<br>
<br>
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.<br></blockquote></div></div></div><div dir="auto"><br></div><div dir="auto">Hi Anthony, </div><div dir="auto"><br></div><div dir="auto">This is an implementation detail, and changing the DB directly isn't recommended. </div><div dir="auto"><br></div><div dir="auto">You can probably find some documentation in the code, but we don't maintain schema docs. </div><div dir="auto"><br></div><div dir="auto">Oved</div><div dir="auto"><br></div><div dir="auto"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Thanks again, I truly appreciate the help!<br>
<br>
Tony<br>
<div class="quoted-text"><br>
-----Original Message-----<br>
From: Alexander Wels [mailto:<a href="mailto:awels@redhat.com">awels@redhat.com</a>]<br>
</div><div class="elided-text">Sent: Tuesday, June 6, 2017 10:36 AM<br>
To: Anthony.Fillmore <<a href="mailto:Anthony.Fillmore@target.com">Anthony.Fillmore@target.com</a>><br>
Cc: <a href="mailto:users@ovirt.org">users@ovirt.org</a>; Brandon.Markgraf <<a href="mailto:Brandon.Markgraf@target.com">Brandon.Markgraf@target.com</a>><br>
Subject: Re: [EXTERNAL] Re: [ovirt-users] oVirt: Host Removal Question<br>
<br>
On Tuesday, June 6, 2017 11:18:35 AM EDT Anthony. Fillmore wrote:<br>
> Hey Alexander,<br>
><br>
> I did those exact steps roughly two days ago...the host is still stuck<br>
> in preparing for maintenance mode. Confirming the host has been<br>
> rebooted seems to have no effect.<br>
><br>
> Any other ideas? Some way to hit the Ovirt Database and manipulate<br>
> the value for what state the host is in? Remove the host entirely<br>
> from the back-end database?<br>
><br>
<br>
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:<br>
<br>
update vds_dynamic set status=2 where vds_id = <id_of_host><br>
<br>
you can figure out the id of the host by doing this<br>
<br>
select vds_id from vds_static where vds_name='<name_of_host>'<br>
<br>
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.<br>
<br>
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).<br>
<br>
> -----Original Message-----<br>
> From: Alexander Wels [mailto:<a href="mailto:awels@redhat.com">awels@redhat.com</a>]<br>
> Sent: Tuesday, June 6, 2017 9:29 AM<br>
> To: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
> Cc: Brandon.Markgraf <<a href="mailto:Brandon.Markgraf@target.com">Brandon.Markgraf@target.com</a>>; Anthony.Fillmore<br>
> <<a href="mailto:Anthony.Fillmore@target.com">Anthony.Fillmore@target.com</a>> Subject: [EXTERNAL] Re: [ovirt-users] oVirt:<br>
> Host Removal Question<br>
> On Monday, June 5, 2017 4:10:54 PM EDT Brandon. Markgraf wrote:<br>
> > Hello oVirt Users,<br>
> > We have a cluster that has been decommissioned and we are trying to<br>
> > remove the hosts from the oVirt Engine but one host is stuck in<br>
> > "Preparing for Maintenance". It's preventing me from removing that<br>
> > host and the associated cluster.<br>
> ><br>
> > The physical server has been shut down and is no longer accessible.<br>
> > What's the best way to take this server in oVirt Engine out of this<br>
> > status so we can remove the host and the cluster from oVirt Engine?<br>
> ><br>
> > Thanks so much in advance and please let me know if there are any<br>
> > questions.<br>
> ><br>
> > Brandon Markgraf | *Target |<br>
><br>
> IIRC when I had that issue (I removed the host physically before<br>
> removing it from oVirt) I had to do the following:<br>
><br>
> - Right click in the grid on the host, and select confirm host has<br>
> been rebooted (this is basically you telling oVirt the host has been<br>
> fenced). - After a while the host should end up as down (or unknown<br>
> state). - You should be able to select maintaince at that point, this<br>
> might take a while (timeouts etc). - This should put the host in<br>
> maintaince and you should be able to remove it then.<br>
<br>
<br>
<br>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
</div></blockquote></div><br></div></div></div>