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

[Oved Ourfali]

On Jun 7, 2017 18:14, "Anthony.Fillmore" 
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:aw...@redhat.com]
Sent: Tuesday, June 6, 2017 10:36 AM
To: Anthony.Fillmore 
Cc: users@ovirt.org; Brandon.Markgraf 
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 = 

you can figure out the id of the host by doing this

select vds_id from vds_static where vds_name=''

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:aw...@redhat.com]
> Sent: Tuesday, June 6, 2017 9:29 AM
> To: users@ovirt.org
> Cc: Brandon.Markgraf ; Anthony.Fillmore
>  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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

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

[Anthony . Fillmore]

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:aw...@redhat.com] 
Sent: Wednesday, June 7, 2017 10:00 AM
To: Anthony.Fillmore 
Cc: users@ovirt.org; Brandon.Markgraf 
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:aw...@redhat.com]
> Sent: Tuesday, June 6, 2017 10:36 AM
> To: Anthony.Fillmore 
> Cc: users@ovirt.org; Brandon.Markgraf 
> 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 = 
> 
> you can figure out the id of the host by doing this
> 
> select vds_id from vds_static where vds_name=''
> 
> 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:aw...@redhat.com]
> > Sent: Tuesday, June 6, 2017 9:29 AM
> > To: users@ovirt.org
> > Cc: Brandon.Markgraf ; Anthony.Fillmore 
> >  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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [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:aw...@redhat.com] 
Sent: Tuesday, June 6, 2017 10:36 AM
To: Anthony.Fillmore 
Cc: users@ovirt.org; Brandon.Markgraf 
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 = 

you can figure out the id of the host by doing this

select vds_id from vds_static where vds_name=''

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:aw...@redhat.com]
> Sent: Tuesday, June 6, 2017 9:29 AM
> To: users@ovirt.org
> Cc: Brandon.Markgraf ; Anthony.Fillmore 
>  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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

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

[Anthony . Fillmore]

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:aw...@redhat.com] 
Sent: Tuesday, June 6, 2017 9:29 AM
To: users@ovirt.org
Cc: Brandon.Markgraf ; Anthony.Fillmore 

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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [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:aw...@redhat.com]
> Sent: Tuesday, June 6, 2017 10:36 AM
> To: Anthony.Fillmore 
> Cc: users@ovirt.org; Brandon.Markgraf 
> 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 = 
> 
> you can figure out the id of the host by doing this
> 
> select vds_id from vds_static where vds_name=''
> 
> 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:aw...@redhat.com]
> > Sent: Tuesday, June 6, 2017 9:29 AM
> > To: users@ovirt.org
> > Cc: Brandon.Markgraf ; Anthony.Fillmore
> >  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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

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

[Alexander Wels]

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 = 

you can figure out the id of the host by doing this

select vds_id from vds_static where vds_name=''

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:aw...@redhat.com]
> Sent: Tuesday, June 6, 2017 9:29 AM
> To: users@ovirt.org
> Cc: Brandon.Markgraf ; Anthony.Fillmore
>  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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users