List:Bugs« Previous MessageNext Message »
From:sasha Date:October 18 2000 5:34pm
Subject:Re: mysql still hangs on FreeBSD 4.1 (long)
View as plain text  
Ekaterina Ivannikova wrote:
> 
> Hi All,
> 
> well, folks, mysql 3.23 also hangs.
> Attempts to connect thru UNIX socket and TCP/IP both hang after asking
> for password.
> 
> This is what mysqlbug has to say:
> 
> >Release:       mysql-3.23.25-beta (Source distribution)
> 
> >Environment:
>         <machine, os, target, libraries (multiple lines)>
> System: FreeBSD hub.all.yans.ru 4.1-RELEASE FreeBSD 4.1-RELEASE #2: Mon Oct  9
> 14:22:57 MSD 2000     root@stripped:/usr/src/sys/compile/HUB  i386
> 
> Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Using builtin specs.
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='cc'  CFLAGS='-Wall -pipe'  CXX='cc'  CXXFLAGS='-Wall -pipe
> -fno-rtti -fno-exceptions -felide-constructors'  LDFLAGS=''
> LIBC:
> -r--r--r--  1 root  wheel  1156960 Jul 28 17:05 /usr/lib/libc.a
> lrwxrwxrwx  1 root  wheel  9 Aug 30 21:17 /usr/lib/libc.so -> libc.so.4
> -r--r--r--  1 root  wheel  553460 Jul 28 17:05 /usr/lib/libc.so.4
> Configure command: ./configure  --prefix=/usr/local/mysql --with-debug=full
> --without-readline --enable-assembler --localstatedir=/var/db/mysql
> --enable-thread-safe-client
> Perl: This is perl, version 5.005_03 built for i386-freebsd
> 
> Attaching with gdb to mysqld process produced the following output:
> 
> bash-2.04# gdb mysqld 47659
> GNU gdb 4.18
> Copyright 1998 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 "i386-unknown-freebsd"...
> 
> /root/mysql-3.23.25-beta/sql/47659: No such file or directory.
> Attaching to program: /root/mysql-3.23.25-beta/sql/mysqld, process 47659
> Reading symbols from /usr/lib/libc_r.so.4...done.
> Reading symbols from /usr/lib/libm.so.2...done.
> Reading symbols from /usr/lib/libz.so.2...done.
> Reading symbols from /usr/lib/libcrypt.so.2...done.
> Reading symbols from /usr/libexec/ld-elf.so.1...done.
> 0x2821ff64 in _thread_sys_poll () from /usr/lib/libc_r.so.4
> (gdb) info threads
>   4 process 47659, thread 4  0x2821780e in _thread_kern_sched ()
>    from /usr/lib/libc_r.so.4
>   3 process 47659, thread 3  0x2821780e in _thread_kern_sched ()
>    from /usr/lib/libc_r.so.4
>   2 process 47659, thread 2  0x2821780e in _thread_kern_sched ()
>    from /usr/lib/libc_r.so.4
> * 1 process 47659, thread 1  0x2821ff64 in _thread_sys_poll ()
>    from /usr/lib/libc_r.so.4
> (gdb) thread 1
> [Switching to thread 1 (process 47659, thread 1)]
> #0  0x2821ff64 in _thread_sys_poll () from /usr/lib/libc_r.so.4
> (gdb) bt
> #0  0x2821ff64 in _thread_sys_poll () from /usr/lib/libc_r.so.4
> #1  0x28218913 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4
> #2  0x28217ffe in _thread_kern_sched () from /usr/lib/libc_r.so.4
> #3  0x28218493 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4
> #4  0x2821643a in pthread_mutex_lock () from /usr/lib/libc_r.so.4
> #5  0x2821d329 in pthread_exit () from /usr/lib/libc_r.so.4
> #6  0x8079ca1 in end_thread (thd=0x8a3d000, put_in_cache=true) at mysqld.cc:928
> #7  0x807ef15 in handle_one_connection (arg=0x8a3d000) at sql_parse.cc:421
> #8  0x281df65b in _thread_start () from /usr/lib/libc_r.so.4
> #9  0x0 in ?? ()
> (gdb) thread 2
> [Switching to thread 2 (process 47659, thread 2)]
> #0  0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
> (gdb) bt
> #0  0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
> #1  0x28218493 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4
> #2  0x2821643a in pthread_mutex_lock () from /usr/lib/libc_r.so.4
> #3  0x2821d329 in pthread_exit () from /usr/lib/libc_r.so.4
> #4  0x8079ca1 in end_thread (thd=0x8a3d000, put_in_cache=true) at mysqld.cc:928
> #5  0x807ef15 in handle_one_connection (arg=0x8a3d000) at sql_parse.cc:421
> #6  0x281df65b in _thread_start () from /usr/lib/libc_r.so.4
> #7  0x0 in ?? ()
> (gdb) thread 3
> [Switching to thread 3 (process 47659, thread 3)]
> #0  0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
> (gdb) bt
> #0  0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
> #1  0x28218493 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4
> #2  0x2821643a in pthread_mutex_lock () from /usr/lib/libc_r.so.4
> #3  0x28216744 in _mutex_cv_lock () from /usr/lib/libc_r.so.4
> #4  0x2821da14 in pthread_cond_timedwait () from /usr/lib/libc_r.so.4
> #5  0x28205389 in _thread_gc () from /usr/lib/libc_r.so.4
> #6  0x281df65b in _thread_start () from /usr/lib/libc_r.so.4
> #7  0x0 in ?? ()
> (gdb) thread 4
> [Switching to thread 4 (process 47659, thread 4)]
> #0  0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
> (gdb) bt
> #0  0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
> #1  0x28218422 in _thread_kern_sched_state () from /usr/lib/libc_r.so.4
> #2  0x281dd39b in sigwait () from /usr/lib/libc_r.so.4
> #3  0x807a244 in signal_hand (arg=0x0) at mysqld.cc:1153
> #4  0x281df65b in _thread_start () from /usr/lib/libc_r.so.4
> #5  0x0 in ?? ()
> (gdb)

This does look like some really strange thread library problem. Can you try the
following:

 * link statically
 * update your libc

if the above does not help, can you write a program that can be run outside of
the context of your system that will hang mysqld on your system?

-- 
MySQL Development Team
   __  ___     ___ ____  __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <sasha@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
        ___/
Thread
mysql still hangs on FreeBSD 4.1 (long)Ekaterina Ivannikova18 Oct
  • Re: mysql still hangs on FreeBSD 4.1 (long)sasha18 Oct
    • Re: mysql still hangs on FreeBSD 4.1 (long)Ekaterina Ivannikova20 Oct
  • mysql still hangs on FreeBSD 4.1 (long)Michael Widenius18 Oct
  • Re: mysql still hangs on FreeBSD 4.1 (long)sasha20 Oct