Mixed DDL/DML load crashes slaves

Bug #787959 reported by Teemu Ollakka on 2011-05-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
High
Teemu Ollakka
0.8
High
Teemu Ollakka
Trunk
High
Teemu Ollakka
codership-maria
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  Edit
Everyone can see this information.

Other bug subscribers