SELECT FOR UPDATE query will not return deadlock error if BF aborted

Bug #1187739 reported by Seppo Jaakola on 2013-06-05
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Medium
Seppo Jaakola
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
Fix Released
Undecided
Unassigned
5.6
Fix Released
Undecided
Unassigned

Bug Description

if SELECT FOR UPDATE... query is aborted due to multi-master conflict, the client will not get get back deadlock error. From client perspective the transaction is successful.

How to reproduce:

mysql-node1> BEGIN;
mysql-node1> SELECT * FROM t WHERE id=1 FOR UPDATE;

mysql-node2> DELETE FROM t WHERE id=1;

mysql-node1> COMMIT;

Changed in codership-mysql:
importance: Undecided → Medium
assignee: nobody → Seppo Jaakola (seppo-jaakola)
milestone: none → 5.5.31-23.7.5
Changed in percona-xtradb-cluster:
milestone: none → 5.5.31-24.8
Changed in percona-xtradb-cluster:
milestone: 5.5.31-23.7.5 → 5.5.31-25
Changed in codership-mysql:
milestone: 5.5.31-23.7.5 → 5.5.32-23.7.6
Changed in percona-xtradb-cluster:
milestone: 5.5.33-23.7.6 → future-5.5
Changed in codership-mysql:
milestone: 5.5.33-23.7.6 → 5.5.34-24.9
Changed in codership-mysql:
assignee: Seppo Jaakola (seppo-jaakola) → nobody
assignee: nobody → Vladislav Klyachin (klyachin)
Changed in codership-mysql:
assignee: Vladislav Klyachin (klyachin) → Seppo Jaakola (seppo-jaakola)
Seppo Jaakola (seppo-jaakola) wrote :

SELECT FOR UPDATE... test is passing for current wsrep-5.6 (revision #4012)

Changed in codership-mysql:
status: New → In Progress
Seppo Jaakola (seppo-jaakola) wrote :

and likewise, wsrep-5.5 (wsrep API #24, revision #3921) passes this test.

So we can assume that some of the past commits has fixed this issue as side effect or the bug was false positive.

Changed in codership-mysql:
status: In Progress → Fix Committed
Changed in codership-mysql:
status: Fix Committed → Fix Released

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1367

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers