| 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: | |
| 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 | ||
[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.
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...