yahoo-eng-team team mailing list archive

[LIU Yulong <yulong@xxxxxxxxxxxxx>]

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