yahoo-eng-team team mailing list archive

[OpenStack Infra <1996180@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://review.opendev.org/c/openstack/neutron/+/864215
Committed: https://opendev.org/openstack/neutron/commit/81004125c4592f2378d8434e41ec2db41a42886b
Submitter: "Zuul (22348)"
Branch:    master

commit 81004125c4592f2378d8434e41ec2db41a42886b
Author: Rodolfo Alonso Hernandez <ralonsoh@xxxxxxxxxx>
Date:   Thu Nov 10 16:43:33 2022 +0100

    [OVN] Prevent maintenance task fail resource stdattr does not exist
    
    In the maintenance task, the method that fixes the missing or not
    updated resources ``DBInconsistenciesPeriodics._fix_create_update``
    not won't exit if the resource is not found in the Neutron database.
    When the OVN revision number is bumped, now the method retrieves the
    resource standard attributes register. If this register does not
    exist, that means the resource has been deleted.
    
    The method catches the ``StandardAttributeIDNotFound`` exception and
    logs an error.
    
    Closes-Bug: #1996180
    Change-Id: Ic47c10ea2ba07347f32f75aa5de3c69e9e261780


** 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/1996180

Title:
  [OVN] "standard_attr" register missing during inconsistency check

Status in neutron:
  Fix Released

Bug description:
  During the inconsistency check, performed by a maintenance worker, the
  "ovn_revision_numbers" register failed because the
  "standardattributes" register was not present [1].

  Snippet:
  2022-11-09 05:44:50.755 21 ERROR neutron.plugins.ml2.drivers.ovn.mech_driver.ovsdb.maintenance oslo_db.exception.DBReferenceError: (pymysql.err.IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`ovs_neutron`.`ovn_revision_numbers`, CONSTRAINT `ovn_revision_numbers_ibfk_1` FOREIGN KEY (`standard_attr_id`) REFERENCES `standardattributes` (`id`) ON DELETE SET NULL)')
  2022-11-09 05:44:50.755 21 ERROR neutron.plugins.ml2.drivers.ovn.mech_driver.ovsdb.maintenance [SQL: INSERT INTO ovn_revision_numbers (standard_attr_id, resource_uuid, resource_type, revision_number, created_at, updated_at) VALUES (%(standard_attr_id)s, %(resource_uuid)s, %(resource_type)s, %(revision_number)s, now(), now())]
  2022-11-09 05:44:50.755 21 ERROR neutron.plugins.ml2.drivers.ovn.mech_driver.ovsdb.maintenance [parameters: {'standard_attr_id': 20222, 'resource_uuid': 'b21666d4-898a-44cf-bd12-2471b182f3d4', 'resource_type': 'networks', 'revision_number': -1}]

  
  [1]https://paste.opendev.org/show/bAX5MlyJtY60zWujIlGu/

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1996180/+subscriptions