<div dir="ltr">Hello Steven,<div><br></div><div>Did you try enabling debugging mode (e.g. by running pgpool -n -d 1>logfile.log 2>&1 &) and adjusting the logging level in pgpool.conf? That should provide more information about why the process is dying.</div><div><br></div><div>Regards,</div><div>Vlad</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Sep 2, 2016 at 1:54 AM, Steven Livingstone <span dir="ltr"><<a href="mailto:steven@livz.org" target="_blank">steven@livz.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi. I have a scenario where i have a connection pooling client<br>
(PGBouncer) making requests to PGPool and the child processes spun up<br>
by PGPool create segmentation faults, increasing in number over time<br>
until the client just gets errors.<br>
<br>
I am new to PGPool debugging and gdb in general, so any help much<br>
appreciated! I have turned off just about every advanced option in<br>
PGPool.conf over the last week but still can't get to the bottom of<br>
this.<br>
<br>
I did managed to create a backtrace of *something* by attaching to one<br>
of the child processes but in attaching to it, it doesn't die any more<br>
:-S As soon as i detach, it dies and there is a segfault as shown<br>
below (this is a small section ... i just get this constantly over<br>
time). .... i suspect i am missing something in how to trace properly.<br>
<br>
Sep 2 08:51:10 data-ha-node-0 pgpool[12573]: [7332-1] 2016-09-02<br>
08:51:10: pid 12573: WARNING: child process with pid: 31577 was<br>
terminated by segmentation fault<br>
Sep 2 08:51:10 data-ha-node-0 pgpool[12573]: [7333-1] 2016-09-02<br>
08:51:10: pid 12573: LOG: fork a new child process with pid: 31595<br>
Sep 2 08:51:10 data-ha-node-0 pgpool[31589]: [7331-1] 2016-09-02<br>
08:51:10: pid 31589: LOG: new connection received<br>
Sep 2 08:51:10 data-ha-node-0 pgpool[31589]: [7331-2] 2016-09-02<br>
08:51:10: pid 31589: DETAIL: connecting host=10.0.1.8 port=53526<br>
Sep 2 08:51:11 data-ha-node-0 kernel: [69483.710126] pgpool[31589]:<br>
segfault at ac ip 00000000004354a5 sp 00007fffffff91d0 error 4 in<br>
pgpool[400000+132000]<br>
Sep 2 08:51:11 data-ha-node-0 pgpool[12573]: [7334-1] 2016-09-02<br>
08:51:11: pid 12573: WARNING: child process with pid: 31589 was<br>
terminated by segmentation fault<br>
Sep 2 08:51:11 data-ha-node-0 pgpool[12573]: [7335-1] 2016-09-02<br>
08:51:11: pid 12573: LOG: fork a new child process with pid: 31601<br>
Sep 2 08:51:11 data-ha-node-0 pgpool[31595]: [7333-1] 2016-09-02<br>
08:51:11: pid 31595: LOG: new connection received<br>
Sep 2 08:51:11 data-ha-node-0 pgpool[31595]: [7333-2] 2016-09-02<br>
08:51:11: pid 31595: DETAIL: connecting host=10.0.1.8 port=53528<br>
Sep 2 08:51:11 data-ha-node-0 kernel: [69484.288433] pgpool[31595]:<br>
segfault at ac ip 00000000004354a5 sp 00007fffffff91d0 error 4 in<br>
pgpool[400000+132000]<br>
Sep 2 08:51:12 data-ha-node-0 pgpool[12573]: [7336-1] 2016-09-02<br>
08:51:12: pid 12573: WARNING: child process with pid: 31595 was<br>
terminated by segmentation fault<br>
Sep 2 08:51:12 data-ha-node-0 pgpool[12573]: [7337-1] 2016-09-02<br>
08:51:12: pid 12573: LOG: fork a new child process with pid: 31605<br>
Sep 2 08:51:12 data-ha-node-0 pgpool[31586]: [7329-1] 2016-09-02<br>
08:51:12: pid 31586: LOG: new connection received<br>
<br>
<br>
<br>
<br>
<br>
(gdb) bt<br>
#0 0x00007ffff717ac33 in select () from /lib/x86_64-linux-gnu/libc.so.<wbr>6<br>
#1 0x0000000000426529 in wait_for_new_connections<br>
(saddr=0x7fffffff95c0, timeout=0x7fffffff9440, fds=0x7686c0) at<br>
protocol/child.c:1854<br>
#2 do_child (fds=fds@entry=0x7686c0) at protocol/child.c:295<br>
#3 0x00000000004076f5 in fork_a_child (fds=0x7686c0, id=1) at<br>
main/pgpool_main.c:678<br>
#4 0x00000000004080cc in reaper () at main/pgpool_main.c:2263<br>
#5 0x000000000040c2a9 in PgpoolMain<br>
(discard_status=discard_<wbr>status@entry=0 '\000',<br>
clear_memcache_oidmaps=clear_<wbr>memcache_oidmaps@entry=0 '\000') at<br>
main/pgpool_main.c:429<br>
#6 0x0000000000405f13 in main (argc=<optimized out>, argv=<optimized<br>
out>) at main/main.c:310<br>
<br>
Any ideas?<br>
<br>
/steven<br>
______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
</blockquote></div><br></div>