Hi folks,

I had a power-out last night that pulled my server come down, and although the system has come up, users can no longer reply to inbound mail.

I'll probably end up spinning up a new VM with a fresh install and then migrate users individually, but I was hoping there might be someone who has had the same problem and been able to fix it...?

I'm on Fedora 11, running zcs-7.1.0_GA_3140.F11.20110329135310

Here's the error details from a failed attempt to reply:

Code:
method:	[unknown]
msg:	system failure: adding children to parent 40570
code:	service.FAILURE
detail:	soap:Receiver
trace:	com.zimbra.common.service.ServiceException: system failure: adding children to parent 40570 ExceptionId:btpool0-0://webmail.davison-family.com/service/soap/SendMsgRequest:1306973763122:312656c3101413db Code:service.FAILURE at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:248) at com.zimbra.cs.db.DbMailItem.setParent(DbMailItem.java:737) at com.zimbra.cs.mailbox.Conversation.create(Conversation.java:245) at com.zimbra.cs.mailbox.Mailbox.createConversation(Mailbox.java:5037) at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(Mailbox.java:4929) at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4695) at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4630) at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4567) at com.zimbra.cs.filter.OutgoingMessageHandler.explicitKeep(OutgoingMessageHandler.java:90) at com.zimbra.cs.filter.OutgoingMessageHandler.implicitKeep(OutgoingMessageHandler.java:117) at com.zimbra.cs.filter.ZimbraMailAdapter.doDefaultFiling(ZimbraMailAdapter.java:332) at com.zimbra.cs.filter.RuleManager.applyRulesToOutgoingMessage(RuleManager.java:448) at com.zimbra.cs.mailbox.MailSender.sendMimeMessage(MailSender.java:516) at com.zimbra.cs.mailbox.MailSender.sendMimeMessage(MailSender.java:425) at com.zimbra.cs.mailbox.MailSender.sendMimeMessage(MailSender.java:385) at com.zimbra.cs.service.mail.SendMsg.doSendMessage(SendMsg.java:193) at com.zimbra.cs.service.mail.SendMsg.handle(SendMsg.java:154) at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:412) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:287) at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:158) at com.zimbra.soap.SoapServlet.doWork(SoapServlet.java:294) at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:215) at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:208) at javax.servlet.http.HttpServlet.service(HttpServlet.java:814) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(SetHeaderFilter.java:79) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 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(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:218) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.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(HandlerWrapper.java:152) at org.mortbay.jetty.handler.rewrite.RewriteHandler.handle(RewriteHandler.java:230) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.handler.DebugHandler.handle(DebugHandler.java:77) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:543) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:946) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure The last packet successfully received from the server was 108 milliseconds ago. The last packet sent successfully to the server was 107 milliseconds ago. Query being executed when exception was thrown: UPDATE mboxgroup5.mail_item SET parent_id = 40570, mod_metadata = 38628, change_date = 1306973762 WHERE mailbox_id = 5 AND (id = 40548 OR id = 40569) at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3055) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312) at com.zimbra.cs.db.DebugPreparedStatement.executeUpdate(DebugPreparedStatement.java:169) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at com.zimbra.cs.db.DbMailItem.setParent(DbMailItem.java:732) ... 50 more
request:	

Body: {
  SendMsgRequest: {
    _jsns: "urn:zimbraMail",
    m: {
      e: [
        0: {
          a: "sender@domain.com",
          add: "0",
          p: "Sender NAme",
          t: "t"
         },
        1: {
          a: "recipient@domain.com",
          p: "Andrew J. Davison",
          t: "f"
         }
       ],
      idnt: "eace906a-28ae-44a7-842e-208c6ec12be7",
      irt: {
        _content: "<BANLkTikzERp52g+TN+z9vATD2tKgsYbTWg@mail.gmail.com>"
       },
      mp: [
        0: {
          content: {
            _content: "Sounds good to me!

----- Original Message -----


<Content removed>

"
           },
          ct: "text/plain"
         }
       ],
      origid: "40548",
      rt: "r",
      su: {
        _content: "Re: Sausage sub group"
       }
     },
    suid: 1306973755761
   }
 },
Header: {
  context: {
    _jsns: "urn:zimbra",
    account: {
      _content: "recipient@domain.com",
      by: "name"
     },
    authToken: "(removed)",
    notify: {
      seq: 2
     },
    session: {
      _content: 157,
      id: 157
     },
    userAgent: {
      name: "ZimbraWebClient - FF3.0 (Win)",
      version: "7.1.0_GA_3140"
     }
   }
 }

	Send Error Report		
	
	Hide Details
Cheers!

Andrew