Results 1 to 4 of 4

Thread: Error in Folders deleting

Hybrid View

  1. #1
    Join Date
    Dec 2011
    Posts
    1
    Rep Power
    3

    Default Error in Folders deleting

    I have an Release 7.1.2_GA_3268.UBUNTU10_64 UBUNTU10_64 FOSS edition.

    in the "Trash" I have some folder previous deleted from their original location but now I can't remove those.

    from CLI:

    zimbra@mail$ zmmailbox -z -m roby gaf |grep Trash
    3 unkn 0 0 /Trash
    2021 mess 0 0 /Trash/ex-Persone2
    2024 mess 0 0 /Trash/ex-Persone2/ex-Boc2
    2022 mess 0 0 /Trash/ex-Persone2/ex-Col2

    zimbra@mail$ zmmailbox -z -m roby deleteFolder "/Trash/ex-Persone2/ex-Col2"
    ERROR: service.FAILURE (system failure: deleting 1 item(s): 2022)

    zimbra@mail$ zmmailbox -z -m roby deleteFolder "/Trash/ex-Persone2"
    ERROR: service.FAILURE (system failure: deleting 1 item(s): 2022)

    zimbra@mail$ zmmailbox -z -m roby deleteFolder "/Trash/ex-Persone2/ex-Boc2"
    ERROR: service.FAILURE (system failure: deleting 1 item(s): 2024)

    while from the web client:

    method: [unknown]
    msg: system failure: deleting 1 item(s): 2022
    code: service.FAILURE
    detail: soap:Receiver
    trace: com.zimbra.common.service.ServiceException: system failure: deleting 1 item(s): 2022 ExceptionId:btpool0-34://www.mysite.net/service/soap/FolderActionRequest:1322830393607:d70001e0e18049ac Code:service.FAILURE at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:248) at com.zimbra.cs.db.DbMailItem.delete(DbMailItem.java :1650) at com.zimbra.cs.db.DbMailItem.delete(DbMailItem.java :1614) at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2624) at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2544) at com.zimbra.cs.mailbox.Folder.deleteSingleFolder(Fo lder.java:1107) at com.zimbra.cs.mailbox.Folder.empty(Folder.java:109 6) at com.zimbra.cs.mailbox.Mailbox.emptySmallFolder(Mai lbox.java:6781) at com.zimbra.cs.mailbox.Mailbox.emptyFolder(Mailbox. java:6765) at com.zimbra.cs.service.mail.FolderAction.handleFold er(FolderAction.java:125) at com.zimbra.cs.service.mail.FolderAction.handle(Fol derAction.java:104) at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:412) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:287) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:158) at com.zimbra.soap.SoapServlet.doWork(SoapServlet.jav a:294) at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:215) at javax.servlet.http.HttpServlet.service(HttpServlet .java:725) at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:208) at javax.servlet.http.HttpServlet.service(HttpServlet .java:814) at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1166) at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(Set HeaderFilter.java:79) at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1157) at org.mortbay.servlet.UserAgentFilter.doFilter(UserA gentFilter.java:81) at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:132) at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:218) 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:422) 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.handler.DebugHandler.handle(Debu gHandler.java:77) 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:946) at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:405) at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:410) at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:451) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`mboxgroup6`.`mail_item`, CONSTRAINT `fk_mail_item_folder_id` FOREIGN KEY (`mailbox_id`, `folder_id`) REFERENCES `mail_item` (`mailbox_id`, `id`)) Query being executed when exception was thrown: DELETE FROM mboxgroup6.mail_item WHERE mailbox_id = 6 AND id = 2022 at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Construc tor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1041) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 59) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2568) at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2113) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2409) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2327) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2312) at com.zimbra.cs.db.DebugPreparedStatement.executeUpd ate(DebugPreparedStatement.java:169) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05) at com.zimbra.cs.db.DbMailItem.delete(DbMailItem.java :1648) ... 44 more
    request:
    roby@mysite.net0_0c8a720e910927224082bc02d647a14c4ddb56fe_69643d3 3363a39623238653535302d313839322d343830322d6136313 32d6664653462623138366538373b6578703d31333a3133323 33030333133383832353b747970653d363a7a696d6272613b

    Someone can help me?
    signed: a newbie!

  2. #2
    Join Date
    Mar 2012
    Posts
    1
    Rep Power
    3

    Default Same issue

    I have a couple users reporting the same issue. Failure notice shows same "system failure: deleting 1 item(s)", etc. as shown in original post.

    Any info available?

  3. #3
    Join Date
    Jul 2007
    Location
    Baltimore
    Posts
    1,649
    Rep Power
    11

    Default

    you may want to try reindexing the account

  4. #4
    Join Date
    Mar 2010
    Posts
    4
    Rep Power
    5

    Default

    Quote Originally Posted by bdial View Post
    you may want to try reindexing the account
    I have the same issue as above. Reindexing the account had no effect. Are there any other suggestions?
    Last edited by furlongm; 11-20-2012 at 08:03 PM.

Similar Threads

  1. Deleting the Junk and Outbox folders?
    By KeepItReal in forum General Questions
    Replies: 0
    Last Post: 11-17-2011, 08:08 PM
  2. Replies: 0
    Last Post: 10-31-2011, 08:20 AM
  3. .pst migration issues
    By jimklein in forum Migration
    Replies: 13
    Last Post: 02-16-2009, 01:55 AM
  4. Many duplicate folders in T-Bird
    By carnold in forum Administrators
    Replies: 0
    Last Post: 08-11-2007, 07:06 AM

Posting Permissions

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