Possibly corrupt index?

[phl4kx]

Hi friends, I have 100 mailbox in my zimbra server, on some accounts I have this error many times /opt/zimbra/log/mailbox.log:


2011-06-20 19:33:16,180 WARN [LmtpServer-19021] [name=jacosta@xxx.com.pe;mid=30;ip=xxx.xxx.xxx.xxx;] index - beginWritingNestLevel is 0 in LuceneIndex.doneWriting, flushing skipped

2011-06-20 19:33:17,219 WARN [LmtpServer-19021] [name=jacosta@xxx.com.pe;mid=30;ip=xxx.xxx.xxx.xxx;] indexadd - Caught exception while indexing message id 0 - indexing blocked. Possibly corrupt index?

java.io.IOException: Could not create index com.zimbra.cs.index.Z23FSDirectory@/opt/zimbra/index/0/30/index/0 (directory already exists)
at com.zimbra.cs.index.LuceneIndex.doWriterOpen(Lucen eIndex.java:868)
at com.zimbra.cs.index.IndexWritersCache.beginWriting (IndexWritersCache.java:210)
at com.zimbra.cs.index.LuceneIndex.beginWriting(Lucen eIndex.java:806)
at com.zimbra.cs.index.LuceneIndex.beginWriteOperatio n(LuceneIndex.java:788)
at com.zimbra.cs.index.MailboxIndex.beginWriteOperati on(MailboxIndex.java:268)
at com.zimbra.cs.mailbox.IndexHelper.indexingPartOfEn dTransaction(IndexHelper.java:987)
at com.zimbra.cs.mailbox.Mailbox.endTransaction(Mailb ox.java:7042)
at com.zimbra.cs.mailbox.IndexHelper.indexItemList(In dexHelper.java:908)
at com.zimbra.cs.mailbox.IndexHelper.indexDeferredIte msInternal(IndexHelper.java:367)
at com.zimbra.cs.mailbox.IndexHelper.indexDeferredIte ms(IndexHelper.java:284)
at com.zimbra.cs.mailbox.IndexHelper.maybeIndexDeferr edItems(IndexHelper.java:240)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:4372)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:4365)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:4313)
at com.zimbra.cs.filter.IncomingMessageHandler.addMes sage(IncomingMessageHandler.java:113)
at com.zimbra.cs.filter.IncomingMessageHandler.implic itKeep(IncomingMessageHandler.java:106)
at com.zimbra.cs.filter.ZimbraMailAdapter.doDefaultFi ling(ZimbraMailAdapter.java:283)
at com.zimbra.cs.filter.ZimbraMailAdapter.executeActi ons(ZimbraMailAdapter.java:187)
at org.apache.jsieve.SieveFactory.evaluate(SieveFacto ry.java:164)
at com.zimbra.cs.filter.RuleManager.applyRulesToIncom ingMessage(RuleManager.java:349)
at com.zimbra.cs.filter.RuleManager.applyRulesToIncom ingMessage(RuleManager.java:312)
at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver MessageToLocalMailboxes(ZimbraLmtpBackend.java:447 )
at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver MessageToLocalMailboxes(ZimbraLmtpBackend.java:279 )
at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver (ZimbraLmtpBackend.java:169)
at com.zimbra.cs.lmtpserver.LmtpHandler.processMessag eData(LmtpHandler.java:365)
at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDA TA(TcpLmtpHandler.java:72)
at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHa ndler.java:350)
at com.zimbra.cs.lmtpserver.LmtpHandler.processComman d(LmtpHandler.java:170)
at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCom mand(TcpLmtpHandler.java:66)
at com.zimbra.cs.tcpserver.ProtocolHandler.processCon nection(ProtocolHandler.java:196)
at com.zimbra.cs.tcpserver.ProtocolHandler.run(Protoc olHandler.java:139)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo rker.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.lucene.store.LockObtainFailedException: Lock obtain timed out: SingleInstanceLock: write.lock
at org.apache.lucene.store.Lock.obtain(Lock.java:85)
at org.apache.lucene.index.IndexWriter.init(IndexWrit er.java:1070)
at org.apache.lucene.index.IndexWriter.<init>(IndexWr iter.java:1044)
at com.zimbra.cs.index.LuceneIndex.doWriterOpen(Lucen eIndex.java:833)
... 32 more


Some solution to this problem please?

I use Release 6.0.10_GA_2692.UBUNTU8_64 UBUNTU8_64 FOSS edition.

Thanks a lot

Additional Info

I have this log message many times in /opt/zimbra/log/mysql_error.log:


TRANSACTION 0 4187380, ACTIVE 0 sec, process no 8157, OS thread id 1101920592 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
MySQL thread id 1, query id 26650 localhost 127.0.0.1 zimbra Sorting result
SELECT id, size, type, unread, folder_id, parent_id, blob_digest, mod_content, mod_metadata, flags, index_id, volume_id FROM mboxgroup41.mail_item WHERE mailbox_id = 41 AND change_date < 1296298475 AND type NOT IN (1,2,13,3,4) AND folder_id = 3 ORDER BY change_date LIMIT 10000

InnoDB: Submit a detailed bug report to http://bugs.mysql.com
110228 5:54:35 InnoDB: error clustered record for sec rec not found
InnoDB: index `i_folder_id_date` of table `mboxgroup41/mail_item`
InnoDB: sec index record PHYSICAL RECORD: n_fields 4; compact format; info bits 0
0: len 4; hex 00000029; asc );; 1: len 4; hex 00000004; asc ;; 2: len 4; hex 4d3fa877; asc M? w;; 3: len 4; hex 000008d4; asc ;;

InnoDB: clust index record PHYSICAL RECORD: n_fields 23; compact format; info bits 0
0: len 4; hex 00000029; asc );; 1: len 4; hex 00000010; asc ;; 2: len 6; hex 000000002c5c; asc ,\;; 3: len 7; hex 800000002d022a; asc - *;; 4: len 1; hex 81; asc ;; 5: len 4; hex 00000001; asc ;; 6: len 4; hex 00000001; asc ;; 7: SQL NULL; 8: SQL NULL; 9: len 4; hex 4b72f540; asc Kr @;; 10: len 8; hex 0000000000000000; asc ;; 11: SQL NULL; 12: SQL NULL; 13: len 4; hex 00000000; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 8; hex 8000000000000000; asc ;; 16: SQL NULL; 17: len 9; hex 427269656663617365; asc Briefcase;; 18: len 9; hex 427269656663617365; asc Briefcase;; 19: len 30; hex 64313a61693165343a6d736571693165343a756e7874693137 65313a7669; asc d1:ai1e4:mseqi1e4:unxti17e1:vi;...(truncated); 20: len 4; hex 00000001; asc ;; 21: len 4; hex 4b72f540; asc Kr @;; 22: len 4; hex 00000001; asc ;;

[obsidian]

Hi

Did you manage to fix this problem ?