Bug #33420 Test 'rpl_packet' fails randomly with changed "Exec_Master_Log_Pos"
Submitted: 20 Dec 2007 23:03 Modified: 21 Jan 17:13
Reporter: Kent Boortz
Status: Closed
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.0.54 OS:Any
Assigned to: Andrei Elkin Target Version:5.0+
Tags: sporadic, test failure, pushbuild
Triage: D3 (Medium) / R1 (None/Negligible) / E3 (Medium)

[20 Dec 2007 23: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 15:17] Sven Sandberg
Other failure in the same test: BUG#41173
[4 Dec 2008 17: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 17: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 15: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 15: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 15: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 20: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 20: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 20: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 18:47] Andrei Elkin
pushed to bugteam trees, starting from 5.0.
[6 Jan 14: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 19: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 7: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 17:18] Paul DuBois
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.
[19 Jan 12: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 14: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 16:52] Jon Stephens
Setting status back to NDI pending merge to 6.0 tree.
[19 Jan 17: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 19: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 17:13] Paul DuBois
Test case changes. No changelog entry needed.