Your message dated Fri, 21 Jan 2011 00:25:31 +0100
with message-id <[email protected]>
and subject line
has caused the Debian Bug report #548956,
regarding mysql-server-5.1: mysql fails to start: segfault in ld-2.9.so
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.)
--
548956: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=548956
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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:
--- End Message ---
--- Begin Message ---
> this bug can be closed.
Sure
--- End Message ---
