[SOLVED] Issues Reindexing Mail Accounts

[Lynner]

We are having a few users on our systems that are having issues searchign through their inboxes. Well when we go to re-index the mailbox it acts like there is nothing inside the box. Here are the logs that I pulled, Any Ideas?

2009-02-03 10:00:06,082 WARN [LmtpServer-224942] [name=Email;mid=844;] index - Possibly corrupt index: 1 indexing operations failed in mailbox transaction.
2009-02-03 10:01:24,915 WARN [LmtpServer-224934] [name=Email;mid=844;] index - Possibly corrupt index: 1 indexing operations failed in mailbox transaction.
2009-02-03 10:02:46,768 WARN [LmtpServer-224947] [name=Email;mid=844;] index - Possibly corrupt index: 1 indexing operations failed in mailbox transaction.
2009-02-03 10:11:48,233 WARN [LmtpServer-225021] [name=Email;mid=844;] index - Possibly corrupt index: 5 indexing operations failed in mailbox transaction.
2009-02-03 10:11:48,233 WARN [LmtpServer-225021] [name=Email;mid=844;] index - Possibly corrupt index: Too many failures (5) trying to indexItemList (total list size=5140) Aborting
2009-02-03 10:11:48,233 INFO [LmtpServer-225021] [name=Email;mid=844;] mailbox - Deferred Indexing: successfully indexed 0 items in 67ms (0.0/sec). (5 items failed to index). IndexDeferredCount now at 5140

[uxbod]

Have a read through Admin Tools & Tidbits - Part 2 » Zimbra :: Blog as you may be able to use the optimize script to rebuild the tables and generate the indexes. Have not done this myself before but may be a better option that Wiki :: MySQL Crash Recovery. Remember to take a backup first !

[Lynner]

This is the Fix that Zimbra Gave us today and it worked great. Thanks! Zimbra!!!

zmprov gmi user@domain.com

You will get this result:
zmprov gmi user@domain.com
mailboxId: ####
quotaUsed: ######

This will give you the mailboxId.
Next go to the index directory:

cd /opt/zimbra/index/0/{mailboxId}/index/0

For Example:
/opt/zimbra/index/0/1244/index/0

And delete the contents of the above directory.

Then you can run the indexing command through the command line:

zmprov rim user@domain.com start.

[eloi]

I probe this solution, and doesn't work, I'm using zimbra network edition 6.0.1.

I search the message that I have infront of my, and doesn't find?

any idea?

[trahloc]

seconded, this did not work for me either.

[RJones]

This worked perfectly for me.

I had 2 accounts that would not re index, the other accounts would work fine.

I had tried re-indexing from the GUI, and the CLI both in and out of maintenance. I followed the steps mentioned there and they worked perfectly, and users can now search their inboxes.

Thanks for the information