Prepared statements can cause node hanging
Bug #1144911 reported by
Seppo Jaakola
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MySQL patches by Codership |
Fix Released
|
Medium
|
Seppo Jaakola | ||
| Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Fix Released
|
Undecided
|
Unassigned | ||
Bug Description
Conflicting prepared statements in multi-master use case can cause node to hang. The symptom is different in Percona XtraDB Cluster and Galera Cluster, but the underlying issue deals with prepared statement execution loop, which does not honor wsrep status codes correctly.
A good way to reproduce, is to run sysbench version 0.4 oltp mode, with high conflict rate and load balanced against two nodes, e.g. like here:
sysbench --test=oltp --oltp-auto-inc=off --oltp-
| Changed in codership-mysql: | |
| status: | New → In Progress |
| importance: | Undecided → Medium |
| assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
| milestone: | none → 5.5.29-23.7.3 |
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #1 |
| Changed in codership-mysql: | |
| status: | In Progress → Fix Committed |
| Changed in codership-mysql: | |
| status: | Fix Committed → Fix Released |
| Changed in percona-xtradb-cluster: | |
| milestone: | none → 5.5.30-23.7.4 |
| status: | New → Fix Released |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
To post a comment you must log in.
PXC suffers from unresolved BF conflict, due to the victim being in sticky CERT_FAILURE state.
GC suffers from unhandled replaying states, replaying was never started.
Both issues have a fix in revision: http://