<div dir="ltr">Hi,<div>pstack from the first "stuck" query of a few setups, hoping this is helpful:</div><div><br></div><div><u>setup #1:</u></div><div><p class="MsoNormal"><b><span style="color:rgb(31,73,125)">postgres<span></span></span></b></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
3083<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007f18d04b9308 in poll () from
/lib64/libc.so.6<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x0000000000650547 in WaitLatchOrSocket ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x00000000005e5f80 in secure_read ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x00000000005ef9db in ?? ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x00000000005efdeb in pq_getbyte ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x00000000006bb2d5 in PostgresMain ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x0000000000662455 in PostmasterMain ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#7 0x00000000005f3fb8 in main ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><b><span style="color:rgb(31,73,125)">pgpool<span></span></span></b></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
30372<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007f12d623a5c3 in __select_nocancel ()
from /lib64/libc.so.6<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x000000000042a7ce in
read_packets_and_process ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x000000000042cf56 in pool_process_query ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x0000000000424200 in do_child ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x0000000000406fcd in fork_a_child ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x00000000004077c3 in reaper ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x0000000000409da5 in pool_sleep ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#7 0x000000000040c14f in PgpoolMain ()<span></span></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">#8 0x000000000040597f in main ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><br></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><br></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><u>setup #2:</u></span></p><p class="MsoNormal"><b><span style="color:rgb(31,73,125)">postgres<span></span></span></b></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
10143<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">Thread
2 (Thread 0x7f062cdcf700 (LWP 30283)):<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007f0629c9f930 in sem_wait () from
/lib64/libpthread.so.0<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x00007f05ad61643d in
v8::internal::LinuxSemaphore::Wait() () from /usr/lib64/libv8.so.3<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x00007f05ad62e020 in
v8::internal::RuntimeProfiler::WaitForSomeIsolateToEnterJS() () from
/usr/lib64/libv8.so.3<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x00007f05ad617546 in v8::internal::SignalSender::Run()
() from /usr/lib64/libv8.so.3<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x00007f05ad616890 in ?? () from
/usr/lib64/libv8.so.3<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x00007f0629c999d1 in start_thread () from
/lib64/libpthread.so.0<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x00007f062b33eb6d in clone () from
/lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">Thread
1 (Thread 0x7f062ceba7c0 (LWP 10143)):<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007f062b335343 in poll () from
/lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x0000000000650547 in WaitLatchOrSocket ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x00000000005e5f80 in secure_read ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x00000000005ef9db in ?? ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x00000000005efdeb in pq_getbyte ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x00000000006bb2d5 in PostgresMain ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x0000000000662455 in PostmasterMain ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#7 0x00000000005f3fb8 in main ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span></p><p class="MsoNormal"><b><span style="color:rgb(31,73,125)">pgpool<span></span></span></b></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
32569<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007f31be38a5c3 in __select_nocancel ()
from /lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x0000000000427432 in pool_check_fd ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x0000000000453c4d in pool_read ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x000000000042863a in do_query ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x0000000000446070 in pool_search_relcache ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x0000000000443ef3 in system_catalog_walker
()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x000000000044059a in
raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#7 0x00000000004408a8 in
raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#8 0x0000000000442aa1 in pool_has_system_catalog
()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#9 0x000000000043f0b8 in pool_where_to_send ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#10
0x00000000004325af in Parse ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#11
0x0000000000434891 in ProcessFrontendResponse ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#12
0x000000000042d047 in pool_process_query ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#13
0x0000000000424200 in do_child ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#14
0x0000000000406fcd in fork_a_child ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#15
0x00000000004077c3 in reaper ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#16
0x0000000000409da5 in pool_sleep ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#17
0x000000000040c14f in PgpoolMain ()<span></span></span></p><p class="MsoNormal">
</p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#18
0x000000000040597f in main ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><br></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><u>setup #3</u></span></p><p class="MsoNormal"><b><span style="color:rgb(31,73,125)">postgres<span></span></span></b></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
5506<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007ff783961308 in poll () from
/lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x0000000000650547 in WaitLatchOrSocket ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x00000000005e5f80 in secure_read ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x00000000005ef9db in ?? ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x00000000005efdeb in pq_getbyte ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x00000000006bb2d5 in PostgresMain ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x0000000000662455 in PostmasterMain ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#7 0x00000000005f3fb8 in main ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span></p><p class="MsoNormal"><b><span style="color:rgb(31,73,125)">pgpool<span></span></span></b></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
25347<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007fa6b0ee05c3 in __select_nocancel ()
from /lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x000000000042a7ce in
read_packets_and_process ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x000000000042cf56 in pool_process_query ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x0000000000424200 in do_child ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x0000000000406fcd in fork_a_child ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x00000000004077c3 in reaper ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x0000000000409da5 in pool_sleep ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#7 0x000000000040c14f in PgpoolMain ()<span></span></span></p><p class="MsoNormal">
</p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#8 0x000000000040597f in main ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><br></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><u>setup #4</u></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><b>postgres<span></span></b></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
1754<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">Thread
2 (Thread 0x7f7c04932700 (LWP 1808)):<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007f7c0177a930 in sem_wait () from
/lib64/libpthread.so.0<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x00007f7b6463143d in
v8::internal::LinuxSemaphore::Wait() () from /usr/lib64/libv8.so.3<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x00007f7b64649020 in
v8::internal::RuntimeProfiler::WaitForSomeIsolateToEnterJS() () from
/usr/lib64/libv8.so.3<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x00007f7b64632546 in
v8::internal::SignalSender::Run() () from /usr/lib64/libv8.so.3<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x00007f7b64631890 in ?? () from
/usr/lib64/libv8.so.3<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x00007f7c017749d1 in start_thread () from
/lib64/libpthread.so.0<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x00007f7c02e19b6d in clone () from
/lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">Thread
1 (Thread 0x7f7c049957c0 (LWP 1754)):<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007f7c02e10343 in poll () from
/lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x0000000000650547 in WaitLatchOrSocket ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x00000000005e5f80 in secure_read ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x00000000005ef9db in ?? ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x00000000005efdeb in pq_getbyte ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x00000000006bb2d5 in PostgresMain ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x0000000000662455 in PostmasterMain ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#7 0x00000000005f3fb8 in main ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><b>pgpool</b><span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
19895<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007f2a75fc75c3 in __select_nocancel ()
from /lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x0000000000427432 in pool_check_fd ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x0000000000453c4d in pool_read ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x000000000042863a in do_query ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x0000000000446070 in pool_search_relcache ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x0000000000442d4e in temp_table_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x0000000000440793 in
raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#7 0x0000000000440782 in
raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#8 0x0000000000440782 in
raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#9 0x0000000000440782 in
raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#10
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#11
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#12
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#13
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#14
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#15
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#16
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#17
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#18
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#19
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#20
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#21
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#22
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#23
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#24
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#25
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#26
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#27
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#28
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#29
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#30
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#31
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#32
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#33
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#34
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#35
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#36
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#37
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#38
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#39
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#40
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#41
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#42
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#43
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#44
0x0000000000440782 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#45
0x000000000044059a in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#46
0x00000000004408a8 in raw_expression_tree_walker ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#47
0x0000000000442a62 in pool_has_temp_table ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#48
0x000000000043f4e3 in pool_where_to_send ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#49
0x00000000004325af in Parse ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#50
0x0000000000434891 in ProcessFrontendResponse ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#51
0x000000000042d047 in pool_process_query ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#52
0x0000000000424200 in do_child ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#53
0x0000000000406fcd in fork_a_child ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#54
0x00000000004077c3 in reaper ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#55
0x0000000000409da5 in pool_sleep ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#56
0x000000000040c14f in PgpoolMain ()<span></span></span></p><p class="MsoNormal">
</p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#57
0x000000000040597f in main ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><br></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><u>setup #5:</u></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><b>postgres<span></span></b></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
8751<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007ff6807e2308 in poll () from
/lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x0000000000650547 in WaitLatchOrSocket ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x00000000005e5f80 in secure_read ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x00000000005ef9db in ?? ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x00000000005efdeb in pq_getbyte ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x00000000006bb2d5 in PostgresMain ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x0000000000662455 in PostmasterMain ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#7 0x00000000005f3fb8 in main ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><b>pgpool<span></span></b></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">pstack
10002<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#0 0x00007f2317c375c3 in __select_nocancel ()
from /lib64/libc.so.6<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#1 0x000000000042a7ce in
read_packets_and_process ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#2 0x000000000042cf56 in pool_process_query ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#3 0x0000000000424200 in do_child ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#4 0x0000000000406fcd in fork_a_child ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#5 0x000000000040baa7 in PgpoolMain ()<span></span></span></p><p class="MsoNormal">
</p><p class="MsoNormal"><span style="color:rgb(31,73,125)">#6 0x000000000040597f in main ()<span></span></span></p><p class="MsoNormal"><span style="color:rgb(31,73,125)"><br></span></p></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 31, 2017 at 9:42 AM, Rolan Yadlin <span dir="ltr"><<a href="mailto:rolan3@gmail.com" target="_blank">rolan3@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi,<div>in many setups in our labs we have "stuck" connections:</div><div>some fit the FAQ, but they seem to remain in "active" state forever (until we restart pgpool):</div><div>this is reproducing all the time but the scenario is unknown.</div><div><br></div><div>examples the output was copied today a few minutes ago from a few setups:</div><div><u>setup 1:</u></div><div>node #1:</div><div><div> psql -Upostgres -h172.18.255.41 -p5432 -c "SELECT pid,state,query_start,query,<wbr>waiting FROM pg_catalog.pg_stat_activity WHERE state !='idle' AND query_start < current_timestamp - interval '30 minutes' ORDER BY query_start;"</div><div> pid | state | query_start | query | waiting</div><div>------+--------+--------------<wbr>-----------------+------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>-------------------------+----<wbr>-----</div><div> 3083 | active | 2017-01-29 15:16:16.907158+00 | SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = to_regclass('"pg_description"'<wbr>) AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog' | f</div><div> 6526 | active | 2017-01-29 15:17:28.657637+00 | SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = to_regclass('"pg_description"'<wbr>) AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog' | f</div><div> 6527 | active | 2017-01-29 15:17:28.657663+00 | SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = to_regclass('"pg_description"'<wbr>) AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog' | f</div><div>(3 rows)</div></div><div><br></div><div><u>node #2:</u></div><div><div> psql -Upostgres -h172.18.255.42 -p5432 -c "SELECT pid,state,query_start,query,<wbr>waiting FROM pg_catalog.pg_stat_activity WHERE state !='idle' AND query_start < current_timestamp - interval '30 minutes' ORDER BY query_start;"</div><div> pid | state | query_start | query | waiting</div><div>-------+---------------------+<wbr>------------------------------<wbr>-+----------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>---</div><div> 26340 | idle in transaction | 2017-01-29 21:56:29.025673+00 | select count(*) as cnt from (select this_.id as id1_4_0_, this_.version as version2_4_0_, this_.update_date as update_d3_4_0_, this_.trigger_date as trigger_4_4_0_, this_.occurrence_date as occurren5_4_0_, this_.state_user_id as state_us6_4</div><div>_0_, this_.action_user_id as action_u7_4_0_, this_.resource_id as resource8_4_0_, this_.parameter01 a</div><div>s paramete9_4_0_, this_.parameter02 as paramet10_4_0_, this_.parameter03 as paramet11_4_0_, this_.par</div><div>ameter04 as paramet12_4_0_, this_.parameter05 as paramet13_4_0_, this_.note as note14_4_0_, this_.ala</div><div>rm_definition_id as alarm_d15_4_0_, this_.severity as severit16_4_0_, this_.domain_id as domain_17_4_</div><div>0_, this_.state as state18_4_0_, this_.invoking_controller as invokin19_4_0_, this_.invoking_element</div><div>as invokin20_4_0_, this_.sub_module_id as sub_mod21_4_0_, this_.sub_instance_id as sub_ins22_4_0_, th</div><div>is_.resource_element_id as resourc23_4_0_, this_.resource_parent_element_<wbr>id as resourc24_4_0_ from al</div><div>arms this_ where this_.resource_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $ | f (1 row)</div><div style="text-decoration:underline"><br></div></div><div><br></div><div><u>setup 2 (currently has only 1 postgres/pgpool node):</u></div><div><div>psql -Upostgres -h172.18.255.41 -p5432 -c "SELECT pid,state,query_start,query,<wbr>waiting FROM pg_catalog.pg_stat_activity WHERE state !='idle' AND query_start < current_timestamp - interval '30 minutes' ORDER BY query_start;"</div><div> pid | state | query_start | query | waiting</div><div>-------+---------------------+<wbr>------------------------------<wbr>-+----------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>-----------+---------</div><div> 10143 | idle in transaction | 2017-01-26 13:34:48.460062+00 | select submodule0_.id as id1_22_0_, submodule0_.name as name2_22_0_ from events_sub_modules submodule0_ where submodule0_.id=$1 | f</div><div> 10134 | idle in transaction | 2017-01-26 14:15:46.345789+00 | select submodule0_.id as id1_22_0_, submodule0_.name as name2_22_0_ from events_sub_modules submodule0_ where submodule0_.id=$1 | f</div><div>(2 rows)</div></div><div><br></div><div><br></div><div><u>setup 3:</u></div><div>node1:</div><div><div>psql -Upostgres -h172.18.255.41 -p5432 -c "SELECT pid,state,query_start,query,<wbr>waiting FROM pg_catalog.pg_stat_activity WHERE state != 'idle' AND query_start < current_timestamp - interval '30 minutes' ORDER BY query_start;"</div><div> pid | state | query_start | query | waiting</div><div>------+--------+--------------<wbr>-----------------+------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>-------------------------+----<wbr>-----</div><div> 5506 | active | 2017-01-31 00:04:39.128256+00 | SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = to_regclass('"pg_description"'<wbr>) AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog' | f</div><div> 5466 | active | 2017-01-31 00:04:39.12857+00 | SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = to_regclass('"pg_description"'<wbr>) AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog' | f</div><div> 5465 | active | 2017-01-31 00:04:39.129839+00 | SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = to_regclass('"pg_description"'<wbr>) AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog' | f</div><div>(3 rows)</div></div><div><br></div><div>unfortunately, there are more examples, some with more than 10 stuck connections, sometimes it gets autovacuum "stuck" in active state,</div><div>we also had instances in which stuck connections were doing updates and caused many transaction waiting for them to end and release locks, but we haven't encountered this in a dew days.</div><div><br></div><div>if you need us to provide more information, just let us know.</div><div><div>Please help us :-)</div><div><br></div></div><div>we are using:</div><div>Postgres 9.5.5</div><div>PG-Pool 3.6.1</div><div>Hibernate/JDBC</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>Rolan.<br></div><div><br></div><div><br></div></font></span></div>
</blockquote></div><br></div>