MySQL Bugs: #39787: New MTR spews extra statements when run under Cygwin on Windows

Bug #39787	New MTR spews extra statements when run under Cygwin on Windows
Submitted:	1 Oct 2008 18:34	Modified:	7 Oct 2008 18:49
Reporter:	Chuck Bell	Email Updates:
Status:	Verified	Impact on me:	None
Category:	Tests: Engine	Severity:	S3 (Non-critical)
Version:	6.0.8	OS:	Windows
Assigned to:		CPU Architecture:	Any
Description:
The MTR as configured in the mysql-6.0-rpl tree does not perform well on Windows under Cygwin.

Additional messages are spewed to the console making the display difficult to read. Also, there are a number of messages that differ from running MTR under Linux.

The Linux example:

cbell@ubuntu64:~/source/bzr/mysql-6.0-bug-39598/mysql-test$ ./mysql-test-run.pl
 --do-test=backup_myisam --suite=main
Logging: ./mysql-test-run.pl  --do-test=backup_myisam --suite=main
MySQL Version 6.0.8
Checking supported features...
 - using ndbcluster when necessary, mysqld supports it
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: /home/cbell/source/bzr/mysql-6.0-bug-39598/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/cbell/source/bzr/mysql-6.0-bug-39598/mysql-test/va
r'...
Installing system database...
Using parallel: 2
Using server port 45553
worker[1] Using MTR_BUILD_THREAD 250, with reserved ports 12500..12509
worker[2] Using MTR_BUILD_THREAD 251, with reserved ports 12510..12519

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

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

main.backup_myisam1                      [ pass ]    162
main.backup_myisam2                      [ pass ]    323
------------------------------------------------------------
The servers were restarted 0 times
Spent 0.485 of 4 seconds executing testcases

All 2 tests were successful.

cbell@ubuntu64:~/source/bzr/mysql-6.0-bug-39598/mysql-test$

The Windows example:

Chuck@mysql_cab_desk /cygdrive/d/source/bzr/mysql-6.0-bug-39598/mysql-test
$ ./mysql-test-run.pl --do-test=backup_myisam --suite=main
Logging: ./mysql-test-run.pl  --do-test=backup_myisam --suite=main
cygpath -m /cygdrive/d/source/bzr/mysql-6.0-bug-39598/mysql-test
cygpath -m /tmp/y4V64obcH7
MySQL Version 6.0.8
Checking supported features...
 - skipping ndbcluster, mysqld not compiled with ndbcluster
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var
Removing old var directory...
Creating var directory 'd:/source/bzr/mysql-6.0-bug-39598/mysql-test/var'...
Installing system database...
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/sql/debug/mysqld.exe
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/tmp/bootstrap.sql
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/log/bootstrap.log
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/log/bootstrap.log
Using parallel: 2
Using server port 50767

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

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

Removing slot 250 used by missing process 180
worker[1] Using MTR_BUILD_THREAD 250, with reserved ports 12500..12509
worker[2] Using MTR_BUILD_THREAD 251, with reserved ports 12510..12519
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/sql/debug/mysqld.exe
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/1/mysqld.1/mysqld.er
r
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/1/mysqld.1/mysqld.er
r
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/sql/debug/mysqld.exe
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/2/mysqld.1/mysqld.er
r
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/client/debug//mysqltest.exe
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/2/mysqld.1/mysqld.er
r
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/1/tmp/check-mysqld_1
.err
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/client/debug//mysqltest.exe
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/2/tmp/check-mysqld_1
.err
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/client/debug//mysqltest.execygpath
-m d:/source/bzr/mysql-6.0-bug-39598/client/debug//mysqltest.exe

cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/2/log/current_test
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/1/log/current_test
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/client/debug//mysqltest.exe
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/client/debug//mysqltest.exe
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/1/tmp/warnings-mysql
d.1.err
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/2/tmp/warnings-mysql
d.1.err
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/1/tmp/warnings-mysql
d.1.err
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/2/tmp/warnings-mysql
d.1.err
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/client/debug//mysqltest.exe
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/client/debug//mysqltest.exe
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/1/tmp/check-mysqld_1
.err
cygpath -m d:/source/bzr/mysql-6.0-bug-39598/mysql-test/var/2/tmp/check-mysqld_1
.err
main.backup_myisam1                      [ pass ]    375
main.backup_myisam2                      [ pass ]    811
------------------------------------------------------------
The servers were restarted 0 times
Spent 1.186 of 29 seconds executing testcases

All 2 tests were successful.

How to repeat:
Build a branch of mysql-6.0-rpl.
Run ./mysql-test-run.pl --do-test=backup_myisam --suite=main.

Suggested fix:
Change MTR to write messages to a log and/or change MTR to run under Cygwin with appropriate environment settings documented.