How to remove compute node from havana

rdo

asked 2013-12-07 11:51:20 -0500

Alin Calinciuc
51 ●2 ●2 ●2

updated 2014-02-03 21:48:49 -0500

scott-devoid
433 ●3 ●4 ●9

Does anyone knows how to remove a node from openstack, I have to mention it is a host that I newly added to cluster , and after that I renamed it, it never had an instances on it or anything else. Now it appears under the hypervisors list and service list. Is there a safe way I can remove it ? I tried : http://pic.dhe.ibm.com/infocenter/tivihelp/v48r1/index.jsp?topic=%2Fcom.ibm.sco.doc_2.2%2Ft_deleting_computenodes.html but it didn't work.

edit retag flag offensive close merge delete

Comments

1

In my Juno deployment I have successfully used nova service-delete <id> to delete the dead nodes, where <id> can be found from nova service-list. However it will mark the corresponding records as deleted but not completely remove them.

wangrich ( 2015-10-24 03:00:58 -0500 )edit

add a comment

5

answered 2014-02-03 03:51:10 -0500

desalvo
121 ●6 ●9 ●11

Hi, actually it seems to be a little more complex. I've recently done it with the following 3 queries:

mysql -u root -p
use nova;
delete from compute_node_stats where compute_node_id=(select cn.id from compute_nodes cn, services s where cn.service_id=s.id and s.host='hostname');
delete from compute_nodes where service_id=(select id from services where host='hostname');
delete from services where host='hostname';

Hope it helps,

Alessandro

edit flag offensive delete link

Comments

1

I don't think that you shoud mess up directly with the database content, it's not very safe.

smaffulli ( 2014-09-03 18:38:42 -0500 )edit

In general you are right, but in havana there is no other way to do that, else than changing the database (which does not impact anything, btw). In icehouse there is an API to do that, so it's not needed anymore.

desalvo ( 2014-09-04 03:47:03 -0500 )edit

@desalvo Can you show me where I can find the API to do this in icehouse?

ADN ( 2015-03-15 22:24:36 -0500 )edit

deleted compute node is still visible in GUI, how to remove it from there also?

snd0cff ( 2020-03-24 06:00:39 -0500 )edit

add a comment

2

answered 2013-12-07 23:29:29 -0500

dheeru

2748 ●15 ●31 ●42

updated 2014-09-03 18:40:30 -0500

smaffulli
6981 ●38 ●68 ●102 http://maffulli.net/

Few options for you. Since you said that you don't have any instances. Just for maintenance you would like to delete.

nova-manage service disable <service-name> <host-name>. This may not be required as you would like to delete it.
Login to nova database and see the service table. Delete the particular entry. This looks better for you case.

$ mysql -u root -p
use nova;
select * from service;
Now you identify the compute node form above query and delete using SQL Query. If you want the readymade query I can give after sometime. i don't have access to my install now.