inconsistency in multi-master test when using binlogging
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
Critical
|
Seppo Jaakola | ||
5.1 |
Fix Released
|
Critical
|
Seppo Jaakola | ||
5.5 |
Fix Released
|
Critical
|
Seppo Jaakola |
Bug Description
two node multi-master test case shows inconsistency when binlogging has been enabled.
How to reproduce:
1. start two nodes with binlog enabled (log-bin, log-slave-updates)
2. start a load balancer (glbd) to distribute load with round robin policy
3. launch randgen load against the load balancer
randgen commandline used was:
./gentest.pl --gendata=
One node will fail in applying with error like:
111005 15:06:49 [ERROR] Slave SQL: Could not execute Update_rows event on table randgen.DD; Can't find record in 'DD', Error_code: 1032; ha
ndler error HA_ERR_
111005 15:06:49 [Warning] WSREP: RBR event 12 apply warning: 120, 15590
111005 15:06:49 [ERROR] WSREP: Failed to apply trx: source: 272ca82d-
s: 1 conn_id: 29 trx_id: 282849 seqnos (l: 2658, g: 15590, s: 15589, d: 15567, ts: 131781637924464
Related branches
Changed in codership-mysql: | |
status: | New → In Progress |
importance: | Undecided → Critical |
assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
milestone: | none → 5.5.15-21.1 |
A fix for statement rollback processing was committed in change set 3579: bazaar. launchpad. net/~codership/ codership- mysql/wsrep- 5.5/revision/ 3579
http://