MySQL Bugs: #24998: rpl_row_delayed_ins.test fails in pushbuild

Bug #24998	rpl_row_delayed_ins.test fails in pushbuild
Submitted:	12 Dec 2006 10:07	Modified:	23 Jan 2007 20:36
Reporter:	Ingo Strüwing	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S1 (Critical)
Version:	5.1.15	OS:	'rhas4-ia64' Pedantic
Assigned to:	Andrei Elkin	CPU Architecture:	Any

Description:
This blocks 5.1-engines from being pushed to main.

An excerpt from https://intranet.mysql.com/~knielsen/pb/getlog.pl?dir=mysql-5.1-engines&entry=istruewing@c...

rpl_row_delayed_ins            [ fail ]

Errors are (from /dev/shm/var-ps_row-8/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/rpl_row_delayed_ins.result	2006-12-08 22:28:54.000000000 +0300
--- r/rpl_row_delayed_ins.reject	2006-12-09 03:29:38.000000000 +0300
***************
*** 19,26 ****
  master-bin.000001	222	Table_map	1	261	table_id: # (test.t1)
  master-bin.000001	261	Write_rows	1	295	table_id: # flags: STMT_END_F
  master-bin.000001	295	Table_map	1	334	table_id: # (test.t1)
! master-bin.000001	334	Write_rows	1	373	table_id: # flags: STMT_END_F
! master-bin.000001	373	Query	1	448	use `test`; flush tables
  SELECT * FROM t1 ORDER BY a;
  a
  1
--- 19,28 ----
  master-bin.000001	222	Table_map	1	261	table_id: # (test.t1)
  master-bin.000001	261	Write_rows	1	295	table_id: # flags: STMT_END_F
  master-bin.000001	295	Table_map	1	334	table_id: # (test.t1)
! master-bin.000001	334	Write_rows	1	368	table_id: # flags: STMT_END_F
! master-bin.000001	368	Table_map	1	407	table_id: # (test.t1)
! master-bin.000001	407	Write_rows	1	441	table_id: # flags: STMT_END_F
! master-bin.000001	441	Query	1	516	use `test`; flush tables
  SELECT * FROM t1 ORDER BY a;
  a
  1
-------------------------------------------------------
Please follow the instructions outlined at

How to repeat:
See the pushbuild log.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/17999

ChangeSet@1.2373, 2007-01-11 23:59:12+02:00, aelkin@dsl-hkibras-fe36f900-97.dhcp.inet.fi +1 -0
  Bug #24998  	rpl_row_delayed_ins.test fails in pushbuild
  
  The test uses show binlog event which is not deterministic due to the single insert delayed
  query can generate up to number of inserted rows row-events pair (table_map + Write_row)
  
  The solution is to leave the current binlogging behaviour as it is and change 
  the test as spliting arguments of insert delayed query. Note, that such fix was applied
  earlier for  binlog_insert_delayed.test :
  https://intranet.mysql.com/secure/apps/irclog.php?channel=22&start_time=2006-09-27 
  
  There are no tests with insert delayed and show binlog events combination requiring
  this fix.

Pushed into 5.1.15.  Only test case fix, no docs needed.

No changelog entry needed.