You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by motty cruz <mo...@gmail.com> on 2014/11/04 21:28:28 UTC
Instance stuck in Expunging state - can't delete it
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_ip_address__vm_id` FOREIGN KEY (`vm_id`) REFERENCES `vm_instance`
(`id`))
mysql>
am running ACS 4.4.1 XenServer,
Thanks for your support,
Motty
Re: Instance stuck in Expunging state - can't delete it
Posted by motty cruz <mo...@gmail.com>.
Thank Ian,
That worked perfectly!
Thanks,
-Motty
On Tue, Nov 4, 2014 at 2:44 PM, Ian Service <is...@ts2.ca> 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, motty cruz <mo...@gmail.com> wrote:
>
> > 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_ip_address__vm_id` FOREIGN KEY (`vm_id`) REFERENCES
> `vm_instance`
> > (`id`))
> > mysql>
> >
> > am running ACS 4.4.1 XenServer,
> > Thanks for your support,
> > Motty
> >
>
--
Thanks for your support,
Motty
Re: Instance stuck in Expunging state - can't delete it
Posted by Ian Service <is...@ts2.ca>.
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 <mo...@gmail.com> wrote:
> 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_ip_address__vm_id` FOREIGN KEY (`vm_id`) REFERENCES `vm_instance`
> (`id`))
> mysql>
>
> am running ACS 4.4.1 XenServer,
> Thanks for your support,
> Motty
>