[pgpool-general: 8058] Re: SSL transport between Pgpool and Postgres

[Mike]

Mar 31, 2022, 09:27 by ishii at sraoss.co.jp:

>>    below is one "loop" of the stderr from pgpool. Currently, in pgpool.conf:
>>
>> failover_on_backend_error = off
>> ssl = on
>> ssl_ca_cert_dir = '/etc/ssl/certs'
>>
>
> Forgot to say. Can you please add below to pgpool.conf and try again.
>
> log_error_verbosity = verbose
>
> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
Here it is:

2022-03-31 07:36:49: pid 70: LOG:  health check failed on node 0 but failover is disallowed for the node
2022-03-31 07:36:49: pid 70: LOCATION:  health_check.c:218
2022-03-31 07:36:50: pid 101: DEBUG:  I am 101 accept fd 6
2022-03-31 07:36:50: pid 101: LOCATION:  child.c:1815
2022-03-31 07:36:50: pid 103: DEBUG:  I am 103 accept fd 6
2022-03-31 07:36:50: pid 103: LOCATION:  child.c:1815
2022-03-31 07:36:54: pid 70: DEBUG:  health check: clearing alarm
2022-03-31 07:36:54: pid 70: LOCATION:  health_check.c:369
2022-03-31 07:36:54: pid 70: DEBUG:  attempting to negotiate a secure connection
2022-03-31 07:36:54: pid 70: DETAIL:  sending client->server SSL request
2022-03-31 07:36:54: pid 70: LOCATION:  pool_ssl.c:107
2022-03-31 07:36:54: pid 70: DEBUG:  attempting to negotiate a secure connection
2022-03-31 07:36:54: pid 70: DETAIL:  client->server SSL response: S
2022-03-31 07:36:54: pid 70: LOCATION:  pool_ssl.c:119
2022-03-31 07:36:54: pid 70: LOG:  pool_ssl: "SSL_connect": "certificate verify failed"
2022-03-31 07:36:54: pid 70: LOCATION:  pool_ssl.c:419
2022-03-31 07:36:54: pid 70: DEBUG:  health check: clearing alarm
2022-03-31 07:36:54: pid 70: LOCATION:  health_check.c:386
2022-03-31 07:36:54: pid 70: DEBUG:  health check: clearing alarm
2022-03-31 07:36:54: pid 70: LOCATION:  health_check.c:386
2022-03-31 07:36:54: pid 70: LOG:  health check retrying on DB node: 0 (round:1)
2022-03-31 07:36:54: pid 70: LOCATION:  health_check.c:413
2022-03-31 07:36:55: pid 70: DEBUG:  health check: clearing alarm
2022-03-31 07:36:55: pid 70: LOCATION:  health_check.c:369
2022-03-31 07:36:55: pid 70: DEBUG:  attempting to negotiate a secure connection
2022-03-31 07:36:55: pid 70: DETAIL:  sending client->server SSL request
2022-03-31 07:36:55: pid 70: LOCATION:  pool_ssl.c:107
2022-03-31 07:36:55: pid 70: DEBUG:  attempting to negotiate a secure connection
2022-03-31 07:36:55: pid 70: DETAIL:  client->server SSL response: S
2022-03-31 07:36:55: pid 70: LOCATION:  pool_ssl.c:119
2022-03-31 07:36:55: pid 70: LOG:  pool_ssl: "SSL_connect": "certificate verify failed"
2022-03-31 07:36:55: pid 70: LOCATION:  pool_ssl.c:419
2022-03-31 07:36:55: pid 70: DEBUG:  health check: clearing alarm
2022-03-31 07:36:55: pid 70: LOCATION:  health_check.c:386
2022-03-31 07:36:55: pid 70: DEBUG:  health check: clearing alarm
2022-03-31 07:36:55: pid 70: LOCATION:  health_check.c:386
2022-03-31 07:36:55: pid 70: LOG:  health check retrying on DB node: 0 (round:2)
2022-03-31 07:36:55: pid 70: LOCATION:  health_check.c:413
2022-03-31 07:36:55: pid 100: DEBUG:  I am 100 accept fd 6
2022-03-31 07:36:55: pid 100: LOCATION:  child.c:1815
2022-03-31 07:36:55: pid 87: DEBUG:  I am 87 accept fd 6
2022-03-31 07:36:55: pid 87: LOCATION:  child.c:1815
2022-03-31 07:36:55: pid 73: ERROR:  Failed to check replication time lag
2022-03-31 07:36:55: pid 73: DETAIL:  No persistent db connection for the node 0
2022-03-31 07:36:55: pid 73: HINT:  check sr_check_user and sr_check_password
2022-03-31 07:36:55: pid 73: CONTEXT:  while checking replication time lag
2022-03-31 07:36:55: pid 73: LOCATION:  pool_worker_child.c:373
2022-03-31 07:36:55: pid 73: DEBUG:  pool_acquire_follow_primary_lock: lock was not held by anyone
2022-03-31 07:36:55: pid 73: LOCATION:  pgpool_main.c:4413
2022-03-31 07:36:55: pid 73: DEBUG:  pool_acquire_follow_primary_lock: succeeded in acquiring lock
2022-03-31 07:36:55: pid 73: LOCATION:  pgpool_main.c:4465
2022-03-31 07:36:55: pid 73: DEBUG:  attempting to negotiate a secure connection
2022-03-31 07:36:55: pid 73: DETAIL:  sending client->server SSL request
2022-03-31 07:36:55: pid 73: LOCATION:  pool_ssl.c:107
2022-03-31 07:36:55: pid 73: DEBUG:  attempting to negotiate a secure connection
2022-03-31 07:36:55: pid 73: DETAIL:  client->server SSL response: S
2022-03-31 07:36:55: pid 73: LOCATION:  pool_ssl.c:119
2022-03-31 07:36:55: pid 73: LOG:  pool_ssl: "SSL_connect": "certificate verify failed"
2022-03-31 07:36:55: pid 73: LOCATION:  pool_ssl.c:419
2022-03-31 07:36:55: pid 73: DEBUG:  pool_release_follow_primary_lock called
2022-03-31 07:36:55: pid 73: LOCATION:  pgpool_main.c:4543
2022-03-31 07:36:56: pid 70: DEBUG:  health check: clearing alarm
2022-03-31 07:36:56: pid 70: LOCATION:  health_check.c:369
2022-03-31 07:36:56: pid 70: DEBUG:  attempting to negotiate a secure connection
2022-03-31 07:36:56: pid 70: DETAIL:  sending client->server SSL request
2022-03-31 07:36:56: pid 70: LOCATION:  pool_ssl.c:107
2022-03-31 07:36:56: pid 70: DEBUG:  attempting to negotiate a secure connection
2022-03-31 07:36:56: pid 70: DETAIL:  client->server SSL response: S
2022-03-31 07:36:56: pid 70: LOCATION:  pool_ssl.c:119
2022-03-31 07:36:56: pid 70: LOG:  pool_ssl: "SSL_connect": "certificate verify failed"
2022-03-31 07:36:56: pid 70: LOCATION:  pool_ssl.c:419
2022-03-31 07:36:56: pid 70: DEBUG:  health check: clearing alarm
2022-03-31 07:36:56: pid 70: LOCATION:  health_check.c:386
2022-03-31 07:36:56: pid 70: DEBUG:  health check: clearing alarm
2022-03-31 07:36:56: pid 70: LOCATION:  health_check.c:386
2022-03-31 07:36:56: pid 70: LOG:  health check failed on node 0 but failover is disallowed for the node