return of error 136

[Tom Kleinpeter <tomwk@xxxxxxxxxxxxxxx>]

I was having some problems with: 

ERROR 1030: Got error 136 from table handler

many versions ago when my indexes got to be around 64M.  

I started getting it again with 3.23.34 when I try to do inserts
into a table with this index size:

-rw-rw----    1 mysql    mysql    94232404 Mar 15 11:34 Files05.MYD
-rw-rw----    1 mysql    mysql    67058688 Mar 15 17:10 Files05.MYI
-rw-rw----    1 mysql    mysql        8664 Sep 20 00:23 Files05.frm

Here's my system info:

Server version          3.23.34
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 2 days 17 hours 34 min 7 sec

Threads: 62  Questions: 13610269  Slow queries: 0  Opens: 57  Flush tables: 1  Open tables: 51 Queries per se
cond avg: 57.659
>Environment:
        <machine, os, target, libraries (multiple lines)>
		System: Linux db2-3.audiogalaxy.com 2.2.18 #1 SMP Mon Dec 11 23:54:40 CST 2000 i686 unknown
		Architecture: i686

		Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
		GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
		gcc version 2.96 20000731 (Red Hat Linux 7.0)
		Compilation info: CC='egcs'  CFLAGS='-O6 -fomit-frame-pointer -mpentium'  CXX='egcs'  CXXFLAGS='-O6 -fomit-fr
		ame-pointer                  -felide-constructors -fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
		LIBC:
		lrwxrwxrwx    1 root     root           14 Dec 11 23:28 /lib/libc.so.6 -> libc-2.1.94.so
		-rwxr-xr-x    1 root     root      4796386 Oct  5 16:46 /lib/libc-2.1.94.so
		-rw-r--r--    1 root     root     22737326 Oct  5 16:09 /usr/lib/libc.a
		-rw-r--r--    1 root     root          178 Oct  5 16:09 /usr/lib/libc.so
		Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all
		-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefi
		x=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/
		share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --withou
		t-berkeley-db --without-innobase '--with-comment=Official MySQL RPM'



-- 
Tom Kleinpeter
tomwk@xxxxxxxxxxxxxxx

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread68399@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php