Bug 2056636 - ovn-controller fails to claim ports, northd reports: Transaction causes multiple rows in \"Port_Binding\" table to have identical values
Summary: ovn-controller fails to claim ports, northd reports: Transaction causes multi...
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Red Hat Enterprise Linux Fast Datapath
Classification: Red Hat
Component: OVN
Version: FDP 19.03
Hardware: Unspecified
OS: Unspecified
high
medium
Target Milestone: ---
: ---
Assignee: Mark Michelson
QA Contact: Jianlin Shi
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2022-02-21 16:55 UTC by Tim Rozet
Modified: 2023-07-28 17:24 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2023-07-28 17:24:18 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker FD-1787 0 None None None 2022-02-21 17:06:46 UTC

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.


Note You need to log in before you can comment on or make changes to this bug.