RE: There are private IP addresses allocated for this pod
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
Re: There are private IP addresses allocated for this pod
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
RE: There are private IP addresses allocated for this pod
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. -- Sent from the Delta quadrant using Borg technology! Nux! www.nux.ro
RE: There are private IP addresses allocated for this pod
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. -- Sent from the Delta quadrant using Borg technology! Nux! www.nux.ro