read_prev_with_key: Got error 127 when reading table

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

read_prev_with_key: Got error 127 when reading table

Post 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.
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Post 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.
Post Reply