Public bug reported:
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/
** Affects: neutron
Importance: Medium
Assignee: Rodolfo Alonso (rodolfo-alonso-hernandez)
Status: New
** Changed in: neutron
Assignee: (unassigned) => Rodolfo Alonso (rodolfo-alonso-hernandez)
** Changed in: neutron
Importance: Undecided => Medium
--
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:
New
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
