Could not execute Delete_rows event

Bug #792797 reported by Teemu Ollakka
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Fix Released
Critical
Teemu Ollakka
0.8
Fix Released
Critical
Teemu Ollakka
Trunk
Fix Committed
Critical
Teemu Ollakka
codership-maria
Fix Committed
Undecided
Unassigned

Bug Description

Three nodes, running insert/delete sqlgen load: /bin/sqlgen --host 127.0.0.1 --port 3307 --rows 500 --tables 4 --duration 3600 --create 1 --users 12 --drops 0 --alters 0 --selects 0 updates 0 --inserts 100

Two of the nodes failed to apply:

110604 16:44:47 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.comm03; Can't find record in 'comm03', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 610, Error_code: 1032
110604 16:44:47 [Warning] WSREP: RBR event 11 apply warning: 120, 582593
110604 16:44:47 [ERROR] WSREP: failed to apply trx: source: 229e1702-8eb1-11e0-0800-9f9f934a00f9 state: CERTIFYING flags: 1 conn_id: 1800 trx_id: 452610469 seqnos (l: 65268, g: 582593, s: 582591, d: 582592, ts: 1307195424256766908)
110604 16:44:47 [ERROR] WSREP: Failed to apply app buffer: 8�M, seqno: 582593, 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():172
         at galera/src/replicator_smm.cpp:apply_trx():474
         at galera/src/replicator_smm.cpp:process_trx():1015

One of the nodes (apparently master for transaction) failed to replay:

110604 13:50:24 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.comm03; Can't find record in 'comm03', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 610, Error_code: 1032
110604 13:50:24 [Warning] WSREP: RBR event 11 apply warning: 120, 582593
110604 13:50:24 [Warning] WSREP: Failed to apply app buffer: 8<EA>M^S, seqno: 582593, 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():172
         at galera/src/replicator_smm.cpp:replay_trx():805

Related branches

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.