11:10 p.m.
--_000_35e477be423f4ec3a3bce2786e32eb81tcemlmbx20phqtargetcom_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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 Mai=
ntenance". It's preventing me from removing that host and the associated c=
luster.
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 |
--_000_35e477be423f4ec3a3bce2786e32eb81tcemlmbx20phqtargetcom_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml"
xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word"
=
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html;
charset=3Diso-8859-=
1">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1"
vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello oVirt
Users,<o:p></o:p></p>
<p class=3D"MsoNormal">We have a cluster that has been decommissioned and
w=
e are trying to remove the hosts from the oVirt Engine but one host is stuc=
k in “Preparing for Maintenance”. It’s preventing
m=
e from removing that host and the associated cluster.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">The physical server has been shut down and is no
lon=
ger accessible. What’s the best way to take this server in oVir=
t Engine out of this status so we can remove the host and the cluster from =
oVirt Engine?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Thanks so much in advance and please let me know if
=
there are any questions.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><b><span
style=3D"font-size:8.0pt;color:#1F497D">Bra=
ndon Markgraf</span></b><span
style=3D"font-size:8.0pt;color:gray"> |
</span><span
style=3D"font-size:9.0pt;font-family:Wingdings;color:red">=A4<=
/span><span
style=3D"font-size:7.5pt;font-family:"Arial",sans-ser=
if;color:#999999">Target</span><span
style=3D"font-size:8.0pt;color:gray"> =
|
</span><span
style=3D"font-size:8.0pt;color:#C00000"><o:p></o:p></span></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>
--_000_35e477be423f4ec3a3bce2786e32eb81tcemlmbx20phqtargetcom_--
5:28 p.m.
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.
6:18 p.m.
New subject: [EXTERNAL] Re: oVirt: Host Removal Question
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?
-----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.
6:35 p.m.
New subject: [EXTERNAL] Re: 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.
8:42 p.m.
New subject: [EXTERNAL] Re: oVirt: Host Removal Question
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.
11:02 p.m.
New subject: [EXTERNAL] Re: oVirt: Host Removal Question
On Jun 7, 2017 18:14, "Anthony.Fillmore" <Anthony.Fillmore(a)target.com>
wrote:
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.
Hi Anthony,
This is an implementation detail, and changing the DB directly isn't
recommended.
You can probably find some documentation in the code, but we don't maintain
schema docs.
Oved
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.
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
5:50 p.m.
New subject: [EXTERNAL] Re: oVirt: Host Removal Question
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
-----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.
5:59 p.m.
New subject: [EXTERNAL] Re: 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@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.
7:02 p.m.
New subject: [EXTERNAL] Re: oVirt: Host Removal Question
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@redhat.com]
Sent: Wednesday, June 7, 2017 10:00 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 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@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.
2530
days inactive
2532
days old
8 comments
4 participants
participants (4)
-
Alexander Wels -
Anthony.Fillmore -
Brandon.Markgraf -
Oved Ourfali