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
