Hello.
I'm not sure, but this is really strange for me. I suggest you to reproduce the problem on the latest release (4.1.9 now). Use official binaries. Also, you may try mysqld-max. Work with backups of your table. Dump it and then import to the new instance of MySQL (4.1.9 or 4.1.9-max). Create a new table from existing one with insert ... select statement. Try to insert rows in a new table. Jon Ribbens <[EMAIL PROTECTED]> wrote: > Does nobody have any ideas on this? It's quite perplexing. > It's MySQL "Ver 14.6 Distrib 4.1.5-gamma", if it makes a difference. > > Jon Ribbens <[EMAIL PROTECTED]> wrote: >> I am getting Error 136 "No more room in index file" on a table, >> but the table does not appear to be full in any way. As you can see >> from the "myisamchk -dv" output below, both the datafile length and >> the keyfile length are much smaller than their respective maximums. >> The table is on a Linux ext3 partition and the partition is nowhere >> near full. >> >> Does anyone know how to fix this problem? I have already tried >> 'alter table foo max_rows=38807046144', which took over 30 hours >> to complete and hasn't had any noticeable effect. >> >> $ uname -a >> Linux fooserver 2.4.21-20.EL #1 Wed Aug 18 20:46:27 EDT 2004 i686 athlon >> i386 GNU/Linux >> >> $ ls -l foo.* >> -rw-rw---- 1 mysql mysql 23990598560 Feb 5 09:19 foo.MYD >> -rw-rw---- 1 mysql mysql 18353124352 Feb 5 09:19 foo.MYI >> -rw-rw---- 1 mysql mysql 9746 Feb 4 03:17 foo.frm >> >> # myisamchk -dv foo >> >> MyISAM file: foo >> Record format: Fixed length >> Character set: latin1_swedish_ci (8) >> File-version: 1 >> Creation time: 2005-02-04 3:17:26 >> Recover time: 2005-02-05 8:59:54 >> Status: open,changed >> Data records: 749706205 Deleted blocks: 0 >> Datafile parts: 749706205 Deleted data: 0 >> Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4 >> Datafile length: 23990598560 Keyfile length: 18353124352 >> Max datafile length: 137438953470 Max keyfile length: 4398046510079 >> Recordlength: 32 >> >> table description: >> Key Start Len Index Type Rec/key Root >> Blocksize >> 1 2 4 unique unsigned long 0 6117707776 >> 1024 >> 2 7 4 multip. unsigned long 0 12235415552 >> 1024 >> 3 11 4 multip. unsigned long 0 18353123328 >> 1024 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
