rsync SST not working under load
| 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
|
Undecided
|
Unassigned | ||
Bug Description
Under dbt2 rsync SST causes inconsistency on joiner and under sysbench it causes a crash:
110607 14:51:05 [Note] WSREP: Shifting JOINER -> JOINED (TO: 4283316)
110607 14:54:24 [ERROR] Slave SQL: Could not execute Update_rows event on table sbtest.sbtest; Can't find record in 'sbtest', Error_code: 1032; handler error HA_ERR_
110607 14:54:24 [Warning] WSREP: RBR event 4 apply warning: 120, 4235189
110607 14:54:26 [ERROR] WSREP: failed to apply trx: source: d8bd5808-
110607 14:54:26 [ERROR] WSREP: Failed to apply app buffer: z�M, seqno: 4235189, status: WSREP_FATAL
Examination of dbt2 dump diffs suggests that a number of transactions are missing on the joiner after rsync SST (it is missing rows and has older timestamps).
Dbt2 diff attached.
Related branches
| Teemu Ollakka (teemu-ollakka) wrote | #1 |
| Teemu Ollakka (teemu-ollakka) wrote | #2 |
| Changed in codership-maria: | |
| status: | New → Fix Committed |
| Changed in codership-mysql: | |
| status: | Fix Committed → Fix Released |
After making SST from slave, got the following on joiner:
InnoDB: Starting in background the rollback of uncommitted transactions
110607 22:13:36 InnoDB: Rolling back trx with id 0 9564622, 1 rows to undo
InnoDB: Rolling back of trx id 0 9564622 completed
However, there should be zero uncommitted transactions on slave in DONOR state.