On Fri, 19 Jun 2009, KU Kam-ming wrote: > same error Okay, so if you cannot even check Invenio indexes, then please launch the low-level MySQL table check:
$ echo 'CHECK TABLE idxWORD01F' | /opt/cds-invenio/bin/dbexec $ echo 'CHECK TABLE idxWORD01R' | /opt/cds-invenio/bin/dbexec $ echo 'CHECK TABLE idxPHRASE01F' | /opt/cds-invenio/bin/dbexec $ echo 'CHECK TABLE idxPHRASE01R' | /opt/cds-invenio/bin/dbexec If the tables are alright, then you can wipe out your indexes and reindex anew: $ echo 'TRUNCATE idxWORD01F' | /opt/cds-invenio/bin/dbexec $ echo 'TRUNCATE idxWORD01R' | /opt/cds-invenio/bin/dbexec $ echo 'TRUNCATE idxPHRASE01F' | /opt/cds-invenio/bin/dbexec $ echo 'TRUNCATE idxPHRASE01R' | /opt/cds-invenio/bin/dbexec $ bibindex -u admin -w global -v 9 -R In the example above, I'm using the global anyfield index (id=1) as an example. You may want to do that for all your indexes (idx* tables). But chances are that if there is a problematic record, then it will be caught with the global index. (Another option is that the problem might be related to the fulltext index, id=9.) Best regards -- Tibor Simko ** CERN Document Server ** <http://cds.cern.ch/>
