[SOLVED] Error deleting index before re-indexing

[alahser]

Hi,

I'm new to Zimbra. I apologize if this has been discussed before, but, I'm not finding help searching the forums or using Google.

I have a mailbox that never produces any search results. Every text search fails. I found information about reindexing the mailbox. When I try to reindex the mailbox, I get this error in zmmailboxd.out:

com.zimbra.common.service.ServiceException: system failure: Error deleting index before re-indexing
ExceptionId:Thread-49:1223424147604:20aa03a621c30a9a
Code:service.FAILURE
        at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:253)
        at com.zimbra.cs.mailbox.Mailbox.reIndex(Mailbox.java:1815)
        at com.zimbra.cs.service.admin.ReIndex$ReIndexThread.run(ReIndex.java:157)
Caused by: java.io.IOException: read past EOF
        at org.apache.lucene.store.BufferedIndexInput.refill(BufferedIndexInput.java:146)
        at org.apache.lucene.store.BufferedIndexInput.readByte(BufferedIndexInput.java:38)
        at org.apache.lucene.store.IndexInput.readInt(IndexInput.java:66)
        at org.apache.lucene.store.IndexInput.readLong(IndexInput.java:89)
        at org.apache.lucene.index.SegmentInfo.(SegmentInfo.java:140)
        at org.apache.lucene.index.SegmentInfos.read(SegmentInfos.java:220)
        at org.apache.lucene.index.IndexFileDeleter.(IndexFileDeleter.java:168)
        at org.apache.lucene.index.IndexWriter.init(IndexWriter.java:723)
        at org.apache.lucene.index.IndexWriter.(IndexWriter.java:666)
        at com.zimbra.cs.index.Lucene23Index.deleteIndex(Lucene23Index.java:334)
        at com.zimbra.cs.index.MailboxIndex.deleteIndex(MailboxIndex.java:500)
        at com.zimbra.cs.mailbox.Mailbox.reIndex(Mailbox.java:1808)
        ... 1 more

This mailbox was originally populated using the outlook pst importer program. I am using FOSS 5.0.10 running on Ubuntu 8.04 LTS. Searches in other mailboxes (which were not loaded using the outlook pst import) do work correctly.

What else can I try?

Thanks in advance,
Andrew

[mmorse]

Welcome to the forums,

When you have a window of time:
1. zmprov gmi user@domain.com
1. Set the problematic account into a restricted mode: zmprov ma user@domain.com zimbraAccountStatus maintenance (this step is not completely necessary but I would prevent access somehow)
3. Shutdown Zimbra (zmcontrol stop)
4. Delete the folder # dedicated to the user under /opt/zimbra/index/0/
5. zmcontrol start - you will see that it rebuilds the index of the mailbox.
6. Wait until the reindexing is finished.
7. If you did step 1, make the account active again. zmprov ma user@domain.com zimbraAccountStatus active

A good read: Account mailbox database structure - Zimbra :: Wiki

[alahser]

Foremost, thanks for taking time to help. I'm not sure how you took my symptoms and came up with such a precise recipe, but I appreciate your experience.

I didn't completely trust the results initially, because, I could not find a log file that indicated that the rebuild occurred without any further error. However, I could verify that text searches were working.

So, I followed your steps exactly. After (for good measure), I performed the following two commands:

/opt/zimbra/bin/zmprov rim user@domain.com start

Then, periodically:

/opt/zimbra/bin/zmprov rim user@domain.com status

I kept the user logged out during this 2nd rebuild. I was able to monitor the status while the re-build was happening. These two steps may not have been necessary, but, it gave me a good feeling. I also found the entry in mailbox.log that indicated:

2008-10-07 23:22:56,710 INFO [Thread-262] [] mailbox - Re-Indexing: Mailbox 12 COMPLETED. Re-indexed 6302 items in 2733092ms. (avg 433ms/item= 2 items/sec) (0 failed)


I have to say, it is very, very, very cool to do simple text searches across > 6000 messages and 1.2Gig of data. The results are amazingly split-second. Thanks for your fine software.

Best Regards,
Andrew