Re: ERROR 1034: Incorrect key file for table: 'EVENTS'

[Mogens Melander]

I have the same error. Ive been shutting down, running isamchk -r,
rebooting the server, a lot of times, but still same error ???

On Sun, 17 Oct 1999 sinisa@stripped wrote:

> 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;
>  >
> +----------+---------+------------+---------------------+--------------+------------------+----------+-------+----------------+-----------------+---------+--------------+
>  > | EVENT_ID | PHYS_ID | LOGICAL_ID | DEVICE_HOSTNAME     | DEVICE_IP    |
> DESCRIPTION      | VARIABLE | VALUE | PARENT_PHYS_ID | PARENT_VARIABLE | SERVICE |
> LAST_UPDATED |
>  >
> +----------+---------+------------+---------------------+--------------+------------------+----------+-------+----------------+-----------------+---------+--------------+
>  > |        4 | RT2     |            | rt2.atl.netrail.net | 205.215.10.2 | Router
> 2 Atlanta | BGPpeer  |     0 | RT1            | BGPpeer         | test    |    940118002
> |
>  > |        3 | RT1     |            | rt1.atl.netrail.net | 205.215.10.3 | Router
> 1 Atlanta | BGPpeer  |     5 |                |                 | test    |    940118002
> |
>  >
> +----------+---------+------------+---------------------+--------------+------------------+----------+-------+----------------+-----------------+---------+--------------+
>  > 2 rows in set (0.01 sec)
>  > 
>  > mysql> delete from EVENTS where SERVICE = 'test';
>  > ERROR 1034: Incorrect key file for table: 'EVENTS'. Try to repair it
>  > 
>  >   If I do a 'delete from EVENTS' everything resets and work again for
>  >  another five minutes. 
>  > 
>  > >How-To-Repeat:
>  >   I believe this might have to do with the order of EVENT_ID.  When
>  >  updated, it puts things out of order.  That's my best guess.  All I'm
>  >  doing is inerting these two fields into the table, updating them,
>  >  and then attempting to delete them.
>  > 
>  > >Fix:
>  > 	
>  > 
>  > >Submitter-Id:	<submitter ID>
>  > >Originator:	Jonathan A. Zdziarski
>  > >Organization:
>  >  Netrail, inc.
>  > >MySQL support: none
>  > >Synopsis:	ERROR 1034: Incorrect key file for table
>  > >Severity:	serious
>  > >Priority:	high
>  > >Category:	mysql
>  > >Class:		sw-bug
>  > >Release:	mysql-3.23.4-alpha (Source distribution)
>  > >Server: /usr/local/bin/mysqladmin  Ver 7.11 Distrib 3.23.4-alpha, for
> pc-solaris2.7 on i386
>  > TCX Datakonsult AB, by Monty
>  > 
>  > Server version		3.23.4-alpha
>  > Protocol version	10
>  > Connection		Localhost via UNIX socket
>  > UNIX socket		/tmp/mysql.sock
>  > Uptime:			1 day 9 hours 50 min 14 sec
>  > 
>  > Threads: 1  Questions: 375613  Slow queries: 52  Opens: 154  Flush tables: 1 
> Open tables: 62
>  > >Environment:
>  > 	
>  > System: SunOS elijah.jesuscafe.com 5.7 Generic_106542-01 i86pc i386 i86pc
>  > Architecture: i86pc
>  > 
>  > Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake
> /usr/local/bin/gcc /usr/ucb/cc
>  > GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.7/2.8.1/specs
>  > gcc version 2.8.1
>  > Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
>  > LIBC: 
>  > -rw-r--r--   1 bin      bin      1540208 Sep  1  1998 /lib/libc.a
>  > lrwxrwxrwx   1 root     root          11 Nov 16  1998 /lib/libc.so ->
> ./libc.so.1
>  > -rwxr-xr-x   1 bin      bin       936736 Sep  1  1998 /lib/libc.so.1
>  > -rw-r--r--   1 bin      bin      1540208 Sep  1  1998 /usr/lib/libc.a
>  > lrwxrwxrwx   1 root     root          11 Nov 16  1998 /usr/lib/libc.so ->
> ./libc.so.1
>  > -rwxr-xr-x   1 bin      bin       936736 Sep  1  1998 /usr/lib/libc.so.1
>  > Configure command: ./configure 
>  > Perl: This is perl, version 5.005_61 built for i86pc-solaris
>  > 
>  > 
>  > 
> 
> 
> Please, everytime you get such a message, shut down a server and run
> isamchk -r on the table.
> 
> Sinisa
> 
> +----------------------------------------------------------------------+
> | TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
> |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
> |    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
> |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
> |  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
> |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
> |             /*/             \*\                Developers Team       |
> +----------------------------------------------------------------------+
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread16196@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>