yahoo-eng-team team mailing list archive

[Andreas Scheuring <andreas.scheuring@xxxxxxxxxx>]

*** 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