Gaspar Bakos wrote:
Hi,
I have a table that stores geometry information in one column in
"point" type. After freshly uploading the table,
myisamcheck --sort-index reports an error:
- Sorting index for MyISAM-table 'TEST_I14_GEOM'
myisamchk: Unknown error 126
myisamchk: error: Can't read key block from filepos: 71995659058108416
MyISAM-table 'TEST_I14_GEOM' is not fixed because of errors
===================
OK, so I go ahead, and fix it:
myisamchk --analyze
Checking MyISAM file: TEST_I14_GEOM
Data records: 37852738 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
MyISAM-table 'TEST_I14_GEOM' is usable but should be fixed
====================
myisamchk --verbose --recover
- recovering (with keycache) MyISAM-table 'TEST_I14_GEOM'
Data records: 37852738
The recovery exists with 0, and is seemingly successful.
====================
Then I go back to
myisamcheck --sort-index, and I get the same error;
myisamchk: Unknown error 126
myisamchk: error: Can't read key block from filepos: 71995659058108416
MyISAM-table 'TEST_I14_GEOM' is not fixed because of errors
Seems like myisamcheck --sort-index does not work with spatial
indexing?
or you have a disk error.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
