inconsistency in multi-master test when using binlogging

Bug #869538 reported by Seppo Jaakola
6
This bug affects 1 person
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=conf/drizzle/translog_drizzle.zz --grammar=conf/drizzle/translog_concurrent1.yy --queries=2000 --threads=6 --dsn=dbi:mysql:host=127.0.0.1:port=3306:user=root:password=rootpass:database=randgen --debug --sqltrace

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_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 6512, Error_code: 1032
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-ef4a-11e0-0800-437afeec7dd5 version: 1 local: 0 state: CERTIFYING flag
s: 1 conn_id: 29 trx_id: 282849 seqnos (l: 2658, g: 15590, s: 15589, d: 15567, ts: 1317816379244640959)

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
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

A fix for statement rollback processing was committed in change set 3579:
http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3579

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

Statement rollback fix merged to wsrep-5.1 in change set 3141:
http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.1/revision/3141

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.