openstack team mailing list archive

[Jonathan Proulx <jon@xxxxxxxxxxxxx>]

Well for posterity or so people can tell me what I did wrong here's
how I seemed to convince the database that  the instance was really
deleted:

UPDATE instances SET
vm_state='deleted',task_state='deleted',deleted=1,deleted_at=now()
WHERE uuid=<FOO>

And here's what I had to do to the volume:

 UPDATE volumes SET
attach_status='detached',instance_id=NULL,mountpoint=NULL,status='available'
WHERE id=<FOO>

Any insight into how I might determine what when wrong here (essex on
ubuntu 12.04 rabbitmq mysql) or if I missed any pieces that will bite
me are appreciated.

-Jon

On Mon, Jul 30, 2012 at 1:03 PM, Jonathan Proulx <jon@xxxxxxxxxxxxx> wrote:
> Hi All,
>
> I have an instance that has been in this state for a couple days:
>
> | OS-EXT-STS:power_state              | 0                                    |
> | OS-EXT-STS:task_state               | deleting                            |
> | OS-EXT-STS:vm_state                 | error                                 |
>
> with this fault:
>
> | fault | {u'message': u'ProcessExecutionError', u'code': 500,
> u'created': u'2012-07-30T16:51:34Z'} |
>
> sending more delete requests seem to have no effect and the node it
> thinks it is on doesn't seem to have any state about it.
>
> How to I clean this up, do I just need to muck out the DB and if so
> what parts of it?
>
> Thanks,
> -Jon