Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1394470 - keystone does not retry on deadlock Transactions [500 Error]
keystone does not retry on deadlock Transactions [500 Error]
Status: CLOSED ERRATA
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-keystone (Show other bugs)
10.0 (Newton)
Unspecified Unspecified
unspecified Severity unspecified
: Upstream M2
: 11.0 (Ocata)
Assigned To: Adam Young
nlevinki
: Triaged
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2016-11-12 06:52 EST by Attila Fazekas
Modified: 2017-05-17 15:46 EDT (History)
5 users (show)

See Also:
Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2017-05-17 15:46:13 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
keystone_exception.txt (16.43 KB, text/plain)
2016-11-12 06:52 EST, Attila Fazekas
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
Launchpad 1604862 None None None 2016-12-08 12:34 EST
Red Hat Product Errata RHEA-2017:1245 normal SHIPPED_LIVE Red Hat OpenStack Platform 11.0 Bug Fix and Enhancement Advisory 2017-05-17 19:01:50 EDT

  None (edit)
Description Attila Fazekas 2016-11-12 06:52:42 EST
Created attachment 1219990 [details]
keystone_exception.txt

Description of problem:
DBDeadlock: (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction')

The above error is retry-able error, but no evidence for keystone would really did a retry before throwing a 500.

Version-Release number of selected component (if applicable):
python-keystone.noarch              1:10.0.0-3.el7ost  @rhos-10.0-puddle        
python-keystoneauth1.noarch         2.12.2-1.el7ost    @rhos-10.0-puddle        
python-keystoneclient.noarch        1:3.5.0-1.el7ost   @rhos-10.0-puddle        
python-keystonemiddleware.noarch    4.9.0-1.el7ost     @rhos-10.0-puddle  


How reproducible:
Unknown
Comment 1 Adam Young 2016-12-08 11:52:39 EST
How can I reproduce this?
Comment 2 Adam Young 2016-12-08 11:52:50 EST
How can I reproduce this?
Comment 3 Adam Young 2016-12-08 12:34:21 EST
Looks like it was fixed upstream.  Changing the external bug to link to the older discussions
Comment 4 Adam Young 2016-12-08 12:38:52 EST
Should be fixed in all versions of OSP 11.
Comment 7 Rodrigo Duarte 2017-02-13 14:25:18 EST
verified for openstack-keystone-11.0.0-0.20170127043446.cefbc3c.el7ost.noarch

When using a MariaDB Galera cluster, the error happens due a race condition [1]. To try to reproduce the error, I've run a big concurrency rally scenario test that would create and delete several roles and projects - this triggers several revocation events. No error was reported or found in keystone logs.

Marking as verified due the lack of evidence the issue persists rather than an actual validation.

[1] http://lists.openstack.org/pipermail/openstack-dev/2015-February/056007.html
Comment 8 errata-xmlrpc 2017-05-17 15:46:13 EDT
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2017:1245

Note You need to log in before you can comment on or make changes to this bug.