Could not execute Delete_rows event

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

Other bug subscribers