[debian-mysql] Bug#539479: mysql-server-5.1: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

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: