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

[jonz]

>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