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 >
