From: Michael Widenius Date: October 18 2000 8:59pm Subject: mysql still hangs on FreeBSD 4.1 (long) List-Archive: http://lists.mysql.com/bugs/450 Message-Id: <14830.3892.119584.512675@narttu.mysql.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "Ekaterina" == Ekaterina Ivannikova writes: Ekaterina> Hi All, Ekaterina> well, folks, mysql 3.23 also hangs. Ekaterina> Attempts to connect thru UNIX socket and TCP/IP both hang after asking Ekaterina> for password. Ekaterina> This is what mysqlbug has to say: >> Release: mysql-3.23.25-beta (Source distribution) >> Environment: Ekaterina> Ekaterina> 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 Ekaterina> (gdb) thread 1 Ekaterina> [Switching to thread 1 (process 47659, thread 1)] Ekaterina> #0 0x2821ff64 in _thread_sys_poll () from /usr/lib/libc_r.so.4 Ekaterina> (gdb) bt Ekaterina> #0 0x2821ff64 in _thread_sys_poll () from /usr/lib/libc_r.so.4 Ekaterina> #1 0x28218913 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4 Ekaterina> #2 0x28217ffe in _thread_kern_sched () from /usr/lib/libc_r.so.4 Ekaterina> #3 0x28218493 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4 Ekaterina> #4 0x2821643a in pthread_mutex_lock () from /usr/lib/libc_r.so.4 Ekaterina> #5 0x2821d329 in pthread_exit () from /usr/lib/libc_r.so.4 Ekaterina> #6 0x8079ca1 in end_thread (thd=0x8a3d000, put_in_cache=true) at mysqld.cc:928 Ekaterina> #7 0x807ef15 in handle_one_connection (arg=0x8a3d000) at sql_parse.cc:421 Ekaterina> #8 0x281df65b in _thread_start () from /usr/lib/libc_r.so.4 I have to agree with Sasha that the above is a clear indication that something is wrong with the thread implementation on your FreeBSD machine. You should try to mail the above backtrace to the FreeBSD developers and ask how it's possible that a thread can get stuck in the above place (It shouldn't be possible). Regards, Monty