Reviewed: https://review.opendev.org/c/openstack/neutron/+/793369 Committed: https://opendev.org/openstack/neutron/commit/a98fe51b83440693f8acf17b157c38a944ef65ef Submitter: "Zuul (22348)" Branch: master
commit a98fe51b83440693f8acf17b157c38a944ef65ef Author: Rodolfo Alonso Hernandez <[email protected]> Date: Thu May 27 10:28:13 2021 +0000 Set "floatingip.fixed_port" as viewonly Set "floatingip.fixed_port" attribute as viewonly. According to [1], "the originating relationship for a particular state change will not produce state changes within the viewonly relationship". That means any change on any of those ports won't change the backref and won't affect "floatingip" object. Closes-Bug: #1930294 [1]https://docs.sqlalchemy.org/en/14/orm/relationship_api.html Change-Id: I202a12f82f70b1094cdb986ba404f396d5e0e427 ** 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/1930294 Title: Port deletion fails due to foreign key constraint Status in neutron: Fix Released Bug description: During a VM deletion, the port cannot be deleted with the following error: http://paste.openstack.org/show/805871/ 2021-05-24 10:55:05.495 29 ERROR neutron.pecan_wsgi.hooks.translation oslo_db.exception.DBReferenceError: (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`))') 2021-05-24 10:55:05.495 29 ERROR neutron.pecan_wsgi.hooks.translation [SQL: DELETE FROM ports WHERE ports.id = %(id)s] The referred port has a floating IP assigned that is concurrently deleted. This error happens when the VM, created with Heat, is deleted. More information about the deployment in https://bugzilla.redhat.com/show_bug.cgi?id=1963903. To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1930294/+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
