FTWRL conflicts with slave appliers
Bug #930221 reported by
Seppo Jaakola
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MySQL patches by Codership |
Fix Released
|
High
|
Seppo Jaakola | ||
Bug Description
FLush table with read locks can conflict with slave applying and remain hanging for indefinitely long period. This problem can occur during rsync SST
To reproduce,:
1. start two nodes and use them as master slave pair.
2. run heavy SQL laod against node 1, e.g.:
sqlgen --host 0 --port 3307 --users 12 --create 1 --duration 3600 --rows 1000 --ac-frac 100
3. run FTWRL commands for node 2 in a loop
Node 2 should hang pretty soon
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #1 |
| Changed in codership-mysql: | |
| status: | New → In Progress |
| importance: | Undecided → High |
| assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
| milestone: | none → 5.5.20-23.4 |
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #2 |
| Changed in codership-mysql: | |
| status: | In Progress → Fix Committed |
| Changed in codership-mysql: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
This issue closely relates to MDL issues in: https:/