List:General Discussion« Previous MessageNext Message »
From:Jonathan A. Zdziarski Date:October 17 1999 6:32pm
Subject:Re: ERROR 1034: Incorrect key file for table: 'EVENTS'
View as plain text  
It doesn't do this in the stable version...i just tried.

On Sun, 17 Oct
1999, Mogens Melander wrote:

> 
> 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.
> > 
> 

Thank you,

Jonathan A. Zdziarski
Sr. Systems Administrator
Netrail, inc. 
888.NET.RAIL x240
http://www.netrail.net

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