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 <[email protected]> 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 -- 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
