Last edited by John Siu; 03-17-2011 at 08:52 PM.
@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
I had the same problem with upgrade from 6.0.9 to 7.1.0.
This fix above helps to running mysql again.
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?
From /opt/zimbra/log/mysql_error.log: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.
/opt/zimbra/conf/my.cnf: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 188.8.131.52 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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)