Your message dated Sun, 3 Jul 2016 11:46:27 +0200
with message-id <[email protected]>
and subject line closing bugs reported against ancient mysql-5.1
has caused the Debian Bug report #539479,
regarding mysql-server-5.1: [ERROR] Can't open the mysql.plugin table. Please
run mysql_upgrade to create it.
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
539479: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=539479
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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:
--- End Message ---
--- Begin Message ---
This bug has been reported against an ancient version of mysql (5.1),
that was last released with Debian 6.0 (squeeze). But even squeeze-lts
has now reached end-of-life and is no longer supported.
The bug is assumed to be fixed (or no longer relevant) in newer mysql
(or mariadb) releases and therefore I'm closing this report now. If the
problem is still reproducible in the currently supported versions
(mysql-5.6/mysql-5.7), feel free to provide more information, reopen
and reassign this bug report.
Andreas
--- End Message ---
