Page 1 of 1

read_prev_with_key: Got error 127 when reading table

Posted: Sun Dec 26, 2004 10:32 pm
by josh
041226 22:45:48 read_prev_with_key: Got error 127 when reading table: ./path/to/table
I get that error upon trying to insert/update.

I ran myisamchk.exe with -r, -f, -o, etc.... they all just checked the database for about 10 minutes then said it's fine.

When trying to browse the database via phpmyadmin it just does not respond and my cpu usage goes all the way up to 100% and I have to kill apache and mysql. My php scripts can however browse through the database.

Posted: Mon Dec 27, 2004 11:46 am
by josh
I managed to get a dump of the table that was causeing the problems, then I re-installed mySql and used command prompt to restore from the dump (couldn't use phpmyadmin because the dump was too large, about 300 megs). Now the table runs fine except for the fact that when I hit browse in phpmyadmin it locks up. I think this is an issue with the phpmyadmin softwear rather then the table itself. If anyone has experienced problems like these please let me know what you did to resolve them.