Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
The FDP team is no longer accepting new bugs in Bugzilla. Please report your issues under FDP project in Jira. Thanks.

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.