NOTICE: pid file found but it seems bogus. Trying to start pgpool anyway... 2022-02-04 16:48:23: pid 9: LOG: reading status file: 1 th backend is set to down status 2022-02-04 16:48:23: pid 9: LOG: health_check_stats_shared_memory_size: requested size: 12288 2022-02-04 16:48:23: pid 9: LOG: memory cache initialized 2022-02-04 16:48:23: pid 9: DETAIL: memcache blocks :64 2022-02-04 16:48:23: pid 9: LOG: allocating (135547176) bytes of shared memory segment 2022-02-04 16:48:23: pid 9: LOG: allocating shared memory segment of size: 135547176 2022-02-04 16:48:24: pid 9: LOG: health_check_stats_shared_memory_size: requested size: 12288 2022-02-04 16:48:24: pid 9: LOG: health_check_stats_shared_memory_size: requested size: 12288 2022-02-04 16:48:24: pid 9: LOG: memory cache initialized 2022-02-04 16:48:24: pid 9: DETAIL: memcache blocks :64 2022-02-04 16:48:24: pid 9: LOG: pool_discard_oid_maps: discarded memqcache oid maps 2022-02-04 16:48:24: pid 9: LOG: Setting up socket for 0.0.0.0:5432 2022-02-04 16:48:24: pid 9: LOG: Setting up socket for :::5432 2022-02-04 16:48:24: pid 9: LOG: find_primary_node_repeatedly: waiting for finding a primary node 2022-02-04 16:48:24: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:24: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:24: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:24: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:24: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:24: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:25: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:25: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:25: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:25: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:25: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:25: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:26: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:26: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:26: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:26: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:26: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:26: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:27: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:27: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:27: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:27: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:27: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:27: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:28: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:28: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:28: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:28: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:28: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:28: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:29: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:29: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:29: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:29: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:29: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:29: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:30: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:30: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:30: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:30: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:30: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:30: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:31: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:31: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:31: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:31: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:31: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:31: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:32: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:32: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:32: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:32: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:32: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:32: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:33: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:33: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:33: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:33: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:33: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:33: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:34: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:34: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:34: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:34: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:34: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:34: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:35: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:35: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:35: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:35: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:35: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:35: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:36: pid 79: LOG: new connection received 2022-02-04 16:48:36: pid 79: DETAIL: connecting host=ec2-16-16-0-1.eu-north-1.compute.amazonaws.com port=33790 2022-02-04 16:48:36: pid 79: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:36: pid 79: DETAIL: Operation now in progress 2022-02-04 16:48:36: pid 79: LOG: received degenerate backend request for node_id: 0 from pid [79] 2022-02-04 16:48:36: pid 79: FATAL: failed to create a backend connection 2022-02-04 16:48:36: pid 79: DETAIL: executing failover on backend 2022-02-04 16:48:36: pid 79: LOG: frontend disconnection: session time: 0:00:00.020 user=pgpool database=postgres host=ec2-16-16-0-1.eu-north-1.compute.amazonaws.com port=33790 2022-02-04 16:48:36: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:36: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:36: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:36: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:36: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:36: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:36: pid 9: LOG: Pgpool-II parent process has received failover request 2022-02-04 16:48:36: pid 9: LOG: ignoring the failover request, since we are still starting up 2022-02-04 16:48:36: pid 9: LOG: child process with pid: 79 exits with status 256 2022-02-04 16:48:36: pid 9: LOG: fork a new child process with pid: 81 2022-02-04 16:48:37: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:37: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:37: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:37: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:37: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:37: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:38: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:38: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:38: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:38: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:38: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:38: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:39: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:39: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:39: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:39: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:39: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:39: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:40: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:40: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:40: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:40: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:40: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:40: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:41: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:41: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:41: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:41: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:41: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:41: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:42: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:42: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:42: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:42: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:42: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:42: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:43: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:43: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:43: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:43: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:43: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:43: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:44: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:44: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:44: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:44: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:44: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:44: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:45: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:45: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:45: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:45: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:45: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:45: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:46: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:46: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:46: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:46: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:46: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:46: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:47: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:47: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:47: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:47: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:47: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:47: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:48: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:48: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:48: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:48: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:48: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:48: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:49: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:49: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:49: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:49: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:49: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:49: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:50: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:50: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:50: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:50: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:50: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:50: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:51: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:51: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:51: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:51: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:51: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:51: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:52: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:52: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:52: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:52: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:52: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:52: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:53: pid 71: LOG: new connection received 2022-02-04 16:48:53: pid 71: DETAIL: connecting host=ec2-16-16-0-1.eu-north-1.compute.amazonaws.com port=34196 2022-02-04 16:48:53: pid 71: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:53: pid 71: DETAIL: Operation now in progress 2022-02-04 16:48:53: pid 71: LOG: received degenerate backend request for node_id: 0 from pid [71] 2022-02-04 16:48:53: pid 71: FATAL: failed to create a backend connection 2022-02-04 16:48:53: pid 71: DETAIL: executing failover on backend 2022-02-04 16:48:53: pid 71: LOG: frontend disconnection: session time: 0:00:00.017 user=pgpool database=postgres host=ec2-16-16-0-1.eu-north-1.compute.amazonaws.com port=34196 2022-02-04 16:48:53: pid 9: LOG: failed to connect to PostgreSQL server on "dbod-ag-test1.ch:6601", getsockopt() failed 2022-02-04 16:48:53: pid 9: DETAIL: Operation now in progress 2022-02-04 16:48:53: pid 9: ERROR: failed to make persistent db connection 2022-02-04 16:48:53: pid 9: DETAIL: connection to host:"dbod-ag-test1.ch:6601" failed 2022-02-04 16:48:53: pid 9: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0 2022-02-04 16:48:53: pid 9: LOG: find_primary_node: standby node is 2 2022-02-04 16:48:53: pid 9: LOG: Pgpool-II parent process has received failover request 2022-02-04 16:48:53: pid 9: LOG: ignoring the failover request, since we are still starting up 2022-02-04 16:48:53: pid 9: LOG: child process with pid: 71 exits with status 256 2022-02-04 16:48:53: pid 9: LOG: fork a new child process with pid: 82