[ovn] transaction error: {"details":"Transaction causes multiple rows in \"MAC_Binding\" table to have identical values

Bug #1868697 reported by Michal Nasiadka
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
neutron
Triaged
Medium
Unassigned

Bug Description

In Kolla-Ansible OVN CI we noticed following entries in OVN Controller logs:

2020-03-21T11:41:45.067Z|00013|ovsdb_idl|WARN|transaction error: {"details":"Transaction causes multiple rows in \"MAC_Binding\" table to have identical values (\"lrp-0bf65362-bb2e-41e0-8ee9-fbff0d063221\" and \"::\") for index on columns \"logical_port\" and \"ip\". First row, with UUID 31fe10d5-989a-4631-a07d-008c30a5f665, existed in the database before this transaction and was not modified by the transaction. Second row, with UUID 6ea1e391-1efa-403f-9399-9d33815c2d74, was inserted by this transaction.","error":"constraint violation"}
17 2020-03-21T11:41:45.067Z|00014|main|INFO|OVNSB commit failed, force recompute next time.

Link to Zuul build logs:
CentOS8:
https://zuul.opendev.org/t/openstack/build/48a2db8d271c4b8bb305d108c34e4e07/log/primary/logs/kolla/openvswitch/ovn-controller.txt#16
https://zuul.opendev.org/t/openstack/build/48a2db8d271c4b8bb305d108c34e4e07/log/

Ubuntu:
https://zuul.opendev.org/t/openstack/build/c118f9e862e247468360fa78d1409833/log/primary/logs/kolla/openvswitch/ovn-controller.txt#18
https://zuul.opendev.org/t/openstack/build/c118f9e862e247468360fa78d1409833/log/

Tags: ovn
Revision history for this message
Maciej Jozefczyk (maciejjozefczyk) wrote :

I saw it a few times but I haven't found why.

Changed in neutron:
importance: Undecided → Medium
status: New → Triaged
Revision history for this message
Reason li (lireason) wrote :

Verify that two gateways are added to the router. This happens when one interface is bound to a gateway chassis and another interface is bound to a gateway chassis.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.