| Bug #43440 | rpl.rpl_temp_table_mix_row fails sporadicly | ||
|---|---|---|---|
| Submitted: | 6 Mar 2009 6:02 | Modified: | 30 Mar 2009 12:21 |
| Reporter: | Zhenxing He | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tests: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.1-bugteam, 6.0-bugteam | OS: | Any |
| Assigned to: | li zhou | CPU Architecture: | Any |
| Tags: | disabled, pushbuild, sporadic, test failure | ||
[23 Mar 2009 9:29]
Georgi Kodinov
Repeatable every time on vm-win2003-64-b prepared statement.
[23 Mar 2009 9:39]
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/70021 2827 Georgi Kodinov 2009-03-23 Disabled the failing test case until bug #43440 is resolved
[23 Mar 2009 9:40]
Georgi Kodinov
Move back to verified after disabling the test case.
[24 Mar 2009 6: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/70135 2829 Leonard Zhou 2009-03-24 Bug#43440 rpl.rpl_temp_table_mix_row fails sporadicly The problem is that after disconnect, the DOPR TEMPORARY TABLE event didn't been written into binlog. So after syncing with slave, the TEMPORARY table on slave is not removed. Waiting DROP TEMPORARY TABLE event to be written into binlog before sync slave with master. @ mysql-test/suite/rpl/t/rpl_temp_table_mix_row.test Waiting DROP TEMPORARY TABLE event to be written into binlog
[24 Mar 2009 9: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/70144 2829 Leonard Zhou 2009-03-24 Bug#43440 rpl.rpl_temp_table_mix_row fails sporadicly The problem is that after disconnect, the DOPR TEMPORARY TABLE event didn't been written into binlog. So after syncing with slave, the TEMPORARY table on slave is not removed. Waiting DROP TEMPORARY TABLE event to be written into binlog before sync slave with master. @ mysql-test/suite/rpl/t/disabled.def Remove disable item. @ mysql-test/suite/rpl/t/rpl_temp_table_mix_row.test Waiting DROP TEMPORARY TABLE event to be written into binlog
[26 Mar 2009 5:16]
li zhou
Pushed into 6.0-bugteam and 5.1-bugteam
[26 Mar 2009 11:49]
Alexander Nozdrin
temporarily disabled in 6.0 (waiting for the fix).
[27 Mar 2009 14:56]
Bugs System
Pushed into 5.1.34 (revid:joro@sun.com-20090327143448-wuuuycetc562ty6o) (version source revid:joro@sun.com-20090323093854-m9snubemhvnwlcka) (merge vers: 5.1.34) (pib:6)
[30 Mar 2009 12:21]
Jon Stephens
Test failure only; no end-user changes to document. Closed without further action.
[13 Apr 2009 9:21]
Bugs System
Pushed into 6.0.11-alpha (revid:alik@sun.com-20090413084402-snnrocwzktcl88ny) (version source revid:joro@sun.com-20090323095254-6hfmqyp4as7jgwdr) (merge vers: 6.0.11-alpha) (pib:6)
[5 May 2009 19:39]
Bugs System
Pushed into 5.1.35 (revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (version source revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (merge vers: 5.1.35) (pib:6)
[6 May 2009 14:10]
Bugs System
Pushed into 6.0.12-alpha (revid:svoj@sun.com-20090506125450-yokcmvqf2g7jhujq) (version source revid:horst@mysql.com-20090327184517-25eq077q2beocs6y) (merge vers: 6.0.11-alpha) (pib:6)
[9 May 2009 16:44]
Bugs System
Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (version source revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (merge vers: 5.1.34-ndb-6.2.18) (pib:6)
[9 May 2009 17:41]
Bugs System
Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (version source revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (merge vers: 5.1.34-ndb-6.3.25) (pib:6)
[9 May 2009 18:38]
Bugs System
Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (version source revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (merge vers: 5.1.34-ndb-7.0.6) (pib:6)
[15 Jun 2009 8:26]
Bugs System
Pushed into 5.1.35-ndb-6.3.26 (revid:jonas@mysql.com-20090615074202-0r5r2jmi83tww6sf) (version source revid:jonas@mysql.com-20090615070837-9pccutgc7repvb4d) (merge vers: 5.1.35-ndb-6.3.26) (pib:6)
[15 Jun 2009 9:06]
Bugs System
Pushed into 5.1.35-ndb-7.0.7 (revid:jonas@mysql.com-20090615074335-9hcltksp5cu5fucn) (version source revid:jonas@mysql.com-20090615072714-rmfkvrbbipd9r32c) (merge vers: 5.1.35-ndb-7.0.7) (pib:6)
[15 Jun 2009 9:46]
Bugs System
Pushed into 5.1.35-ndb-6.2.19 (revid:jonas@mysql.com-20090615061520-sq7ds4yw299ggugm) (version source revid:jonas@mysql.com-20090615054654-ebgpz7elwu1xj36j) (merge vers: 5.1.35-ndb-6.2.19) (pib:6)
Description: rpl_temp_table_mix_row fails sporadicly on PUSHBUILD: rpl.rpl_temp_table_mix_row [ fail ] Test ended at 2009-02-23 19:23:58 CURRENT_TEST: rpl.rpl_temp_table_mix_row --- e:/pb/bzr_mysql-5.1-bugteam/517/mysql-5.1.33-pb517/mysql-test/suite/rpl/r/rpl_temp_table_mix_row.result 2009-02-23 20:06:58.000000000 +0300 +++ e:\pb\bzr_mysql-5.1-bugteam\517\mysql-5.1.33-pb517\mysql-test\suite\rpl\r\rpl_temp_table_mix_row.reject 2009-02-23 21:23:58.034249800 +0300 @@ -19,7 +19,7 @@ ==== Verify results on slave ==== SHOW STATUS LIKE "Slave_open_temp_tables"; Variable_name Value -Slave_open_temp_tables 0 +Slave_open_temp_tables 1 ==== Clean up ==== [on master] DROP TABLE t1; mysqltest: Result content mismatch How to repeat: Check the xref: http://tinyurl.com/cfovhv Suggested fix: I think the problem is that after disconnect, the DOPR TEMPORARY TABLE event probably has not been written to binlog, so after syncing with slave, the TEMPORARY table on slave is not removed. I think the test should wait for that binlog event appear on master before sync with slave. I'd suggest to add the following before sync with the slave after disconnect: let $wait_binlog_event= DROP; source include/wait_for_binlog_event.inc;