Results 1 to 4 of 4

Thread: Mysql update to 5.6.11

  1. #1
    asalar is offline Starter Member
    Join Date
    Aug 2013
    Posts
    2
    Rep Power
    1

    Default Mysql update to 5.6.11

    I have a problem with Zimbra after updating MySQL. I use Zimbra 6.0.13 and recently updated MySQL from 5.0.90 to 5.6.11. But whenever I enter my email host I see this error in mailbox.log:
    thanks for reply


    2013-08-19 14:42:03,942 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:1376907123942:b95bbe3cc3b 8cc13
    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:307)
    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:722)
    Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNODB STATUS' at line 1

    Query being executed when exception was thrown:

    SHOW INNODB STATUS
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:936)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 31)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 3283)
    at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1332)
    at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1467)
    at com.zimbra.cs.db.DebugPreparedStatement.executeQue ry(DebugPreparedStatement.java:160)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:93 )
    at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:1 30)
    ... 8 more

  2. #2
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,201
    Rep Power
    56

    Default

    This is in the wrong forum as it's not a question about ZCS development, I'll move it to the correct forum.

    Quote Originally Posted by asalar View Post
    I have a problem with Zimbra after updating MySQL. I use Zimbra 6.0.13 and recently updated MySQL from 5.0.90 to 5.6.11. But whenever I enter my email host I see this error in mailbox.log:
    Which MySQL are you talking about, the on in your ZCS install or the one in your distribution?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    asalar is offline Starter Member
    Join Date
    Aug 2013
    Posts
    2
    Rep Power
    1

    Default

    Thanks Phoenix
    I'm sorry about posting in wrong forum.
    I have updated MySQL in ZCS and also its third party dependencies.

  4. #4
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,201
    Rep Power
    56

    Default

    Quote Originally Posted by asalar View Post
    I have updated MySQL in ZCS and also its third party dependencies.
    Why in heavens name did you do that? The packages in ZCS are designed to be installed as a complete package and not upgraded individually - ZCS is meant to be updated by running the complete install of the most recent version. Did you take a backup before making this change?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mysql update after 7.0 install
    By cpaul_carling in forum Installation
    Replies: 7
    Last Post: 05-06-2012, 06:13 PM
  2. Replies: 0
    Last Post: 12-05-2011, 11:50 AM
  3. mysql update issues
    By ak2009 in forum Installation
    Replies: 0
    Last Post: 09-02-2008, 10:58 PM
  4. Replies: 0
    Last Post: 06-13-2008, 02:56 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •