I have been receiving error 127 from table handler when running some basic
select queries on a large table 1.8 M rows.
I have run myisamchk with the -o -r and -e options but for each of them I
receive an error that is not fixed and I assume that this error is the same
one that is causing the 127 error.
Any idea on how to fix this corruption?
when running - o
# ../../bin/myisamchk -o tblhit.MYI
- recovering (with keycache) MyISAM-table 'tblhit.MYI'
Data records: 1863059
Wrong bytesec: 0- 0- 0 at 156040928; Skipped
Data records: 1863004
when running - r
# ../../bin/myisamchk -r tblhit.MYI
- recovering (with sort) MyISAM-table 'tblhit.MYI'
Data records: 1863354
- Fixing index 1
Wrong bytesec: 0- 0- 0 at 155194936; Skipped
- Fixing index 2
Data records: 1862991
when running -e
# ../../bin/myisamchk -e tblhit.MYI
Checking MyISAM file: tblhit.MYI
Data records: 1862994 Deleted blocks: 0
- check file-size
../../bin/myisamchk: error: Size of datafile is: 156040928 Should
be: 156041128
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
../../bin/myisamchk: error: Found key at page 15202304 that points to record
outside datafile
- check records and index references
../../bin/myisamchk: error: Record-count is not ok; is 1862991 Should
be: 1862994
../../bin/myisamchk: warning: Found 1862991 parts Should
be: 1862994 parts
MyISAM-table 'tblhit.MYI' is corrupted
Fix it using switch "-r" or "-o"
Any help would be appreciated
Michael Blood
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php