[pgpool-general: 2801] Re: Child process hangs in active state

[Junegunn Choi]

We had the same issue today:

root     17780  0.0  0.0 104060  2120 ?        S    17:06   0:00 sudo -u
pgpool bash -c /db/pgpool/bin/pgpool -n -D -f
/db/pgpool/conf/pgm/pgpool.conf -F /db/pgpool/conf/pgm/pcp.conf -a
/db/pgpool/conf/pg
pgpool   17783  0.0  0.0  63848  1040 ?        S    17:06   0:00  \_ bash
-c /db/pgpool/bin/pgpool -n -D -f /db/pgpool/conf/pgm/pgpool.conf -F
/db/pgpool/conf/pgm/pcp.conf -a /db/pgpool/conf/pgm/pool_hba.
pgpool   17784  0.0  0.0  27820  8452 ?        S    17:06   0:00      \_
/db/pgpool/bin/pgpool -n -D -f /db/pgpool/conf/pgm/pgpool.conf -F
/db/pgpool/conf/pgm/pcp.conf -a /db/pgpool/conf/pgm/pool_hba.conf
pgpool   17849  0.1  0.0 1394592 4968 ?        S    17:06   0:02      |
\_ pgpool: cloud cloud 10.28.12.164(1490) SET
pgpool   17887  0.0  0.0  27984  3100 ?        S    17:06   0:00      |
\_ pgpool: PCP: wait for connection request
pgpool   17888  0.0  0.0  27816  1392 ?        S    17:06   0:00      |
\_ pgpool: worker process
pgpool   23015  0.4  0.0  34700  4980 ?        S    17:16   0:03      |
\_ pgpool: accept connection
pgpool   23461  0.4  0.0  34708  4964 ?        S    17:17   0:03      |
\_ pgpool: accept connection
pgpool   27649  1.3  0.0  34792  4996 ?        S    17:25   0:03      |
\_ pgpool: cloud cloud 10.27.32.162(63629) idle
pgpool   27671  1.7  0.0  34792  5012 ?        S    17:25   0:04      |
\_ pgpool: cloud cloud 10.28.21.227(19551) idle
pgpool   27683  1.4  0.0  34792  4996 ?        S    17:25   0:03      |
\_ pgpool: cloud cloud 10.30.25.32(6826) idle
pgpool   27684  1.5  0.0  34780  5004 ?        S    17:25   0:04      |
\_ pgpool: cloud cloud 10.30.25.92(56946) idle
--- the rest omitted ---


(gdb) where
#0  0x0000003d222cdaf3 in __select_nocancel () from /lib64/libc.so.6
#1  0x0000000000418c61 in pool_check_fd (cp=<value optimized out>) at
pool_process_query.c:951
#2  0x000000000041d0d4 in pool_read2 (cp=0x1b490fa0, len=1392508889) at
pool_stream.c:264
#3  0x00000000004486db in CommandComplete (frontend=0x1b49b6d0,
backend=0x1b485810) at pool_proto_modules.c:2135
#4  0x000000000044988d in ProcessBackendResponse (frontend=0x1b49b6d0,
backend=0x1b485810, state=0x7fffbe069630, num_fields=0x7fffbe069636) at
pool_proto_modules.c:2701
#5  0x000000000041b68d in pool_process_query (frontend=0x1b49b6d0,
backend=0x1b485810, reset_request=1) at pool_process_query.c:289
#6  0x000000000040b1a0 in do_child (unix_fd=4, inet_fd=5) at child.c:384
#7  0x000000000040455f in fork_a_child (unix_fd=4, inet_fd=5, id=62) at
main.c:1258
#8  0x0000000000407476 in main (argc=<value optimized out>,
argv=0x7fffbe0702e8) at main.c:668


(gdb) p *cp
$4 = {fd = 9, wbuf = 0x1b491500 "Q", wbufsz = 8192, wbufpo = 0, ssl_active
= -1, hp = 0x1b493510 "S", po = 0, bufsz = 1024, len = 0, sbuf = 0x0,
sbufsz = 0, buf2 = 0x2b863ebb0010 "\027DateStyle",
  bufsz2 = 1392509952, buf3 = 0x0, bufsz3 = 0, isbackend = 1, db_node_id =
2, tstate = 84 'T', is_internal_transaction_started = 1 '\001', auth_kind =
5, pwd_size = 0,
  password = '\000' <repeats 1023 times>, salt = "\000\000\000", params =
{num = 0, names = 0x1b493920, values = 0x1b493d30}, no_forward = 0, kind =
0 '\000', protoVersion = 0, raddr = {addr = {
      ss_family = 0, __ss_align = 0, __ss_padding = '\000' <repeats 111
times>}, salen = 0}, auth_method = uaReject, auth_arg = 0x0, database =
0x0, username = 0x0}


-- 
cheers,
junegunn choi.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140429/79200311/attachment.html>