Larsk Kellogg-Stedman shared a few weeks ago the tool he uses to clean up OpenStack database after messing with it:
http://markmail.org/message/gygnjvdy3njwfrtg maybe it's useful for others, too. Cheers, stef On 07/12/2012 12:48 PM, Sébastien Han wrote: > http://www.sebastien-han.fr/blog/2012/07/10/delete-a-vm-in-an-error-state/ > > > On Thu, Jul 12, 2012 at 8:34 PM, Tong Li <liton...@us.ibm.com > <mailto:liton...@us.ibm.com>> wrote: > > Hi, Hien, > I had same problem. The only way that I can get rid of it is to > remove the record for that instance from the following 3 mysql db > tables in the following order. > > security_group_instance_association > instance_info_caches > instances > > hope that helps. > > Tong Li > Emerging Technologies & Standards > > Inactive hide details for Hien Phan ---07/12/2012 02:08:58 > PM---Hello list, I've just installed Openstack Essex on Ubuntu > 12.04Hien Phan ---07/12/2012 02:08:58 PM---Hello list, I've just > installed Openstack Essex on Ubuntu 12.04. Everything works well > > From: Hien Phan <phanquoch...@gmail.com <mailto:phanquoch...@gmail.com>> > To: openstack@lists.launchpad.net <mailto:openstack@lists.launchpad.net> > Date: 07/12/2012 02:08 PM > Subject: [Openstack] [nova] VM stucks in deleting task state > Sent by: openstack-bounces+litong01=us.ibm....@lists.launchpad.net > <mailto:us.ibm....@lists.launchpad.net> > > ------------------------------------------------------------------------ > > > > Hello list, > > I've just installed Openstack Essex on Ubuntu 12.04. Everything > works well except one problem I just faced: > When I try terminate VM in dashboard. It stuck in deleting ask for > few hours until now. I can not connect VM. I try reboot using nova > command and error : > > root@openstack-node01:~# nova reboot hien-vm02 > ERROR: Cannot 'reboot' while instance is in task_state deleting > (HTTP 409) > root@openstack-node01:~# nova reboot hien-vm01 > ERROR: Cannot 'reboot' while instance is in task_state deleting > (HTTP 409) > root@openstack-node01:~# nova list > > +--------------------------------------+-----------+--------+-------------------------------------+ > | ID | Name | Status > | Networks | > > +--------------------------------------+-----------+--------+-------------------------------------+ > | b924a325-b07f-480b-9a31-3049736fbfde | hien-vm02 | ACTIVE | > private=172.16.1.35, 192.168.255.34 | > | e7908096-83e6-480d-9131-efa4ea73ca0d | hien-vm01 | ACTIVE | > private=172.16.1.34, 192.168.255.33 | > > +--------------------------------------+-----------+--------+-------------------------------------+ > > > > Openstack Dashboard screenshot image: _http://i.imgur.com/7e4cf.png_ > > How i can delete VMs completely ? > Thanks in advance. > -- > Best regards, > Phan Quoc Hien > _ > _<http://www.mrhien.info/> > _______________________________________________ > Mailing list: https://launchpad.net/~openstack > Post to : openstack@lists.launchpad.net > <mailto:openstack@lists.launchpad.net> > Unsubscribe : https://launchpad.net/~openstack > More help : https://help.launchpad.net/ListHelp > > > _______________________________________________ > Mailing list: https://launchpad.net/~openstack > Post to : openstack@lists.launchpad.net > <mailto:openstack@lists.launchpad.net> > Unsubscribe : https://launchpad.net/~openstack > More help : https://help.launchpad.net/ListHelp > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~openstack > Post to : openstack@lists.launchpad.net > Unsubscribe : https://launchpad.net/~openstack > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp