[arch-general] mysql won't start after upgrade

Scott Weisman sweisman at pobox.com
Sun Apr 12 11:36:05 EDT 2009


I just upgraded MySQL on my Arch box to the latest version (5.1.33-1),
and all of a sudden, MySQL won't start.

I get the following in my mysql.err file (in /var/lib/mysql):

090412 07:53:21 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
090412  7:53:21 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of different
size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 16777216 bytes!
090412  7:53:21 [ERROR] Plugin 'InnoDB' init function returned error.
090412  7:53:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090412  7:53:21 [ERROR] /usr/sbin/mysqld: unknown variable
'innodb_log_arch_dir=/var/lib/mysql'
090412  7:53:21 [ERROR] Aborting
090412  7:53:21 [Warning] Forcing shutdown of 2 plugins
090412  7:53:21 [Note] /usr/sbin/mysqld: Shutdown complete
090412 07:53:21 mysqld_safe mysqld from pid file
/var/lib/mysql/humidor.pid ended

I run mysql_upgrade, as instructed, but it also doesn't work. It
expects a working daemon of MySQL, which as the above log output
attests, isn't available.

Can someone help?! Until this upgrade, MySQL has run flawlessly for years.

Thanks,

Scott


More information about the arch-general mailing list