Results 1 to 4 of 4

Thread: Error in Folders deleting

  1. #1
    riccionese is offline Beginner Member
    Join Date
    Dec 2011
    Rep Power

    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:// Code:service.FAILURE at com.zimbra.common.service.ServiceException.FAILURE ( at com.zimbra.cs.db.DbMailItem.delete( :1650) at com.zimbra.cs.db.DbMailItem.delete( :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 at com.zimbra.cs.mailbox.Folder.empty( 6) at com.zimbra.cs.mailbox.Mailbox.emptySmallFolder(Mai at com.zimbra.cs.mailbox.Mailbox.emptyFolder(Mailbox. java:6765) at com.zimbra.cs.service.mail.FolderAction.handleFold er( at com.zimbra.cs.service.mail.FolderAction.handle(Fol at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng 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 at javax.servlet.http.HttpServlet.service(HttpServlet .java:814) at org.mortbay.jetty.servlet.ServletHolder.handle(Ser at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter( at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(Set at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter( at org.mortbay.servlet.UserAgentFilter.doFilter(UserA at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:132) at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter( at org.mortbay.jetty.servlet.ServletHandler.handle(Se at at org.mortbay.jetty.servlet.SessionHandler.handle(Se at org.mortbay.jetty.handler.ContextHandler.handle(Co at org.mortbay.jetty.webapp.WebAppContext.handle(WebA at org.mortbay.jetty.handler.ContextHandlerCollection .handle( at org.mortbay.jetty.handler.HandlerCollection.handle ( at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha at org.mortbay.jetty.handler.rewrite.RewriteHandler.h andle( at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha at org.mortbay.jetty.handler.DebugHandler.handle(Debu at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha at org.mortbay.jetty.Server.handle( at org.mortbay.jetty.HttpConnection.handleRequest(Htt at org.mortbay.jetty.HttpConnection$ ntent( at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa at org.mortbay.jetty.HttpConnection.handle(HttpConnec at at org.mortbay.thread.BoundedThreadPool$ n( 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( at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance( at java.lang.reflect.Constructor.newInstance(Construc at com.mysql.jdbc.Util.handleNewInstance( 9) at com.mysql.jdbc.Util.getInstance( at com.mysql.jdbc.SQLError.createSQLException(SQLErro 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( 59) at com.mysql.jdbc.MysqlIO.sqlQueryDirect( :2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm at com.mysql.jdbc.PreparedStatement.executeInternal(P at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre at com.zimbra.cs.db.DebugPreparedStatement.executeUpd ate( at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate( 05) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate( 05) at com.zimbra.cs.db.DbMailItem.delete( :1648) ... 44 more
    roby@mysite.net0_0c8a720e910927224082bc02d647a14c4ddb56fe_69643d3 3363a39623238653535302d313839322d343830322d6136313 32d6664653462623138366538373b6578703d31333a3133323 33030333133383832353b747970653d363a7a696d6272613b

    Someone can help me?
    signed: a newbie!

  2. #2
    tmorrison is offline Starter Member
    Join Date
    Mar 2012
    Rep Power

    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
    bdial's Avatar
    bdial is offline Moderator
    Join Date
    Jul 2007
    Rep Power


    you may want to try reindexing the account

  4. #4
    furlongm is offline New Member
    Join Date
    Mar 2010
    Rep Power


    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.

Thread Information

Users Browsing this Thread

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

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, 07: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, 06: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