| Bug #38068 | binlog_stm_binlog fails sporadically in pushbuild | ||
|---|---|---|---|
| Submitted: | 12 Jul 2008 14:37 | Modified: | 15 Sep 2008 19:15 |
| Reporter: | Andrei Elkin | ||
| Status: | Closed | ||
| Category: | Server: Replication | Severity: | S2 (Serious) |
| Version: | 6.0, 5.1 | OS: | Any |
| Assigned to: | Sven Sandberg | Target Version: | 5.1+ |
| Tags: | sporadic, test failure, pushbuild | ||
| Triage: | D3 (Medium) | ||
[23 Jul 2008 18: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 10: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 10: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 10:45]
Sven Sandberg
pushed to 5.1-testfixes
[29 Jul 2008 17: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 17: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 17: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 9: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 4: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 21: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 22: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 23:04]
Chuck Bell
Released in 6.0.7
[27 Aug 2008 3:15]
Paul DuBois
No changelog entry needed.
[27 Aug 2008 3:18]
Paul DuBois
Setting report to NDI pending push into 5.1.x.
[28 Aug 2008 22: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 2:42]
Paul DuBois
Setting report to NDI pending push into 5.1.x.
[14 Sep 2008 3: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 19: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...