List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:October 18 1999 5:31pm
Subject:Re: ERROR 1034: Incorrect key file for table: 'EVENTS'
View as plain text  
>>>>> "Jonathan" == Jonathan A Zdziarski <jonz@stripped> writes:

Jonathan> it is...but i don't experience this problem with 3.22 only the new
Jonathan> alpha.

<cut>

>> > > > jonz@stripped writes:
>> > > >  > >Description:
>> > > >  >  After updating rows in a table, on an AUTO_INCREMENTing key
> table,
>> > > >  >   I receive 'ERROR 1034: Incorrect key file for table. Try
> and repair it'.
>> > > >  > mysql> select * from EVENTS;

Hi!

First;  When one reports like the above, the fastest way to get this
fixed is to upload the problem file (checked to ensure that it doesn't 
contain any errors), to:

ftp://www.mysql.com/pub/mysql/secret

together with a script that corrupts its.  By doing this you can be
sure to get this fixed VERY rappidly.

I did just fix for MySQL 3.23.5 a bug that corrupted indexes when the
first column was a CHAR that could have NULL values.  If your table
has such a column. I strongly suggest you to try MySQL 3.23.5 and
report if this helps!

Anyway;  You can probably get MySQL 3.23 to work by switching the
problem table to ISAM:

ALTER TABLE EVENTS TYPE=isam;

(I would however like to get a copy of your table if it doesn't work
in MySQL 3.23.5 to nail the bug!)

Regards,
Monty

Thread
ERROR 1034: Incorrect key file for table: 'EVENTS'jonz17 Oct
  • Re: ERROR 1034: Incorrect key file for table: 'EVENTS'sinisa17 Oct
    • Re: ERROR 1034: Incorrect key file for table: 'EVENTS'Mogens Melander17 Oct
      • Re: ERROR 1034: Incorrect key file for table: 'EVENTS'Jonathan A. Zdziarski17 Oct
        • Re: ERROR 1034: Incorrect key file for table: 'EVENTS'Mogens Melander17 Oct
          • Re: ERROR 1034: Incorrect key file for table: 'EVENTS'Jonathan A. Zdziarski17 Oct
            • Re: ERROR 1034: Incorrect key file for table: 'EVENTS'Michael Widenius18 Oct
      • Re: ERROR 1034: Incorrect key file for table: 'EVENTS'sinisa18 Oct