I am repeatedly getting this error message from MySQL, i.e.:
mysql> select * from mantis_user_table;
ERROR 1030: Got error 127 from table handler
This problem manifests itself in the web-based system as a complete lack of bugs if the error comes from the mantis_bug_table table!
Googling shows that this apparently means 'the database is corrupt' and sure enough myisamchk says:
root# myisamchk -e mantis_user_table.MYI
Checking MyISAM file: mantis_user_table.MYI
Data records: 25 Deleted blocks: 0
myisamchk: warning: 1 client is using or hasn't closed the table properly
- check file-size
myisamchk: error: Size of datafile is: 3980 Should be: 4000
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check records and index references
myisamchk: warning: Found 25 parts Should be: 26 parts
MyISAM-table 'mantis_user_table.MYI' is corrupted
Fix it using switch "-r" or "-o"
I have been fixing tables using the -o option, but firstly, this seems to create a lot of data loss (several bugs/comments/files lost each time - myisamchck reports 'truncation of rows' or somesuch) and secondly, the tables seem to keep getting corrupt soon after I repair them!
Does anybody have any idea what could be happening? Is the 'client is using or hasn't closed the table properly' error significant or does this always happen with Mantis? Any other suggestions?
We are using MySQL Ver 12.22 Distrib 4.0.21, for apple-darwin7.5.0 (powerpc) on Mac OS X 10.3 with PHP 4.3.2.
Thanks in advance,
"We come to bury Windows, not to praise it." http://www.linux.org