yahoo-eng-team team mailing list archive

[Thomas Herve <1771293@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Found here: http://logs.openstack.org/38/567238/3/check/heat-functional-
convg-mysql-
lbaasv2-py35/295509a/logs/screen-q-svc.txt.gz#_May_14_09_25_12_996826

The following query fails:

oslo_db.exception.DBDeadlock: (pymysql.err.InternalError) (1213,
'Deadlock found when trying to get lock; try restarting transaction')
[SQL: 'UPDATE quotausages SET dirty=%(dirty)s WHERE
quotausages.project_id = %(quotausages_project_id)s AND
quotausages.resource = %(quotausages_resource)s'] [parameters: {'dirty':
1, 'quotausages_project_id': '9774958ed24f4e28b5d2f5d72863861d',
'quotausages_resource': 'network'}

The incoming DELETE API call fails with a 500.

** 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/1771293

Title:
  Deadlock with quota when deleting port

Status in neutron:
  New

Bug description:
  Found here: http://logs.openstack.org/38/567238/3/check/heat-
  functional-convg-mysql-
  lbaasv2-py35/295509a/logs/screen-q-svc.txt.gz#_May_14_09_25_12_996826

  The following query fails:

  oslo_db.exception.DBDeadlock: (pymysql.err.InternalError) (1213,
  'Deadlock found when trying to get lock; try restarting transaction')
  [SQL: 'UPDATE quotausages SET dirty=%(dirty)s WHERE
  quotausages.project_id = %(quotausages_project_id)s AND
  quotausages.resource = %(quotausages_resource)s'] [parameters:
  {'dirty': 1, 'quotausages_project_id':
  '9774958ed24f4e28b5d2f5d72863861d', 'quotausages_resource': 'network'}

  The incoming DELETE API call fails with a 500.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1771293/+subscriptions