Are there any known issues with table corrouption on 4.0.14-standard-log?
I'm getting recurring problems with a single table becoming corrupted, does
mysql handle disk full problems gracefully or could that cause something
like this?
# myisamchk -c jobs
Checking MyISAM file: jobs
Data records: 53484 Deleted blocks: 37182
myisamchk: warning: Table is marked as crashed
- check file-size
- check key delete-chain
- check record delete-chain
myisamchk: warning: Not used space is supposed to be: 29749896 but is:
29749108
myisamchk: error: record delete-link-chain corrupted
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check data record references index: 6
- check data record references index: 7
- check data record references index: 8
- check data record references index: 9
- check record links
myisamchk: warning: Found 37181 deleted blocks Should be: 37182
myisamchk: warning: Found 139912 parts Should be:
139913 parts
MyISAM-table 'jobs' is corrupted
Fix it using switch "-r" or "-o"
--
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
