Re: No more room in index file (136) - but index is not full?

2005-02-07 Thread Jon Ribbens
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

Re: No more room in index file (136) - but index is not full?

2005-02-07 Thread Gleb Paharenko
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

No more room in index file (136) - but index is not full?

2005-02-05 Thread Jon Ribbens
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