Mixed DDL/DML load crashes slaves
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
High
|
Teemu Ollakka | ||
0.8 |
Fix Released
|
High
|
Teemu Ollakka | ||
Trunk |
Fix Committed
|
High
|
Teemu Ollakka | ||
codership-maria |
Fix Committed
|
High
|
Unassigned |
Bug Description
To reproduce, first start DML load:
./bin/sqlgen --host 127.0.0.1 --port 3306 --rows 1000 --tables 2 --duration 36000 --create 1 --users 8
Then start DROP/CREATE tables on background:
while true; do ./bin/sqlgen --host 127.0.0.1 --port 3306 --rows 1000 --tables 2 --users 0 --duration 0; sleep 1; done
After a while slaves fail to apply RBR event:
110512 12:07:17 [ERROR] Slave SQL: Error 'Table 'test.comm00' doesn't exist' on opening tables, Error_code: 1146
110512 12:07:17 [Warning] WSREP: RBR event 2 apply warning: 1146, 1963723
110512 12:07:17 [ERROR] WSREP: Failed to apply app buffer: U��M, seqno: 1963723, status: WSREP_FATAL
at galera/
at galera/
at galera/
at galera/
at galera/
at galera/
at galera/
110512 12:07:17 [Note] WSREP: recv thread exiting (code:6)
Related branches
Changed in codership-maria: | |
importance: | Undecided → High |
Changed in codership-maria: | |
status: | New → Fix Committed |
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |