[pgpool-general: 5011] buffer overflow on SHOW pool_nodes and strange SSL log message
Jay Wineinger
jay.wineinger at gmail.com
Thu Sep 22 01:57:44 JST 2016
I'm attempting to use pgpool to load balance across AWS RDS Postgres 9.5
instances. I appear to have that working, since I can see queries going to
both backend 0 and 1 in the pgpool logs.
However, when I try to SHOW pool_nodes, the child handling the current
connection seems to die with a buffer overflow.
Can anyone explain what might be the issue? SHOW pool_nodes worked fine in
a local environment with docker containers, but when I started testing with
RDS (which forces SSL connections, if that matters), I get this error.
Also, I'm wondering if someone can explain the "No such file or directory"
error in the pool_ssl log message. My RDS enforces SSL connections, and I
was able to issue other queries when connected via pgpool, so it follows
that pgpool was able to find the cert and use it to connect to the backends.
thanks!
Jay
postgres=> show pool_nodes;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
postgres=> \q
Then, from my pgpool logs:
2016-09-21 16:15:20: pid 1: LOG: Backend status file
/var/log/postgresql/pgpool_status does not exist
2016-09-21 16:15:20: pid 1: LOG: Setting up socket for 0.0.0.0:5432
2016-09-21 16:15:20: pid 1: LOG: Setting up socket for :::5432
2016-09-21 16:15:20: pid 1: LOG: pgpool-II successfully started. version
3.4.3 (tataraboshi)
2016-09-21 16:15:20: pid 1: LOG: find_primary_node: checking backend no 0
2016-09-21 16:15:20: pid 1: LOG: find_primary_node: primary node id is 0
2016-09-21 16:16:04: pid 46: LOG: new connection received
2016-09-21 16:16:04: pid 46: DETAIL: connecting host=172.17.0.1 port=34477
2016-09-21 16:16:04: pid 46: LOG: pool_ssl: "Loading SSL certificate": "No
such file or directory"
2016-09-21 16:16:04: pid 46: LOG: new connection received
2016-09-21 16:16:04: pid 46: DETAIL: connecting host=172.17.0.1 port=34482
2016-09-21 16:16:04: pid 46: LOG: pool_ssl: "Loading SSL certificate": "No
such file or directory"
*** buffer overflow detected ***: pgpool: dbuser postgres 172.17.0.1(34482)
SHOW terminated
======= Backtrace: =========
/lib/x86_64-linux-gnu/libc.so.6(+0x77725)[0x7f11562ae725]
/lib/x86_64-linux-gnu/libc.so.6(__fortify_fail+0x5c)[0x7f115634f89c]
/lib/x86_64-linux-gnu/libc.so.6(+0x1168a0)[0x7f115634d8a0]
/lib/x86_64-linux-gnu/libc.so.6(+0x115d49)[0x7f115634cd49]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x467221]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x4672b3]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x43493c]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x43995c]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x42cd3a]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x42d4b3]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x427936]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x407f6c]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x40c1c9]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x40673c]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0)[0x7f1156257830]
pgpool: dbuser postgres 172.17.0.1(34482) SHOW[0x406b99]
======= Memory map: ========
00400000-00533000 r-xp 00000000 fc:03 4461907
/usr/sbin/pgpool
00732000-00733000 r--p 00132000 fc:03 4461907
/usr/sbin/pgpool
00733000-00734000 rw-p 00133000 fc:03 4461907
/usr/sbin/pgpool
00734000-00751000 rw-p 00000000 00:00 0
02120000-02197000 rw-p 00000000 00:00 0
[heap]
02197000-021fe000 rw-p 00000000 00:00 0
[heap]
7f1150f62000-7f1150f67000 r-xp 00000000 fc:03 4457383
/lib/x86_64-linux-gnu/libnss_dns-2.23.so
7f1150f67000-7f1151167000 ---p 00005000 fc:03 4457383
/lib/x86_64-linux-gnu/libnss_dns-2.23.so
7f1151167000-7f1151168000 r--p 00005000 fc:03 4457383
/lib/x86_64-linux-gnu/libnss_dns-2.23.so
7f1151168000-7f1151169000 rw-p 00006000 fc:03 4457383
/lib/x86_64-linux-gnu/libnss_dns-2.23.so
7f1151169000-7f1151174000 r-xp 00000000 fc:03 4457385
/lib/x86_64-linux-gnu/libnss_files-2.23.so
7f1151174000-7f1151373000 ---p 0000b000 fc:03 4457385
/lib/x86_64-linux-gnu/libnss_files-2.23.so
7f1151373000-7f1151374000 r--p 0000a000 fc:03 4457385
/lib/x86_64-linux-gnu/libnss_files-2.23.so
7f1151374000-7f1151375000 rw-p 0000b000 fc:03 4457385
/lib/x86_64-linux-gnu/libnss_files-2.23.so
7f1151375000-7f115137b000 rw-p 00000000 00:00 0
7f115137b000-7f1151382000 r-xp 00000000 fc:03 4461766
/usr/lib/x86_64-linux-gnu/libffi.so.6.0.4
7f1151382000-7f1151581000 ---p 00007000 fc:03 4461766
/usr/lib/x86_64-linux-gnu/libffi.so.6.0.4
7f1151581000-7f1151582000 r--p 00006000 fc:03 4461766
/usr/lib/x86_64-linux-gnu/libffi.so.6.0.4
7f1151582000-7f1151583000 rw-p 00007000 fc:03 4461766
/usr/lib/x86_64-linux-gnu/libffi.so.6.0.4
7f1151583000-7f1151652000 r-xp 00000000 fc:03 4461871
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6
7f1151652000-7f1151852000 ---p 000cf000 fc:03 4461871
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6
7f1151852000-7f1151855000 r--p 000cf000 fc:03 4461871
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6
7f1151855000-7f1151857000 rw-p 000d2000 fc:03 4461871
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6
7f1151857000-7f1151858000 rw-p 00000000 00:00 0
7f1151858000-7f115189e000 r-xp 00000000 fc:03 4461791
/usr/lib/x86_64-linux-gnu/libhx509.so.5.0.0
7f115189e000-7f1151a9e000 ---p 00046000 fc:03 4461791
/usr/lib/x86_64-linux-gnu/libhx509.so.5.0.0
7f1151a9e000-7f1151aa0000 r--p 00046000 fc:03 4461791
/usr/lib/x86_64-linux-gnu/libhx509.so.5.0.0
7f1151aa0000-7f1151aa2000 rw-p 00048000 fc:03 4461791
/usr/lib/x86_64-linux-gnu/libhx509.so.5.0.0
7f1151aa2000-7f1151aa3000 rw-p 00000000 00:00 0
7f1151aa3000-7f1151ab1000 r-xp 00000000 fc:03 4461785
/usr/lib/x86_64-linux-gnu/libheimbase.so.1.0.0
7f1151ab1000-7f1151cb0000 ---p 0000e000 fc:03 4461785
/usr/lib/x86_64-linux-gnu/libheimbase.so.1.0.0
7f1151cb0000-7f1151cb1000 r--p 0000d000 fc:03 4461785
/usr/lib/x86_64-linux-gnu/libheimbase.so.1.0.0
7f1151cb1000-7f1151cb2000 rw-p 0000e000 fc:03 4461785
/usr/lib/x86_64-linux-gnu/libheimbase.so.1.0.0
7f1151cb2000-7f1151cd9000 r-xp 00000000 fc:03 4461882
/usr/lib/x86_64-linux-gnu/libwind.so.0.0.0
7f1151cd9000-7f1151ed9000 ---p 00027000 fc:03 4461882
/usr/lib/x86_64-linux-gnu/libwind.so.0.0.0
7f1151ed9000-7f1151eda000 r--p 00027000 fc:03 4461882
/usr/lib/x86_64-linux-gnu/libwind.so.0.0.0
7f1151eda000-7f1151edb000 rw-p 00028000 fc:03 4461882
/usr/lib/x86_64-linux-gnu/libwind.so.0.0.0
7f1151edb000-7f1151f5a000 r-xp 00000000 fc:03 4461773
/usr/lib/x86_64-linux-gnu/libgmp.so.10.3.0
7f1151f5a000-7f1152159000 ---p 0007f000 fc:03 4461773
/usr/lib/x86_64-linux-gnu/libgmp.so.10.3.0
7f1152159000-7f115215a000 r--p 0007e000 fc:03 4461773
/usr/lib/x86_64-linux-gnu/libgmp.so.10.3.0
7f115215a000-7f115215b000 rw-p 0007f000 fc:03 4461773
/usr/lib/x86_64-linux-gnu/libgmp.so.10.3.0
7f115215b000-7f115218d000 r-xp 00000000 fc:03 4461789
/usr/lib/x86_64-linux-gnu/libhogweed.so.4.2
7f115218d000-7f115238c000 ---p 00032000 fc:03 4461789
/usr/lib/x86_64-linux-gnu/libhogweed.so.4.2
7f115238c000-7f115238d000 r--p 00031000 fc:03 4461789
/usr/lib/x86_64-linux-gnu/libhogweed.so.4.2
7f115238d000-7f115238e000 rw-p 00032000 fc:03 4461789
/usr/lib/x86_64-linux-gnu/libhogweed.so.4.2
7f115238e000-7f11523c2000 r-xp 00000000 fc:03 4461835
/usr/lib/x86_64-linux-gnu/libnettle.so.6.2
7f11523c2000-7f11525c1000 ---p 00034000 fc:03 4461835
/usr/lib/x86_64-linux-gnu/libnettle.so.6.2
7f11525c1000-7f11525c3000 r--p 00033000 fc:03 4461835
/usr/lib/x86_64-linux-gnu/libnettle.so.6.2
7f11525c3000-7f11525c4000 rw-p 00035000 fc:03 4461835
/usr/lib/x86_64-linux-gnu/libnettle.so.6.2
7f11525c4000-7f11525d5000 r-xp 00000000 fc:03 4461873
/usr/lib/x86_64-linux-gnu/libtasn1.so.6.5.1
7f11525d5000-7f11527d5000 ---p 00011000 fc:03 4461873
/usr/lib/x86_64-linux-gnu/libtasn1.so.6.5.1
7f11527d5000-7f11527d6000 r--p 00011000 fc:03 4461873
/usr/lib/x86_64-linux-gnu/libtasn1.so.6.5.1
7f11527d6000-7f11527d7000 rw-p 00012000 fc:03 4461873
/usr/lib/x86_64-linux-gnu/libtasn1.so.6.5.1
7f11527d7000-7f1152808000 r-xp 00000000 fc:03 4461793
/usr/lib/x86_64-linux-gnu/libidn.so.11.6.15
7f1152808000-7f1152a08000 ---p 00031000 fc:03 4461793
/usr/lib/x86_64-linux-gnu/libidn.so.11.6.15
7f1152a08000-7f1152a09000 r--p 00031000 fc:03 4461793
/usr/lib/x86_64-linux-gnu/libidn.so.11.6.15
7f1152a09000-7f1152a0a000 rw-p 00032000 fc:03 4461793
/usr/lib/x86_64-linux-gnu/libidn.so.11.6.15
7f1152a0a000-7f1152a63000 r-xp 00000000 fc:03 4461847
/usr/lib/x86_64-linux-gnu/libp11-kit.so.0.1.0
7f1152a63000-7f1152c62000 ---p 00059000 fc:03 4461847
/usr/lib/x86_64-linux-gnu/libp11-kit.so.0.1.0
7f1152c62000-7f1152c6c000 r--p 00058000 fc:03 4461847
/usr/lib/x86_64-linux-gnu/libp11-kit.so.0.1.0
7f1152c6c000-7f1152c6e000 rw-p 00062000 fc:03 4461847
/usr/lib/x86_64-linux-gnu/libp11-kit.so.0.1.0
7f1152c6e000-7f1152c87000 r-xp 00000000 fc:03 4457435
/lib/x86_64-linux-gnu/libz.so.1.2.8
7f1152c87000-7f1152e86000 ---p 00019000 fc:03 4457435
/lib/x86_64-linux-gnu/libz.so.1.2.8
7f1152e86000-7f1152e87000 r--p 00018000 fc:03 4457435
/lib/x86_64-linux-gnu/libz.so.1.2.8
7f1152e87000-7f1152e88000 rw-p 00019000 fc:03 4457435
/lib/x86_64-linux-gnu/libz.so.1.2.8
7f1152e88000-7f1152e9d000 r-xp 00000000 fc:03 4461864
/usr/lib/x86_64-linux-gnu/libroken.so.18.1.0
7f1152e9d000-7f115309c000 ---p 00015000 fc:03 4461864
/usr/lib/x86_64-linux-gnu/libroken.so.18.1.0
7f115309c000-7f115309d000 r--p 00014000 fc:03 4461864
/usr/lib/x86_64-linux-gnu/libroken.so.18.1.0
7f115309d000-7f115309e000 rw-p 00015000 fc:03 4461864
/usr/lib/x86_64-linux-gnu/libroken.so.18.1.0
7f115309e000-7f11530ce000 r-xp 00000000 fc:03 4461783
/usr/lib/x86_64-linux-gnu/libhcrypto.so.4.1.0
7f11530ce000-7f11532ce000 ---p 00030000 fc:03 4461783
/usr/lib/x86_64-linux-gnu/libhcrypto.so.4.1.0
7f11532ce000-7f11532cf000 r--p 00030000 fc:03 4461783
/usr/lib/x86_64-linux-gnu/libhcrypto.so.4.1.0
7f11532cf000-7f11532d0000 rw-p 00031000 fc:03 4461783
/usr/lib/x86_64-linux-gnu/libhcrypto.so.4.1.0
7f11532d0000-7f11532d1000 rw-p 00000000 00:00 0
7f11532d1000-7f1153370000 r-xp 00000000 fc:03 4461740
/usr/lib/x86_64-linux-gnu/libasn1.so.8.0.0
7f1153370000-7f115356f000 ---p 0009f000 fc:03 4461740
/usr/lib/x86_64-linux-gnu/libasn1.so.8.0.0
7f115356f000-7f1153570000 r--p 0009e000 fc:03 4461740
/usr/lib/x86_64-linux-gnu/libasn1.so.8.0.0
7f1153570000-7f1153573000 rw-p 0009f000 fc:03 4461740
/usr/lib/x86_64-linux-gnu/libasn1.so.8.0.0
7f1153573000-7f11535f7000 r-xp 00000000 fc:03 4461802
/usr/lib/x86_64-linux-gnu/libkrb5.so.26.0.0
7f11535f7000-7f11537f6000 ---p 00084000 fc:03 4461802
/usr/lib/x86_64-linux-gnu/libkrb5.so.26.0.0
7f11537f6000-7f11537f9000 r--p 00083000 fc:03 4461802
/usr/lib/x86_64-linux-gnu/libkrb5.so.26.0.0
7f11537f9000-7f11537fc000 rw-p 00086000 fc:03 4461802
/usr/lib/x86_64-linux-gnu/libkrb5.so.26.0.0
7f11537fc000-7f11537fd000 rw-p 00000000 00:00 0
7f11537fd000-7f1153805000 r-xp 00000000 fc:03 4461787
/usr/lib/x86_64-linux-gnu/libheimntlm.so.0.1.0
7f1153805000-7f1153a04000 ---p 00008000 fc:03 4461787
/usr/lib/x86_64-linux-gnu/libheimntlm.so.0.1.0
7f1153a04000-7f1153a05000 r--p 00007000 fc:03 4461787
/usr/lib/x86_64-linux-gnu/libheimntlm.so.0.1.0
7f1153a05000-7f1153a06000 rw-p 00008000 fc:03 4461787
/usr/lib/x86_64-linux-gnu/libheimntlm.so.0.1.0
7f1153a06000-7f1153a09000 r-xp 00000000 fc:03 4460615
/lib/x86_64-linux-gnu/libkeyutils.so.1.5
7f1153a09000-7f1153c08000 ---p 00003000 fc:03 4460615
/lib/x86_64-linux-gnu/libkeyutils.so.1.5
7f1153c08000-7f1153c09000 r--p 00002000 fc:03 4460615
/lib/x86_64-linux-gnu/libkeyutils.so.1.5
7f1153c09000-7f1153c0a000 rw-p 00003000 fc:03 4460615
/lib/x86_64-linux-gnu/libkeyutils.so.1.5
7f1153c0a000-7f1153d2d000 r-xp 00000000 fc:03 4461775
/usr/lib/x86_64-linux-gnu/libgnutls.so.30.6.2
7f1153d2d000-7f1153f2c000 ---p 00123000 fc:03 4461775
/usr/lib/x86_64-linux-gnu/libgnutls.so.30.6.2
7f1153f2c000-7f1153f37000 r--p 00122000 fc:03 4461775
/usr/lib/x86_64-linux-gnu/libgnutls.so.30.6.2
7f1153f37000-7f1153f39000 rw-p 0012d000 fc:03 4461775
/usr/lib/x86_64-linux-gnu/libgnutls.so.30.6.2
7f1153f39000-7f1153f3a000 rw-p 00000000 00:00 0
7f1153f3a000-7f1153f77000 r-xp 00000000 fc:03 4461779
/usr/lib/x86_64-linux-gnu/libgssapi.so.3.0.0
7f1153f77000-7f1154177000 ---p 0003d000 fc:03 4461779
/usr/lib/x86_64-linux-gnu/libgssapi.so.3.0.0
7f1154177000-7f1154178000 r--p 0003d000 fc:03 4461779
/usr/lib/x86_64-linux-gnu/libgssapi.so.3.0.0
7f1154178000-7f115417a000 rw-p 0003e000 fc:03 4461779
/usr/lib/x86_64-linux-gnu/libgssapi.so.3.0.0
7f115417a000-7f115417b000 rw-p 00000000 00:00 0
7f115417b000-7f1154192000 r-xp 00000000 fc:03 4457408
/lib/x86_64-linux-gnu/libresolv-2.23.so
7f1154192000-7f1154392000 ---p 00017000 fc:03 4457408
/lib/x86_64-linux-gnu/libresolv-2.23.so
7f1154392000-7f1154393000 r--p 00017000 fc:03 4457408
/lib/x86_64-linux-gnu/libresolv-2.23.so
7f1154393000-7f1154394000 rw-p 00018000 fc:03 4457408
/lib/x86_64-linux-gnu/libresolv-2.23.so
7f1154394000-7f1154396000 rw-p 00000000 00:00 0
7f1154396000-7f11543a3000 r-xp 00000000 fc:03 4461808
/usr/lib/x86_64-linux-gnu/liblber-2.4.so.2.10.5
7f11543a3000-7f11545a3000 ---p 0000d000 fc:03 4461808
/usr/lib/x86_64-linux-gnu/liblber-2.4.so.2.10.5
7f11545a3000-7f11545a4000 r--p 0000d000 fc:03 4461808
/usr/lib/x86_64-linux-gnu/liblber-2.4.so.2.10.5
7f11545a4000-7f11545a5000 rw-p 0000e000 fc:03 4461808
/usr/lib/x86_64-linux-gnu/liblber-2.4.so.2.10.5
7f11545a5000-7f11545af000 r-xp 00000000 fc:03 4461806
/usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
7f11545af000-7f11547ae000 ---p 0000a000 fc:03 4461806
/usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
7f11547ae000-7f11547af000 r--p 00009000 fc:03 4461806
/usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
7f11547af000-7f11547b0000 rw-p 0000a000 fc:03 4461806
/usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
7f11547b0000-7f11547b3000 r-xp 00000000 fc:03 4457343
/lib/x86_64-linux-gnu/libcom_err.so.2.1
7f11547b3000-7f11549b2000 ---p 00003000 fc:03 4457343
/lib/x86_64-linux-gnu/libcom_err.so.2.1
7f11549b2000-7f11549b3000 r--p 00002000 fc:03 4457343
/lib/x86_64-linux-gnu/libcom_err.so.2.1
7f11549b3000-7f11549b4000 rw-p 00003000 fc:03 4457343
/lib/x86_64-linux-gnu/libcom_err.so.2.1
7f11549b4000-7f11549e0000 r-xp 00000000 fc:03 4461800
/usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
7f11549e0000-7f1154bdf000 ---p 0002c000 fc:03 4461800
/usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
7f1154bdf000-7f1154be1000 r--p 0002b000 fc:03 4461800
/usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
7f1154be1000-7f1154be2000 rw-p 0002d000 fc:03 4461800
/usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
7f1154be2000-7f1154be3000 rw-p 00000000 00:00 0
7f1154be3000-7f1154ca6000 r-xp 00000000 fc:03 4461804
/usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
7f1154ca6000-7f1154ea6000 ---p 000c3000 fc:03 4461804
/usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
7f1154ea6000-7f1154eb3000 r--p 000c3000 fc:03 4461804
/usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
7f1154eb3000-7f1154eb5000 rw-p 000d0000 fc:03 4461804
/usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
7f1154eb5000-7f1154eb8000 r-xp 00000000 fc:03 4457349
/lib/x86_64-linux-gnu/libdl-2.23.so
7f1154eb8000-7f11550b7000 ---p 00003000 fc:03 4457349
/lib/x86_64-linux-gnu/libdl-2.23.so
7f11550b7000-7f11550b8000 r--p 00002000 fc:03 4457349
/lib/x86_64-linux-gnu/libdl-2.23.so
7f11550b8000-7f11550b9000 rw-p 00003000 fc:03 4457349
/lib/x86_64-linux-gnu/libdl-2.23.so
7f11550b9000-7f11550d5000 r-xp 00000000 fc:03 4457330
/lib/x86_64-linux-gnu/libaudit.so.1.0.0
7f11550d5000-7f11552d4000 ---p 0001c000 fc:03 4457330
/lib/x86_64-linux-gnu/libaudit.so.1.0.0
7f11552d4000-7f11552d5000 r--p 0001b000 fc:03 4457330
/lib/x86_64-linux-gnu/libaudit.so.1.0.0
7f11552d5000-7f11552d6000 rw-p 0001c000 fc:03 4457330
/lib/x86_64-linux-gnu/libaudit.so.1.0.0
7f11552d6000-7f11552e0000 rw-p 00000000 00:00 0
7f11552e0000-7f11552f6000 r-xp 00000000 fc:03 4457357
/lib/x86_64-linux-gnu/libgcc_s.so.1
7f11552f6000-7f11554f5000 ---p 00016000 fc:03 4457357
/lib/x86_64-linux-gnu/libgcc_s.so.1
7f11554f5000-7f11554f6000 rw-p 00015000 fc:03 4457357
/lib/x86_64-linux-gnu/libgcc_s.so.1
7f11554f6000-7f11555fe000 r-xp 00000000 fc:03 4457368
/lib/x86_64-linux-gnu/libm-2.23.so
7f11555fe000-7f11557fd000 ---p 00108000 fc:03 4457368
/lib/x86_64-linux-gnu/libm-2.23.so
7f11557fd000-7f11557fe000 r--p 00107000 fc:03 4457368
/lib/x86_64-linux-gnu/libm-2.23.so
7f11557fe000-7f11557ff000 rw-p 00108000 fc:03 4457368
/lib/x86_64-linux-gnu/libm-2.23.so
7f11557ff000-7f1155971000 r-xp 00000000 fc:03 4458222
/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.21
7f1155971000-7f1155b71000 ---p 00172000 fc:03 4458222
/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.21
7f1155b71000-7f1155b7b000 r--p 00172000 fc:03 4458222
/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.21
7f1155b7b000-7f1155b7d000 rw-p 0017c000 fc:03 4458222
/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.21
7f1155b7d000-7f1155b81000 rw-p 00000000 00:00 0
7f1155b81000-7f1155b9a000 r-xp 00000000 fc:03 4461869
/usr/lib/x86_64-linux-gnu/libsasl2.so.2.0.25
7f1155b9a000-7f1155d9a000 ---p 00019000 fc:03 4461869
/usr/lib/x86_64-linux-gnu/libsasl2.so.2.0.25
7f1155d9a000-7f1155d9b000 r--p 00019000 fc:03 4461869
/usr/lib/x86_64-linux-gnu/libsasl2.so.2.0.25
7f1155d9b000-7f1155d9c000 rw-p 0001a000 fc:03 4461869
/usr/lib/x86_64-linux-gnu/libsasl2.so.2.0.25
7f1155d9c000-7f1155de9000 r-xp 00000000 fc:03 4461811
/usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2.10.5
7f1155de9000-7f1155fe8000 ---p 0004d000 fc:03 4461811
/usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2.10.5
7f1155fe8000-7f1155fea000 r--p 0004c000 fc:03 4461811
/usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2.10.5
7f1155fea000-7f1155feb000 rw-p 0004e000 fc:03 4461811
/usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2.10.5
7f1155feb000-7f1155fed000 rw-p 00000000 00:00 0
7f1155fed000-7f1156034000 r-xp 00000000 fc:03 4461781
/usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
7f1156034000-7f1156233000 ---p 00047000 fc:03 4461781
/usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
7f1156233000-7f1156235000 r--p 00046000 fc:03 4461781
/usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
7f1156235000-7f1156237000 rw-p 00048000 fc:03 4461781
/usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
7f1156237000-7f11563f7000 r-xp 00000000 fc:03 4457336
/lib/x86_64-linux-gnu/libc-2.23.so
7f11563f7000-7f11565f6000 ---p 001c0000 fc:03 4457336
/lib/x86_64-linux-gnu/libc-2.23.so
7f11565f6000-7f11565fa000 r--p 001bf000 fc:03 4457336
/lib/x86_64-linux-gnu/libc-2.23.so
7f11565fa000-7f11565fc000 rw-p 001c3000 fc:03 4457336
/lib/x86_64-linux-gnu/libc-2.23.so
7f11565fc000-7f1156600000 rw-p 00000000 00:00 0
7f1156600000-7f1156609000 r-xp 00000000 fc:03 4457344
/lib/x86_64-linux-gnu/libcrypt-2.23.so
7f1156609000-7f1156808000 ---p 00009000 fc:03 4457344
/lib/x86_64-linux-gnu/libcrypt-2.23.so
7f1156808000-7f1156809000 r--p 00008000 fc:03 4457344
/lib/x86_64-linux-gnu/libcrypt-2.23.so
7f1156809000-7f115680a000 rw-p 00009000 fc:03 4457344
/lib/x86_64-linux-gnu/libcrypt-2.23.so
7f115680a000-7f1156838000 rw-p 00000000 00:00 0
7f1156838000-7f1156a67000 r-xp 00000000 fc:03 4460607
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
7f1156a67000-7f1156c66000 ---p 0022f000 fc:03 4460607
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
7f1156c66000-7f1156c82000 r--p 0022e000 fc:03 4460607
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
7f1156c82000-7f1156c8f000 rw-p 0024a000 fc:03 4460607
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
7f1156c8f000-7f1156c93000 rw-p 00000000 00:00 0
7f1156c93000-7f1156cf2000 r-xp 00000000 fc:03 4460620
/lib/x86_64-linux-gnu/libssl.so.1.0.0
7f1156cf2000-7f1156ef1000 ---p 0005f000 fc:03 4460620
/lib/x86_64-linux-gnu/libssl.so.1.0.0
7f1156ef1000-7f1156ef5000 r--p 0005e000 fc:03 4460620
/lib/x86_64-linux-gnu/libssl.so.1.0.0
7f1156ef5000-7f1156efc000 rw-p 00062000 fc:03 4460620
/lib/x86_64-linux-gnu/libssl.so.1.0.0
7f1156efc000-7f1156f09000 r-xp 00000000 fc:03 4457394
/lib/x86_64-linux-gnu/libpam.so.0.83.1
7f1156f09000-7f1157108000 ---p 0000d000 fc:03 4457394
/lib/x86_64-linux-gnu/libpam.so.0.83.1
7f1157108000-7f1157109000 r--p 0000c000 fc:03 4457394
/lib/x86_64-linux-gnu/libpam.so.0.83.1
7f1157109000-7f115710a000 rw-p 0000d000 fc:03 4457394
/lib/x86_64-linux-gnu/libpam.so.0.83.1
7f115710a000-7f115713a000 r-xp 00000000 fc:03 4461820
/usr/lib/x86_64-linux-gnu/libmemcached.so.11.0.0
7f115713a000-7f1157339000 ---p 00030000 fc:03 4461820
/usr/lib/x86_64-linux-gnu/libmemcached.so.11.0.0
7f1157339000-7f115733a000 r--p 0002f000 fc:03 4461820
/usr/lib/x86_64-linux-gnu/libmemcached.so.11.0.0
7f115733a000-7f115733b000 rw-p 00030000 fc:03 4461820
/usr/lib/x86_64-linux-gnu/libmemcached.so.11.0.0
7f115733b000-7f1157353000 r-xp 00000000 fc:03 4457404
/lib/x86_64-linux-gnu/libpthread-2.23.so
7f1157353000-7f1157552000 ---p 00018000 fc:03 4457404
/lib/x86_64-linux-gnu/libpthread-2.23.so
7f1157552000-7f1157553000 r--p 00017000 fc:03 4457404
/lib/x86_64-linux-gnu/libpthread-2.23.so
7f1157553000-7f1157554000 rw-p 00018000 fc:03 4457404
/lib/x86_64-linux-gnu/libpthread-2.23.so
7f1157554000-7f1157558000 rw-p 00000000 00:00 0
7f1157558000-7f1157584000 r-xp 00000000 fc:03 4461851
/usr/lib/x86_64-linux-gnu/libpq.so.5.8
7f1157584000-7f1157784000 ---p 0002c000 fc:03 4461851
/usr/lib/x86_64-linux-gnu/libpq.so.5.8
7f1157784000-7f1157787000 r--p 0002c000 fc:03 4461851
/usr/lib/x86_64-linux-gnu/libpq.so.5.8
7f1157787000-7f1157788000 rw-p 0002f000 fc:03 4461851
/usr/lib/x86_64-linux-gnu/libpq.so.5.8
7f1157788000-7f11577ae000 r-xp 00000000 fc:03 4457316
/lib/x86_64-linux-gnu/ld-2.23.so
7f11577da000-7f11577db000 rw-p 00000000 00:00 0
7f11577db000-7f1157984000 rw-s 00000000 00:04 32769
/SYSV00000000 (deleted)
7f1157984000-7f1157992000 rw-s 00000000 00:04 0
/SYSV00000000 (deleted)
7f1157992000-7f11579a7000 rw-p 00000000 00:00 0
7f11579a7000-7f11579a8000 rw-s 00000000 00:04 131076
/SYSV00000000 (deleted)
7f11579a8000-7f11579aa000 rw-s 00000000 00:04 98307
/SYSV00000000 (deleted)
7f11579aa000-7f11579ab000 rw-s 00000000 00:04 65538
/SYSV00000000 (deleted)
7f11579ab000-7f11579ad000 rw-p 00000000 00:00 0
7f11579ad000-7f11579ae000 r--p 00025000 fc:03 4457316
/lib/x86_64-linux-gnu/ld-2.23.so
7f11579ae000-7f11579af000 rw-p 00026000 fc:03 4457316
/lib/x86_64-linux-gnu/ld-2.23.so
7f11579af000-7f11579b0000 rw-p 00000000 00:00 0
7ffd0a96f000-7ffd0a990000 rw-p 00000000 00:00 0
[stack]
7ffd0a9b8000-7ffd0a9ba000 r-xp 00000000 00:00 0
[vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0
[vsyscall]
2016-09-21 16:16:11: pid 1: LOG: child process with pid: 46 exits with
status 134 by signal 6
2016-09-21 16:16:11: pid 1: LOG: fork a new child process with pid: 49
2016-09-21 16:16:11: pid 45: LOG: new connection received
2016-09-21 16:16:11: pid 45: DETAIL: connecting host=172.17.0.1 port=34492
2016-09-21 16:16:12: pid 45: LOG: DB node id: 0 backend pid: 27794
statement: DISCARD ALL
2016-09-21 16:16:12: pid 45: LOG: DB node id: 1 backend pid: 25181
statement: DISCARD ALL
And finally, from the RDS postgres master's logs:
2016-09-21 16:16:04 UTC:10.66.20.158(59988):dbuser at postgres:[27786]:LOG:
could not receive data from client: Connection reset by peer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160921/b3d56ad4/attachment-0001.html>
More information about the pgpool-general
mailing list