Public bug reported: 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. ** Affects: neutron Importance: Undecided Status: In Progress -- 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: In Progress 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
