>Description: When I start up my fresh compiled mysqld it crashes immediately, the error log file says:
040801 00:07:28 mysqld restarted 040801 0:07:29 Warning: Can't open time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 233983 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x84e8140 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbffff2e8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8156843 0x40174b83 0x40366093 0x815849d 0x403164c0 0x80d15a1 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at (nil) is invalid pointer thd->thread_id=-606348325 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Resolving the stack trace with the symbols generated by nm -D -n /usr/sbin/mysqld gives: matrix ~ # resolve_stack_dump mysqld.sym -n mysqld.stack 0x8156843 handle_segfault + 643 0x40174b83 _end + 936145507 0x40366093 _end + 938182515 0x815849d main + 525 0x403164c0 _end + 937855904 0x80d15a1 _start + 33 debugging gives: matrix mysql # gdb /usr/sbin/mysqld GNU gdb 6.1.1 Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i686-pc-linux-gnu"...(no debugging symbols found)...Using host libthread_db library "/lib/libthread_db.so.1". (gdb) set args --datadir=/var/lib/mysql --skip-stack-trace --gdb (gdb) run Starting program: /usr/sbin/mysqld --datadir=/var/lib/mysql --skip-stack-trace --gdb warning: Unable to find dynamic linker breakpoint function. GDB will be unable to debug shared library initializers and track explicitly loaded dynamic code. (no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)... Program received signal SIG32, Real-time event 32. 0x401719f3 in pthread_getconcurrency () from /lib/libpthread.so.0 (gdb) backtrace full #0 0x401719f3 in pthread_getconcurrency () from /lib/libpthread.so.0 No symbol table info available. #1 0x40177b84 in ?? () from /lib/libpthread.so.0 No symbol table info available. #2 0xbffff630 in ?? () No symbol table info available. #3 0xbffff6c8 in ?? () No symbol table info available. #4 0x4017151b in pthread_getconcurrency () from /lib/libpthread.so.0 No symbol table info available. #5 0xbffff630 in ?? () No symbol table info available. #6 0x00000020 in ?? () No symbol table info available. #7 0xbffff630 in ?? () No symbol table info available. #8 0x4016ffaa in pthread_mutex_unlock () from /lib/libpthread.so.0 No symbol table info available. Previous frame inner to this frame (corrupt stack?) (gdb) n Single stepping until exit from function pthread_getconcurrency, which has no line number information. 0x40170d62 in pthread_create () from /lib/libpthread.so.0 (gdb) s Single stepping until exit from function pthread_create, which has no line number information. 0x08156ca8 in handle_segfault () (gdb) n Single stepping until exit from function handle_segfault, which has no line number information. Program received signal SIG32, Real-time event 32. 0x401719f3 in pthread_getconcurrency () from /lib/libpthread.so.0 (gdb) n Single stepping until exit from function pthread_getconcurrency, which has no line number information. 0x4016e018 in pthread_cond_wait () from /lib/libpthread.so.0 (gdb) n Single stepping until exit from function pthread_cond_wait, which has no line number information. 0x40172e40 in sem_timedwait () from /lib/libpthread.so.0 (gdb) n Single stepping until exit from function sem_timedwait, which has no line number information. 040801 0:32:26 Warning: Can't open time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them Program received signal SIGSEGV, Segmentation fault. 0x40366093 in strlen () from /lib/libc.so.6 (gdb) n Single stepping until exit from function strlen, which has no line number information. Program terminated with signal SIGSEGV, Segmentation fault. The program no longer exists. (gdb) backtrace full No stack. (gdb) quit Hope this helps you identifying the reasons why mysqld keeps crashing on my system, if you need further information feel free to contact me. >How-To-Repeat: I just have to start mysqld. >Fix: No idea, sorry :-( >Submitter-Id: ? >Originator: Helge Jung >Organization: ECO-Logic Software GmbH >MySQL support: none (yet) >Synopsis: <synopsis of the problem (one line)> >Severity: critical (I suppose) >Priority: high (mysql doesn't even start) >Category: mysql >Class: sw-bug >Release: mysql-4.1.3-beta (Gentoo Linux mysql-4.1.3_beta) >C compiler: gcc (GCC) 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, >pie-8.7.6) >C++ compiler: g++ (GCC) 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, >pie-8.7.6) >Environment: <machine, os, target, libraries (multiple lines)> System: Linux matrix 2.6.5-gentoo-r1 #13 Mon Jul 5 19:22:10 i686 AMD Athlon(tm) processor AuthenticAMD GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.4/specs Configured with: /var/tmp/portage/gcc-3.3.4-r1/work/gcc-3.3.4/configure --prefix=/usr --bindir=/usr/i686-pc-linux-gnu/gcc-bin/3.3 --includedir=/usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.4/include --datadir=/usr/share/gcc-data/i686-pc-linux-gnu/3.3 --mandir=/usr/share/gcc-data/i686-pc-linux-gnu/3.3/man --infodir=/usr/share/gcc-data/i686-pc-linux-gnu/3.3/info --enable-shared --host=i686-pc-linux-gnu --target=i686-pc-linux-gnu --with-system-zlib --enable-languages=c,c++ --enable-threads=posix --enable-long-long --disable-checking --disable-libunwind-exceptions --enable-cstdio=stdio --enable-version-specific-runtime-libs --with-gxx-include-dir=/usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.4/include/g++-v3 --with-local-prefix=/usr/local --enable-shared --enable-nls --without-included-gettext --disable-multilib --enable-__cxa_atexit --enable-clocale=generic Thread model: posix gcc version 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6) Compilation info: CC='gcc' CFLAGS='-O2' CXX='g++' CXXFLAGS='-O2 -felide-constructors -fno-exceptions -fno-rtti -g' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jul 22 19:55 /lib/libc.so.6 -> libc-2.3.4.so -rwxr-xr-x 1 root root 1186432 Jul 22 19:55 /lib/libc-2.3.4.so -rw-r--r-- 1 root root 2605880 Jul 22 19:55 /usr/lib/libc.a -rwxr-xr-x 1 root root 204 Jul 22 19:55 /usr/lib/libc.so -rwxr-xr-x 1 root root 580404 May 11 08:47 /usr/lib/libc.so.5 lrwxrwxrwx 1 root root 19 May 11 12:34 /usr/lib/libc-client.a -> /usr/lib/c-client.a Configure command: ./configure '--prefix=/usr' '--host=i686-pc-linux-gnu' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--datadir=/usr/share' '--sysconfdir=/etc' '--localstatedir=/var/lib' '--with-extra-charsets=complex' '--libexecdir=/usr/sbin' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--with-mysqld-user=mysql' '--with-debug=full' '--with-charset=utf8' '--with-extra-charsets=all' '--with-comment=Gentoo Linux mysql-4.1.3_beta' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--enable-thread-safe-client' '--with-berkeley-db=./bdb' '--without-readline' '--enable-shared' '--enable-static' '--with-libwrap' '--without-innodb' '--with-vio' '--with-openssl' '--with-debug' 'CC=gcc' 'CFLAGS=-O2' 'CXXFLAGS=-O2 -felide-constructors -fno-exceptions -fno-rtti -g' 'CXX=g++' 'host_alias=i686-pc-linux-gnu' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
