Bug 2056636

Summary: ovn-controller fails to claim ports, northd reports: Transaction causes multiple rows in \"Port_Binding\" table to have identical values
Product: Red Hat Enterprise Linux Fast Datapath Reporter: Tim Rozet <trozet>
Component: OVNAssignee: Mark Michelson <mmichels>
Status: CLOSED WONTFIX QA Contact: Jianlin Shi <jishi>
Severity: medium Docs Contact:
Priority: high    
Version: FDP 19.03CC: ctrautma, jiji, mmichels
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2023-07-28 17:24:18 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Tim Rozet 2022-02-21 16:55:04 UTC
Description of problem:
prometheus pod never gets ovn-installed, even after multiple recreation attempts. Looking at the logs sbdb, nbdb looks like they stop outputting anything for a long time. One northd has an error that occurs multiple times:

2022-02-01T17:00:00.423623212Z 2022-02-01T17:00:00Z|00426|ovsdb_idl|WARN|transaction error: {"details":"Transaction causes multiple rows in \"Port_Binding\" table to have identical values (fb959166-7b3b-4e52-8418-c9ead6dbe90c and 5113) for index on columns \"datapath\" and \"tunnel_key\".  First row, with UUID d8b73ed1-fcd9-43c8-bfb5-58f9544c82da, was inserted by this transaction.  Second row, with UUID d6195d50-bbb3-4455-bd9d-b82c0402e068, existed in the database before this transaction and was not modified by the transaction.","error":"constraint violation"}


Version-Release number of selected component (if applicable):
ovn21.09-21.09.0-20.el8fdp

Workaround:
Deleting all the ovnk pods seemed to workaround the issue.

Comment 4 Mark Michelson 2023-07-28 17:24:18 UTC
I'm closing this issue since questions asked over a year ago were not answered. It's also likely no longer relevant since this has not shown up again in newer versions of OVN.