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 <[email protected]> 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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
