[pgpool-general: 5014] Re: buffer overflow on SHOW pool_nodes and strange SSL log message
Tatsuo Ishii
ishii at sraoss.co.jp
Thu Sep 22 07:28:47 JST 2016
It's a known problem and fixed in the latest stable versions, 3.5.4
etc.
https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=2e8be5997722831a512002a32cb3fd74c63875c5
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> 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
More information about the pgpool-general
mailing list