Replay aborted autocommit queries
Bug #326871 reported by
Seppo Jaakola
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MySQL patches by Codership |
Fix Released
|
Wishlist
|
Seppo Jaakola | ||
Bug Description
Autocommit queries can be aborted due to cluster wide conflict. In such situations, deadlock error code is returned to the application.
However, not all applications are prepared to deal with deadlocks with autocommit queries, and it would help in migrating to cluster usage, if cluster could automatically replay the aborted query.
There should be an option variable to enable/disable replaying of aborted autocommit queries. This might not be always, a wanted behavior.
| Changed in codership-mysql: | |
| assignee: | nobody → seppo-jaakola |
| importance: | Undecided → Wishlist |
| status: | New → In Progress |
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #1 |
| Changed in codership-mysql: | |
| status: | In Progress → Fix Committed |
| Changed in codership-mysql: | |
| milestone: | none → demo-2 |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
Appears, that the fix for this slipped in in the merge change-set 2786. It was a bit premature, but there it is now.
The fix introduces new system variable: wsrep_retry_
for telling if autocommit query retrying should happen or not.