Results 1 to 5 of 5

Thread: Corrupt database? Table mboxgroupXX.revision doesn't exist

  1. #1
    Join Date
    May 2012
    Posts
    3
    Rep Power
    3

    Default Corrupt database? Table mboxgroupXX.revision doesn't exist

    Hi.
    Today, some user can't login on web gui to zimbra mail.

    Zimbra try select from non exist table.

    Code:
    com.zimbra.common.service.ServiceException: system failure: fetching folder data for mailbox 145
    ExceptionId:btpool0-33://localhost/service/soap/NoOpRequest:1337155676860:4898304e4098edb8
    Code:service.FAILURE
            at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:253)
            at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMailItem.java:2102)
            at com.zimbra.cs.mailbox.Mailbox.loadFoldersAndTags(Mailbox.java:1535)
            at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mailbox.java:1239)
            at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mailbox.java:1190)
            at com.zimbra.cs.mailbox.Mailbox.getConfig(Mailbox.java:1263)
            at com.zimbra.cs.mailbox.Mailbox.open(Mailbox.java:458)
            at com.zimbra.cs.mailbox.MailboxManager.getMailboxById(MailboxManager.java:521)
            at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:369)
            at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:337)
            at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:298)
            at com.zimbra.cs.session.Session.register(Session.java:138)
            at com.zimbra.cs.session.SoapSession.register(SoapSession.java:433)
            at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:337)
            at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:290)
            at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:399)
            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:303)
            at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:217)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
            at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:206)
            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:155)
            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:585)
            at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:988)
            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:415)
            at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:429)
            at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mboxgroup45.revision' doesn't exist
    
    Query being executed when exception was thrown:
    SELECT mi.folder_id, SUM(rev.size) FROM mboxgroup45.mail_item AS mi, mboxgroup45.revision AS rev WHERE mi.id = rev.item_id AND rev.mailbox_id = 145 AND mi.ma
    ilbox_id = rev.mailbox_id GROUP BY folder_id
    
    
            at sun.reflect.GeneratedConstructorAccessor87.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.Util.getInstance(Util.java:384)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
            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.executeQuery(PreparedStatement.java:2275)
            at com.zimbra.cs.db.DebugPreparedStatement.executeQuery(DebugPreparedStatement.java:156)
            at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
            at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
            at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMailItem.java:2084)
            ... 48 more

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,587
    Rep Power
    58

    Default

    I'll move this to the correct forum as it's not a question about Zimbra Desktop (which is where you posted).

    Quote Originally Posted by loginrl103 View Post
    Today, some user can't login on web gui to zimbra mail.
    You can start by updating your forum profile with the output of the following command (do not post the output in this thread):

    Code:
    zmcontrol -v
    You should then try a forum search and look at some of the results.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    Join Date
    May 2012
    Posts
    3
    Rep Power
    3

    Default

    thx, correct profile, search nothing found

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,587
    Rep Power
    58

    Default

    Quote Originally Posted by loginrl103 View Post
    thx, correct profile, search nothing found
    I've already given you the search in my previous post with the details of the problem.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    Join Date
    May 2012
    Posts
    3
    Rep Power
    3

    Default

    finding post not have information about my problem.

Similar Threads

  1. Replies: 5
    Last Post: 05-11-2012, 03:16 PM
  2. Database integrity check
    By mludwig in forum Administrators
    Replies: 4
    Last Post: 08-15-2011, 03:56 AM
  3. [SOLVED] Zimbra 7.0.1 Database Issue after upgrade
    By n.bochev in forum Administrators
    Replies: 3
    Last Post: 03-16-2011, 02:07 AM
  4. Replies: 6
    Last Post: 03-14-2011, 05:21 AM
  5. [SOLVED] New zcs 7 install : database errors founds
    By dkbk in forum Administrators
    Replies: 4
    Last Post: 03-01-2011, 06:49 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
  •