I have Zimbra Desktop 2.0.1 (build 10559) Windows XP with seven accounts created (6 IMAP, one Comcast POP).
ONE of the IMAP accounts (the largest) gives the error below whenever you click in the box. It APPEARS to stay synced, at least as far as the account status showing read/unread mesaages, but...
  • can't be used to read new messages, although after first startup latest messages appear in "All Mailboxes" display.
  • a "Send/Receive" in this mailbox may keep spinning forever.

The IMAP server is SCOoffice 4.2, the OEM variant of the Bynari Cyrus IMAP server.

I've clicked on "Send Error Report" many times. This behaviour also occurred in 2.0.0.

Thanks in advance.
Tom



A network service error has occurred.
method: SearchRequest
msg: system failure: fetching search metadata
code: service.FAILURE
detail: soap:Receiver
trace: com.zimbra.common.service.ServiceException: system failure: fetching search metadata ExceptionId:btpool0-5:1293138279687:dc8d15da7fb20cb8 Code:service.FAILURE at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:248) at com.zimbra.cs.db.DbSearch.searchInternal(DbSearch. java:759) at com.zimbra.cs.db.DbSearch.search(DbSearch.java:572 ) at com.zimbra.cs.index.DBQueryOperation.noLuceneGetNe xtChunk(DBQueryOperation.java:850) at com.zimbra.cs.index.DBQueryOperation.getNextChunk( DBQueryOperation.java:1101) at com.zimbra.cs.index.DBQueryOperation.peekNext(DBQu eryOperation.java:625) at com.zimbra.cs.index.QueryOperation.hasNext(QueryOp eration.java:159) at com.zimbra.cs.index.ItemPreloadingGrouper.bufferHi ts(ItemPreloadingGrouper.java:51) at com.zimbra.cs.index.BufferingResultsGrouper.hasNex t(BufferingResultsGrouper.java:60) at com.zimbra.cs.index.MsgQueryResults.internalGetNex tHit(MsgQueryResults.java:62) at com.zimbra.cs.index.MsgQueryResults.bufferNextHit( MsgQueryResults.java:125) at com.zimbra.cs.index.MsgQueryResults.peekNext(MsgQu eryResults.java:146) at com.zimbra.cs.index.ZimbraQueryResultsImpl.hasNext (ZimbraQueryResultsImpl.java:70) at com.zimbra.cs.index.HitIdGrouper.bufferHits(HitIdG rouper.java:63) at com.zimbra.cs.index.BufferingResultsGrouper.peekNe xt(BufferingResultsGrouper.java:69) at com.zimbra.cs.index.FilteredQueryResults.peekNext( FilteredQueryResults.java:132) at com.zimbra.cs.index.FilteredQueryResults.hasNext(F ilteredQueryResults.java:102) at com.zimbra.cs.index.ResultsPager.hasNext(ResultsPa ger.java:151) at com.zimbra.cs.service.mail.Search.putHits(Search.j ava:200) at com.zimbra.cs.service.mail.Search.handle(Search.ja va:127) at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:420) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:274) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:158) at com.zimbra.soap.SoapServlet.doWork(SoapServlet.jav a:291) at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:212) at javax.servlet.http.HttpServlet.service(HttpServlet .java:727) at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:181) at javax.servlet.http.HttpServlet.service(HttpServlet .java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:390) at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:418) at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:152) at org.mortbay.jetty.handler.rewrite.RewriteHandler.h andle(RewriteHandler.java:230) at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:543) at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:939) at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:755) at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:405) at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:413) at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:451) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (too many SQL variables) at org.sqlite.DB.newSQLException(DB.java:374) at org.sqlite.DB.newSQLException(DB.java:378) at org.sqlite.DB.throwex(DB.java:365) at org.sqlite.NativeDB.prepare(Native Method) at org.sqlite.DB.prepare(DB.java:123) at org.sqlite.PrepStmt.(PrepStmt.java:44) at org.sqlite.Conn.prepareStatement(Conn.java:403) at org.sqlite.Conn.prepareStatement(Conn.java:398) at org.sqlite.Conn.prepareStatement(Conn.java:382) at com.zimbra.cs.db.RetryConnection$1.execute(RetryCo nnection.java:23) at com.zimbra.cs.db.AbstractRetry.doRetry(AbstractRet ry.java:44) at com.zimbra.cs.db.RetryConnection.prepareStatement( RetryConnection.java:27) at org.apache.commons.dbcp.DelegatingConnection.prepa reStatement(DelegatingConnection.java:248) at org.apache.commons.dbcp.PoolingDataSource$PoolGuar dConnectionWrapper.prepareStatement(PoolingDataSou rce.java:302) at com.zimbra.cs.db.DbPool$Connection.prepareStatemen t(DbPool.java:105) at com.zimbra.cs.db.DbSearch.searchInternal(DbSearch. java:710) ... 45 more
request:

Body: {
SearchRequest: {
_jsns: "urn:zimbraMail",
limit: 400,
locale: {
_content: "en_US"
},
offset: 0,
query: "in:"inbox"",
sortBy: "dateDesc",
types: "message",
tz: {
id: "America/New_York"
}
}
},
Header: {
context: {
_jsns: "urn:zimbra",
account: {
_content: "tom@microlite.com",
by: "name"
},
authToken: "(removed)",
notify: {
seq: 167
},
session: {
_content: 18,
id: 18
},
userAgent: {
name: "ZimbraWebClient - PRISM (Win)",
version: "0.0"
}
}
}