 Empty Trash Errors
I have a number of emails in my trash that won't purge. This is the message I get:
Product name: Zimbra Desktop
Product version: 1.0.4
Build ID: 1833
Release type: R
OS Platform: Windows XP x86 5.1
Time of event: 2011-01-20 11:29:14
Error type: service.FAILURE
Item ID: 11871
Error summary: delete item failed
Failure details - PLEASE REMOVE ANY SENSITIVE INFORMATION
----------------------------------------------------------------------------
com.zimbra.common.service.ServiceException: system failure: deleting contents for virtual conversation -11871
ExceptionId:btpool0-16:1295551754250:36a8225642f8c0f6
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbMailItem.deleteContents(DbMailI tem.java:1408)
at com.zimbra.cs.db.DbMailItem.delete(DbMailItem.java :1345)
at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2448)
at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2372)
at com.zimbra.cs.mailbox.Message.delete(Message.java: 802)
at com.zimbra.cs.mailbox.Mailbox.delete(Mailbox.java: 5752)
at com.zimbra.cs.mailbox.OfflineMailbox.delete(Offlin eMailbox.java:242)
at com.zimbra.cs.service.mail.ItemActionHelper.execut eLocal(ItemActionHelper.java:351)
at com.zimbra.cs.service.mail.ItemActionHelper.schedu le(ItemActionHelper.java:313)
at com.zimbra.cs.service.mail.ItemActionHelper.HARD_D ELETE(ItemActionHelper.java:97)
at com.zimbra.cs.service.mail.ItemAction.handleCommon (ItemAction.java:138)
at com.zimbra.cs.service.mail.MsgAction.handle(MsgAct ion.java:43)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:429)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:286)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:160)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:275)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:716)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:406)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.handler.RewriteHandler.handle(Re writeHandler.java:176)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:442)
Caused by: java.sql.SQLException: DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID' for key (3,11871). The statement has been rolled back.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeS tatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
at com.zimbra.cs.db.DbMailItem.deleteContents(DbMailI tem.java:1406)
... 37 more
Caused by: ERROR 23503: DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID' for key (3,11871). The statement has been rolled back.
at org.apache.derby.iapi.error.StandardException.newE xception(Unknown Source)
at org.apache.derby.impl.sql.execute.ReferencedKeyRIC hecker.doCheck(Unknown Source)
at org.apache.derby.impl.sql.execute.RISetChecker.doP KCheck(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteResultSet. runFkChecker(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeRes ultSet.runFkChecker(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeRes ultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement .execute(Unknown Source)
... 42 more
----------------------------------------------------------------------------
Thanks.
Brendan  | 
Bugzilla
Wiki
Source
Linear Mode
