Bug #47638 The rpl_killed_ddl test fails on Windows
Submitted: 25 Sep 2009 2:53 Modified: 20 Nov 2010 0:08
Reporter: Igor Babaev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Zhenxing He CPU Architecture:Any
Tags: experimental, pb2, test failure

[25 Sep 2009 2:53] Igor Babaev
Description:
When working on Windows with the build created from the current mysql-5.1 tree 
(http://bazaar.launchpad.net/~mysql/mysql-server/mysql-5.1/) and trying to run

mysql-5.1\mysql-test>perl mysql-test-run.pl rpl_killed_ddl

I've got an unexpected result.

How to repeat:
Install MySQL from the build tree on Windows following the instructions that could be
found in win/README.

Run 

mysql-5.1\mysql-test>perl mysql-test-run.pl rpl_killed_ddl

You'll get something like this:

C:\mysql-5.1\mysql-test>perl mysql-test-run.pl rpl_killed_ddl
Logging: mysql-test-run.pl  rpl_killed_ddl
MySQL Version 5.1.40
Checking supported features...
 - skipping ndbcluster, mysqld not compiled with ndbcluster
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
 - adding combinations for rpl
vardir: C:/mysql-5.1/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory 'C:/mysql-5.1/mysql-test/var'...
Installing system database...
Using server port 2082

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
rpl.rpl_killed_ddl 'row'                 [ fail ]
        Test ended at 2009-09-24 19:40:04

CURRENT_TEST: rpl.rpl_killed_ddl
ERROR 1054 (42S22) at line 1: Unknown column 'event_name' in 'field list'
mysqltest: In included file ".\include\diff_master_slave.inc": At line 14: command "$MYSQL test -e "$diff_statement" > $MYSQLTEST_VARDIR/tmp/diff_master.out" fa
iled

Output from before failure:
exec of 'C:\mysql-5.1\client\debug\\mysql.exe --defaults-file=C:/mysql-5.1/mysql-test/var/my.cnf test -e "SELECT event_name, event_body, execute_at
FROM information_schema.events where event_name like 'e%'" > C:/mysql-5.1/mysql-test/var/tmp/diff_master.out' failed, error: 1, status: 1, errno: 2

The result from queries just before the failure was:
< snip >
END;
//
CREATE INDEX i1 ON t1 (a);
CREATE VIEW v1 AS SELECT a FROM t1 WHERE a < 100;
[on master]
[on master1]
CREATE DATABASE d2;
source include/kill_query.inc;
source include/diff_master_slave.inc;
DROP DATABASE d1;
source include/kill_query.inc;
source include/diff_master_slave.inc;
DROP DATABASE d2;
source include/kill_query.inc;
source include/diff_master_slave.inc;
CREATE EVENT e2
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
DO INSERT INTO test.t1 VALUES (2);
source include/kill_query.inc;
source include/diff_master_slave.inc;

More results from queries before failure can be found in G:\maria\mysql-5.1\mysql-test\var\log\rpl_killed_ddl.log

 - saving 'C:/mysql-5.1/mysql-test/var/log/rpl.rpl_killed_ddl-row/' to 'C:/mysql-5.1/mysql-test/var/log/rpl.rpl_killed_ddl-row/'

Only  1  of 3 completed.
mysql-test-run: *** ERROR: Not all tests completed
[25 Sep 2009 5:09] Sveta Smirnova
Thank you for the report.

Verified as described.
[25 Sep 2009 14:00] Luis Soares
See also BUG#45520.
[14 Dec 2009 6:11] 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/93841

3256 He Zhenxing	2009-12-14
      Bug#47638 The rpl_killed_ddl test fails on Windows
      
      When the $diff_statement variable for diff_master_slave.inc was
      put in multiple lines, the rear part of the statement would be 
      missing when being executed on Windows systems.
      
      Fixed the problem by always putting the value for $diff_statement
      in one line.
     @ mysql-test/suite/rpl/t/rpl_killed_ddl.test
        putting the statement for $diff_statement variable in one line.
[21 Dec 2009 6:15] 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/95165

3289 He Zhenxing	2009-12-21
      Bug#47638 The rpl_killed_ddl test fails on Windows
      
      When the $diff_statement variable for diff_master_slave.inc was
      put in multiple lines, the rear part of the statement would be 
      missing when being executed on Windows systems.
      
      Fixed the problem by always putting the value for $diff_statement
      in one line.
     @ mysql-test/suite/rpl/t/rpl_killed_ddl.test
        putting the statement for $diff_statement variable in one line.
[21 Dec 2009 6:15] Zhenxing He
See also Bug#49837
[15 Jan 2010 9:02] Bugs System
Pushed into 5.1.43 (revid:joro@sun.com-20100115085139-qkh0i0fpohd9u9p5) (version source revid:zhenxing.he@sun.com-20091221061445-dt246sw1heq9j2ke) (merge vers: 5.1.42) (pib:16)
[16 Jan 2010 1:28] Paul DuBois
Changes to test case. No changelog entry needed.

Setting report to NDI pending push to 5.5.x+.
[20 Jan 2010 15:17] Alexander Nozdrin
Making the test case experimental staring from Celosia (next-mr).
[5 Feb 2010 11:46] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100204063540-9czpdmpixi3iw2yb) (version source revid:alik@sun.com-20091224075613-es9uswo4lidkm3tj) (pib:16)
[5 Feb 2010 11:53] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100205113942-oqovjy0eoqbarn7i) (version source revid:alik@sun.com-20100204064210-ljwanqvrjs83s1gq) (merge vers: 6.0.14-alpha) (pib:16)
[5 Feb 2010 11:59] Bugs System
Pushed into 5.5.2-m2 (revid:alik@sun.com-20100203172258-1n5dsotny40yufxw) (version source revid:alexey.kopytov@sun.com-20091223134205-pk9yvgfvpn3hy7lh) (merge vers: 5.5.1-m2) (pib:16)
[5 Feb 2010 16:57] Paul DuBois
Changes to test case. No changelog entry needed.
[12 Mar 2010 14:10] Bugs System
Pushed into 5.1.44-ndb-7.0.14 (revid:jonas@mysql.com-20100312135944-t0z8s1da2orvl66x) (version source revid:jonas@mysql.com-20100312115609-woou0te4a6s4ae9y) (merge vers: 5.1.44-ndb-7.0.14) (pib:16)
[12 Mar 2010 14:26] Bugs System
Pushed into 5.1.44-ndb-6.2.19 (revid:jonas@mysql.com-20100312134846-tuqhd9w3tv4xgl3d) (version source revid:jonas@mysql.com-20100312060623-mx6407w2vx76h3by) (merge vers: 5.1.44-ndb-6.2.19) (pib:16)
[12 Mar 2010 14:40] Bugs System
Pushed into 5.1.44-ndb-6.3.33 (revid:jonas@mysql.com-20100312135724-xcw8vw2lu3mijrhn) (version source revid:jonas@mysql.com-20100312103652-snkltsd197l7q2yg) (merge vers: 5.1.44-ndb-6.3.33) (pib:16)
[12 Mar 2010 17:24] Paul DuBois
No changelog entry needed.
[15 Jun 2010 8:31] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100615080558-cw01bzdqr1bdmmec) (version source revid:mmakela@bk-internal.mysql.com-20100415070122-1nxji8ym4mao13ao) (pib:16)
[4 Aug 2010 8:07] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:mmakela@bk-internal.mysql.com-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:18)
[4 Aug 2010 8:23] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:mmakela@bk-internal.mysql.com-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:18)
[4 Aug 2010 19:56] Paul DuBois
Changes to test suite. No changelog entry needed.
[18 Oct 2010 10:35] Sven Sandberg
rpl.rpl_killed_ddl was marked experimental because of this bug. Please re-enable the test before closing this bug.
[7 Nov 2010 4:38] 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/123026

3122 He Zhenxing	2010-11-07
      Remove rpl_killed_ddl.test from experimental after fixed BUG#47638
[7 Nov 2010 4:41] 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/123027

3260 He Zhenxing	2010-11-07
      Remove rpl_killed_ddl.test from experimental after fixed BUG#47638
[13 Nov 2010 16:17] Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)
[13 Nov 2010 16:31] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:alexander.nozdrin@oracle.com-20101113152540-gxro4g0v29l27f5x) (pib:21)
[16 Nov 2010 2:02] Paul DuBois
Changes to test suite. No changelog entry needed.
[16 Dec 2010 22:27] Bugs System
Pushed into mysql-5.5 5.5.9 (revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (version source revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (merge vers: 5.5.9) (pib:24)