[pgpool-general-jp: 655] Re: pgpool-ii 19ノード以上設定時のshow pool_status

[NamaT]

石井様
お返事ありがとうございます。

gdbの出力は下記のようになりました。
OSはCentOS5.3を使用しています。

別端末のpsqlから show pool_status を入力後に (gdb) continue しています。取得方法はこれでよろしいでしょうか。
ご指摘の通り、show pool status 後に接続していたpgpoolプロセスが落ちて、別PIDが生成されておりました。


----ここから----
# ps ax | grep idle
22868 pts/0    S      0:00 pgpool: postgres postgres [local] idle
22911 ?        Ss     0:00 postgres: postgres postgres
127.0.0.1(58924) idle

# gdb /usr/local/bin/pgpool 22868
GNU gdb Fedora (6.8-37.el5)
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "i386-redhat-linux-gnu"...
Attaching to program: /usr/local/bin/pgpool, process 22868

warning: .dynamic section for "/lib/i686/nosegneg/libc.so.6" is not at
the expected address

warning: difference appears to be caused by prelink, adjusting expectations

warning: .dynamic section for "/lib/libcrypt.so.1" is not at the
expected address

warning: difference appears to be caused by prelink, adjusting expectations
Reading symbols from /usr/local/pgsql/lib/libpq.so.5...done.
Loaded symbols for /usr/local/pgsql/lib/libpq.so.5
Reading symbols from /usr/local/lib/libpcp.so.0...done.
Loaded symbols for /usr/local/lib/libpcp.so.0
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/i686/nosegneg/libm.so.6...done.
Loaded symbols for /lib/i686/nosegneg/libm.so.6
Reading symbols from /lib/i686/nosegneg/libc.so.6...done.
Loaded symbols for /lib/i686/nosegneg/libc.so.6
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
0x00b15402 in __kernel_vsyscall ()
(gdb) bt
#0  0x00b15402 in __kernel_vsyscall ()
#1  0x001dbfad in ___newselect_nocancel () from /lib/i686/nosegneg/libc.so.6
#2  0x0806052e in pool_process_query (frontend=0x8b52a88,
backend=0x8b518c0, connection_reuse=0,
first_ready_for_query_received=0)
    at pool_process_query.c:224
#3  0x0804ff89 in do_child (unix_fd=3, inet_fd=4) at child.c:429
#4  0x0804b639 in fork_a_child (unix_fd=3, inet_fd=4, id=3) at main.c:836
#5  0x0804c3dd in failover () at main.c:1348
#6  0x0804c765 in pool_sleep (second=<value optimized out>) at main.c:1819
#7  0x0804d10b in main (argc=2, argv=0xbfa72b04) at main.c:588
(gdb) continue
Continuing.

Program received signal SIGSEGV, Segmentation fault.
0x08003395 in ?? ()
(gdb) bt
#0  0x08003395 in ?? ()
#1  0x08b52a88 in ?? ()
#2  0x08b518c0 in ?? ()
#3  0x00000000 in ?? ()

(gdb) detach
LND: Sending signal 11 to process 22868
Detaching from program: /usr/local/bin/pgpool, process 22868
(gdb) quit

# ps ax | grep idle
22941 pts/0    S      0:00 pgpool: postgres postgres [local] idle
22942 ?        Ss     0:00 postgres: postgres postgres 127.0.0.1(36977) idle
----ここまで----

以上よろしくお願い致します。