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

[Douglas Soares de Andrade]

Em Domingo 12 Abril 2009, às 12:36:05, Scott Weisman escreveu:
> 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

Hi Scott,

Delete this file:

/var/lib/mysql/ib_logfile0

If this not work, try read the following threads:

http://forums.mysql.com/read.php?22,144428,241055#msg-241055
http://venublog.com/2008/04/23/simple-way-to-crash-innodb-plugin-10/
http://bugs.mysql.com/bug.php?id=20851