>>>>> "Ekaterina" == Ekaterina Ivannikova <kate@stripped>
> 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> <machine, os, target, libraries (multiple lines)>
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
<cut>
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
