yahoo-eng-team team mailing list archive

[Prinika <nairprinikasankaran@xxxxxxxxx>]

Public bug reported:

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

** Affects: neutron
     Importance: Undecided
     Assignee: Rahul U Nair (rahulunair)
         Status: New

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