Bug #16897 Test "merge" fails due to "file exists"
Submitted: 30 Jan 2006 11:55 Modified: 14 Feb 2006 10:40
Reporter: Joerg Bruehe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.18 OS:MacOS (OS X x86 "tiger")
Assigned to: CPU Architecture:Any

[30 Jan 2006 11:55] Joerg Bruehe
Description:
Release build of 4.1.18, based on ChangeSet
  1.2463 06/01/27 13:38:15 kent@mysql.com +1 -0
  disabled.def:
    Enabled rpl_* tests now when bug fixed

No such effect noted in 4.1.17, seems to be new.

Occurred only once: OS X x86, "debug" build, "PS protocol" test run.

=====
merge                          [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line NNN: query 'alter table t3 UNION=(t1,t2)' failed: 1: Can't create/write to file './test/#sql-1637_1.MRG' (Errcode: 17)
(the last lines may be the most important ones)
=====

Error code check:
mysqldev@osx-tiger-x86:~> osx-tiger-x86/mysql-4.1.18/extra/perror 17
OS error code  17:  File exists

How to repeat:
Run the etst suite on a "debug" build.
[14 Feb 2006 10:40] Valeriy Kravchuk
Sorry, but I was not able to repeat the problem you described. I had build 4.1.18 with the following simple configure options:

./configure --prefix=/Users/mysqldev/valeriy/dbs/4.1 --with-debug
make
make install
cd ../dbs/4.1/

and:

mysqldev@osx-tiger-x86:~/valeriy/dbs/4.1/mysql-test> ./mysql-test-run --ps-protocol merge
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/master-data --skip-innodb --skip-ndbcluster --skip-bdb
060214 13:49:24 [Warning] Setting lower_case_table_names=2 because file system for /Users/mysqldev/valeriy/dbs/4.1/mysql-test/var/master-data/ is case insensitive
Installing Slave Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --b
asedir=.. --datadir=mysql-test/var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb
060214 13:49:24 [Warning] Setting lower_case_table_names=2 because file system for /Users/mysqldev/valeriy/dbs/4.1/mysql-test/var/slave-data/ is case insensitive
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
merge                          [ pass ]
-------------------------------------------------------

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
All 1 tests were successful.