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
