Nux, Have a look at the file create_schema.sql from the git repository. As far as I know there are no cascading deletes supported and as you started deleting you'll have to follow the relations yourself. a mysql workbench is going to be your best friend right now. 'host_pod_ref' is not ref'd from just the host and pod tables.
Daan On Mon, Jun 24, 2013 at 11:35 AM, Nux! <n...@li.nux.ro> wrote: > On 22.06.2013 15:15, Nux! wrote: > >> On 22.06.2013 11:56, Nux! wrote: >> >>> On 22.06.2013 11:36, Pranav Saxena wrote: >>> >>>> Did you try deleting the physical network ? If not , try that . >>>> >>> There is no network left (other than the one for the basic zone, >>> which I need obviously). There's just the pod. >>> Where is this private range in DB? I cold try to delete it from there >>> and see if I can get rid of the pod. >>> >> >> Tried to delete the pod from the DB directly, but I'm getting this: >> >> SQL query: >> >> DELETE FROM `cloud`.`host_pod_ref` WHERE `host_pod_ref`.`id` =2 >> >> MySQL said: Documentation >> #1451 - Cannot delete or update a parent row: a foreign key >> constraint fails (`cloud`.`cluster`, CONSTRAINT `fk_cluster__pod_id` >> FOREIGN KEY (`pod_id`) REFERENCES `host_pod_ref` (`id`)) >> >> CC-ing in dev@, maybe they can advise on how to remove a Pod from the >> DB directly. >> > > Anyone? > > > -- > Sent from the Delta quadrant using Borg technology! > > Nux! > www.nux.ro >
