trx replaying causes BF-BF conflict in wsrep-5.5
Bug #826554 reported by
Seppo Jaakola
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MySQL patches by Codership |
Fix Released
|
Critical
|
Seppo Jaakola | ||
| 5.5 |
Fix Released
|
Critical
|
Seppo Jaakola | ||
Bug Description
When testing with high conflict rate sqlgen load on 2 nodes in multi-master topology, a replaying transaction entered in lock conflict with slave applier
| Changed in codership-mysql: | |
| status: | New → In Progress |
| importance: | Undecided → Critical |
| assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
| milestone: | none → 1.0 |
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #1 |
| Changed in codership-mysql: | |
| status: | In Progress → Fix Committed |
To post a comment you must log in.
The test load used in this case was:
sqlgen --host=127.0.0.1 --port=3306 --user=root --password=rootpass --tables=2 --rows=50 --create=0 --duration=600 --users=8
...and glbd balanced load between 2 MySQL/Galera nodes
After the commit for lp:826913, this problem did not reproduce anymore. The problem related to replaying and sec index usage.