Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1993493

Summary: Duplicate entry 'xxxxxxxxxxx.localdomain' for key 'PRIMARY'
Product: Red Hat OpenStack Reporter: Jean-Francois Beaudoin <jbeaudoi>
Component: openstack-neutronAssignee: Slawek Kaplonski <skaplons>
Status: CLOSED WONTFIX QA Contact: Eran Kuris <ekuris>
Severity: medium Docs Contact:
Priority: medium    
Version: 16.1 (Train)CC: ccamposr, chrisw, dhill, enothen, fpiccion, ralonsoh, scohen
Target Milestone: ---Keywords: Triaged
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 2097160 (view as bug list) Environment:
Last Closed: 2021-10-25 13:18:52 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:
Bug Depends On:    
Bug Blocks: 2097160    

Description Jean-Francois Beaudoin 2021-08-13 14:32:25 UTC
Description of problem:
"Duplicate entry 'xxxxxxxxxxx.localdomain' for key 'PRIMARY'" mentions into neutron logs keeps re-occuring

Version-Release number of selected component (if applicable):
puppet-neutron-15.5.1-0.20200714085940.7d0406b.el8ost.noarch Wed Dec  2 16:33:18 2020
python3-neutronclient-6.14.1-0.20200629073412.a09e824.el8ost.noarch Wed Dec  2 16:28:45 2020
Red Hat OpenStack Platform release 16.1.3 GA (Train)


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:

Additional info:
2021-08-09 07:16:18.799 26 ERROR oslo_db.api oslo_db.exception.DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, "Duplicate entry 'xxxxxxxxxxxxx.localdomain' for key 'PRIMARY'")
2021-08-09 07:16:18.799 26 ERROR oslo_db.api [SQL: UPDATE ml2_port_bindings SET host=%(host)s, vif_type=%(vif_type)s, vif_details=%(vif_details)s WHERE ml2_port_bindings.port_id = %(ml2_port_bindings_port_id)s AND ml2_port_bindings.host = %(ml2_port_bindings_host)s]
2021-08-09 07:16:18.799 26 ERROR oslo_db.api [parameters: {'host': 'xxxxx.localdomain', 'vif_type': 'unbound', 'vif_details': '', 'ml2_port_bindings_port_id': 'xxxxxxxxxxxxxx', 'ml2_port_bindings_host': 'xxxxxx.localdomain'}]
2021-08-09 07:16:18.799 26 ERROR oslo_db.api (Background on this error at: http://sqlalche.me/e/gkpj)

Comment 7 Miro Tomaska 2022-08-01 13:47:01 UTC
*** Bug 2109054 has been marked as a duplicate of this bug. ***