Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Upgrade Problem from Zimbra 6.0.8 to Zimbra 7

  1. #1
    gerembel@hotmail.com is offline Junior Member
    Join Date
    Mar 2011
    Posts
    6
    Rep Power
    4

    Default Upgrade Problem from Zimbra 6.0.8 to Zimbra 7

    I have problem upgrading ZCS Release 6.0.8_GA_2661.RHEL5_64_20100820052503 RHEL5_64 FOSS edition to Zimbra 7.

    When upgrading to Zimbra 7, the process ran until mysql starting and I have waited for 15 min.. and nothing happened

    Here's the log
    Code:
    Removing existing packages
    
       zimbra-ldap...done
       zimbra-logger...done
       zimbra-mta...done
       zimbra-snmp...done
       zimbra-store...done
       zimbra-memcached...done
       zimbra-core...done
    
    Removing deployed webapp directories
    Installing packages
    
        zimbra-core......zimbra-core-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
        zimbra-ldap......zimbra-ldap-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
        zimbra-logger......zimbra-logger-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
        zimbra-mta......zimbra-mta-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
        zimbra-snmp......zimbra-snmp-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
        zimbra-store......zimbra-store-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
        zimbra-memcached......zimbra-memcached-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
    
    Setting defaults from saved config in /opt/zimbra/.saveconfig/config.save
       HOSTNAME=*********
       LDAPHOST=*********
       LDAPPORT=389
       SNMPTRAPHOST=*********
       SMTPSOURCE=*********
       SMTPDEST=*********
       SNMPNOTIFY=yes
       SMTPNOTIFY=yes
       LDAPROOTPW=*********
       LDAPZIMBRAPW=*********
       LDAPPOSTPW=*********
       LDAPREPPW=*********
       LDAPAMAVISPW=*********
       LDAPNGINXPW=*********
    Restoring existing configuration file from /opt/zimbra/.saveconfig/localconfig.xml...done
    Operations logged to /tmp/zmsetup.03082011-090739.log
    Upgrading from  to 7.0.0_GA_3077
    Stopping zimbra services...done.
    Verifying /opt/zimbra/conf/my.cnf
    Starting mysql...
    And here is the mysql_error.log
    Code:
    [root@zeus log]# tail -f mysql_error.log
    110308  8:51:42 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.90-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution
    110308  9:05:56 [Note] /opt/zimbra/mysql/libexec/mysqld: Normal shutdown
    
    110308  9:05:56  InnoDB: Starting shutdown...
    110308  9:05:57  InnoDB: Shutdown completed; log sequence number 0 1765920
    110308  9:05:57 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete
    
    110308 09:05:57  mysqld ended
    
    110308 09:07:45 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
    110308  9:07:45 [Warning] '--log_slow_queries' is deprecated and will be removed                                                                                         in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' in stead.
    110308  9:07:45 [Warning] '--log-long-format' is deprecated and will be removed                                                                                         in a future release. Please use '--log-short-format' instead.
    /opt/zimbra/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
    110308  9:07:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    110308  9:07:45 [ERROR] /opt/zimbra/mysql/libexec/mysqld: unknown variable 'inno                                                                                        db_buffer_pool_size=117124300'
    110308  9:07:45 [ERROR] Aborting
    
    110308  9:07:45 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete
    
    110308 09:07:45 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
    Has anybody had any problem like this?

    Thanks for your kindness support

  2. #2
    John Siu is offline Loyal Member
    Join Date
    Feb 2011
    Posts
    82
    Rep Power
    4

    Default

    I had the exact same problem the day I did the upgrade. Please post your
    /opt/zimbra/conf/my.cnf

    or compare your with the following:
    Code:
    [mysqld]
    
    slow_query_log = 1
    
    plugin-load = innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_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
    
    #log-slow-queries = /opt/zimbra/log/myslow.log
    slow_query_log_file = /opt/zimbra/log/myslow.log
    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   = 238806834
    innodb_log_file_size      = 104857600
    innodb_log_buffer_size    = 8388608
    innodb_file_per_table
    innodb_open_files = 2710
    innodb_max_dirty_pages_pct = 10
    innodb_flush_method       = O_DIRECT
    
    [mysqld_safe]
    
    pid-file = /opt/zimbra/db/mysql.pid
    
    err-log      = /opt/zimbra/log/mysqld.log
    This should be standard for single machine Zimbra installation.

    But also check if your zimbra mysql version, should be:
    Code:
    /opt/zimbra/mysql-standard-5.1.52-pc-linux-gnu-i686-glibc23
    If the above config fix this issue, you should run upgrade again and this time should go all the way to normal completion.

    Another thing to check is the linux user zimbra is able to sudo (/etc/sudoer) and ssh (/etc/ssh/sshd_config). I am using Debian here, RedHaat may be a bit different.

  3. #3
    gerembel@hotmail.com is offline Junior Member
    Join Date
    Mar 2011
    Posts
    6
    Rep Power
    4

    Default

    Here is my.cnf configuration
    Code:
    [mysqld]
    
    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
    tmpdir       = /opt/zimbra/data/tmp
    
    external-locking
    
    log-slow-queries = /opt/zimbra/log/myslow.log
    long-query-time  = 1
    log-long-format
    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
    
    # (Num mailbox groups * Num tables in each group) + padding
    table_cache = 1200
    
    innodb_buffer_pool_size        = 117124300
    innodb_log_file_size           = 104857600
    innodb_log_buffer_size         = 8388608
    innodb_file_per_table
    
    # Value is: 200 + max_connections + 2 * table_cache
    innodb_open_files              = 2710
    
    innodb_max_dirty_pages_pct     = 10
    innodb_flush_method            = O_DIRECT
    innodb_flush_log_at_trx_commit = 0
    
    [mysqld_safe]
    
    err-log      = /opt/zimbra/log/mysqld.log
    pid-file     = /opt/zimbra/db/mysql.pid
    I never change my.cnf configuration.

    The version of my sql is the same with you.

    Notes: I use Redhat 5.4

    If the above config fix this issue...
    Is it my.cnf config?

    Thanks

  4. #4
    John Siu is offline Loyal Member
    Join Date
    Feb 2011
    Posts
    82
    Rep Power
    4

    Default

    I compared and modified yours to match, give it a try and mysql should start.

    Code:
    [mysqld]
    
    
    #---
    slow_query_log = 1
    
    plugin-load = innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so
    
    ignore-builtin-innodb
    innodb=FORCE
    slow_query_log_file = /opt/zimbra/log/myslow.log
    #---
    
    
    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
    tmpdir       = /opt/zimbra/data/tmp
    
    external-locking
    
    
    #---
    #log-slow-queries = /opt/zimbra/log/myslow.log
    #---
    
    
    long-query-time  = 1
    log-long-format
    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
    
    # (Num mailbox groups * Num tables in each group) + padding
    table_cache = 1200
    
    innodb_buffer_pool_size        = 117124300
    innodb_log_file_size           = 104857600
    innodb_log_buffer_size         = 8388608
    innodb_file_per_table
    
    # Value is: 200 + max_connections + 2 * table_cache
    innodb_open_files              = 2710
    
    innodb_max_dirty_pages_pct     = 10
    innodb_flush_method            = O_DIRECT
    innodb_flush_log_at_trx_commit = 0
    
    [mysqld_safe]
    
    err-log      = /opt/zimbra/log/mysqld.log
    pid-file     = /opt/zimbra/db/mysql.pid
    You have the exact same problem as mine before. You will have to do some table reload after your upgrade is complete, but let do it one step a time.

  5. #5
    gerembel@hotmail.com is offline Junior Member
    Join Date
    Mar 2011
    Posts
    6
    Rep Power
    4

    Default

    Sorry for long response time..
    Today I tried
    1. Make clean install ZCS 6.0.8
    2. Change my.cnf with yours.
    3. upgrade to Zimbra 7.
    And the upgrade process still failed.

    Here is the result:
    Installing:
    zimbra-core
    zimbra-ldap
    zimbra-logger
    zimbra-mta
    zimbra-snmp
    zimbra-store
    zimbra-memcached

    The system will be modified. Continue? [N]
    Exit? [N] n

    The system will be modified. Continue? [N] y

    Shutting down zimbra mail

    Backing up the ldap database...done.

    Removing existing packages

    zimbra-ldap...done
    zimbra-logger...done
    zimbra-mta...done
    zimbra-snmp...done
    zimbra-store...done
    zimbra-memcached...done
    zimbra-core...done

    Removing deployed webapp directories
    Installing packages

    zimbra-core......zimbra-core-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
    zimbra-ldap......zimbra-ldap-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
    zimbra-logger......zimbra-logger-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
    zimbra-mta......zimbra-mta-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
    zimbra-snmp......zimbra-snmp-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
    zimbra-store......zimbra-store-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done
    zimbra-memcached......zimbra-memcached-7.0.0_GA_3077.RHEL5_64-20110127201852.x86_64.rpm...done

    Setting defaults from saved config in /opt/zimbra/.saveconfig/config.save
    HOSTNAME=******
    LDAPHOST=******
    LDAPPORT=389
    SNMPTRAPHOST=******
    SMTPSOURCE=******
    SMTPDEST=******
    SNMPNOTIFY=yes
    SMTPNOTIFY=yes
    LDAPROOTPW=******
    LDAPZIMBRAPW=******
    LDAPPOSTPW=******
    LDAPREPPW=******
    LDAPAMAVISPW=******
    LDAPNGINXPW=******
    Restoring existing configuration file from /opt/zimbra/.saveconfig/localconfig.x
    Operations logged to /tmp/zmsetup.03092011-160947.log
    Upgrading from to 7.0.0_GA_3077
    Stopping zimbra services...done.
    Verifying /opt/zimbra/conf/my.cnf
    Starting mysql...done.
    I can't upgrade version

    UPGRADE FAILED - exiting.
    Did I make any mistake ?

  6. #6
    liverpoolfcfan's Avatar
    liverpoolfcfan is online now Outstanding Member
    Join Date
    Oct 2009
    Location
    Dublin, IRELAND
    Posts
    712
    Rep Power
    6

    Default

    Since you are just testing an upgrade, I would start with 7.0.1 that was just released before further troubleshooting.

  7. #7
    gerembel@hotmail.com is offline Junior Member
    Join Date
    Mar 2011
    Posts
    6
    Rep Power
    4

    Default

    Quote Originally Posted by liverpoolfcfan View Post
    Since you are just testing an upgrade, I would start with 7.0.1 that was just released before further troubleshooting.
    Now I'm trying to upgrade using Zimbra 7.0.1.. I'll give you the results as soon as possible

    Thanks before

  8. #8
    gerembel@hotmail.com is offline Junior Member
    Join Date
    Mar 2011
    Posts
    6
    Rep Power
    4

    Default

    I still had the problem like before. Do you have any idea to solve it?

  9. #9
    John Siu is offline Loyal Member
    Join Date
    Feb 2011
    Posts
    82
    Rep Power
    4

    Default

    Code:
    su - zimbra
    zmcontrol stop
    mysql_server start
    Can zimbra mysql start correctly?

  10. #10
    gerembel@hotmail.com is offline Junior Member
    Join Date
    Mar 2011
    Posts
    6
    Rep Power
    4

    Default

    No, I can't start zimbra.. The problem is same with before...
    The problem in mysql can't upgrade...

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Old Backup stay in TO_DELETE status and no clearing..
    By bartounet in forum Administrators
    Replies: 0
    Last Post: 10-05-2010, 07:40 AM
  2. /tmp filling
    By Nutz in forum Administrators
    Replies: 8
    Last Post: 02-22-2008, 02:00 AM
  3. Replies: 8
    Last Post: 02-27-2007, 04:10 AM
  4. dspam logrotate errors
    By michaeln in forum Users
    Replies: 7
    Last Post: 02-19-2007, 12:45 PM
  5. Unable to start tomcat
    By chanck in forum Administrators
    Replies: 11
    Last Post: 06-11-2006, 12:58 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
  •