HI, All tables are fine. No problem. I did a TRUNCATE and rebuild the index by -R (repair) option. It's fine. However, the web interface now shows NO record. (http://ecdl.hkuspace.hku.hk)
I am wondering if I need to figure out the problematic record in order to fix the index problem. How? -----Original Message----- From: Tibor Simko [mailto:[email protected]] Sent: Friday, June 19, 2009 8:35 PM To: KU Kam-ming Cc: project-cdsware-users (CDSware users list.) Subject: Re: bibindex error 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/>
