On Fri, 09 Sep 2011, Alexander Wagner wrote:
> 2011-09-09 09:30:31 --> EMERGENCY: tmp_idxWORD09F needs to repair 205 of
> 205 index records

It looks like you have tmp_idx* tables left behind from a previous
re-indexing job.  You can safely remove these by doing:

  $ echo "SHOW TABLES LIKE 'tmp%'" | /opt/invenio/bin/dbexec
  $ echo "DROP TABLE tmp_idxWORD09F" | /opt/invenio/bin/dbexec
  $ echo "DROP TABLE tmp_idxWORD09R" | /opt/invenio/bin/dbexec
  [...]

> Curiously enough, my problem appears in a --reindex call.
> I'd guess that this should recreate the indexes from scratch
> anyway so any inconsistency should be resolved by this
> automatically regardless if it existed before.

Yes, `bibindex -R' should well drop any temporary tables that may have
been left behind from former re-indexing jobs.  It seems that in your
case the tables were not dropped.  This may be because you are running
an older master branch of Invenio?  (prior to 2010-03-31?)
<http://invenio-software.org/repo/invenio/commit/?id=4ca75d715b96259ce53801109e24abdd8421b3ad>

Best regards
-- 
Tibor Simko

Reply via email to