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,