yahoo-eng-team team mailing list archive

[Rodolfo Alonso <1930294@xxxxxxxxxxxxxxxxxx>]

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