Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Upgrade Problem from Zimbra 6.0.8 to Zimbra 7

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

    Default

    Quote Originally Posted by gerembel@hotmail.com View Post
    No, I can't start zimbra.. The problem is same with before...
    The problem in mysql can't upgrade...
    Is the my.cnf same as the one you post before? If yes, put in the one I modify for you, then try starting it with "mysql_server start". Don't start zimbra, only the mysql server. You have to do it within zimbra login. Then post the error log.
    Last edited by John Siu; 03-17-2011 at 07:52 PM.

  2. #12
    Filly is offline Junior Member
    Join Date
    May 2009
    Posts
    7
    Rep Power
    6

    Default

    @John Siu : Thank you very much. It helped me solve the same problem. Following lines i had to take from you my.cnf example shown:

    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

  3. #13
    schachi-mdf is offline Starter Member
    Join Date
    Nov 2009
    Posts
    2
    Rep Power
    5

    Default

    I had the same problem with upgrade from 6.0.9 to 7.1.0.
    This fix above helps to running mysql again.

  4. #14
    jrv
    jrv is offline Active Member
    Join Date
    Nov 2008
    Posts
    28
    Rep Power
    6

    Default

    This seems to make mysql start but it's not quite finished yet. It appears a mysql_upgrade is needed but I know nothing about mysql: how do I do that upgrade?

    During install.sh:

    Code:
    Upgrading from 6.0.16_GA_2998 to 7.0.1_GA_3105
    Stopping zimbra services...done.
    Verifying /opt/zimbra/conf/my.cnf
    Starting mysql...done.
    I can't upgrade version 6.0.16_GA
    
    UPGRADE FAILED - exiting.
    From /opt/zimbra/log/mysql_error.log:

    Code:
    121024 03:37:52 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
    /opt/zimbra/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
    121024  3:37:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use GCC atomic builtins
    InnoDB: Compressed tables use zlib 1.2.3.3
    121024  3:37:52  InnoDB: Initializing buffer pool, size = 227.0M
    121024  3:37:52  InnoDB: Completed initialization of buffer pool
    121024  3:37:52  InnoDB: highest supported file format is Barracuda.
    121024  3:37:52  InnoDB: Warning: allocated tablespace 14, old maximum was 0
    121024  3:37:52 InnoDB Plugin 1.0.15 started; log sequence number 2281437488
    121024  3:37:52 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    121024  3:37:52 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50051, now running 50155. Please use mysql_upgrade to fix this error.
    121024  3:37:52 [ERROR] mysql.user has no `Event_priv` column at position 29
    121024  3:37:52 [ERROR] Cannot open mysql.event
    121024  3:37:52 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    121024  3:37:52 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
    Version: '5.1.55-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution
    /opt/zimbra/conf/my.cnf:

    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
    Release 6.0.6_GA_2324.UBUNTU8 UBUNTU8 FOSS edition

Page 2 of 2 FirstFirst 12

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
  •