List:Bugs« Previous MessageNext Message »
From:Jan Dvorak Date:September 6 2000 8:20pm
Subject:ERROR 1034: Incorrect key file for table: 'test'.
View as plain text  
>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