Mixed DDL/DML load crashes slaves

Bug #787959 reported by Teemu Ollakka
6
This bug affects 1 person
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/src/replicator_smm.cpp:apply_data():77
         at galera/src/replicator_smm.cpp:apply_ws():100
         at galera/src/replicator_smm.cpp:apply_wscoll():121
         at galera/src/replicator_smm.cpp:apply_trx_ws():143
         at galera/src/replicator_smm.cpp:apply_trx_ws():164
         at galera/src/replicator_smm.cpp:apply_trx():465
         at galera/src/replicator_smm.cpp:process_trx():997
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
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.