[pgpool-general: 5881] Pgpool-3.7.1 segmentation fault
Philip Champon
philip at adaptly.com
Wed Jan 24 04:33:04 JST 2018
Hello poolers,
I've compiled pgpool-3.7.1 (./configure --with-openssl; libpq.5.9), for
Ubuntu 14.04, to connect to RDS Aurora Postgres (9.6.3). When I try to
authenticate, pgpool child process segfaults. My config file follows the
instructions set forth by the aurora instructions
<http://www.pgpool.net/docs/latest/en/html/example-aurora.html>, I think?
Have I misconfigured something, to cause this segfault?
Any guidance would be appreciated!
Thanks,
Philip
$ psql -h localhost -U user staging
Password for user user:
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
*Log*
2018-01-23 19:23:35: pid 19872: DEBUG: initializing backend status
2018-01-23 19:23:35: pid 19872: LOCATION: child.c:1823
2018-01-23 19:23:42: pid 19872: DEBUG: I am 19872 accept fd 7
2018-01-23 19:23:42: pid 19872: LOCATION: child.c:2161
2018-01-23 19:23:42: pid 19872: LOG: new connection received
2018-01-23 19:23:42: pid 19872: DETAIL: connecting host=localhost
port=53419
2018-01-23 19:23:42: pid 19872: LOCATION: child.c:2174
2018-01-23 19:23:42: pid 19872: DEBUG: reading startup packet
2018-01-23 19:23:42: pid 19872: DETAIL: Protocol Major: 1234 Minor: 5679
database: user:
2018-01-23 19:23:42: pid 19872: LOCATION: child.c:629
2018-01-23 19:23:42: pid 19872: DEBUG: selecting backend connection
2018-01-23 19:23:42: pid 19872: DETAIL: SSLRequest from client
2018-01-23 19:23:42: pid 19872: LOCATION: child.c:2237
2018-01-23 19:23:42: pid 19872: DEBUG: pool_write: to frontend: kind:N po:0
2018-01-23 19:23:42: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:42: pid 19872: DEBUG: pool_flush_it: flush size: 1
2018-01-23 19:23:42: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:42: pid 19872: DEBUG: reading startup packet
2018-01-23 19:23:42: pid 19872: DETAIL: application_name: psql
2018-01-23 19:23:42: pid 19872: LOCATION: child.c:587
2018-01-23 19:23:42: pid 19872: DEBUG: reading startup packet
2018-01-23 19:23:42: pid 19872: DETAIL: Protocol Major: 3 Minor: 0
database: staging user: user
2018-01-23 19:23:42: pid 19872: LOCATION: child.c:629
2018-01-23 19:23:42: pid 19872: DEBUG: creating new connection to backend
2018-01-23 19:23:42: pid 19872: DETAIL: connecting 0 backend
2018-01-23 19:23:42: pid 19872: LOCATION: pool_connection_pool.c:837
2018-01-23 19:23:42: pid 19872: DEBUG: creating new connection to backend
2018-01-23 19:23:42: pid 19872: DETAIL: skipping backend slot 0 because
backend_status = 3
2018-01-23 19:23:42: pid 19872: LOCATION: pool_connection_pool.c:844
2018-01-23 19:23:42: pid 19872: DEBUG: creating new connection to backend
2018-01-23 19:23:42: pid 19872: DETAIL: connecting 1 backend
2018-01-23 19:23:42: pid 19872: LOCATION: pool_connection_pool.c:837
2018-01-23 19:23:42: pid 19872: DEBUG: pool_flush_it: flush size: 84
2018-01-23 19:23:42: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:42: pid 19872: DEBUG: pool_read: read 13 bytes from
backend 1
2018-01-23 19:23:42: pid 19872: LOCATION: pool_stream.c:191
2018-01-23 19:23:42: pid 19872: DEBUG: reading message length
2018-01-23 19:23:42: pid 19872: DETAIL: slot: 1 length: 12
2018-01-23 19:23:42: pid 19872: LOCATION: pool_auth.c:1108
2018-01-23 19:23:42: pid 19872: DEBUG: authentication backend
2018-01-23 19:23:42: pid 19872: DETAIL: auth kind:5
2018-01-23 19:23:42: pid 19872: LOCATION: pool_auth.c:145
2018-01-23 19:23:42: pid 19872: DEBUG: authentication backend
2018-01-23 19:23:42: pid 19872: DETAIL: trying md5 authentication
2018-01-23 19:23:42: pid 19872: LOCATION: pool_auth.c:242
2018-01-23 19:23:42: pid 19872: DEBUG: pool_write: to frontend: kind:R po:0
2018-01-23 19:23:42: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:42: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:42: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:42: pid 19872: DEBUG: pool_write: to frontend: length:4
po:5
2018-01-23 19:23:42: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:42: pid 19872: DEBUG: pool_write: to frontend: length:4
po:9
2018-01-23 19:23:42: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:42: pid 19872: DEBUG: pool_flush_it: flush size: 13
2018-01-23 19:23:42: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:55: pid 19872: DEBUG: I am 19872 accept fd 7
2018-01-23 19:23:55: pid 19872: LOCATION: child.c:2161
2018-01-23 19:23:55: pid 19872: LOG: new connection received
2018-01-23 19:23:55: pid 19872: DETAIL: connecting
host=ip-10-20-1-193.us-west-2.compute.internal port=51609
2018-01-23 19:23:55: pid 19872: LOCATION: child.c:2174
2018-01-23 19:23:56: pid 19872: DEBUG: reading startup packet
2018-01-23 19:23:56: pid 19872: DETAIL: Protocol Major: 1234 Minor: 5679
database: user:
2018-01-23 19:23:56: pid 19872: LOCATION: child.c:629
2018-01-23 19:23:56: pid 19872: DEBUG: selecting backend connection
2018-01-23 19:23:56: pid 19872: DETAIL: SSLRequest from client
2018-01-23 19:23:56: pid 19872: LOCATION: child.c:2237
2018-01-23 19:23:56: pid 19872: DEBUG: pool_write: to frontend: kind:N po:0
2018-01-23 19:23:56: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:56: pid 19872: DEBUG: pool_flush_it: flush size: 1
2018-01-23 19:23:56: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:56: pid 19872: DEBUG: reading startup packet
2018-01-23 19:23:56: pid 19872: DETAIL: application_name: psql
2018-01-23 19:23:56: pid 19872: LOCATION: child.c:587
2018-01-23 19:23:56: pid 19872: DEBUG: reading startup packet
2018-01-23 19:23:56: pid 19872: DETAIL: Protocol Major: 3 Minor: 0
database: staging user: user
2018-01-23 19:23:56: pid 19872: LOCATION: child.c:629
2018-01-23 19:23:56: pid 19872: DEBUG: creating new connection to backend
2018-01-23 19:23:56: pid 19872: DETAIL: connecting 0 backend
2018-01-23 19:23:56: pid 19872: LOCATION: pool_connection_pool.c:837
2018-01-23 19:23:56: pid 19872: DEBUG: creating new connection to backend
2018-01-23 19:23:56: pid 19872: DETAIL: skipping backend slot 0 because
backend_status = 3
2018-01-23 19:23:56: pid 19872: LOCATION: pool_connection_pool.c:844
2018-01-23 19:23:56: pid 19872: DEBUG: creating new connection to backend
2018-01-23 19:23:56: pid 19872: DETAIL: connecting 1 backend
2018-01-23 19:23:56: pid 19872: LOCATION: pool_connection_pool.c:837
2018-01-23 19:23:56: pid 19872: DEBUG: pool_flush_it: flush size: 84
2018-01-23 19:23:56: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:56: pid 19872: DEBUG: pool_read: read 13 bytes from
backend 1
2018-01-23 19:23:56: pid 19872: LOCATION: pool_stream.c:191
2018-01-23 19:23:56: pid 19872: DEBUG: reading message length
2018-01-23 19:23:56: pid 19872: DETAIL: slot: 1 length: 12
2018-01-23 19:23:56: pid 19872: LOCATION: pool_auth.c:1108
2018-01-23 19:23:56: pid 19872: DEBUG: authentication backend
2018-01-23 19:23:56: pid 19872: DETAIL: auth kind:5
2018-01-23 19:23:56: pid 19872: LOCATION: pool_auth.c:145
2018-01-23 19:23:56: pid 19872: DEBUG: authentication backend
2018-01-23 19:23:56: pid 19872: DETAIL: trying md5 authentication
2018-01-23 19:23:56: pid 19872: LOCATION: pool_auth.c:242
2018-01-23 19:23:56: pid 19872: DEBUG: pool_write: to frontend: kind:R po:0
2018-01-23 19:23:56: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:56: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:56: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:56: pid 19872: DEBUG: pool_write: to frontend: length:4
po:5
2018-01-23 19:23:56: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:56: pid 19872: DEBUG: pool_write: to frontend: length:4
po:9
2018-01-23 19:23:56: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:56: pid 19872: DEBUG: pool_flush_it: flush size: 13
2018-01-23 19:23:56: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: I am 19872 accept fd 7
2018-01-23 19:23:57: pid 19872: LOCATION: child.c:2161
2018-01-23 19:23:57: pid 19872: LOG: new connection received
2018-01-23 19:23:57: pid 19872: DETAIL: connecting host=localhost
port=53440
2018-01-23 19:23:57: pid 19872: LOCATION: child.c:2174
2018-01-23 19:23:57: pid 19872: DEBUG: reading startup packet
2018-01-23 19:23:57: pid 19872: DETAIL: Protocol Major: 1234 Minor: 5679
database: staging user: staging
2018-01-23 19:23:57: pid 19872: LOCATION: child.c:629
2018-01-23 19:23:57: pid 19872: DEBUG: selecting backend connection
2018-01-23 19:23:57: pid 19872: DETAIL: SSLRequest from client
2018-01-23 19:23:57: pid 19872: LOCATION: child.c:2237
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:N po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: reading startup packet
2018-01-23 19:23:57: pid 19872: DETAIL: application_name: psql
2018-01-23 19:23:57: pid 19872: LOCATION: child.c:587
2018-01-23 19:23:57: pid 19872: DEBUG: reading startup packet
2018-01-23 19:23:57: pid 19872: DETAIL: Protocol Major: 3 Minor: 0
database: staging user: user
2018-01-23 19:23:57: pid 19872: LOCATION: child.c:629
2018-01-23 19:23:57: pid 19872: DEBUG: creating new connection to backend
2018-01-23 19:23:57: pid 19872: DETAIL: connecting 0 backend
2018-01-23 19:23:57: pid 19872: LOCATION: pool_connection_pool.c:837
2018-01-23 19:23:57: pid 19872: DEBUG: creating new connection to backend
2018-01-23 19:23:57: pid 19872: DETAIL: skipping backend slot 0 because
backend_status = 3
2018-01-23 19:23:57: pid 19872: LOCATION: pool_connection_pool.c:844
2018-01-23 19:23:57: pid 19872: DEBUG: creating new connection to backend
2018-01-23 19:23:57: pid 19872: DETAIL: connecting 1 backend
2018-01-23 19:23:57: pid 19872: LOCATION: pool_connection_pool.c:837
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 84
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_read: read 13 bytes from
backend 1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:191
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: slot: 1 length: 12
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1108
2018-01-23 19:23:57: pid 19872: DEBUG: authentication backend
2018-01-23 19:23:57: pid 19872: DETAIL: auth kind:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:145
2018-01-23 19:23:57: pid 19872: DEBUG: authentication backend
2018-01-23 19:23:57: pid 19872: DETAIL: trying md5 authentication
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:242
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:R po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:9
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 13
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: performing md5 authentication
2018-01-23 19:23:57: pid 19872: DETAIL: DB node id: 1 salt: bb706d70
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:860
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to backend: 1 kind:p
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:437
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 41
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_read: read 324 bytes from
backend 1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:191
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:R po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 9
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 26
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1 name:"application_name"
value:"psql"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:22
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 27
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 25
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1 name:"client_encoding"
value:"UTF8"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:21
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 26
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 23
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1 name:"DateStyle"
value:"ISO, MDY"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:19
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 24
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 25
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1 name:"integer_datetimes"
value:"on"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:21
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 26
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 27
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1 name:"IntervalStyle"
value:"postgres"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:23
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 28
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 21
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1 name:"is_superuser"
value:"off"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:17
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 22
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 25
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1 name:"server_encoding"
value:"UTF8"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:21
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 26
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 25
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1 name:"server_version"
value:"9.6.3"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:21
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 26
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 36
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1
name:"session_authorization" value:"user"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:32
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 37
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 35
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1
name:"standard_conforming_strings" value:"on"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:31
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 36
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:S po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: master slot: 1 length: 17
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1157
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: process parameter status
2018-01-23 19:23:57: pid 19872: DETAIL: backend:1 name:"TimeZone"
value:"UTC"
2018-01-23 19:23:57: pid 19872: LOCATION: pool_process_query.c:948
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:13
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 18
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:57: pid 19872: DEBUG: reading message length
2018-01-23 19:23:57: pid 19872: DETAIL: slot: 1 length: 12
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:1108
2018-01-23 19:23:57: pid 19872: DEBUG: authentication backend
2018-01-23 19:23:57: pid 19872: DETAIL: cp->info[i]:0x7f2adf5e4088
pid:17362
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:394
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: kind:K po:0
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:448
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:1
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: sending backend key data
2018-01-23 19:23:57: pid 19872: DETAIL: send pid 17362 to frontend
2018-01-23 19:23:57: pid 19872: LOCATION: pool_auth.c:524
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:5
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_write: to frontend: length:4
po:9
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:451
2018-01-23 19:23:57: pid 19872: DEBUG: pool_flush_it: flush size: 13
2018-01-23 19:23:57: pid 19872: LOCATION: pool_stream.c:614
2018-01-23 19:23:58: pid 19869: WARNING: child process with pid: 19872 was
terminated by segmentation fault
*Config*
listen_addresses = '*'
port = 5432
socket_dir = '/tmp'
pcp_listen_addresses = '*'
pcp_port = 9898
pcp_socket_dir = '/tmp'
listen_backlog_multiplier = 2
serialize_accept = off
backend_hostname0 = 'primary-host'
backend_port0 = 5432
backend_weight0 = 2
backend_flag0 = 'ALWAYS_MASTER'
backend_hostname1 = 'secondary-host'
backend_port1 = 5432
backend_weight1 = 1
backend_flag1 = 'ALLOW_TO_FAILOVER'
enable_pool_hba = on
pool_passwd = 'pool_passwd'
authentication_timeout = 60
ssl = off
num_init_children = 4
max_pool = 4
child_life_time = 300
child_max_connections = 0
connection_life_time = 0
client_idle_limit = 0
log_destination = 'stderr'
log_line_prefix = '%t: pid %p: '
log_connections = on
log_hostname = on
log_statement = on
log_per_node_statement = on
log_standby_delay = 'if_over_threshold'
log_error_verbosity = verbose
log_min_messages = debug1
pid_file_name = '/var/run/pgpool/pgpool.pid'
logdir = '/var/log/pgpool'
connection_cache = on
reset_query_list = 'ABORT; DISCARD ALL'
replication_mode = off
replicate_select = off
insert_lock = off
lobj_lock_table = ''
replication_stop_on_mismatch = off
failover_if_affected_tuples_mismatch = off
load_balance_mode = on
ignore_leading_white_space = on
white_function_list = ''
black_function_list = 'currval,lastval,nextval,setval'
database_redirect_preference_list = ''
app_name_redirect_preference_list = ''
allow_sql_comments = off
master_slave_mode = on
master_slave_sub_mode = 'stream'
sr_check_period = 0
delay_threshold = 10000000
follow_master_command = ''
health_check_period0 = 0
health_check_timeout0 = 20
health_check_password0 = 'PW'
health_check_user0 = 'user'
health_check_database0 = 'db'
health_check_max_retries0 = 20
health_check_retry_delay0 = 1
connect_timeout0 = 10000
health_check_period1 = 0
health_check_timeout1 = 20
health_check_password1 = 'PW'
health_check_user1 = 'user'
health_check_database1 = 'db'
health_check_max_retries1 = 20
health_check_retry_delay1 = 1
connect_timeout1 = 10000
fail_over_on_backend_error = off
use_watchdog = off
clear_memqcache_on_escalation = on
check_temp_table = on
check_unlogged_table = on
memory_cache_enabled = off
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180123/0a7d25db/attachment-0001.html>
More information about the pgpool-general
mailing list