Results 1 to 3 of 3

Thread: Purge Trash Error

  1. #1
    Chadsel Chen is offline Active Member
    Join Date
    Jul 2007
    Location
    New York, NY
    Posts
    46
    Rep Power
    7

    Default Purge Trash Error

    I got the following errors when I tried to purge a trash forlder of one my user.

    2008-05-28 15:44:45,213 INFO [http-443-Processor48] [name=brad@christoffersonrobb.com;aname=admin@chris toffersonrobb.com;mid=77;ip=82.109.221.162;ua=Zimb raWebClient - FF2.0 (Win)/4.5.10_GA_1575.RHEL5_64;] SoapEngine - handler exception
    com.zimbra.common.service.ServiceException: system failure: marking deletions for conversations crossing folder 3
    at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:165)
    at com.zimbra.cs.db.DbMailItem.markDeletionTargets(Db MailItem.java:942)
    at com.zimbra.cs.mailbox.Folder.propagateDeletion(Fol der.java:881)
    at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:1633)
    at com.zimbra.cs.mailbox.Folder.empty(Folder.java:845 )
    at com.zimbra.cs.mailbox.Mailbox.emptyFolder(Mailbox. java:4554)
    at com.zimbra.cs.service.mail.FolderAction.handleFold er(FolderAction.java:117)
    at com.zimbra.cs.service.mail.FolderAction.handle(Fol derAction.java:98)
    at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:266)
    at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:163)
    at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:85)
    at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:220)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:709)
    at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:152)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
    at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
    at org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:541)
    at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:667)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)

    at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:619)
    Caused by: com.mysql.jdbc.exceptions.MySQLDataException: Data truncation: Out of range value adjusted for column 'size' at row 1

    Query being executed when exception was thrown:

    com.mysql.jdbc.ServerPreparedStatement[23168] - UPDATE mboxgroup77.mail_item, (SELECT parent_id pid, COUNT(*) count FROM mboxgroup77.mail_item WHERE mailbox_id = 77 AND folder_id = 3 AND parent_id IS NOT NULL GROUP BY parent_id) x SET size = size - count, metadata = NULL, mod_metadata = 190122, change_date = 1212003885 WHERE mailbox_id = 77 AND id = pid AND type = 4
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2868)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 73)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecu te(ServerPreparedStatement.java:1160)
    at com.mysql.jdbc.ServerPreparedStatement.executeInte rnal(ServerPreparedStatement.java:685)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1400)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1314)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1299)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
    at com.zimbra.cs.db.DbMailItem.markDeletionTargets(Db MailItem.java:938)
    ... 28 more

    mbox xxxx@xxxxxxxx.com> gaf
    Id View Unread Msg Count Path
    ---------- ---- ---------- ---------- ----------
    1 conv 0 0 /
    10 appo 0 21 /Calendar
    14 mess 0 0 /Chats
    7 cont 0 5 /Contacts
    6 mess 0 10 /Drafts
    13 cont 0 484 /Emailed Contacts
    2 mess 8965 38765 /Inbox
    1734 conv 0 18 /Inbox/CCDS
    49963 conv 0 0 /Journal
    4 mess 385 508 /Junk
    12 wiki 0 1 /Notebook
    49964 conv 0 0 /Notes
    4041 mess 11020 11277 /Old Mail
    49962 conv 0 0 /Outbox
    81726 conv 0 0 /Returned Mail
    5 mess 4019 8825 /Sent
    15 task 0 0 /Tasks
    3 conv 0 7223 /Trash
    81724 conv 0 0 /Undelivered
    mbox xxxx@xxxx.com>

    I got the same error either throught GUI or zmmailbox command. Can someone help me with this issue?

    Thanks

  2. #2
    Chadsel Chen is offline Active Member
    Join Date
    Jul 2007
    Location
    New York, NY
    Posts
    46
    Rep Power
    7

    Default

    Does anyone have any idea?

  3. #3
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default

    Not off the top of my head. Please file a bug and attach the stack trace.
    Bugzilla - Wiki - Downloads - Before posting... Search!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. Replies: 20
    Last Post: 03-18-2008, 05:37 AM
  3. [SOLVED] Debian Etch 32 / 64: MTA not working
    By xflip in forum Installation
    Replies: 2
    Last Post: 01-18-2008, 04:58 AM
  4. M3 problem with shares
    By titangears in forum Users
    Replies: 4
    Last Post: 01-12-2006, 01:01 PM
  5. Building native libraries on MacOS X
    By ajmas in forum Developers
    Replies: 3
    Last Post: 10-14-2005, 11:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •