cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From motty cruz <motty.c...@gmail.com>
Subject Re: Instance stuck in Expunging state - can't delete it
Date Tue, 04 Nov 2014 23:03:36 GMT
Thank Ian,
That worked perfectly!

Thanks,
-Motty

On Tue, Nov 4, 2014 at 2:44 PM, Ian Service <iservice@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 <motty.cruz@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message