Hi
I am seeing an interesting (annoying) problem where my myisam tables are getting corrupted when subjected to a heavy update/insert load, generating the following errors:
Error 'Got error 127 from table handler' on query 'update content set content=...
This error seems to occur randomly, but frequently, and does not seem to depend on the size of the table. I have seen this happen on tables with 500,000 rows and 47,000,000 rows.
This corruption can happen either at the end of the table, or in the middle of the table. If it happens at the end of the table, the table can no longer be appended until it is fixed.
Myisamchk is able to fix the issue.
I am using MySQL version 4.0.18 on a dual 64 bit AMD machines running the latest gentoo linux distribution.
Thanks in advance for any help.
François
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
