Unable to remove lab machines stuck in a state of rebooting
| ♥ 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 |
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 jameslcoleman (Questions: 2, Answers: 300) Answered on July 23, 2019 8:15 pm
|