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/[EMAIL PROTECTED]

Reply via email to