OVN controllers - Transaction causes multiple rows in "Encap" table to have identical values

Issue

• OVN controllers on Edge sites fail to register with "Transaction causes multiple rows in "Encap" table to have identical values"

2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.transaction [-] Traceback (most recent call last):                                                                              
  File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/connection.py", line 128, in run                                                                                           
    txn.results.put(txn.do_commit())
  File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/transaction.py", line 86, in do_commit                                                                                     
    command.run_idl(txn)
  File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/command.py", line 168, in run_idl                                                                                          
    record = self.api.lookup(self.table, self.record)
  File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/__init__.py", line 172, in lookup                                                                                          
    return self._lookup(table, record)
  File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/__init__.py", line 215, in _lookup                                                                                         
    row = idlutils.row_by_value(self, rl.table, rl.column, record)
  File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/idlutils.py", line 130, in row_by_value                                                                                    
    raise RowNotFound(table=table, col=column, match=match)
ovsdbapp.backend.ovs_idl.idlutils.RowNotFound: Cannot find Chassis_Private with name=9ec08d48-23a3-447e-9da7-71a171d38ac0                                                                    

2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command [-] Error executing command: ovsdbapp.backend.ovs_idl.idlutils.RowNotFound: Cannot find Chassis_Private with name=9ec08d48-23a3-447e-9da7-71a171d38ac0
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command Traceback (most recent call last):                                                                                      
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/api.py", line 111, in transaction                                     
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     yield self._nested_txns_map[cur_thread_id]                                                                          
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command KeyError: 140241704471744
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command During handling of the above exception, another exception occurred:                                                     
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command Traceback (most recent call last):                                                                                      
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/command.py", line 42, in execute                      
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     t.add(self)
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib64/python3.6/contextlib.py", line 88, in __exit__                                                       
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     next(self.gen)
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/api.py", line 119, in transaction                                     
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     del self._nested_txns_map[cur_thread_id]                                                                            
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/api.py", line 69, in __exit__                                         
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     self.result = self.commit()                                                                                         
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/transaction.py", line 62, in commit                   
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     raise result.ex
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/connection.py", line 128, in run                      
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     txn.results.put(txn.do_commit())                                                                                    
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/transaction.py", line 86, in do_commit                
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     command.run_idl(txn)
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/command.py", line 168, in run_idl                     
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     record = self.api.lookup(self.table, self.record)                                                                   
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/__init__.py", line 172, in lookup                     
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     return self._lookup(table, record)                                                                                  
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/__init__.py", line 215, in _lookup                    
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     row = idlutils.row_by_value(self, rl.table, rl.column, record)                                                      
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command   File "/usr/lib/python3.6/site-packages/ovsdbapp/backend/ovs_idl/idlutils.py", line 130, in row_by_value               
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command     raise RowNotFound(table=table, col=column, match=match)                                                             
2021-04-12 09:14:09.814 64258 ERROR ovsdbapp.backend.ovs_idl.command ovsdbapp.backend.ovs_idl.idlutils.RowNotFound: Cannot find Chassis_Private with name=9ec08d48-23a3-447e-9da7-71a171d38ac0

• openvswitch/ovn-controller.log

2021-04-12T09:14:48.994Z|04753|ovsdb_idl|WARN|Dropped 56170 log messages in last 60 seconds (most recently, 0 seconds ago) due to excessive rate                                             
2021-04-12T09:14:48.994Z|04754|ovsdb_idl|WARN|transaction error: {"details":"Transaction causes multiple rows in \"Encap\" table to have identical values (geneve and \"10.14.2.7\") for index on columns \"type\" and \"ip\".  First row, with UUID 3973cad5-eb8a-4f29-85c3-c105d861c0e0, was inserted by this transaction.  Second row, with UUID f06b71a8-4162-475b-8542-d27db3a9097a, existed in the database before this transaction and was not modified by the transaction.","error":"constraint violation"}                                                                      
2021-04-12T09:15:48.993Z|04755|ovsdb_idl|WARN|Dropped 55709 log messages in last 60 seconds (most recently, 0 seconds ago) due to excessive rate                                             
2021-04-12T09:15:48.993Z|04756|ovsdb_idl|WARN|transaction error: {"details":"Transaction causes multiple rows in \"Encap\" table to have identical values (geneve and \"10.14.2.7\") for index on columns \"type\" and \"ip\".  First row, with UUID f06b71a8-4162-475b-8542-d27db3a9097a, existed in the database before this transaction and was not modified by the transaction.  Second
row, with UUID f81c3e8c-8c24-41bc-95a1-3a1ced147ebb, was inserted by this transaction.","error":"constraint violation"}                                                                      
2021-04-12T09:16:48.993Z|04757|ovsdb_idl|WARN|Dropped 55070 log messages in last 60 seconds (most recently, 0 seconds ago) due to excessive rate                                             
2021-04-12T09:16:48.993Z|04758|ovsdb_idl|WARN|transaction error: {"details":"Transaction causes multiple rows in \"Encap\" table to have identical values (geneve and \"10.14.2.7\") for index on columns \"type\" and \"ip\".  First row, with UUID 87a8ee7a-a0fb-4600-a05a-8f6af6a609ba, was inserted by this transaction.  Second row, with UUID f06b71a8-4162-475b-8542-d27db3a9097a, existed in the database before this transaction and was not modified by the transaction.","error":"constraint violation"}