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';