diff options
author | Roman Podoliaka <rpodolyaka@mirantis.com> | 2016-12-09 15:44:42 +0200 |
---|---|---|
committer | Roman Podoliaka <rpodolyaka@mirantis.com> | 2016-12-09 15:52:08 +0200 |
commit | 7c8f0f48bfb941dc1147768493bbaf81bb437d58 (patch) | |
tree | cb8f1e295432e33d0e7dabfb95bd08ff1e0222e6 | |
parent | 6bc62b047b02efd8fd6186ec0935faad975f0ffe (diff) | |
download | oslo-db-7c8f0f48bfb941dc1147768493bbaf81bb437d58.tar.gz |
exc_filters: fix deadlock detection for percona xtradb cluster
percona xtradb cluster server produces an error like:
(1213, u'WSREP detected deadlock/conflict and aborted the transaction.
Try restarting the transaction')
which is currently not detected properly and, thus, not retried.
Closes-Bug: #1648818
Change-Id: Ic43cb0e0946506a4b7ce9f94ee9eba5e025ed3d5
-rw-r--r-- | oslo_db/sqlalchemy/exc_filters.py | 2 | ||||
-rw-r--r-- | oslo_db/tests/sqlalchemy/test_exc_filters.py | 8 |
2 files changed, 10 insertions, 0 deletions
diff --git a/oslo_db/sqlalchemy/exc_filters.py b/oslo_db/sqlalchemy/exc_filters.py index d3dd9b2..9fb81c3 100644 --- a/oslo_db/sqlalchemy/exc_filters.py +++ b/oslo_db/sqlalchemy/exc_filters.py @@ -62,6 +62,8 @@ def filters(dbname, exception_type, regex): @filters("mysql", sqla_exc.DatabaseError, r"^.*\b1205\b.*Lock wait timeout exceeded.*") @filters("mysql", sqla_exc.InternalError, r"^.*\b1213\b.*Deadlock found.*") +@filters("mysql", sqla_exc.InternalError, + r"^.*\b1213\b.*detected deadlock/conflict.*") @filters("postgresql", sqla_exc.OperationalError, r"^.*deadlock detected.*") @filters("postgresql", sqla_exc.DBAPIError, r"^.*deadlock detected.*") @filters("ibm_db_sa", sqla_exc.DBAPIError, r"^.*SQL0911N.*") diff --git a/oslo_db/tests/sqlalchemy/test_exc_filters.py b/oslo_db/tests/sqlalchemy/test_exc_filters.py index 293de15..0894c3d 100644 --- a/oslo_db/tests/sqlalchemy/test_exc_filters.py +++ b/oslo_db/tests/sqlalchemy/test_exc_filters.py @@ -938,6 +938,14 @@ class TestDeadlock(TestsExceptionFilter): "transaction')" ) + def test_mysql_pymysql_wsrep_deadlock(self): + self._run_deadlock_detect_test( + "mysql", + "(1213, 'WSREP detected deadlock/conflict and aborted the " + "transaction. Try restarting the transaction')", + orig_exception_cls=self.InternalError + ) + def test_mysql_pymysql_galera_deadlock(self): self._run_deadlock_detect_test( "mysql", |