Results 1 to 2 of 2

Thread: Mysql server is not running after ZCS upgrade from zcs-6.0.6 to zcs-7.2.3

  1. #1
    chandu is offline Elite Member
    Join Date
    Dec 2007
    Posts
    445
    Rep Power
    7

    Default Mysql server is not running after ZCS upgrade from zcs-6.0.6 to zcs-7.2.3

    Dear All,

    I have performing testing on my production dump for zimbra upgrade from zcs-6.0.6_GA_2330.RHEL5_64 to zcs-7.2.3_GA_2872.RHEL5_64.
    After upgradation mysql.server is not getting started and giving error as below :

    ################################################## #

    [zimbra@mail ~]$ zmcontrol status
    Host mail.tcsion.com
    antispam Running
    antivirus Running
    ldap Running
    logger Running
    mailbox Stopped
    mysql.server is not running.
    memcached Running
    mta Running
    snmp Running
    spell Running
    stats Stopped
    zmconfigd Running
    [zimbra@mail ~]$ zmcontrol -v
    Release 7.2.3_GA_2872.RHEL5_64_20130304144832 RHEL5_64 FOSS edition.
    [zimbra@mail ~]$

    ################################################## ###############


    Mysql Configuration is as below :

    [mysqld]

    max_allowed_packet = 16777216

    slow_query_log_file = /opt/zimbra/log/myslow.log

    slow_query_log = 1

    plugin-load = innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_pl ugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lo ck_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_ plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;inn odb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset =ha_innodb_plugin.so



    ignore-builtin-innodb

    innodb=FORCE

    innodb_flush_log_at_trx_commit = 0

    tmpdir = /opt/zimbra/data/tmp

    basedir = /opt/zimbra/mysql
    datadir = /opt/zimbra/db/data
    socket = /opt/zimbra/db/mysql.sock
    pid-file = /opt/zimbra/db/mysql.pid
    bind-address = localhost
    port = 7306
    user = zimbra

    external-locking

    long-query-time = 1
    log-queries-not-using-indexes

    thread_cache_size = 110
    max_connections = 110

    # We do a lot of writes, query cache turns out to be not useful.
    query_cache_type = 0

    sort_buffer_size = 1048576
    read_buffer_size = 1048576

    # Increase the size of the table cache, since each mailbox has its
    # own set of tables
    table_cache = 1200

    innodb_buffer_pool_size = 3787525324
    innodb_log_file_size = 524288000
    innodb_log_buffer_size = 8388608
    innodb_file_per_table
    innodb_open_files = 2710
    innodb_max_dirty_pages_pct = 30
    innodb_flush_method = O_DIRECT

    [mysqld_safe]

    pid-file = /opt/zimbra/db/mysql.pid

    err-log = /opt/zimbra/log/mysqld.log


    ################################################## ##########

    Mysql error logs are as below :

    130329 14:18:15 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use GCC atomic builtins
    InnoDB: Compressed tables use zlib 1.2.3
    130329 14:18:15 InnoDB: Initializing buffer pool, size = 3.5G
    130329 14:18:16 InnoDB: Completed initialization of buffer pool
    130329 14:18:16 InnoDB: highest supported file format is Barracuda.
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    130329 14:18:16 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Error: trying to add tablespace 1513 of name './mboxgroup1/mail_item_dumpster.ibd'
    InnoDB: to the tablespace memory cache, but tablespace
    InnoDB: 1513 of name './zimbra/flush_enforcer.ibd' already exists in the tablespace
    InnoDB: memory cache!
    130329 14:18:16 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
    ~
    ~
    ##############################################


    I do not have much knowledge for mysql DB so please help.. Mean whille I am searching on net as well..

    Thanks and Regards,

  2. #2
    Raunaq's Avatar
    Raunaq is offline Zimbra Employee
    Join Date
    Nov 2012
    Location
    Bangalore
    Posts
    163
    Rep Power
    2

    Default

    HeY Chandu,

    Can you follow Mysql Crash Recovery - Zimbra :: Wiki and see if that helps?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. mysql.server is not running
    By SirGarvin in forum Administrators
    Replies: 2
    Last Post: 08-21-2012, 11:37 AM
  2. mysql.server Not Running
    By PS-Man in forum Error Reports
    Replies: 6
    Last Post: 10-15-2008, 02:36 AM
  3. mysql.server is not running
    By aileen in forum Administrators
    Replies: 1
    Last Post: 07-31-2008, 08:55 AM
  4. mysql.server not running
    By indu in forum Administrators
    Replies: 2
    Last Post: 01-02-2008, 01:07 AM
  5. mysql.server is not running
    By Oswald-Kolle in forum Installation
    Replies: 27
    Last Post: 05-01-2007, 08:28 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
  •