yahoo-eng-team team mailing list archive

[Rodolfo Alonso <1996180@xxxxxxxxxxxxxxxxxx>]

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