Bug 2213833 - [RHOSP16.2] Duplicate entry 'xxxxxxxxxxx.localdomain' for key 'PRIMARY'
Summary: [RHOSP16.2] Duplicate entry 'xxxxxxxxxxx.localdomain' for key 'PRIMARY'
Keywords:
Status: NEW
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-nova
Version: 16.2 (Train)
Hardware: x86_64
OS: Linux
medium
medium
Target Milestone: ---
: ---
Assignee: OSP DFG:Compute
QA Contact: Eran Kuris
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2023-06-09 14:09 UTC by Luigi Tamagnone
Modified: 2023-08-08 15:27 UTC (History)
14 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed:
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
OpenStack gerrit 653506 0 None NEW Handle inactive port binding in _update_port_binding_for_instance 2023-07-12 15:42:10 UTC
Red Hat Issue Tracker OSP-25719 0 None None None 2023-06-09 14:17:34 UTC
Red Hat Knowledge Base (Solution) 6829811 0 None None None 2023-06-09 14:09:30 UTC

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)
Note You need to log in before you can comment on or make changes to this bug.