Bug #45521 rpl_slave_skip fails in pb2

• Submitted: 16 Jun 2009 10:30
• Modified: 2 Oct 2009 12:27
• Reporter: Georgi Kodinov
• Status: Duplicate
• Category: Tests: Replication
• Severity: S3 (Non-critical)
• Version: 5.0-bugteam, 5.0-main
• OS: Windows
• Assigned to: Assigned Account
• CPU Architecture: Any

[16 Jun 2009 10:30] Georgi Kodinov

Description:
rpl_slave_skip fails sporadically on windows pb2 in 5.0-bugteam with : 
rpl_slave_skip                 [ fail ]

mysqltest: At line 68: query 'STOP SLAVE' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
a	b
1	master
2	master
3	master
4	master,slave
5	master,slave
6	master,slave
**** On Slave ****
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;
START SLAVE;
SELECT * FROM t1 ORDER BY a;
a	b
4	master,slave
5	master,slave
6	master,slave
**** On Master ****
DELETE FROM t1;
==== Skipping two normal transactions ==== 
**** On Slave ****
STOP SLAVE;

More results from queries before failure can be found in G:\pb2\test\sb_1-584200-1245078778.92\mysql-5.0.83-win-x86-test\mysql-test\var\log\rpl_slave_skip.log

How to repeat:
run pb2 on mysql-5.0-bugteam : https://central.sun.net/http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_f...

Suggested fix:
Either fix or disable the test

[22 Jun 2009 9:30] Sveta Smirnova

See also bug #44152, bug #44430 and bug #45411

[6 Jul 2009 10:21] 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/78001

2795 Georgi Kodinov	2009-07-06
      Bug #45521: disabled the test case

[6 Jul 2009 11:48] Georgi Kodinov

back to "Verified" : just a test suite disablement

[7 Jul 2009 7:52] Bugs System

Pushed into 5.0.84 (revid:[e-mail]-20090707074938-ksah1ibn0vs92cem) (version source revid:[e-mail]-20090706102041-66zxxau9tlmdguig) (merge vers: 5.0.84) (pib:11)

[8 Jul 2009 13:30] Bugs System

Pushed into 5.1.37 (revid:[e-mail]-20090708131116-kyz8iotbum8w9yic) (version source revid:[e-mail]-20090706103609-62l08z5dpwqy29wt) (merge vers: 5.1.37) (pib:11)

[9 Jul 2009 7:35] Bugs System

Pushed into 5.0.84 (revid:[e-mail]-20090707074938-ksah1ibn0vs92cem) (version source revid:[e-mail]-20090706102041-66zxxau9tlmdguig) (merge vers: 5.0.84) (pib:11)

[9 Jul 2009 7:38] Bugs System

Pushed into 5.1.37 (revid:[e-mail]-20090708131116-kyz8iotbum8w9yic) (version source revid:[e-mail]-20090706103609-62l08z5dpwqy29wt) (merge vers: 5.1.37) (pib:11)

[10 Jul 2009 11:21] Bugs System

Pushed into 5.4.4-alpha (revid:[e-mail]-20090710111017-bnh2cau84ug1hvei) (version source revid:[e-mail]-20090706104514-4dj1xron15x44x6h) (merge vers: 5.4.4-alpha) (pib:11)

[26 Aug 2009 13:46] Bugs System

Pushed into 5.1.37-ndb-7.0.8 (revid:[e-mail]-20090826132541-yablppc59e3yb54l) (version source revid:[e-mail]-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)

[26 Aug 2009 13:46] Bugs System

Pushed into 5.1.37-ndb-6.3.27 (revid:[e-mail]-20090826105955-bkj027t47gfbamnc) (version source revid:[e-mail]-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)

[26 Aug 2009 13:48] Bugs System

Pushed into 5.1.37-ndb-6.2.19 (revid:[e-mail]-20090825194404-37rtosk049t9koc4) (version source revid:[e-mail]-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)

[27 Aug 2009 16:33] Bugs System

Pushed into 5.1.35-ndb-7.1.0 (revid:[e-mail]-20090827163030-6o3kk6r2oua159hr) (version source revid:[e-mail]-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)

[2 Oct 2009 12:27] Zhenxing He

dup of bug#45242

[21 Dec 2009 11: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/95210

2827 Serge Kozlov	2009-12-21
      Bug#8693, Bug#45521.
      modified:
        mysql-test/t/disabled.def

[14 Jan 2010 8:27] Bugs System

Pushed into 5.0.90 (revid:[e-mail]-20100114082402-05fod2h6z9x9wok8) (version source revid:[e-mail]-20091221114008-v9c2n1rd15cwjr6p) (merge vers: 5.0.89) (pib:16)

[15 Jan 2010 9:02] Bugs System

Pushed into 5.1.43 (revid:[e-mail]-20100115085139-qkh0i0fpohd9u9p5) (version source revid:[e-mail]-20091223070903-6rn5kgl3chedqnxd) (merge vers: 5.1.42) (pib:16)

[5 Feb 2010 11:51] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100204063540-9czpdmpixi3iw2yb) (version source revid:[e-mail]-20100119163614-172adculixyu26j5) (pib:16)

[5 Feb 2010 11:56] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100205113942-oqovjy0eoqbarn7i) (version source revid:[e-mail]-20100204064210-ljwanqvrjs83s1gq) (merge vers: 6.0.14-alpha) (pib:16)

[5 Feb 2010 12:02] Bugs System

Pushed into 5.5.2-m2 (revid:[e-mail]-20100203172258-1n5dsotny40yufxw) (version source revid:[e-mail]-20091225105650-qletdbs0wz9sx5nc) (merge vers: 5.5.1-m2) (pib:16)

[12 Mar 2010 14:20] Bugs System

Pushed into 5.1.44-ndb-7.0.14 (revid:[e-mail]-20100312135944-t0z8s1da2orvl66x) (version source revid:[e-mail]-20100312115609-woou0te4a6s4ae9y) (merge vers: 5.1.44-ndb-7.0.14) (pib:16)

[12 Mar 2010 14:35] Bugs System

Pushed into 5.1.44-ndb-6.2.19 (revid:[e-mail]-20100312134846-tuqhd9w3tv4xgl3d) (version source revid:[e-mail]-20100312060623-mx6407w2vx76h3by) (merge vers: 5.1.44-ndb-6.2.19) (pib:16)

[12 Mar 2010 14:51] Bugs System

Pushed into 5.1.44-ndb-6.3.33 (revid:[e-mail]-20100312135724-xcw8vw2lu3mijrhn) (version source revid:[e-mail]-20100312103652-snkltsd197l7q2yg) (merge vers: 5.1.44-ndb-6.3.33) (pib:16)