upgrade from 6.0.9 to 7.0.0b2 and b3 failed

[Goulou]

Hello everyone,

I tried to upgrade my zcs install from 6.0.9 to both 7.0.0 beta 2 and beta 3, and it failed in both case with the same error.
The second time, I managed to keep the logs and output of installation, they are as follow :
install.log : nothing unexpected
zmsetup.log :

Sat Dec 25 13:04:16 2010 Verifying /opt/zimbra/conf/my.cnf
Sat Dec 25 13:04:16 2010 Getting local config zimbra_home
Sat Dec 25 13:04:16 2010 Getting local config mysql_mycnf
Sat Dec 25 13:04:17 2010 Getting local config zimbra_log_directory
Sat Dec 25 13:04:17 2010 *** Running as zimbra user: /opt/zimbra/libexec/zminiutil --backup=.pre-7.0.0_BETA3 --section=mysqld --key=ignore-builtin-innodb --set /opt/zimbra/conf/my.cnf
Sat Dec 25 13:04:17 2010 *** Running as zimbra user: /opt/zimbra/libexec/zminiutil --backup=.pre-7.0.0_BETA3 --section=mysqld --set --key=plugin-load --value='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' /opt/zimbra/conf/my.cnf
Sat Dec 25 13:04:21 2010 *** Running as zimbra user: /opt/zimbra/libexec/zminiutil --backup=.pre-7.0.0_BETA3 --section=mysqld --unset --key=log-long-format /opt/zimbra/conf/my.cnf
Sat Dec 25 13:04:21 2010 *** Running as zimbra user: /opt/zimbra/libexec/zminiutil --backup=.pre-7.0.0_BETA3 --section=mysqld --unset --key=log-slow-queries /opt/zimbra/conf/my.cnf
Sat Dec 25 13:04:22 2010 *** Running as zimbra user: /opt/zimbra/libexec/zminiutil --backup=.pre-7.0.0_BETA3 --section=mysqld --set --key=slow_query_log --value=1 /opt/zimbra/conf/my.cnf
Sat Dec 25 13:04:22 2010 *** Running as zimbra user: /opt/zimbra/libexec/zminiutil --backup=.pre-7.0.0_BETA3 --section=mysqld --set --key=slow_query_log_file --value=/opt/zimbra/log/myslow.log /opt/zimbra/conf/my.cnf
Sat Dec 25 13:04:23 2010 Starting mysql...
Sat Dec 25 13:04:23 2010 *** Running as zimbra user: /opt/zimbra/bin/mysql.server start
Starting mysqld...done.
Sat Dec 25 13:04:36 2010 done.
Sat Dec 25 13:04:39 2010 This appears to be 6.0.9_GA
Sat Dec 25 13:04:39 2010 Checking ldap status...
Sat Dec 25 13:04:39 2010 *** Running as zimbra user: /opt/zimbra/bin/ldap status
Sat Dec 25 13:04:40 2010 not running.
Sat Dec 25 13:04:40 2010 Running zmldapapplyldif...
Sat Dec 25 13:04:40 2010 *** Running as zimbra user: /opt/zimbra/libexec/zmldapapplyldif
Sat Dec 25 13:04:51 2010 done.
Sat Dec 25 13:04:51 2010 Checking ldap status...
Sat Dec 25 13:04:51 2010 *** Running as zimbra user: /opt/zimbra/bin/ldap status
slapd running pid: 29357
Sat Dec 25 13:04:51 2010 already running.
Sat Dec 25 13:04:51 2010 Getting local config mysql_root_password
Sat Dec 25 13:04:52 2010 Getting local config zimbra_tmp_directory
Sat Dec 25 13:04:52 2010 Getting local config mysql_socket
Sat Dec 25 13:04:52 2010 Running mysql_upgrade...
Sat Dec 25 13:04:52 2010 *** Running as zimbra user: /opt/zimbra/mysql/bin/mysql_upgrade --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock --user=root --password=FOuucXBdQdMctIxICMqYJTDz1n3 > /opt/zimbra/data/tmp/mysql_upgrade.out 2>&1
Sat Dec 25 13:04:55 2010 done.

standard output :

Starting mysql...done.
This appears to be 6.0.9_GA
Checking ldap status...not running.
Running zmldapapplyldif...done.
Checking ldap status...already running.
Running mysql_upgrade...done.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
Sat Dec 25 13:04:56 2010: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=6m6rTEJ8gDHZ4kvMTi7rYaqtjQvbuOq --database=zimbra --batch --skip-column-names'.

The install process seems to start mysql (for the mysql_upgrade step), but quickly after it tries to access the mysql server and it has died for an unknown reason...

The error was identical with zcs-7.0.0-beta2, and I could fortunately always revert it to 6.0.9 using lvm snapshot.

I would be very happy to test 7.0, so if anyone has any idea of how to do it, I test it as soon as possible!

Goulou

[maxxer]

I tried 7b3 myself, but as a fresh install, still haven't tried upgrade.
But this is very interesting. I guess filing a bug report, with details about your system and architecture, will help you and Zimbra better identifying the issue.

[Goulou]

I've added few version informations and submitted the bug here :
https://bugzilla.zimbra.com/show_bug.cgi?id=54993

Hope it will help!