Bug #33420 Test 'rpl_packet' fails randomly with changed "Exec_Master_Log_Pos"
Submitted: 20 Dec 2007 22:03 Modified: 21 Jan 2009 16:13
Reporter: Kent Boortz Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.0.54 OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[20 Dec 2007 22:03] Kent Boortz
Description:
The test 'rpl_packet' fails what looks like randomly,
when creating different products, different modes when
running the tests. But the failure looks the same,
same position change, from 2138 to 2028

--- r/rpl_packet.result      2007-12-15 00:14:18.000000000 +0300
+++ r/rpl_packet.reject      2007-12-15 08:41:19.000000000 +0300
@@ -43,7 +43,7 @@
 Last_Errno     0
 Last_Error
 Skip_Counter   0
-Exec_Master_Log_Pos    2138
+Exec_Master_Log_Pos    2028
 Relay_Log_Space        #
 Until_Condition        None
 Until_Log_File

How to repeat:
Hard to repeat, likely have to run this test
many times, possibly with some additional load
on the machine.
[2 Dec 2008 14:17] Sven Sandberg
Other failure in the same test: BUG#41173
[4 Dec 2008 16:31] Sven Sandberg
Andrei committed a patch that affected another bug too, which caused the bug system to not pick it up here. This is the commit that I approve:

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/60612

2734 Andrei Elkin	2008-12-04
      Bug #41173 rpl_packet fails sporadically on pushbuild: query 'DROP TABLE t1' failed
      Bug #33420 Test 'rpl_packet' fails randomly with changed "Exec_Master_Log_Pos"
      
      The both issues appeared to be a race between the SQL thread executing CREATE table
t1
      and the IO thread that is expected to stop at the consequent big size event.
      
      The two events need serialization which is implemented.
      The early bug required back-porting a part fixes for bug#38350 exclusively for 5.0
version.
[4 Dec 2008 16:36] 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/60630

2734 Andrei Elkin	2008-12-04
      Bug #33420 Test 'rpl_packet' fails randomly with changed "Exec_Master_Log_Pos"
      
      Bug #41173 rpl_packet fails sporadically on pushbuild: query 'DROP TABLE t1' failed
      
      
      The both issues appeared to be a race between the SQL thread executing CREATE table t1
      and the IO thread that is expected to stop at the consequent big size event.
      The two events need serialization which is implemented.
      The early bug required back-porting a part fixes for bug#38350 exclusively for 5.0 version.
[8 Dec 2008 14:29] 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/60937

2735 Andrei Elkin	2008-12-08 [merge]
      merge 5.0->5.0-bugteam for a local tree containing bug#33420 Test 'rpl_packet' fails randomly.
[8 Dec 2008 14:44] 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/60944

2780 Andrei Elkin	2008-12-08 [merge]
      merge bug#33420, bug#41173 on bt 5.0 -> 5.1
[8 Dec 2008 14:50] 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/60945

2777 Andrei Elkin	2008-12-08 [merge]
      merge bug#33420, bug#41173 on bt 5.1 -> 6.0.
[8 Dec 2008 19:31] 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/60979

2781 Andrei Elkin	2008-12-08 [merge]
      merge 5.1-bt -> 6.0-bt Bug #33420.
[8 Dec 2008 19:40] 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/60980

2730 Andrei Elkin	2008-12-08
      Bug #33420 Test 'rpl_packet' fails randomly with changed "Exec_Master_Log_Pos"
      
      binlog_row_mix_innodb_myisam resutls are corrected.
      The last operations prior the dup error is
      TRUNCATE table t2;
      Therefore after
      --error ER_DUP_ENTRY
      INSERT INTO t2 select * from t1;
      table t2 must be empty, and that is what the updated results confirm.
[8 Dec 2008 19:47] 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/60981

2782 Andrei Elkin	2008-12-08 [merge]
      merge 5.1-bt with Bug #33420 fixes to 6.0-bt.
[9 Dec 2008 17:47] Andrei Elkin
pushed to bugteam trees, starting from 5.0.
[6 Jan 2009 13:56] Bugs System
Pushed into 5.0.76 (revid:joro@sun.com-20090105160414-8q9j4bi1klkfwiup) (version source revid:azundris@mysql.com-20081230114734-nmsc37ak330zlygn) (merge vers: 5.0.76) (pib:6)
[6 Jan 2009 18:34] Paul DuBois
Test case changes, no changelog entry needed.

Setting report to NDI pending push into 5.1.x/6.0.x.
[15 Jan 2009 6:32] Bugs System
Pushed into 5.1.31 (revid:joro@sun.com-20090115053147-tx1oapthnzgvs1ro) (version source revid:azundris@mysql.com-20081230114838-cn52tu180wcrvh0h) (merge vers: 5.1.31) (pib:6)
[15 Jan 2009 16:18] Paul DuBois
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.
[19 Jan 2009 11:22] Bugs System
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090115073240-1wanl85vlvw2she1) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 13:00] Bugs System
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 15:52] Jon Stephens
Setting status back to NDI pending merge to 6.0 tree.
[19 Jan 2009 16:06] Bugs System
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)
[20 Jan 2009 18:53] Bugs System
Pushed into 6.0.10-alpha (revid:joro@sun.com-20090119171328-2hemf2ndc1dxl0et) (version source revid:azundris@mysql.com-20081230114916-c290n83z25wkt6e4) (merge vers: 6.0.9-alpha) (pib:6)
[21 Jan 2009 16:13] Paul DuBois
Test case changes. No changelog entry needed.