Error in Folders deleting

[riccionese]

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!

[tmorrison]

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?

[bdial]

you may want to try reindexing the account