Package: mysql-server-5.1 Version: 5.1.39-1 Severity: grave Justification: renders package unusable
After the latest upgrade to the latest mysql-server-5.1 package, mysql-server fails to start. The error msg I see is similar as I've seen in other bug reports, but this is not due to an upgrade from 5.0 to 5.1 (which I did some time ago), but from the upgrade to 5.1.39-1. This is the output from syslog (daemon.log basically says the same): Sep 29 20:55:21 the-shire mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Sep 29 20:55:21 the-shire kernel: [ 172.603566] mysqld[4690]: segfault at 4 ip b78694ec sp bf9293e8 error 4 in ld-2.9.so[b785f000+1c000] Sep 29 20:55:21 the-shire mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Sep 29 20:55:26 the-shire kernel: [ 177.568343] __ratelimit: 4 callbacks suppressed Sep 29 20:55:26 the-shire kernel: [ 177.568354] mysqld[4733]: segfault at 4 ip b78fa4ec sp bff5b9a8 error 4 in ld-2.9.so[b78f0000+1c000] Sep 29 20:55:27 the-shire kernel: [ 178.588364] mysqld[4742]: segfault at 4 ip b78e64ec sp bf912298 error 4 in ld-2.9.so[b78dc000+1c000] Sep 29 20:55:28 the-shire kernel: [ 179.608563] mysqld[4751]: segfault at 4 ip b79484ec sp bfd842e8 error 4 in ld-2.9.so[b793e000+1c000] Sep 29 20:55:29 the-shire kernel: [ 180.628191] mysqld[4760]: segfault at 4 ip b78544ec sp bff82608 error 4 in ld-2.9.so[b784a000+1c000] Sep 29 20:55:30 the-shire kernel: [ 181.648465] mysqld[4769]: segfault at 4 ip b78a34ec sp bfbeef58 error 4 in ld-2.9.so[b7899000+1c000] Sep 29 20:55:31 the-shire kernel: [ 182.668697] mysqld[4778]: segfault at 4 ip b77ca4ec sp bfa48058 error 4 in ld-2.9.so[b77c0000+1c000] Sep 29 20:55:32 the-shire kernel: [ 183.690146] mysqld[4787]: segfault at 4 ip b77ca4ec sp bff0baf8 error 4 in ld-2.9.so[b77c0000+1c000] Sep 29 20:55:33 the-shire kernel: [ 184.711055] mysqld[4796]: segfault at 4 ip b79414ec sp bf848f18 error 4 in ld-2.9.so[b7937000+1c000] Sep 29 20:55:34 the-shire kernel: [ 185.736899] mysqld[4805]: segfault at 4 ip b77f84ec sp bfcd20d8 error 4 in ld-2.9.so[b77ee000+1c000] Sep 29 20:55:35 the-shire kernel: [ 186.770378] mysqld[4814]: segfault at 4 ip b78604ec sp bfa59e28 error 4 in ld-2.9.so[b7856000+1c000] Sep 29 20:55:35 the-shire kernel: [ 186.776683] mysqld[4822]: segfault at 4 ip b77fc4ec sp bfe8f6b8 error 4 in ld-2.9.so[b77f2000+1c000] Sep 29 20:55:35 the-shire /etc/init.d/mysql[4828]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Sep 29 20:55:35 the-shire /etc/init.d/mysql[4828]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Sep 29 20:55:35 the-shire /etc/init.d/mysql[4828]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Sep 29 20:55:35 the-shire /etc/init.d/mysql[4828]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Sep 29 20:55:35 the-shire /etc/init.d/mysql[4828]: Sep 29 20:55:35 the-shire kernel: [ 187.298872] mysqld[4872]: segfault at 4 ip b78804ec sp bff09328 error 4 in ld-2.9.so[b7876000+1c000] Sep 29 20:55:35 the-shire kernel: [ 187.314467] mysqld[4880]: segfault at 4 ip b78a54ec sp bfca2128 error 4 in ld-2.9.so[b789b000+1c000] Sep 29 20:55:35 the-shire kernel: [ 187.371696] mysqld[4927]: segfault at 4 ip b78974ec sp bff271f8 error 4 in ld-2.9.so[b788d000+1c000] Sep 29 20:55:35 the-shire mysqld_safe[4910]: /usr/bin/mysql_install_db: line 423: 4923 Done { echo "use mysql;"; cat $create_system_tables $fill_system_tables; } Sep 29 20:55:35 the-shire mysqld_safe[4910]: 4925 | eval "$filter_cmd_line" Sep 29 20:55:35 the-shire mysqld_safe[4910]: 4927 Segmentation fault | $mysqld_install_cmd_line > /dev/null Sep 29 20:55:35 the-shire mysqld_safe[4910]: Sep 29 20:55:35 the-shire mysqld_safe[4910]: Installation of system tables failed! Examine the logs in Sep 29 20:55:35 the-shire mysqld_safe[4910]: /var/lib/mysql for more information. Sep 29 20:55:35 the-shire mysqld_safe[4910]: Sep 29 20:55:35 the-shire mysqld_safe[4910]: You can try to start the mysqld daemon with: Sep 29 20:55:35 the-shire mysqld_safe[4910]: Sep 29 20:55:35 the-shire mysqld_safe[4910]: shell> /usr/sbin/mysqld --skip-grant & Sep 29 20:55:35 the-shire mysqld_safe[4910]: Sep 29 20:55:35 the-shire mysqld_safe[4910]: and use the command line tool /usr/bin/mysql Sep 29 20:55:35 the-shire mysqld_safe[4910]: to connect to the mysql database and look at the grant tables: Sep 29 20:55:35 the-shire mysqld_safe[4910]: Sep 29 20:55:35 the-shire mysqld_safe[4910]: shell> /usr/bin/mysql -u root mysql Sep 29 20:55:35 the-shire mysqld_safe[4910]: mysql> show tables Sep 29 20:55:35 the-shire mysqld_safe[4910]: Sep 29 20:55:35 the-shire mysqld_safe[4910]: Try 'mysqld --help' if you have problems with paths. Using --log Sep 29 20:55:35 the-shire mysqld_safe[4910]: gives you a log in /var/lib/mysql that may be helpful. Sep 29 20:55:35 the-shire mysqld_safe[4910]: Sep 29 20:55:35 the-shire mysqld_safe[4910]: The latest information about MySQL is available on the web at Sep 29 20:55:35 the-shire mysqld_safe[4910]: http://www.mysql.com/. Please consult the MySQL manual section Sep 29 20:55:35 the-shire mysqld_safe[4910]: 'Problems running mysql_install_db', and the manual section that Sep 29 20:55:35 the-shire mysqld_safe[4910]: describes problems on your OS. Another information source are the Sep 29 20:55:35 the-shire mysqld_safe[4910]: MySQL email archives available at http://lists.mysql.com/. Sep 29 20:55:35 the-shire mysqld_safe[4910]: Sep 29 20:55:35 the-shire mysqld_safe[4910]: Please check all of the above before mailing us! And remember, if Sep 29 20:55:35 the-shire mysqld_safe[4910]: you do mail us, you MUST use the /usr/scripts/mysqlbug script! Sep 29 20:55:35 the-shire mysqld_safe[4910]: Sep 29 20:55:35 the-shire kernel: [ 187.387720] mysqld[4940]: segfault at 4 ip b78f34ec sp bf980cc8 error 4 in ld-2.9.so[b78e9000+1c000] Sep 29 20:55:35 the-shire kernel: [ 187.395532] mysqld[4947]: segfault at 4 ip b79194ec sp bfaa2aa8 error 4 in ld-2.9.so[b790f000+1c000] Sep 29 20:55:36 the-shire mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Sep 29 20:55:36 the-shire mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Sep 29 20:55:39 the-shire kernel: [ 190.699316] __ratelimit: 7 callbacks suppressed Sep 29 20:55:39 the-shire kernel: [ 190.699322] mysqld[5135]: segfault at 4 ip b789c4ec sp bfa22898 error 4 in ld-2.9.so[b7892000+1c000] Sep 29 20:55:40 the-shire kernel: [ 191.715297] mysqld[5144]: segfault at 4 ip b78e44ec sp bfa780e8 error 4 in ld-2.9.so[b78da000+1c000] Sep 29 20:55:41 the-shire kernel: [ 192.745347] mysqld[5153]: segfault at 4 ip b79144ec sp bfd3f058 error 4 in ld-2.9.so[b790a000+1c000] Sep 29 20:55:42 the-shire kernel: [ 193.760325] mysqld[5162]: segfault at 4 ip b77ad4ec sp bfd78048 error 4 in ld-2.9.so[b77a3000+1c000] Sep 29 20:55:43 the-shire kernel: [ 194.780640] mysqld[5171]: segfault at 4 ip b77f94ec sp bfd374e8 error 4 in ld-2.9.so[b77ef000+1c000] Sep 29 20:55:44 the-shire kernel: [ 195.805488] mysqld[5180]: segfault at 4 ip b78714ec sp bf9d6438 error 4 in ld-2.9.so[b7867000+1c000] Sep 29 20:55:45 the-shire kernel: [ 196.837202] mysqld[5189]: segfault at 4 ip b78ef4ec sp bf88c728 error 4 in ld-2.9.so[b78e5000+1c000] Sep 29 20:55:46 the-shire kernel: [ 197.851360] mysqld[5198]: segfault at 4 ip b78164ec sp bf95a888 error 4 in ld-2.9.so[b780c000+1c000] Sep 29 20:55:47 the-shire kernel: [ 198.866224] mysqld[5207]: segfault at 4 ip b79524ec sp bf8fc888 error 4 in ld-2.9.so[b7948000+1c000] Sep 29 20:55:48 the-shire kernel: [ 199.883044] mysqld[5216]: segfault at 4 ip b78524ec sp bf898e28 error 4 in ld-2.9.so[b7848000+1c000] Sep 29 20:55:49 the-shire kernel: [ 200.903342] mysqld[5225]: segfault at 4 ip b77e94ec sp bfbcf278 error 4 in ld-2.9.so[b77df000+1c000] Sep 29 20:55:50 the-shire kernel: [ 201.923503] mysqld[5234]: segfault at 4 ip b77a54ec sp bf856868 error 4 in ld-2.9.so[b779b000+1c000] Sep 29 20:55:50 the-shire kernel: [ 201.953263] mysqld[5242]: segfault at 4 ip b77b84ec sp bf8134d8 error 4 in ld-2.9.so[b77ae000+1c000] Sep 29 20:55:50 the-shire /etc/init.d/mysql[5248]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Sep 29 20:55:50 the-shire /etc/init.d/mysql[5248]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Sep 29 20:55:50 the-shire /etc/init.d/mysql[5248]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Sep 29 20:55:50 the-shire /etc/init.d/mysql[5248]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Sep 29 20:55:50 the-shire /etc/init.d/mysql[5248]: It could be that the above output is from 2 times it failed to start, one during bootup and one after doing an "aptitude safe-upgrade" which tried to configure (again) mysql-server, since it failed during the upgrade yesterday. If more information is needed, just ask. -- 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-bigmem (SMP w/2 CPU cores) 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.111 add and remove users and groups ii debconf [debconf-2.0] 1.5.27 Debian configuration management sy ii libc6 2.9-26 GNU C Library: Shared libraries ii libdbi-perl 1.609-1 Perl Database Interface (DBI) ii libgcc1 1:4.4.1-4 GCC support library ii libmysqlclient16 5.1.39-1 MySQL database client library ii libstdc++6 4.4.1-4 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.39-1 MySQL database client binaries ii mysql-common 5.1.39-1 MySQL database common files (e.g. ii passwd 1:4.1.4.2-1 change and administer password and ii perl 5.10.1-3 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-15 compression library - runtime Versions of packages mysql-server-5.1 recommends: ii bsd-mailx [mailx] 8.1.2-0.20090911cvs-1 simple mail user agent pn libhtml-template-p <none> (no description available) 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: -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org