[debian-mysql] Bug#539479: mysql-server-5.1: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Olaf van der Spek
OlafvdSpek at GMail.Com
Sat Aug 1 09:57:13 UTC 2009
Package: mysql-server-5.1
Version: 5.1.36-4
Severity: normal
Hi,
I upgraded from 5.0 to 5.1 but something went wrong.
Setting up mysql-server-5.1 (5.1.36-4) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.1; however:
Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.1
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Aug 1 11:56:02 debian mysqld_safe[4003]: 090801 11:56:02 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Aug 1 11:56:02 debian mysqld_safe[4003]: 090801 11:56:02 [ERROR] Aborting
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]: 090801 11:56:02 [Warning] Forcing shutdown of 2 plugins
Aug 1 11:56:02 debian mysqld_safe[4003]: 090801 11:56:02 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]: Installation of system tables failed! Examine the logs in
Aug 1 11:56:02 debian mysqld_safe[4003]: /var/lib/mysql for more information.
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]: You can try to start the mysqld daemon with:
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]: shell> /usr/sbin/mysqld --skip-grant &
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]: and use the command line tool /usr/bin/mysql
Aug 1 11:56:02 debian mysqld_safe[4003]: to connect to the mysql database and look at the grant tables:
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]: shell> /usr/bin/mysql -u root mysql
Aug 1 11:56:02 debian mysqld_safe[4003]: mysql> show tables
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]: Try 'mysqld --help' if you have problems with paths. Using --log
Aug 1 11:56:02 debian mysqld_safe[4003]: gives you a log in /var/lib/mysql that may be helpful.
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]: The latest information about MySQL is available on the web at
Aug 1 11:56:02 debian mysqld_safe[4003]: http://www.mysql.com/. Please consult the MySQL manual section
Aug 1 11:56:02 debian mysqld_safe[4003]: 'Problems running mysql_install_db', and the manual section that
Aug 1 11:56:02 debian mysqld_safe[4003]: describes problems on your OS. Another information source are the
Aug 1 11:56:02 debian mysqld_safe[4003]: MySQL email archives available at http://lists.mysql.com/.
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4003]: Please check all of the above before mailing us! And remember, if
Aug 1 11:56:02 debian mysqld_safe[4003]: you do mail us, you MUST use the /usr/scripts/mysqlbug script!
Aug 1 11:56:02 debian mysqld_safe[4003]:
Aug 1 11:56:02 debian mysqld_safe[4039]: 090801 11:56:02 [Note] Plugin 'FEDERATED' is disabled.
Aug 1 11:56:03 debian mysqld_safe[4039]: 090801 11:56:03 InnoDB: Started; log sequence number 0 43655
Aug 1 11:56:03 debian mysqld_safe[4039]: 090801 11:56:03 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Aug 1 11:56:03 debian mysqld_safe[4039]: 090801 11:56:03 [ERROR] Aborting
Aug 1 11:56:03 debian mysqld_safe[4039]:
Aug 1 11:56:03 debian mysqld_safe[4039]: 090801 11:56:03 InnoDB: Starting shutdown...
Aug 1 11:56:04 debian mysqld_safe[4039]: 090801 11:56:04 InnoDB: Shutdown completed; log sequence number 0 43655
Aug 1 11:56:04 debian mysqld_safe[4039]: 090801 11:56:04 [Warning] Forcing shutdown of 1 plugins
Aug 1 11:56:04 debian mysqld_safe[4039]: 090801 11:56:04 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 1 11:56:04 debian mysqld_safe[4039]:
Aug 1 11:56:04 debian mysqld_safe[4055]: 090801 11:56:04 [Note] Plugin 'FEDERATED' is disabled.
Aug 1 11:56:04 debian mysqld_safe[4055]: 090801 11:56:04 InnoDB: Started; log sequence number 0 43655
Aug 1 11:56:04 debian mysqld_safe[4055]: 090801 11:56:04 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Aug 1 11:56:04 debian mysqld_safe[4055]: 090801 11:56:04 [ERROR] Aborting
Aug 1 11:56:04 debian mysqld_safe[4055]:
Aug 1 11:56:04 debian mysqld_safe[4055]: 090801 11:56:04 InnoDB: Starting shutdown...
Aug 1 11:56:05 debian mysqld_safe[4055]: 090801 11:56:05 InnoDB: Shutdown completed; log sequence number 0 43655
Aug 1 11:56:05 debian mysqld_safe[4055]: 090801 11:56:05 [Warning] Forcing shutdown of 1 plugins
Aug 1 11:56:05 debian mysqld_safe[4055]: 090801 11:56:05 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 1 11:56:05 debian mysqld_safe[4055]:
Aug 1 11:56:05 debian mysqld_safe[4067]: 090801 11:56:05 [Note] Plugin 'FEDERATED' is disabled.
Aug 1 11:56:05 debian mysqld_safe[4067]: 090801 11:56:05 InnoDB: Started; log sequence number 0 43655
Aug 1 11:56:05 debian mysqld_safe[4067]: 090801 11:56:05 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Aug 1 11:56:05 debian mysqld_safe[4067]: 090801 11:56:05 [ERROR] Aborting
Aug 1 11:56:05 debian mysqld_safe[4067]:
Aug 1 11:56:05 debian mysqld_safe[4067]: 090801 11:56:05 InnoDB: Starting shutdown...
Aug 1 11:56:06 debian mysqld_safe[4067]: 090801 11:56:06 InnoDB: Shutdown completed; log sequence number 0 43655
Aug 1 11:56:06 debian mysqld_safe[4067]: 090801 11:56:06 [Warning] Forcing shutdown of 1 plugins
Aug 1 11:56:06 debian mysqld_safe[4067]: 090801 11:56:06 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 1 11:56:06 debian mysqld_safe[4067]:
Aug 1 11:56:06 debian mysqld_safe[4079]: 090801 11:56:06 [Note] Plugin 'FEDERATED' is disabled.
Aug 1 11:56:06 debian mysqld_safe[4079]: 090801 11:56:06 InnoDB: Started; log sequence number 0 43655
Aug 1 11:56:06 debian mysqld_safe[4079]: 090801 11:56:06 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Aug 1 11:56:06 debian mysqld_safe[4079]: 090801 11:56:06 [ERROR] Aborting
Aug 1 11:56:06 debian mysqld_safe[4079]:
Aug 1 11:56:06 debian mysqld_safe[4079]: 090801 11:56:06 InnoDB: Starting shutdown...
Aug 1 11:56:07 debian mysqld_safe[4079]: 090801 11:56:07 InnoDB: Shutdown completed; log sequence number 0 43655
Aug 1 11:56:07 debian mysqld_safe[4079]: 090801 11:56:07 [Warning] Forcing shutdown of 1 plugins
Aug 1 11:56:07 debian mysqld_safe[4079]: 090801 11:56:07 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 1 11:56:07 debian mysqld_safe[4079]:
Aug 1 11:56:08 debian mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Aug 1 11:56:08 debian mysqld: 090801 11:56:08 [Note] Plugin 'FEDERATED' is disabled.
Aug 1 11:56:08 debian mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
Aug 1 11:56:08 debian mysqld: 090801 11:56:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Aug 1 11:56:08 debian mysqld: 090801 11:56:08 InnoDB: Started; log sequence number 0 43655
Aug 1 11:56:08 debian mysqld: 090801 11:56:08 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Aug 1 11:56:08 debian mysqld: 090801 11:56:08 [ERROR] Aborting
Aug 1 11:56:08 debian mysqld:
Aug 1 11:56:08 debian mysqld: 090801 11:56:08 InnoDB: Starting shutdown...
Aug 1 11:56:09 debian mysqld: 090801 11:56:09 InnoDB: Shutdown completed; log sequence number 0 43655
Aug 1 11:56:09 debian mysqld: 090801 11:56:09 [Warning] Forcing shutdown of 1 plugins
Aug 1 11:56:09 debian mysqld: 090801 11:56:09 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 1 11:56:09 debian mysqld:
Aug 1 11:56:09 debian mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Aug 1 11:56:22 debian /etc/init.d/mysql[4409]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 1 11:56:22 debian /etc/init.d/mysql[4409]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 1 11:56:22 debian /etc/init.d/mysql[4409]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 1 11:56:22 debian /etc/init.d/mysql[4409]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 1 11:56:22 debian /etc/init.d/mysql[4409]:
Greetings,
Olaf
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.30-1-686 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages mysql-server-5.1 depends on:
ii adduser 3.110 add and remove users and groups
ii debconf [debconf-2.0] 1.5.27 Debian configuration management sy
ii libc6 2.9-23 GNU C Library: Shared libraries
ii libdbi-perl 1.609-1 Perl Database Interface (DBI)
ii libgcc1 1:4.4.1-1 GCC support library
ii libmysqlclient16 5.1.36-4 MySQL database client library
ii libstdc++6 4.4.1-1 The GNU Standard C++ Library v3
ii libwrap0 7.6.q-18 Wietse Venema's TCP wrappers libra
ii lsb-base 3.2-23 Linux Standard Base 3.2 init scrip
ii mysql-client-5.1 5.1.36-4 MySQL database client binaries
ii mysql-common 5.1.36-4 MySQL database common files (e.g.
ii passwd 1:4.1.4.2-1 change and administer password and
ii perl 5.10.0-24 Larry Wall's Practical Extraction
ii psmisc 22.8-1 utilities that use the proc file s
ii zlib1g 1:1.2.3.3.dfsg-14 compression library - runtime
Versions of packages mysql-server-5.1 recommends:
ii bsd-mailx [mailx] 8.1.2-0.20081101cvs-2 A simple mail user agent
ii libhtml-template-p 2.9-1 HTML::Template : A module for usin
Versions of packages mysql-server-5.1 suggests:
pn tinyca <none> (no description available)
-- debconf information:
mysql-server/error_setting_password:
mysql-server-5.1/start_on_boot: true
mysql-server-5.1/postrm_remove_databases: false
mysql-server-5.1/nis_warning:
mysql-server-5.1/really_downgrade: false
mysql-server/password_mismatch:
mysql-server/no_upgrade_when_using_ndb:
More information about the pkg-mysql-maint
mailing list