Created attachment 1219990 [details]
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 can I reproduce this?
Looks like it was fixed upstream. Changing the external bug to link to the older discussions
Should be fixed in all versions of OSP 11.
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 . 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.
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.