Query cache usage can cause hanging
Bug #359162 reported by
Seppo Jaakola
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
Low
|
Seppo Jaakola | ||
0.8 |
Fix Released
|
Low
|
Seppo Jaakola |
Bug Description
Observed with sqlgen testing a hanging situation, when query cache was enabled. Following sqlgen parameters used:
* tables 50
* rows 1000
* nodes 2
* users 10
* r/w ratio: 50/50
* trans-min 2, tans-max 4
Query cache was enable on both nodes.
Both nodes were hanging after few minutes of test running
Changed in codership-mysql: | |
milestone: | 0.6.1 → 0.7 |
Changed in codership-mysql: | |
milestone: | 0.7 → 0.8 |
Changed in codership-mysql: | |
status: | In Progress → Confirmed |
Changed in codership-mysql: | |
milestone: | 0.8 → none |
Changed in codership-mysql: | |
milestone: | none → 0.7.4 |
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Problem does not reproduce with debug build.
gdb session shows that other node has a hanging slave applier thread inside Query_cache: :invalidate_ table()