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