Bug 1982981 - deadlock error in neutron log about connection to MariaDB During network stack create
Summary: deadlock error in neutron log about connection to MariaDB During network stac...
Keywords:
Status: CLOSED EOL
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-neutron
Version: 13.0 (Queens)
Hardware: x86_64
OS: Linux
medium
medium
Target Milestone: ---
: ---
Assignee: Rodolfo Alonso
QA Contact: Eran Kuris
URL:
Whiteboard:
Depends On:
Blocks: 1999125 2001870
TreeView+ depends on / blocked
 
Reported: 2021-07-16 08:02 UTC by Gianluca Consalvi
Modified: 2023-11-08 04:25 UTC (History)
6 users (show)

Fixed In Version: openstack-neutron-12.1.1-47.el7ost
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1999125 (view as bug list)
Environment:
Last Closed: 2023-07-10 17:33:55 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Launchpad 1939432 0 None None None 2021-08-10 17:00:39 UTC
OpenStack gerrit 804218 0 None None None 2021-08-11 09:45:07 UTC
Red Hat Issue Tracker OSP-6268 0 None None None 2021-11-15 13:07:08 UTC

Description Gianluca Consalvi 2021-07-16 08:02:59 UTC
Description of problem:
The template creates 400 port(vnf core requirement) and it seems neutron requires more time to create the port.
seems there is a deadlock error in neutron log about connection to MariaDB:
2021-07-15 11:39:26.923 45 ERROR neutron_lib.callbacks.manager       DBDeadlock: (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u'UPDATE agents SET `load`=%(load)s WHERE agents.id = %(agents_id)s'] [parameters: {'load': 4, 'agents_id': u'138c03ba-87d6-4773-b506-e197d6aaf50a'}] (Background on this error at: http://sqlalche.me/e/2j85)
      DBDeadlock: (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try r

Version-Release number of selected component (if applicable):
Openstack 13z8

How reproducible:
Network stack create

Steps to Reproduce:
1.Openstack Stack Create using a network yaml file



Actual results:
waiting 20/30 min to finish just network create(238)

Expected results:
Finish in 2/3 minutes

Additional info:
Disk SSD only for the director
The behavior is visible in all the cluster osp13z8 installed in the last year with the new Hardware (HP Gen 10)and not in the old cluster with Old HW (HP GEN 9) with the same release software.

Comment 11 Lon Hohberger 2023-07-10 17:33:55 UTC
OSP13 support officially ended on 27 June 2023

Comment 12 Red Hat Bugzilla 2023-11-08 04:25:10 UTC
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 120 days


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