On Thu, 8 Aug 2002, Peter Zaitsev wrote:

PZ>>>Well. Really what I really need is back trace from GDB connected to the
process during the hang

Here we go: Attaching to program `/mysql/libexec/mysqld', process 4342 Reading symbols from /shlib/libdl.so...done. Reading symbols from /weblib/local/lib/libpthread.so.14...done. Reading symbols from /usr/lib/libz.so.1...done. Reading symbols from /shlib/libm.so.0.0...done. Reading symbols from /shlib/libc.so.1...done. Reading symbols from /shlib/libgcc.so.1...done. Reading symbols from /shlib/ld-bsdi.so...done. 0x4824b575 in _syscall_sys_select () (gdb) bt #0 0x4824b575 in _syscall_sys_select () #1 0x48202a56 in __pth_sched_eventmanager () #2 0x48202297 in __pth_scheduler () #3 0x482037b8 in pth_spawn_trampoline () #4 0x48201975 in pth_mctx_set_bootstrap () #5 0x482018ea in pth_mctx_set_trampoline () #6 <signal handler called> #7 0x482d57b6 in _syscall_sys_sigsuspend () (gdb) continue Continuing.

Program received signal SIGUSR1, User defined signal 1. 0x482d57b6 in _syscall_sys_sigsuspend () (gdb) bt #0 0x482d57b6 in _syscall_sys_sigsuspend () #1 0x4820179e in __pth_mctx_set () #2 0x48203a1b in pth_spawn () #3 0x481ff04e in pthread_create () #4 0x8080b44 in create_new_thread (thd=0x8285000) at mysqld.cc:2389 #5 0x808128b in handle_connections_sockets (arg=0x0) at mysqld.cc:2618 #6 0x80803af in main (argc=15, argv=0x8213340) at mysqld.cc:2142 #7 0x804c7d7 in __start () (gdb) continue Continuing.

Program received signal SIGUSR1, User defined signal 1. 0x482d57b6 in _syscall_sys_sigsuspend () (gdb) bt #0 0x482d57b6 in _syscall_sys_sigsuspend () #1 0x4820179e in __pth_mctx_set () #2 0x48203a1b in pth_spawn () #3 0x481ff04e in pthread_create () #4 0x8080b44 in create_new_thread (thd=0x8285000) at mysqld.cc:2389 #5 0x808128b in handle_connections_sockets (arg=0x0) at mysqld.cc:2618 #6 0x80803af in main (argc=15, argv=0x8213340) at mysqld.cc:2142 #7 0x804c7d7 in __start () (gdb) continue Continuing.

Program received signal SIGPIPE, Broken pipe. 0x482d56f5 in _syscall_sys_sigprocmask () (gdb) bt #0 0x482d56f5 in _syscall_sys_sigprocmask () #1 0x48202a13 in __pth_sched_eventmanager () #2 0x48202297 in __pth_scheduler () #3 0x482037b8 in pth_spawn_trampoline () #4 0x48201975 in pth_mctx_set_bootstrap () #5 0x482018ea in pth_mctx_set_trampoline () #6 <signal handler called> #7 0x482d57b6 in _syscall_sys_sigsuspend () (gdb) continue Continuing.

Program received signal SIGUSR1, User defined signal 1. 0x482d57b6 in _syscall_sys_sigsuspend () (gdb) bt #0 0x482d57b6 in _syscall_sys_sigsuspend () #1 0x4820179e in __pth_mctx_set () #2 0x48203a1b in pth_spawn () #3 0x481ff04e in pthread_create () #4 0x807f66a in signal_hand (arg=0x0) at mysqld.cc:1564 #5 0x482037b8 in pth_spawn_trampoline () #6 0x48201975 in pth_mctx_set_bootstrap () #7 0x482018ea in pth_mctx_set_trampoline () #8 <signal handler called> #9 0x482d57b6 in _syscall_sys_sigsuspend () #10 0x6d2f016a in ?? () Error accessing memory address 0x5: Cannot allocate memory. (gdb) continue Continuing.

Program received signal SIGUSR1, User defined signal 1. 0x482d57b6 in _syscall_sys_sigsuspend () (gdb) bt #0 0x482d57b6 in _syscall_sys_sigsuspend () #1 0x4820179e in __pth_mctx_set () #2 0x48203a1b in pth_spawn () #3 0x481ff04e in pthread_create () #4 0x807f66a in signal_hand (arg=0x0) at mysqld.cc:1564 #5 0x482037b8 in pth_spawn_trampoline () #6 0x48201975 in pth_mctx_set_bootstrap () #7 0x482018ea in pth_mctx_set_trampoline () #8 <signal handler called> #9 0x482d57b6 in _syscall_sys_sigsuspend () #10 0x6d2f016a in ?? () Error accessing memory address 0x5: Cannot allocate memory. (gdb) continue Continuing.

command. <<<<<<

Program received signal SIGUSR1, User defined signal 1. 0x482d56f5 in _syscall_sys_sigprocmask () (gdb) bt #0 0x482d56f5 in _syscall_sys_sigprocmask () #1 0x4826a300 in siglongjmp () #2 0x482037b8 in pth_spawn_trampoline () #3 0x48201975 in pth_mctx_set_bootstrap () #4 0x482018ea in pth_mctx_set_trampoline () #5 <signal handler called> #6 0x482d57b6 in _syscall_sys_sigsuspend () (gdb) continue Continuing.

Program exited normally. (gdb)