retrying SELECT queries

Bug #1076382 reported by Seppo Jaakola
6
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_autocommit is defined).
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
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

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

Changed in codership-mysql:
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.