yahoo-eng-team team mailing list archive

[OpenStack Infra <1930294@xxxxxxxxxxxxxxxxxx>]

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 <ralonsoh@xxxxxxxxxx>
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