Bug 2213833

Summary: [RHOSP16.2] Duplicate entry 'xxxxxxxxxxx.localdomain' for key 'PRIMARY'
Product: Red Hat OpenStack Reporter: Luigi Tamagnone <ltamagno>
Component: openstack-novaAssignee: OSP DFG:Compute <osp-dfg-compute>
Status: NEW --- QA Contact: Eran Kuris <ekuris>
Severity: medium Docs Contact:
Priority: medium    
Version: 16.2 (Train)CC: alifshit, bgibizer, chrisw, dasmith, egarciar, eglynn, jhakimra, kchamart, osp-dfg-compute, sbauza, scohen, sgordon, twilson, vromanso
Target Milestone: ---Keywords: Triaged
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Luigi Tamagnone 2023-06-09 14:09:31 UTC 
This bug was initially created as a copy of Bug #1993493 

I am copying this bug because: A customer on RHOSP16.2 faced a similar issue.

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.6.0-2.20211210020612.914b228.el8ost.noarch Fri Mar 11 02:04:27 2022
python3-neutronclient-6.14.1-2.20220111010835.a09e824.el8ost.noarch Fri Mar 11 01:59:30 2022
[rhosp-release] Red Hat OpenStack Platform release 16.2.2 (Train)


How reproducible:
I'm not sure probably after live migration failed.

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)