FS#14211 - Mysql start crash after latest update.

Attached to Project: Arch Linux
Opened by Vasilii (Vasilii) - Monday, 13 April 2009, 08:08 GMT
Last edited by Andrea Scarpino (BaSh) - Tuesday, 14 April 2009, 21:59 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To No-one
Architecture All
Severity Critical
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

Description:

vs@vs /var/log % sudo mysqld start -u root
mysqld: Table 'mysql.plugin' doesn't exist
090413 11:03:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090413 11:03:12 InnoDB: Started; log sequence number 0 287859600
090413 11:03:12 [ERROR] mysqld: unknown variable 'innodb_log_arch_dir=/var/lib/mysql'
090413 11:03:12 [ERROR] Aborting

090413 11:03:12 InnoDB: Starting shutdown...
090413 11:03:13 InnoDB: Shutdown completed; log sequence number 0 287859600
090413 11:03:13 [Warning] Forcing shutdown of 2 plugins
090413 11:03:13 [Note] mysqld: Shutdown complete

Additional info:
* package version(s)
* config and/or log files etc.
mysqld: Table 'mysql.plugin' doesn't exist
090413 11:03:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090413 11:03:12 InnoDB: Started; log sequence number 0 287859600
090413 11:03:12 [ERROR] mysqld: unknown variable 'innodb_log_arch_dir=/var/lib/mysql'
090413 11:03:12 [ERROR] Aborting

090413 11:03:12 InnoDB: Starting shutdown...
090413 11:03:13 InnoDB: Shutdown completed; log sequence number 0 287859600
090413 11:03:13 [Warning] Forcing shutdown of 2 plugins
090413 11:03:13 [Note] mysqld: Shutdown complete

vs@vs /var/log % sudo mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck'...
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
vs@vs /var/log % sudo -u root mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck'...
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
vs@vs /var/log % sudo mysqld start -u root
mysqld: Table 'mysql.plugin' doesn't exist
090413 11:05:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090413 11:05:19 InnoDB: Started; log sequence number 0 287859600
090413 11:05:19 [ERROR] mysqld: unknown variable 'innodb_log_arch_dir=/var/lib/mysql'
090413 11:05:19 [ERROR] Aborting

090413 11:05:19 InnoDB: Starting shutdown...
090413 11:05:20 InnoDB: Shutdown completed; log sequence number 0 287859600
090413 11:05:20 [Warning] Forcing shutdown of 2 plugins
090413 11:05:20 [Note] mysqld: Shutdown complete

Steps to reproduce:
This task depends upon

Closed by  Andrea Scarpino (BaSh)
Tuesday, 14 April 2009, 21:59 GMT
Reason for closing:  Works for me
Additional comments about closing:  read the comments
Comment by Jari Y (jase) - Monday, 13 April 2009, 17:49 GMT
From some ubuntu mailinglist I found a tip:

"Well, after removing the following config entries I was able to start mysqld
and run mysql_upgrade.

#skip-innodb
#skip-bdb
#skip-federated"

So I commented out:
#skip-locking
#skip-innodb
#skip-bdb

and MySQL started. Then I run mysql_upgrade and now everything is working like before. It's propably skip-innodb that prevents it from starting.
Comment by Vasilii (Vasilii) - Monday, 13 April 2009, 18:12 GMT
Thank you Jari for the reply but I found some minutes ago that after i comment
#innodb_log_arch_dir = /var/lib/mysql
in the my.cnf

it started successfully.

Loading...