Public bug reported: 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, ** Affects: neutron Importance: Undecided Assignee: Fernando Royo (froyoredhat) Status: New ** Changed in: neutron Assignee: (unassigned) => Fernando Royo (froyoredhat) -- 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: New 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 : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp