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 -- 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