LinkBack URL
About LinkBacks
[SOLVED] NE resource deleted, can't be restored, mysql contstraing violations
Actual problem: 5.0.2 backups can't be restored to 5.0.4 server. Keep reading.
So I just accidentally deleted a resource account, which was sharing a global calendar to almost every user on the system.
zmrestore attempts fail with "Error code: service.FAILURE Message: system failure: restoring table: mailbox Details:soap:Receiver"
Help!!!
I've mitigated the impact on users by disabling the minicalendar and zmmailbox df all mountpoints to the global calendar, but still getting zillions of these:
Code:ExceptionId:btpool0-2082:1206550663127:e2052f28a0145c52 Code:service.FAILURE at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.j ava:253) at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox.java:182) at com.zimbra.cs.mailbox.MailboxManager.createMailbox(MailboxManager.jav a:669) at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxMan ager.java:290) at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxMan ager.java:226) at com.zimbra.soap.DocumentHandler.getRequestedMailbox(DocumentHandler.j ava:157) at com.zimbra.cs.service.mail.MailDocumentHandler.preHandle(MailDocument Handler.java:46) at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:387) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:250) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:156) at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:177) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487 ) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1093) at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:132) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1084) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3 60) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav a:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1 81) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7 16) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:406) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand lerCollection.java:211) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection. java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1 39) at org.mortbay.jetty.handler.RewriteHandler.handle(RewriteHandler.java:1 76) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1 39) at org.mortbay.jetty.Server.handle(Server.java:313) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50 6) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio n.java:844) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja va:396) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool .java:442) Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry 'fc5cfd24-e9c6-449d-b20c-2c46f130ed83' for key 2 Query being executed when exception was thrown: com.mysql.jdbc.ServerPreparedStatement[68421] - INSERT INTO mailbox(account_id, id, group_id, index_volume_id, item_id_checkpoint, last_backup_at, comment) SELE CT 'fc5cfd24-e9c6-449d-b20c-2c46f130ed83', next_mailbox_id, 0, index_volume_id, 255, null, 'wsgcal@example.com' FROM current_volumes ORDER BY index_volume_id L IMIT 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt atement.java:1160) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared Statement.java:685) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :1400) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :1314) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :1299) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del egatingPreparedStatement.java:233) at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox.java:137) ... 35 more 2008-03-26 11:57:43,130 ERROR [btpool0-2082] [name=wsgcal@example.com;aname=cmi ller@example.com;ip=137.22.128.119;ua=Zimbra iSync Connector/5.0.1971 (Mac OS X 1049);] mailbox - Error during mailbox creation com.zimbra.common.service.ServiceException: system failure: writing new mailbox row for account fc5cfd24-e9c6-449d-b20c-2c46f130ed83 ExceptionId:btpool0-2082:1206550663130:e2052f28a0145c52 Code:service.FAILURE at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.j ava:253) at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox.java:182) at com.zimbra.cs.mailbox.MailboxManager.createMailbox(MailboxManager.jav a:669) at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxMan ager.java:290) at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxMan ager.java:226) at com.zimbra.soap.DocumentHandler.getRequestedMailbox(DocumentHandler.j ava:157) at com.zimbra.soap.SoapEngine.generateResponseHeader(SoapEngine.java:483 ) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:283) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:156) at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:177) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487 ) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1093) at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:132) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1084) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3 60) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav a:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1 81) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7 16) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:406) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand lerCollection.java:211) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection. java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1 39) at org.mortbay.jetty.handler.RewriteHandler.handle(RewriteHandler.java:1 76) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1 39) at org.mortbay.jetty.Server.handle(Server.java:313) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50 6) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio n.java:844) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja va:396) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool .java:442) Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry 'fc5cfd24-e9c6-449d-b20c-2c46f130ed83' for key 2 Query being executed when exception was thrown: com.mysql.jdbc.ServerPreparedStatement[68421] - INSERT INTO mailbox(account_id, id, group_id, index_volume_id, item_id_checkpoint, last_backup_at, comment) SELE CT 'fc5cfd24-e9c6-449d-b20c-2c46f130ed83', next_mailbox_id, 0, index_volume_id, 255, null, 'wsgcal@example.com' FROM current_volumes ORDER BY index_volume_id L IMIT 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt atement.java:1160) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared Statement.java:685) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :1400) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :1314) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :1299) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del egatingPreparedStatement.java:233) at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox.java:137) ... 34 more
