yahoo-eng-team team mailing list archive

[OpenStack Infra <2017680@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://review.opendev.org/c/openstack/neutron/+/881827
Committed: https://opendev.org/openstack/neutron/commit/9f6f6d5082b4341529144e992d5293675146ae88
Submitter: "Zuul (22348)"
Branch:    master

commit 9f6f6d5082b4341529144e992d5293675146ae88
Author: Fernando Royo <froyo@xxxxxxxxxx>
Date:   Fri Apr 28 16:16:27 2023 +0200

    Return 409 Conflict to tenant user deleting port attached to FIP
    
    When a tenant user try to delete a port that has attached a FIP by
    an admin user is getting a 500 ServerError.
    
    This patch improves the error to 409 Conflict doing some additionals
    checks on the delete_port method.
    
    New exception has been included locally, but will be removed as soon
    neutron-lib bumps to a newer release.
    
    Closes-Bug: 2017680
    Change-Id: Iab77c64c03fd0d44ff7a3fc1c556d85a8c480bb9


** Changed in: neutron
       Status: In Progress => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2017680

Title:
  Tenant user cannot delete a port associated with an FIP belonging to
  the admin tenant

Status in neutron:
  Fix Released

Bug description:
  When a tenant A creates a port but an admin associated a FIP to that
  port. At this point, tenant A cannot delete the port, because a
  foreign key relation with the FIP (500 server error).

  2023-04-14 10:01:49.116 277 ERROR neutron.pecan_wsgi.hooks.translation
  pymysql.err.IntegrityError: (1451, 'Cannot delete or update a parent
  row: a foreign key constraint fails (`ovs_neutron`.`floatingips`,
  CONSTRAINT `floatingips_ibfk_1` FOREIGN KEY (`fixed_port_id`)
  REFERENCES `ports` (`id`))')

  Basically the issue is the user is not allowed to disassociate the
  port from the FIP,

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/2017680/+subscriptions