Hi, below is a stacktrace of a mysql 4.0.2 compilation, on a BSDi 4.1 machine, with pth in pthread compat mode. The symptom, is that the `mysqladmin shutdown' command needs to be issued twice before the server is shutdown.
After troubleshooting and recompilation, uninstalling pth and using the native threads works, so the system supports the needed thread calls. Both Pth 1.4.0 as 1.4.1 have these issues and are compiled with --enable-syscall-soft. If you need more information, let me know. P.S.: note the section marked with >>>>>>> <<<<<<< which is the point at which the mysqld server is idle, and the mysqladmin binary is killed and subsequently the command is re-issued. >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. > > >>>> At this point I stopped mysqladmin and re-issued the shutdown >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) Best regards, Melvyn Sopacua WebMaster IDG.nl _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ If it applies, where it applies - this email is a personal contribution and does not reflect the views of my employer IDG.nl. \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\ ______________________________________________________________________ GNU Portable Threads (Pth) http://www.gnu.org/software/pth/ User Support Mailing List [EMAIL PROTECTED] Automated List Manager (Majordomo) [EMAIL PROTECTED]
