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? All this is under FC3 on x86_64 AMD opteron, MySQL 5.0.22. Any ideas? Gaspar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
