[debian-mysql] Bug#548956: mysql-server-5.1: mysql fails to start: segfault in ld-2.9.so
Diederik de Haas
didi.debian at cknow.org
Tue Sep 29 20:05:03 UTC 2009
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:
More information about the pkg-mysql-maint
mailing list