Thank Ian, That worked perfectly! Thanks, -Motty
On Tue, Nov 4, 2014 at 2:44 PM, Ian Service <iserv...@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.c...@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
