openstack team mailing list archive

[Stefano Maffulli <stefano@xxxxxxxxxxxxx>]

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 <litong01@xxxxxxxxxx
> <mailto:litong01@xxxxxxxxxx>> 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 <phanquochien@xxxxxxxxx <mailto:phanquochien@xxxxxxxxx>>
>     To: openstack@xxxxxxxxxxxxxxxxxxx <mailto:openstack@xxxxxxxxxxxxxxxxxxx>
>     Date: 07/12/2012 02:08 PM
>     Subject: [Openstack] [nova] VM stucks in deleting task state
>     Sent by: openstack-bounces+litong01=us.ibm.com@xxxxxxxxxxxxxxxxxxx
>     <mailto:us.ibm.com@xxxxxxxxxxxxxxxxxxx>
> 
>     ------------------------------------------------------------------------
> 
> 
> 
>     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@xxxxxxxxxxxxxxxxxxx
>     <mailto:openstack@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~openstack
>     More help   : https://help.launchpad.net/ListHelp
> 
> 
>     _______________________________________________
>     Mailing list: https://launchpad.net/~openstack
>     Post to     : openstack@xxxxxxxxxxxxxxxxxxx
>     <mailto:openstack@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~openstack
>     More help   : https://help.launchpad.net/ListHelp
> 
> 
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp
>