← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1771293] Re: Deadlock with quota when deleting port

 

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 <obondarev@xxxxxxxxxxxx>
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/1771293

Title:
  Deadlock with quota when deleting port

Status in neutron:
  Fix Released

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


References