List:Bugs« Previous MessageNext Message »
From:Jan Dvorak Date:September 6 2000 8:25pm
Subject:Re: ERROR 1034: Incorrect key file for table: 'test'.
View as plain text  
Hi Developers,

Any progress in fixing this one?

The bug repeats on my installation
(MySQL 3.23.23 compiled from source, Linux 2.2, glibc 2.1.3).

I've found the problem goes away if:
 * If one makes index on the prefix of the TEXT column alone.
or
 * If one makes the TEXT column NOT NULL.
or
 * If one doesn't use the TEXT column in the index at all. 

Jan


Michael Braunoeder wrote:
> 
> >Description:
> 
> If I submit a select with a grouping function in the select clause and a
> where clause on the table below, mysql produces the error 1034. A select
> without a where or without a group function works fine.
> 
> A myisamchk -r or -o couldn't fix the problem, a myisamchk -e didn't report
> a problem.
> 
> >How-To-Repeat:
> 
> CREATE TABLE test (
>        f1 int(11) DEFAULT '0' NOT NULL,
>        f2 varchar(16) DEFAULT '' NOT NULL,
>        f5 text,
>        KEY index_name (f1,f2,f5(16))
>     );
> 
> INSERT INTO test VALUES (0,'traktor','1111111111111');
> 
> INSERT INTO test VALUES (1,'traktor','1111111111111111111111111');
> 
> select count(*) from test where f2='traktor';
> 
> 
> >Fix:
> 
> don't use the KEY ...
> 
> >Submitter-Id:  <submitter ID>
> >Originator:    Michael Braunoeder
> >Organization:
> >MySQL support: none
> >Synopsis:      ERROR 1034: Incorrect key file for table: 'test'.
> >Severity:      serious
> >Priority:       medium
> >Category:      mysql
> >Class:         sw-bug
> >Release:       mysql-3.23.23-beta (Source distribution)
> 
> >Environment:
>         <machine, os, target, libraries (multiple lines)>
> System: SunOS knoedel 5.6 Generic_105181-19 sun4u sparc SUNW,UltraSPARC-IIi-cEngine
> Architecture: sun4
> 
> Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
> /usr/local/bin/cc
> GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.7.2.3/specs
> gcc version 2.7.2.3
> Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
> LIBC:
> -rw-r--r--   1 bin      bin      1608144 Feb  8  2000 /lib/libc.a
> lrwxrwxrwx   1 root     root          11 Apr 18 17:29 /lib/libc.so -> ./libc.so.1
> -rwxr-xr-x   1 bin      bin      1014272 Feb  8  2000 /lib/libc.so.1
> -rw-r--r--   1 bin      bin      1608144 Feb  8  2000 /usr/lib/libc.a
> lrwxrwxrwx   1 root     root          11 Apr 18 17:29 /usr/lib/libc.so ->
> ./libc.so.1
> -rwxr-xr-x   1 bin      bin      1014272 Feb  8  2000 /usr/lib/libc.so.1
> Configure command: ./configure  --prefix=/var/apps/mysql --with-mysqld-user=mysql
> Perl: This is perl, version 5.005_02 built for sun4-solaris
> 
> --
> ++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++ Ing. Michael Braunoeder    KPNQwest tech staff ++
> ++ M.Braunoeder@stripped                 MB125 ++
> ++ Phone +43-1-899 33-0      Fax +43-1-899 33-533 ++
Thread
ERROR 1034: Incorrect key file for table: 'test'.Jan Dvorak6 Sep
Re: ERROR 1034: Incorrect key file for table: 'test'.Jan Dvorak6 Sep
  • PATCH: ERROR 1034: Incorrect key file for table: 'test'.Michael Widenius7 Sep