The solution from Axel Vanzaghi worked also for me.
However to delete the rows I had to disable FOREIGN_KEY_CHECKS
SET FOREIGN_KEY_CHECKS=0; delete from instances where vm_state='deleted'; SET FOREIGN_KEY_CHECKS=1;
If anyone has a more clean solution for this, please share :)
Saverio
The solution from Axel Vanzaghi worked also for me.
However to delete the rows I had to disable FOREIGN_KEY_CHECKS
SET FOREIGN_ KEY_CHECKS= 0; KEY_CHECKS= 1;
delete from instances where vm_state='deleted';
SET FOREIGN_
If anyone has a more clean solution for this, please share :)
Saverio