Bug 1982981
| Summary: | deadlock error in neutron log about connection to MariaDB During network stack create | |||
|---|---|---|---|---|
| Product: | Red Hat OpenStack | Reporter: | Gianluca Consalvi <gconsalv> | |
| Component: | openstack-neutron | Assignee: | Rodolfo Alonso <ralonsoh> | |
| Status: | CLOSED EOL | QA Contact: | Eran Kuris <ekuris> | |
| Severity: | medium | Docs Contact: | ||
| Priority: | medium | |||
| Version: | 13.0 (Queens) | CC: | chrisw, lmiccini, ltamagno, mbayer, ralonsoh, scohen | |
| Target Milestone: | --- | Keywords: | Triaged, ZStream | |
| Target Release: | --- | |||
| Hardware: | x86_64 | |||
| OS: | Linux | |||
| Whiteboard: | ||||
| Fixed In Version: | openstack-neutron-12.1.1-47.el7ost | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1999125 (view as bug list) | Environment: | ||
| Last Closed: | 2023-07-10 17:33:55 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: | 1999125, 2001870 | |||
OSP13 support officially ended on 27 June 2023 The needinfo request[s] on this closed bug have been removed as they have been unresolved for 120 days |
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.