[debian-mysql] Bug#694390: Bug#694390: mysql-server-5.1: failure to install w/ apt-get
Clint Byrum
clint at ubuntu.com
Tue Nov 27 12:19:57 UTC 2012
tags 694390 moreinfo
stop
Hugh, it seems like this was a transient error from the logs:
Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [ERROR] Do you already have another mysqld server running on port: 3306 ?
So, my question is, do you already have something listening on port 3306?
If no, then is it possible that the stop action is just failing to wait
long enough for mysqld to die? Do you, by any chance, have a very large
InnoDB database and/or transaction log already in place in /var/lib/mysql?
I wonder if this might be related to this bug as well:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=609537
Excerpts from Hugh Esco's message of 2012-11-25 16:01:29 -0800:
> Package: mysql-server-5.1
> Version: 5.1.49-3
> Severity: normal
> Tags: d-i
>
> $ sudo apt-get install mysql-server-5.1
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Suggested packages:
> tinyca
> The following NEW packages will be installed:
> mysql-server-5.1
> 0 upgraded, 1 newly installed, 0 to remove and 45 not upgraded.
> Need to get 0 B/6,528 kB of archives.
> After this operation, 14.3 MB of additional disk space will be used.
> Preconfiguring packages ...
> Selecting previously deselected package mysql-server-5.1.
> (Reading database ... 196158 files and directories currently installed.)
> Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.49-3_i386.deb) ...
> Processing triggers for man-db ...
> Setting up mysql-server-5.1 (5.1.49-3) ...
> Stopping MySQL database server: mysqld.
> 121125 18:47:38 [Note] Plugin 'FEDERATED' is disabled.
> 121125 18:47:38 InnoDB: Started; log sequence number 0 44233
> 121125 18:47:38 InnoDB: Starting shutdown...
> 121125 18:47:44 InnoDB: Shutdown completed; log sequence number 0 44233
> 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
> configured to not write apport reports
> Errors were encountered while processing:
> mysql-server-5.1
> E: Sub-process /usr/bin/dpkg returned an error code (1)
>
> ----------------------------------------
>
> /var/log/syslog --
>
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: PLEASE REMEMBER TO SET A
> PASSWORD FOR THE MySQL r
> oot USER !
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: To do so, start the server,
> then issue the follow
> ing commands:
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: /usr/bin/mysqladmin -u root
> password 'new-passwor
> d'
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: /usr/bin/mysqladmin -u root
> -h debianmarcus9 pass
> word 'new-password'
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: Alternatively you can run:
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
> /usr/bin/mysql_secure_installation
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: which will also give you the
> option of removing the test
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: databases and anonymous user
> created by default. This is
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: strongly recommended for
> production servers.
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: See the manual for more
> instructions.
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: Please report any problems
> with the /usr/scripts/mysqlbug script!
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29506]: 121125 18:45:46 [Note] Plugin
> 'FEDERATED' is disabled.
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29506]: 121125 18:45:46 InnoDB:
> Started; log sequence number 0 44233
> Nov 25 18:45:46 debianmarcus9 mysqld_safe[29506]: 121125 18:45:46 InnoDB:
> Starting shutdown...
> Nov 25 18:45:51 debianmarcus9 mysqld_safe[29506]: 121125 18:45:51 InnoDB:
> Shutdown completed; log sequence number 0 44233
> Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: 121125 18:45:51 [Note] Plugin
> 'FEDERATED' is disabled.
> Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: 121125 18:45:51 InnoDB:
> Started; log sequence number 0 44233
> Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: ERROR: 1064 You have an
> error in your SQL syntax; check the manual that corresponds to your MySQL
> server version for the right syntax to use near 'ALTER TABLE user ADD column
> Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
> Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: 121125 18:45:51 [ERROR]
> Aborting
> Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]:
> Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: 121125 18:45:51 InnoDB:
> Starting shutdown...
> Nov 25 18:45:56 debianmarcus9 mysqld_safe[29525]: 121125 18:45:56 InnoDB:
> Shutdown completed; log sequence number 0 44233
> Nov 25 18:45:56 debianmarcus9 mysqld_safe[29525]: 121125 18:45:56 [Note]
> /usr/sbin/mysqld: Shutdown complete
> Nov 25 18:45:56 debianmarcus9 mysqld_safe[29525]:
> Nov 25 18:45:56 debianmarcus9 mysqld_safe[29540]: 121125 18:45:56 [Note] Plugin
> 'FEDERATED' is disabled.
> Nov 25 18:45:56 debianmarcus9 mysqld_safe[29540]: 121125 18:45:56 InnoDB:
> Started; log sequence number 0 44233
> Nov 25 18:45:56 debianmarcus9 mysqld_safe[29540]: 121125 18:45:56 InnoDB:
> Starting shutdown...
> Nov 25 18:46:02 debianmarcus9 mysqld_safe[29540]: 121125 18:46:02 InnoDB:
> Shutdown completed; log sequence number 0 44233
> Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: 121125 18:46:02 [Note] Plugin
> 'FEDERATED' is disabled.
> Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: 121125 18:46:02 InnoDB:
> Started; log sequence number 0 44233
> Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: ERROR: 1050 Table 'plugin'
> already exists
> Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: 121125 18:46:02 [ERROR]
> Aborting
> Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]:
> Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: 121125 18:46:02 InnoDB:
> Starting shutdown...
> Nov 25 18:46:07 debianmarcus9 mysqld_safe[29555]: 121125 18:46:07 InnoDB:
> Shutdown completed; log sequence number 0 44233
> Nov 25 18:46:07 debianmarcus9 mysqld_safe[29555]: 121125 18:46:07 [Note]
> /usr/sbin/mysqld: Shutdown complete
> Nov 25 18:46:07 debianmarcus9 mysqld_safe[29555]:
> Nov 25 18:46:07 debianmarcus9 mysqld_safe: Starting mysqld daemon with
> databases from /var/lib/mysql
> Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [Note] Plugin 'FEDERATED'
> is disabled.
> Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 InnoDB: Started; log
> sequence number 0 44233
> Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [ERROR] Can't start
> server: Bind on TCP/IP port: Address already in use
> Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [ERROR] Do you already
> have another mysqld server running on port: 3306 ?
> Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [ERROR] Aborting
> Nov 25 18:46:07 debianmarcus9 mysqld:
> Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 InnoDB: Starting
> shutdown...
> Nov 25 18:46:12 debianmarcus9 mysqld: 121125 18:46:12 InnoDB: Shutdown
> completed; log sequence number 0 44233
> Nov 25 18:46:12 debianmarcus9 mysqld: 121125 18:46:12 [Note] /usr/sbin/mysqld:
> Shutdown complete
> Nov 25 18:46:12 debianmarcus9 mysqld:
> Nov 25 18:46:12 debianmarcus9 mysqld_safe: mysqld from pid file
> /var/run/mysqld/mysqld.pid ended
> Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]: 0 processes alive and
> '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
> Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]:
> #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
> Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]: error: 'Can't connect
> to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
> Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]: Check that mysqld is
> running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
> Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]:
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: PLEASE REMEMBER TO SET A
> PASSWORD FOR THE MySQL root USER !
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: To do so, start the server,
> then issue the following commands:
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: /usr/bin/mysqladmin -u root
> password 'new-password'
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: /usr/bin/mysqladmin -u root
> -h debianmarcus9 password 'new-password'
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: Alternatively you can run:
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
> /usr/bin/mysql_secure_installation
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: which will also give you the
> option of removing the test
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: databases and anonymous user
> created by default. This is
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: strongly recommended for
> production servers.
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: See the manual for more
> instructions.
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30216]: 121125 18:47:33 [Note] Plugin
> 'FEDERATED' is disabled.
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30216]: 121125 18:47:33 InnoDB:
> Started; log sequence number 0 44233
> Nov 25 18:47:33 debianmarcus9 mysqld_safe[30216]: 121125 18:47:33 InnoDB:
> Starting shutdown...
> Nov 25 18:47:38 debianmarcus9 mysqld_safe[30216]: 121125 18:47:38 InnoDB:
> Shutdown completed; log sequence number 0 44233
> Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: 121125 18:47:44 [Note] Plugin
> 'FEDERATED' is disabled.
> Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: 121125 18:47:44 InnoDB:
> Started; log sequence number 0 44233
> Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: ERROR: 1064 You have an
> error in your SQL syntax; check the manual that corresponds to your MySQL
> server version for the right syntax to use near 'ALTER TABLE user ADD column
> Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
> Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: 121125 18:47:44 [ERROR]
> Aborting
> Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]:
> Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: 121125 18:47:44 InnoDB:
> Starting shutdown...
> Nov 25 18:47:49 debianmarcus9 mysqld_safe[30248]: 121125 18:47:49 InnoDB:
> Shutdown completed; log sequence number 0 44233
> Nov 25 18:47:49 debianmarcus9 mysqld_safe[30248]: 121125 18:47:49 [Note]
> /usr/sbin/mysqld: Shutdown complete
> Nov 25 18:47:49 debianmarcus9 mysqld_safe[30248]:
> Nov 25 18:47:49 debianmarcus9 mysqld_safe[30263]: 121125 18:47:49 [Note] Plugin
> 'FEDERATED' is disabled.
> Nov 25 18:47:49 debianmarcus9 mysqld_safe[30263]: 121125 18:47:49 InnoDB:
> Started; log sequence number 0 44233
> Nov 25 18:47:49 debianmarcus9 mysqld_safe[30263]: 121125 18:47:49 InnoDB:
> Starting shutdown...
> Nov 25 18:47:54 debianmarcus9 mysqld_safe[30263]: 121125 18:47:54 InnoDB:
> Shutdown completed; log sequence number 0 44233
> Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: 121125 18:47:54 [Note] Plugin
> 'FEDERATED' is disabled.
> Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: 121125 18:47:54 InnoDB:
> Started; log sequence number 0 44233
> Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: ERROR: 1050 Table 'plugin'
> already exists
> Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: 121125 18:47:54 [ERROR]
> Aborting
> Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]:
> Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: 121125 18:47:54 InnoDB:
> Starting shutdown...
> Nov 25 18:47:59 debianmarcus9 mysqld_safe[30278]: 121125 18:47:59 InnoDB:
> Shutdown completed; log sequence number 0 44233
> Nov 25 18:47:59 debianmarcus9 mysqld_safe[30278]: 121125 18:47:59 [Note]
> /usr/sbin/mysqld: Shutdown complete
> Nov 25 18:47:59 debianmarcus9 mysqld_safe[30278]:
> Nov 25 18:48:00 debianmarcus9 mysqld_safe: Starting mysqld daemon with
> databases from /var/lib/mysql
> Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 [Note] Plugin 'FEDERATED'
> is disabled.
> Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 InnoDB: Started; log
> sequence number 0 44233
> Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 [ERROR] Can't start
> server: Bind on TCP/IP port: Address already in use
> Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 [ERROR] Do you already
> have another mysqld server running on port: 3306 ?
> Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 [ERROR] Aborting
> Nov 25 18:48:00 debianmarcus9 mysqld:
> Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 InnoDB: Starting
> shutdown...
> Nov 25 18:48:05 debianmarcus9 mysqld: 121125 18:48:05 InnoDB: Shutdown
> completed; log sequence number 0 44233
> Nov 25 18:48:05 debianmarcus9 mysqld: 121125 18:48:05 [Note] /usr/sbin/mysqld:
> Shutdown complete
> Nov 25 18:48:05 debianmarcus9 mysqld:
> Nov 25 18:48:05 debianmarcus9 mysqld_safe: mysqld from pid file
> /var/run/mysqld/mysqld.pid ended
> Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]: 0 processes alive and
> '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
> Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]:
> #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
> Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]: error: 'Can't connect
> to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
> Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]: Check that mysqld is
> running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
> Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]:
>
>
>
> -- System Information:
> Debian Release: 6.0.5
> APT prefers stable
> APT policy: (500, 'stable')
> Architecture: i386 (i686)
>
> Kernel: Linux 2.6.32-5-686 (SMP w/2 CPU cores)
> Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
> Shell: /bin/sh linked to /bin/dash
>
> Versions of packages mysql-server-5.1 depends on:
> ii adduser 3.112+nmu2 add and remove users and groups
> ii debconf [de 1.5.36.1 Debian configuration management sy
> ii libc6 2.11.3-3 Embedded GNU C Library: Shared lib
> ii libdbi-perl 1.612-1 Perl Database Interface (DBI)
> ii libgcc1 1:4.4.5-8 GCC support library
> ii libmysqlcli 5.1.63-0+squeeze1 MySQL database client library
> ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3
> ii lsb-base 3.2-23.2squeeze1 Linux Standard Base 3.2 init scrip
> ii mysql-clien 5.1.63-0+squeeze1 MySQL database client binaries
> ii mysql-commo 5.1.63-0+squeeze1 MySQL database common files, e.g.
> ii mysql-serve 5.1.49-3 MySQL database server binaries
> ii passwd 1:4.1.4.2+svn3283-2+squeeze1 change and administer password and
> ii perl 5.10.1-17squeeze3 Larry Wall's Practical Extraction
> ii psmisc 22.11-1 utilities that use the proc file s
> ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
>
> Versions of packages mysql-server-5.1 recommends:
> ii bsd-mailx [mailx] 8.1.2-0.20100314cvs-1 simple mail user agent
> ii libhtml-template-p 2.9-2 module for using HTML Templates wi
>
> 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