Unable to remove lab machines stuck in a state of rebooting

Question ID: 109055
0
0

Hello. I have two machines that have been stuck in Lab Management in the Host State of Rebooting. I am unable to remove these machines from Lab Management because of this. I have manually rebooted these machines and tried to re install lab service on each of the host machines, but the host state has not changed from rebooting. I would like to remove them from the list. Can you help me with this?

Marked as spam
Posted by (Questions: 204, Answers: 14)
Asked on July 23, 2019 8:13 pm
4 views
Answers
0
Private answer

I have seen this before, and I was able to delete the hosts hung in a rebooting state by running the following query. If you are able to do so, I would like for you to access Site Admin and click on the 'Lab Management' tab. In the 'Lab Management' tab, you will need to expand 'LAB_PROJECT' and locate the 'LAB_HOSTS' table. You will need to run one of the following queries to delete the hosts that are hung in the rebooting state. You will need to replace 'Host_1' and 'Host_2' in the following queries with the host ID's of the affected hosts in your environment.

Deletes ONE host from the table:

DELETE FROM LAB_HOSTS WHERE HOST_ID = 'Host_1'

Deletes MULTIPLE hosts from the table:

DELETE FROM LAB_HOSTS WHERE HOST_ID LIKE 'Host_1, Host_2'

After you run the query above, go back into Lab Management, click refresh, and the affected projects should be removed from the list of hosts. I hope this helps.

Marked as spam
Posted by (Questions: 2, Answers: 265)
Answered on July 23, 2019 8:15 pm
I really appreciate it! The hosts have been removed from the list. Thanks!
( at July 23, 2019 8:15 pm)