Upgrade Problem from Zimbra 6.0.8 to Zimbra 7

Printable View

Show 40 post(s) from this thread on one page

03-07-2011, 07:08 PM
gerembel@hotmail.com

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
03-07-2011, 09:57 PM
John Siu

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.
03-07-2011, 10:47 PM
gerembel@hotmail.com

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

Quote:

If the above config fix this issue...

Is it my.cnf config?

Thanks
03-07-2011, 11:38 PM
John Siu

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.
03-09-2011, 08:03 PM
gerembel@hotmail.com

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:

Quote:

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 ?
03-10-2011, 03:16 AM
liverpoolfcfan

Since you are just testing an upgrade, I would start with 7.0.1 that was just released before further troubleshooting.
03-14-2011, 01:32 AM
gerembel@hotmail.com

Quote:

Originally Posted by liverpoolfcfan

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
03-14-2011, 08:43 PM
gerembel@hotmail.com

I still had the problem like before. Do you have any idea to solve it?
03-14-2011, 09:23 PM
John Siu

Code:

su - zimbra zmcontrol stop mysql_server start

Can zimbra mysql start correctly?
03-17-2011, 06:36 PM
gerembel@hotmail.com

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

Show 40 post(s) from this thread on one page