Bug #8671 Test 'myisam' fails in _all_ builds
Submitted: 22 Feb 2005 8:58 Modified: 22 Feb 2005 12:49
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.3-pre OS:All Unix
Assigned to: Michael Widenius CPU Architecture:Any

[22 Feb 2005 8:58] Joerg Bruehe
Description:
In Monday's pull, test 'myisam' fails with this message on all platforms (where the compile / link for 'debug' succeeded) - this includes the vanilla Linux/x86!

myisam                         [ fail ]

Errors are (from /local/users/mysqldev/barney/test/mysql-debug-5.0.3-alpha-dec-osf5.1b-alphaev67/mysql-test/var/log/mysqltest-time) :
/local/users/mysqldev/barney/test/mysql-debug-5.0.3-alpha-dec-osf5.1b-alphaev67/bin/mysqltest: At line 552: query 'drop table t1' failed with wrong errno 6 instead of 1051...
/local/users/mysqldev/barney/test/mysql-debug-5.0.3-alpha-dec-osf5.1b-alphaev67/bin/mysqltest: At line 556: query 'drop table t1' failed with wrong errno 6 instead of 1105...
/local/users/mysqldev/barney/test/mysql-debug-5.0.3-alpha-dec-osf5.1b-alphaev67/bin/mysqltest: At line 559: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/myisam.result     Tue Feb 22 00:59:21 2005
--- r/myisam.reject     Tue Feb 22 03:13:10 2005
***************
*** 1156,1164 ****
  Error 2       Can't find file: 't1' (errno: 2)
  create table t1 (a int) engine=myisam;
  drop table t1;
! ERROR 42S02: Unknown table 't1'
  create table t1 (a int) engine=myisam;
  drop table t1;
! ERROR HY000: File './test/t1.MYD' not found (Errcode: 2)
  drop table t1;
  ERROR 42S02: Unknown table 't1'
--- 1156,1164 ----
  Error 2       Can't find file: 't1' (errno: 2)
  create table t1 (a int) engine=myisam;
  drop table t1;
! ERROR HY000: Error on delete of './test/t1.MYI' (Errcode: 2)
  create table t1 (a int) engine=myisam;
  drop table t1;
! ERROR HY000: Error on delete of './test/t1.MYD' (Errcode: 2)
  drop table t1;
  ERROR 42S02: Unknown table 't1'
-------------------------------------------------------

This build is based on changeset
  1.1880 05/02/21 20:41:48 monty@mysql.com +8 -0
  Generate warning in ha_delete_table() if files is missing in handler

The error was _not_ observed in the weekend build based on
  1.1862 05/02/18 17:46:30 pem@mysql.com +1 -0
  Merge mysql.com:/usr/local/bk/mysql-5.0
  into mysql.com:/home/pem/work/mysql-5.0
(of which no 'debug' was made).

How to repeat:
Just build + test.
[22 Feb 2005 12:49] Michael Widenius
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html