Yes, it's a VPS running on Xen. But itruns since version 6 without a problem and now a have this problem. I played with the hosts and after playing I restored it to the orginal and now I get this errors too.
mailbox.log:
2011-07-08 04:16:26,314 INFO [btpool0-12://localhost:7071/service/admin/soap/GetDomainInfoRequest] [ip=127.0.0.1;ua=ZCS/7.1.0_GA_3140;] soap - GetDomainInfoRequest
2011-07-08 04:16:27,943 INFO [btpool0-14://mail.test.com/service/soap/BatchRequest] [name=xxx@test.com;ip=80.64.152.96;ua=ZimbraWebClie nt - FF3.0 (Win)/7.1.0_GA_3140;] soap - BatchRequest
2011-07-08 04:16:27,943 INFO [btpool0-14://mail.test.com/service/soap/BatchRequest] [name=xxx@test.com;ip=80.64.152.96;ua=ZimbraWebClie nt - FF3.0 (Win)/7.1.0_GA_3140;] soap - (batch) GetMailboxMetadataRequest
2011-07-08 04:16:27,944 INFO [btpool0-14://mail.test.com/service/soap/BatchRequest] [name=xxx@test.com;ip=80.64.152.96;ua=ZimbraWebClie nt - FF3.0 (Win)/7.1.0_GA_3140;] session - exception while creating session
com.zimbra.common.service.ServiceException: system failure: fetching stats on mailbox 6
ExceptionId:btpool0-14://mail.test.com/service/soap/BatchRequest:1310112987944:d0904828e78b537a
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:248)
at com.zimbra.cs.db.DbMailbox.getMailboxStats(DbMailb ox.java:770)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByI d(MailboxManager.java:456)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccountId(MailboxManager.java:346)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccountId(MailboxManager.java:297)
at com.zimbra.cs.session.Session.register(Session.jav a:138)
at com.zimbra.cs.session.SoapSession.register(SoapSes sion.java:433)
at com.zimbra.soap.DocumentHandler.getSession(Documen tHandler.java:337)
at com.zimbra.soap.DocumentHandler.getSession(Documen tHandler.java:290)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:399)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:273)
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:218)
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.MySQLSyntaxErrorEx ception: Unknown table engine 'InnoDB'
Query being executed when exception was thrown:
SELECT account_id, group_id, size_checkpoint, contact_count, item_id_checkpoint, change_checkpoint, tracking_sync, tracking_imap, index_volume_id, last_soap_access, new_messages, idx_deferred_count, highest_indexed FROM mailbox WHERE id = 6
at sun.reflect.GeneratedConstructorAccessor47.newInst ance(Unknown Source)
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:1054)
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.executeQuery(Prep aredStatement.java:2275)
at com.zimbra.cs.db.DebugPreparedStatement.executeQue ry(DebugPreparedStatement.java:156)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
at com.zimbra.cs.db.DbMailbox.getMailboxStats(DbMailb ox.java:702)
... 42 more
2011-07-08 04:16:27,946 INFO [btpool0-14://mail.test.com/service/soap/BatchRequest] [name=xxx@test.com;ip=80.64.152.96;ua=ZimbraWebClie nt - FF3.0 (Win)/7.1.0_GA_3140;] SoapEngine - handler exception
com.zimbra.common.service.ServiceException: system failure: fetching stats on mailbox 6
ExceptionId:btpool0-14://mail.test.com/service/soap/BatchRequest:1310112987945:d0904828e78b537a
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:248)
at com.zimbra.cs.db.DbMailbox.getMailboxStats(DbMailb ox.java:770)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByI d(MailboxManager.java:456)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccountId(MailboxManager.java:346)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccountId(MailboxManager.java:297)
at com.zimbra.soap.DocumentHandler.getRequestedMailbo x(DocumentHandler.java:155)
at com.zimbra.cs.service.mail.GetMailboxMetadata.hand le(GetMailboxMetadata.java:32)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:412)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:273)
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:218)
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.MySQLSyntaxErrorEx ception: Unknown table engine 'InnoDB'
Query being executed when exception was thrown:
SELECT account_id, group_id, size_checkpoint, contact_count, item_id_checkpoint, change_checkpoint, tracking_sync, tracking_imap, index_volume_id, last_soap_access, new_messages, idx_deferred_count, highest_indexed FROM mailbox WHERE id = 6
at sun.reflect.GeneratedConstructorAccessor47.newInst ance(Unknown Source)
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:1054)
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.executeQuery(Prep aredStatement.java:2275)
at com.zimbra.cs.db.DebugPreparedStatement.executeQue ry(DebugPreparedStatement.java:156)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
at com.zimbra.cs.db.DbMailbox.getMailboxStats(DbMailb ox.java:702)
... 40 more
2011-07-08 04:16:50,415 WARN [mailboxd.csv] [] DbStats - An error occurred while getting current database stats
com.zimbra.common.service.ServiceException: system failure: SQL: 'SHOW INNODB STATUS'
ExceptionId:mailboxd.csv:1310113010415:d0904828e78 b537a
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:248)
at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:1 34)
at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:1 76)
at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:2 02)
at com.zimbra.cs.db.DbStats.getStatData(DbStats.java: 45)
at com.zimbra.common.stats.RealtimeStats.getData(Real timeStats.java:67)
at com.zimbra.cs.stats.ZimbraPerf$MailboxdStats.getDa taLines(ZimbraPerf.java:519)
at com.zimbra.common.stats.StatsDumper.call(StatsDump er.java:110)
at com.zimbra.common.stats.StatsDumper$1.run(StatsDum per.java:79)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown table engine 'InnoDB'
Query being executed when exception was thrown:
SHOW INNODB STATUS
at sun.reflect.GeneratedConstructorAccessor47.newInst ance(Unknown Source)
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:1054)
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.executeQuery(Prep aredStatement.java:2275)
at com.zimbra.cs.db.DebugPreparedStatement.executeQue ry(DebugPreparedStatement.java:156)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:1 30)
... 8 more
Please can someone help me. Thanks. |