Package: mysql-server-5.0 Version: 5.0.32-3 Severity: grave Justification: causes non-serious data loss
Hello, Since yesterday, we do have mysql crashs on one of our servers running debian/etch. We had this crash once yesterday night, and once today. The error log in /var/log/syslog is: Feb 13 17:02:32 merkur86 mysqld[15652]: *** glibc detected *** double free or corruption (!prev): 0x08b26088 *** Feb 13 17:02:32 merkur86 mysqld[15652]: mysqld got signal 6; Feb 13 17:02:32 merkur86 mysqld[15652]: This could be because you hit a bug. It is also possible that this binary Feb 13 17:02:32 merkur86 mysqld[15652]: or one of the libraries it was linked against is corrupt, improperly built, Feb 13 17:02:32 merkur86 mysqld[15652]: or misconfigured. This error can also be caused by malfunctioning hardware. Feb 13 17:02:32 merkur86 mysqld[15652]: We will try our best to scrape up some info that will hopefully help diagnose Feb 13 17:02:32 merkur86 mysqld[15652]: the problem, but since we have already crashed, something is definitely wrong Feb 13 17:02:32 merkur86 mysqld[15652]: and this may fail. Feb 13 17:02:32 merkur86 mysqld[15652]: Feb 13 17:02:32 merkur86 mysqld[15652]: key_buffer_size=16777216 Feb 13 17:02:32 merkur86 mysqld[15652]: read_buffer_size=131072 Feb 13 17:02:32 merkur86 mysqld[15652]: max_used_connections=16 Feb 13 17:02:32 merkur86 mysqld[15652]: max_connections=100 Feb 13 17:02:32 merkur86 mysqld[15652]: threads_connected=14 Feb 13 17:02:32 merkur86 mysqld[15652]: It is possible that mysqld could use up to Feb 13 17:02:32 merkur86 mysqld[15652]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 233983 K Feb 13 17:02:32 merkur86 mysqld[15652]: bytes of memory Feb 13 17:02:32 merkur86 mysqld[15652]: Hope that's ok; if not, decrease some variables in the equation. Feb 13 17:02:32 merkur86 mysqld[15652]: Feb 13 17:02:32 merkur86 mysqld[15652]: thd=0x8b186d0 Feb 13 17:02:32 merkur86 mysqld[15652]: Attempting backtrace. You can use the following information to find out Feb 13 17:02:32 merkur86 mysqld[15652]: where mysqld died. If you see no messages after this, something went Feb 13 17:02:32 merkur86 mysqld[15652]: terribly wrong... Feb 13 17:02:32 merkur86 mysqld[15652]: Cannot determine thread, fp=0xb0e78558, backtrace may not be correct. Feb 13 17:02:32 merkur86 mysqld[15652]: Stack range sanity check OK, backtrace follows: Feb 13 17:02:32 merkur86 mysqld[15652]: 0x81c0649 Feb 13 17:02:32 merkur86 mysqld[15652]: 0xb7cfb947 Feb 13 17:02:32 merkur86 mysqld[15652]: 0xb7cfd0c9 Feb 13 17:02:32 merkur86 mysqld[15652]: 0xb7d30fda Feb 13 17:02:32 merkur86 mysqld[15652]: 0xb7d3889f Feb 13 17:02:32 merkur86 mysqld[15652]: 0xb7d38942 Feb 13 17:02:32 merkur86 mysqld[15652]: 0x8484df3 Feb 13 17:02:32 merkur86 mysqld[15652]: 0x81dbc5d Feb 13 17:02:32 merkur86 mysqld[15652]: 0x81dd188 Feb 13 17:02:32 merkur86 mysqld[15652]: 0x81ddb94 Feb 13 17:02:32 merkur86 mysqld[15652]: 0xb7f640bd Feb 13 17:02:32 merkur86 mysqld[15652]: 0xb7d9e93e Feb 13 17:02:32 merkur86 mysqld[15652]: New value of fp=(nil) failed sanity check, terminating stack trace! Feb 13 17:02:32 merkur86 mysqld[15652]: Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved Feb 13 17:02:32 merkur86 mysqld[15652]: stack trace is much more helpful in diagnosing the problem, so please do Feb 13 17:02:32 merkur86 mysqld[15652]: resolve it Feb 13 17:02:32 merkur86 mysqld[15652]: Trying to get some variables. Feb 13 17:02:32 merkur86 mysqld[15652]: Some pointers may be invalid and cause the dump to abort... Feb 13 17:02:32 merkur86 mysqld[15652]: thd->query at (nil) is invalid pointer Feb 13 17:02:32 merkur86 mysqld[15652]: thd->thread_id=66 Feb 13 17:02:32 merkur86 mysqld[15652]: The manual page at http://www.mysql.com/doc/en/Crashing.html contains Feb 13 17:02:32 merkur86 mysqld[15652]: information that should help you find out what is causing the crash. I already did this 'stack trace': [ copied the 0x... hex digits to mysqld.stack] # cp /usr/share/doc/mysql-server-5.0/mysqld.sym.gz # gzip -d mysqld.sym.gz # resolve_stack_dump -s mysqld.sym -n mysqld.stack 0x81c0649 handle_segfault + 681 0xb7cfb947 _end + -1352585609 0xb7cfd0c9 _end + -1352579591 0xb7d30fda _end + -1352366838 0xb7d3889f _end + -1352335921 0xb7d38942 _end + -1352335758 0x8484df3 free_root + 67 0x81dbc5d _Z16dispatch_command19enum_server_commandP3THDPcj + 509 0x81dd188 _Z10do_commandP3THD + 136 0x81ddb94 handle_one_connection + 2308 0xb7f640bd _end + -1350060563 0xb7d9e93e _end + -1351917970 We do have a mysql backup script running every 30 Minutes. Maybe this one is the reason for the crash, but regardless whatever the reason may be, mysqld should not crash ever. See the script mysql-backup.sh attached. ... jonas -- System Information: Debian Release: 4.0 APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.15-1-i386-merkur86 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages mysql-server-5.0 depends on: ii adduser 3.102 Add and remove users and groups ii debconf [debconf-2.0] 1.5.11 Debian configuration management sy ii libc6 2.3.6.ds1-10 GNU C Library: Shared libraries ii libdbi-perl 1.53-1 Perl5 database interface by Tim Bu ii libgcc1 1:4.1.1-21 GCC support library ii libmysqlclient15off 5.0.32-3 mysql database client library ii libncurses5 5.5-5 Shared libraries for terminal hand ii libreadline5 5.2-2 GNU readline and history libraries ii libstdc++6 4.1.1-21 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-12 Wietse Venema's TCP wrappers libra ii lsb-base 3.1-22 Linux Standard Base 3.1 init scrip ii mysql-client-5.0 5.0.32-3 mysql database client binaries ii mysql-common 5.0.32-3 mysql database common files (e.g. ii passwd 1:4.0.18.1-6 change and administer password and ii perl 5.8.8-7 Larry Wall's Practical Extraction ii psmisc 22.3-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3-13 compression library - runtime Versions of packages mysql-server-5.0 recommends: ii mailx 1:8.1.2-0.20050715cvs-1 A simple mail user agent -- debconf information: mysql-server-5.0/really_downgrade: false * mysql-server-5.0/need_sarge_compat: false mysql-server-5.0/start_on_boot: true mysql-server/error_setting_password: mysql-server-5.0/mysql_update_hints1: mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false mysql-server-5.0/need_sarge_compat_done: true mysql-server-5.0/no_upgrade_with_isam_tables: * mysql-server-5.0/mysql_install_db_notes:
mysql-backup.sh
Description: application/shellscript
