Empty trash error on webmail

[gutocarvalho]

When i try to clean my trash folder i always receive this message (webmail).

A network service error has occurred. msg: system failure: marking deletions for conversations crossing folder 1777
code: service.FAILURE
method: FolderActionRequest
detail: soap:Receiver
trace: btpool0-1145:1229359924943:7274c21977433427

--- mailbox.log ---------------------------

com.zimbra.common.service.ServiceException: system failure: marking deletions for conversations crossing folder 1777
ExceptionId:btpool0-1119:1229357837535:7274c21977433427
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbMailItem.markDeletionTargets(Db MailItem.java:1209)
at com.zimbra.cs.mailbox.Folder.propagateDeletion(Fol der.java:1034)
at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2391)
at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2372)
at com.zimbra.cs.mailbox.Folder.deleteSingleFolder(Fo lder.java:1005)
at com.zimbra.cs.mailbox.Folder.empty(Folder.java:994 )
at com.zimbra.cs.mailbox.Mailbox.emptyFolder(Mailbox. java:6250)
at com.zimbra.cs.service.mail.FolderAction.handleFold er(FolderAction.java:124)
at com.zimbra.cs.service.mail.FolderAction.handle(Fol derAction.java:103)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:433)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:288)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:167)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:269)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:189)
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$CachedCha in.doFilter(ServletHandler.java:1093)
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:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:360)
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.rewrite.RewriteHandler.h andle(RewriteHandler.java:350)
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: Got error 28 from storage engine

Query being executed when exception was thrown:

com.mysql.jdbc.ServerPreparedStatement[44443] - UPDATE mboxgroup21.mail_item, (SELECT parent_id pid, COUNT(*) count FROM mboxgroup21.mail_item WHERE mailbox_id = 1221 AND folder_id = 1777 AND parent_id IS NOT NULL GROUP BY parent_id) AS x SET size = size - count, metadata = NULL, mod_metadata = 3724, change_date = 1229357837 WHERE mailbox_id = 1221 AND id = pid AND type = 4
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2870)
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:1165)
... 38 more


I'm still trying to figure out the problem.

[]'s
Guto

[marcmac]

any errors in the mysql error log? does this persist across a restart? I've never seen that "marking deletions for conversations crossing folder 1777" - what operation are you performing, empty trash? Trash shouldn't be folder 1777 - is there a folder IN your trash?

[bburtin]

$ perror 28
OS error code  28:  No space left on device

Gotta love MySQL error reporting.

[arto]

I haved the same problem.

In my case i mounted in /tmp a smbfs directory and zimbra failed to write into /tmp directory and caused this fail. When i dismount /tmp all run ok.