Bug #38068 binlog_stm_binlog fails sporadically in pushbuild
Submitted: 12 Jul 2008 12:37 Modified: 15 Sep 2008 17:15
Reporter: Andrei Elkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:6.0, 5.1 OS:Any
Assigned to: Sven Sandberg CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[12 Jul 2008 12:37] Andrei Elkin
Description:
        tfl_name: binlog.binlog_stm_binlog 'mix'
        tfl_text: binlog.binlog_stm_binlog 'mix' [ fail ]
        tfl_tst_type: rpl_binlog_row
        psh_order: 54
        tfl_bld_platform: debx86-b

--- /data0/pushbuild/pb2/pb/bzr_mysql-6.0-bugteam/54/mysql-6.0.6-alpha-pb54/mysql-test/suite/binlog/r/binlog_stm_binlog.result	2008-07-11 17:31:45.000000000 +0300
+++ /data0/pushbuild/pb2/pb/bzr_mysql-6.0-bugteam/54/mysql-6.0.6-alpha-pb54/mysql-test/suite/binlog/r/binlog_stm_binlog.reject	2008-07-11 19:22:29.864900264 +0300
@@ -656,10 +656,6 @@
 master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
 master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
 master-bin.000001	#	Query	#	#	use `test`; COMMIT
-master-bin.000001	#	Query	#	#	use `test`; BEGIN
-master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
-master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
-master-bin.000001	#	Query	#	#	use `test`; COMMIT
 insert delayed into t1 values (null),(null),(null),(null);
 insert delayed into t1 values (null),(null),(400),(null);
 11 == 11

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...
[23 Jul 2008 16:51] Bugs System
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/50352

2707 Sven Sandberg	2008-07-23
      BUG#38068: binlog_stm_binlog fails sporadically in pushbuild
      Problem: binlog_stm_binlog runs INSERT DELAYED queries, and
      then prints the contents of the binlog. Before checking the
      contents of the binlog, the test waits until the rows have
      appeared in the table. However, this is not enough, since
      INSERT DELAYED does not write rows to the binlog at the same
      time as it writes them to the table. So there is a race.
      Fix: Add a FLUSH TABLES before SHOW BINLOG EVENTS. That
      waits until the insert_delayed thread is done.
[24 Jul 2008 8:45] Bugs System
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/50387

2707 Sven Sandberg	2008-07-23
      BUG#38068: binlog_stm_binlog fails sporadically in pushbuild
      Problem: binlog_stm_binlog runs INSERT DELAYED queries, and
      then prints the contents of the binlog. Before checking the
      contents of the binlog, the test waits until the rows have
      appeared in the table. However, this is not enough, since
      INSERT DELAYED does not write rows to the binlog at the same
      time as it writes them to the table. So there is a race.
      Fix: Add a FLUSH TABLES before SHOW BINLOG EVENTS. That
      waits until the insert_delayed thread is done.
[24 Jul 2008 8:45] Bugs System
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/50388

2707 Sven Sandberg	2008-07-23
      BUG#38068: binlog_stm_binlog fails sporadically in pushbuild
      Problem: binlog_stm_binlog runs INSERT DELAYED queries, and
      then prints the contents of the binlog. Before checking the
      contents of the binlog, the test waits until the rows have
      appeared in the table. However, this is not enough, since
      INSERT DELAYED does not write rows to the binlog at the same
      time as it writes them to the table. So there is a race.
      Fix: Add a FLUSH TABLES before SHOW BINLOG EVENTS. That
      waits until the insert_delayed thread is done.
[24 Jul 2008 8:45] Sven Sandberg
pushed to 5.1-testfixes
[29 Jul 2008 15:30] Bugs System
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/50661

2708 Sven Sandberg	2008-07-29
      BUG#38068: binlog_stm_binlog fails sporadically in pushbuild
      Post-push fix: updated some result files that were affected
      by the previous fix to this bug.
[29 Jul 2008 15:30] Bugs System
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/50662

2708 Sven Sandberg	2008-07-29
      BUG#38068: binlog_stm_binlog fails sporadically in pushbuild
      Post-push fix: updated some result files that were affected
      by the previous fix to this bug.
[29 Jul 2008 15:30] Bugs System
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/50663

2708 Sven Sandberg	2008-07-29
      BUG#38068: binlog_stm_binlog fails sporadically in pushbuild
      Post-push fix: updated some result files that were affected
      by the previous fix to this bug.
[14 Aug 2008 7:17] Bugs System
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/51600

2677 He Zhenxing	2008-08-14 [merge]
      Merge with mysql-5.1-rpl-testfixes
[15 Aug 2008 2:02] Bugs System
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/51688

2769 He Zhenxing	2008-08-15 [merge]
      Merge 6.0-rpl-testfixes -> 6.0
[19 Aug 2008 19:54] Bugs System
Pushed into 6.0.7-alpha  (revid:sven@mysql.com-20080729153613-51heovjrpr35m79o) (version source revid:sven@mysql.com-20080818175803-c1nutd5773r6b4gd) (pib:3)
[19 Aug 2008 20:29] Paul DuBois
Test case changes. No changelog entry needed.

Setting report to Patch Queued pending push of fix into 5.1.x.
[25 Aug 2008 21:04] Chuck Bell
Released in 6.0.7
[27 Aug 2008 1:15] Paul DuBois
No changelog entry needed.
[27 Aug 2008 1:18] Paul DuBois
Setting report to NDI pending push into 5.1.x.
[28 Aug 2008 20:16] Bugs System
Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)
[29 Aug 2008 0:42] Paul DuBois
Setting report to NDI pending push into 5.1.x.
[14 Sep 2008 1:41] Bugs System
Pushed into 6.0.7-alpha  (revid:sven@mysql.com-20080723165639-tec20vibwu1rjc0n) (version source revid:timothy.smith@sun.com-20080813081634-s8rre51iveicu311) (pib:3)
[15 Sep 2008 17:15] Jon Stephens
Test case only - no need to document in changelog.