set removed=now()
where id=279;
> From: makrand.sa...@ipsoft.com
> To: users@cloudstack.apache.org
> Subject: RE: Stuck in expunging state
> Date: Mon, 6 Apr 2015 18:06:07 +
>
> Hi,
>
> Check VM details first. Here example vm has id as 8143.
>
> Confirm VM
Excellent suggestion. That worked perfectly!
> From: makrand.sa...@ipsoft.com
> To: users@cloudstack.apache.org
> Subject: RE: Stuck in expunging state
> Date: Mon, 6 Apr 2015 18:06:07 +
>
> Hi,
>
> Check VM details first. Here example vm has id as 8143.
>
&g
psoft.com
From: Michael Phillips
Sent: Monday, April 6, 2015 10:39 PM
To: users@cloudstack.apache.org
Subject: RE: Stuck in expunging state
Is there a way to remove an instance manually from the database?
> From: mphilli7...@hotmail.com
> To: users@cloudstack.apach
Is there a way to remove an instance manually from the database?
> From: mphilli7...@hotmail.com
> To: users@cloudstack.apache.org
> Subject: Stuck in expunging state
> Date: Mon, 6 Apr 2015 09:11:34 -0500
>
>
>
>
>
>
>
> I have a vm that won'
I have a vm that won't expunge. Upon further investigation the cloudstack log
shows the following error "Unable to expunge
VM[User|i-112-207-VM]java.lang.NullPointerException" See this screenshot
https://www.dropbox.com/s/4juutxz2v7htkg1/vm1.PNG?dl=0. In vcenter I noticed
the vm's rook vm
Thank Ian,
That worked perfectly!
Thanks,
-Motty
On Tue, Nov 4, 2014 at 2:44 PM, Ian Service wrote:
> Hey Motty,
>
> I just update the removed field to remove instances stuck in Expunging.
>
> UPDATE vm_instance SET removed=NOW() WHERE name="hd01";
>
> - Ian
>
> On Tue, Nov 4, 2014 at 3:28 PM,
Hey Motty,
I just update the removed field to remove instances stuck in Expunging.
UPDATE vm_instance SET removed=NOW() WHERE name="hd01";
- Ian
On Tue, Nov 4, 2014 at 3:28 PM, motty cruz wrote:
> Hello All,
> I have a VM instance in expungning state, I tried to delete it in the DB
> but I wa
Hello All,
I have a VM instance in expungning state, I tried to delete it in the DB
but I was not successful.
mysql> DELETE from vm_instance where name='hd01';
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
constraint fails (`cloud`.`user_ip_address`, CONSTRAINT
`fk_user_i
