Reviewed: https://review.opendev.org/683128 Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=ab286bcdaccb788ab9df3186e0605e93a9b10bbc Submitter: Zuul Branch: master
commit ab286bcdaccb788ab9df3186e0605e93a9b10bbc Author: Oleg Bondarev <[email protected]> Date: Thu Sep 19 16:11:06 2019 +0400 Set DB retry for quota_enforcement pecan_wsgi hook The hook starts a DB transaction and should be covered with DB retry decorator. Closes-Bug: #1777965 Closes-Bug: #1771293 Change-Id: I044980a98845edc7b0a02e3323a1e62eb54c10c7 ** Changed in: neutron Status: In Progress => Fix Released -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1777965 Title: Create port get quota related DBDeadLock Status in neutron: Fix Released Bug description: ENV: Neutron stable/queens (12.0.1) CentOS 7 (3.10.0-514.26.2.el7.x86_64) Ceph v10.2.9 Jewel Exception: 2018-06-20 14:21:52.070 140217 ERROR oslo_middleware.catch_errors DBDeadlock: (pymysql.err.InternalError) (1205, u'Lock wait timeout exceeded; try restarting transaction') [SQL: u'UPDATE quotausages SET dirty=%(dirty)s WHERE quotausages.project_id = %(quotausages_project_id)s AND quotausages.resource = %(quotausages_resource)s'] [parameters: {'quotausages_project_id': u'f4ff15be8de443b78baf21640d93132b', 'dirty': 1, 'quotausages_resource': u'port'}] (Background on this error at: http://sqlalche.me/e/2j85) API req and resp: req: 2018-06-20 14:21:35.997 140217 DEBUG neutron.api.v2.base [req-1622426f-193c-439a-ac8e-09f9cd1809e5 03570241e4ea4f2d8e52e48eabc73f8e f4ff15be8de443b78baf21640d93132b - default default] Request body: {u'port': {u'network_id': u'014d37e6-1d99-42de-8023-0859c0721ddc', u'tenant_id': u'f4ff15be8de443b78baf21640d93132b', u'device_id': u'ccdc82d7-cf7e-473d-8721-b09a91a5f10f', u'admin_state_up': True}} prepare_request_body /usr/lib/python2.7/site-packages/neutron/api/v2/base.py:690 500 resp: 2018-06-20 14:21:52.075 140217 INFO neutron.wsgi [req-1622426f-193c-439a-ac8e-09f9cd1809e5 03570241e4ea4f2d8e52e48eabc73f8e f4ff15be8de443b78baf21640d93132b - default default] 10.129.169.147 "POST /v2.0/ports HTTP/1.1" status: 500 len: 399 time: 16.0932069 LOG: http://paste.openstack.org/show/723982/ How to reproduce: Use nova boot with --min_count 300 to create 1core1g test VM. To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1777965/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
