Public bug reported:
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.
** Affects: neutron
Importance: Undecided
Status: New
--
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:
New
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 : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
