*** This bug is a duplicate of bug 1535707 *** https://bugs.launchpad.net/bugs/1535707
Marking this as duplicate, as the root cause of both is the same. I'll expand the other bugs descirption to also cover this issue ** This bug has been marked a duplicate of bug 1535707 Create router with external network attached doesn't notify l3 agent -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1554197 Title: Deleting router-gateway-port throws a DB foreign key error Status in neutron: New Bug description: 1. High level description: Create a external network and associate to a router during creation using "--external_gateway_info type=dict network_id=" option. This creates a gateway-port. When you attempt to delete this gateway port you get a DB foreign key error as follows: "DBError: (IntegrityError) (1451, 'Cannot delete or update a pare nt row: a foreign key constraint fails (`neutron`.`routers`, CONSTRAINT `routers_ibfk_1` FOREIGN KEY (`gw_port_id`) REFERENC ES `ports` (`id`))') 'DELETE FROM ports WHERE ports.id = %s' ('76573418-f9ff-4f2d-8ffb-d0a200f7f1ea',)" 2. Pre-conditions: All resources are created as a admin tenant 3. Step-by-step reproduction steps: Steps and error message posted here: http://paste.openstack.org/show/489584/ 4. Expected output: If this action is not supported then an error message similar to following should be thrown: "More than one external network exists" 5. Actual output: we get "Request Failed: internal server error while processing your request." With a DB trace on neutron logs 6. Version: Master Branch (Mitaka) (also applicable in liberty/kilo) Devstack installation for Mitaka To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1554197/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp