retrying SELECT queries
Bug #1076382 reported by
Seppo Jaakola
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
Medium
|
Seppo Jaakola | ||
5.5 |
Fix Released
|
Medium
|
Seppo Jaakola |
Bug Description
Current RC (5.5.28-23.7) will retry also SELECT queries (if aborted by DDL, and wsrep_retry_
SELECT retrying is generally not safe, due to potential violation with client protocol.
This has caused regression test lp:917416 to fail intermittently.
Related branches
Changed in codership-mysql: | |
status: | New → In Progress |
importance: | Undecided → Medium |
assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
milestone: | none → 5.5.28-23.7 |
To post a comment you must log in.
A straight forward fix, by disabling retry for SELECTs has been pushed with revision: http:// bazaar. launchpad. net/~codership/ codership- mysql/wsrep- 5.5/revision/ 3818
A more optimal variant can distinguish between safe and un-safe SELECTs and allow retrying of safe SELECTs