Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.700: main pid 8745: LOG: Backend status file /var/log/postgresql/pgpool_status discarded Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.700: main pid 8745: LOCATION: pgpool_main.c:3697 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.701: main pid 8745: LOG: health_check_stats_shared_memory_size: requested size: 12288 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.701: main pid 8745: LOCATION: health_check.c:541 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.701: main pid 8745: LOG: memory cache initialized Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.701: main pid 8745: DETAIL: memcache blocks :64 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.701: main pid 8745: LOCATION: pool_memqcache.c:2059 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.701: main pid 8745: LOG: allocating (138292616) bytes of shared memory segment Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.701: main pid 8745: LOCATION: pgpool_main.c:3545 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.701: main pid 8745: LOG: allocating shared memory segment of size: 138292616 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.701: main pid 8745: LOCATION: pool_shmem.c:60 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.832: main pid 8745: LOG: health_check_stats_shared_memory_size: requested size: 12288 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.832: main pid 8745: LOCATION: health_check.c:541 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.832: main pid 8745: LOG: health_check_stats_shared_memory_size: requested size: 12288 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.832: main pid 8745: LOCATION: health_check.c:541 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.832: main pid 8745: LOG: memory cache initialized Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.832: main pid 8745: DETAIL: memcache blocks :64 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.832: main pid 8745: LOCATION: pool_memqcache.c:2059 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.834: main pid 8745: LOG: pool_discard_oid_maps: discarded memqcache oid maps Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.834: main pid 8745: LOCATION: pgpool_main.c:3626 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.844: main pid 8745: LOG: waiting for watchdog to initialize Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:01.844: main pid 8745: LOCATION: pgpool_main.c:330 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.845: watchdog pid 8748: LOG: setting the local watchdog node name to "proxy-psql0-stage-cn1.psqldb-stage.example.com:9999 Linux proxy-psql0-stage-cn1" Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.845: watchdog pid 8748: LOCATION: watchdog.c:770 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.845: watchdog pid 8748: LOG: watchdog cluster is configured with 1 remote nodes Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.845: watchdog pid 8748: LOCATION: watchdog.c:780 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.846: watchdog pid 8748: LOG: watchdog remote node:0 on proxy-psql0-stage-cn2.psqldb-stage.example.com:9000 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.846: watchdog pid 8748: LOCATION: watchdog.c:797 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.846: watchdog pid 8748: LOG: interface monitoring is disabled in watchdog Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.846: watchdog pid 8748: LOCATION: watchdog.c:666 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.846: watchdog pid 8748: INFO: IPC socket path: "/var/run/postgresql/.s.PGPOOLWD_CMD.9000" Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.846: watchdog pid 8748: LOCATION: watchdog.c:1349 Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.846: watchdog pid 8748: LOG: watchdog node state changed from [DEAD] to [LOADING] Sep 30 13:19:01 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:01.846: watchdog pid 8748: LOCATION: watchdog.c:7221 Sep 30 13:19:06 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:06.853: watchdog pid 8748: LOG: watchdog node state changed from [LOADING] to [JOINING] Sep 30 13:19:06 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:06.853: watchdog pid 8748: LOCATION: watchdog.c:7221 Sep 30 13:19:10 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:10.859: watchdog pid 8748: LOG: watchdog node state changed from [JOINING] to [INITIALIZING] Sep 30 13:19:10 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:10.859: watchdog pid 8748: LOCATION: watchdog.c:7221 Sep 30 13:19:11 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:11.860: watchdog pid 8748: LOG: I am the only alive node in the watchdog cluster Sep 30 13:19:11 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:11.860: watchdog pid 8748: HINT: skipping stand for coordinator state Sep 30 13:19:11 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:11.860: watchdog pid 8748: LOCATION: watchdog.c:5831 Sep 30 13:19:11 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:11.860: watchdog pid 8748: LOG: watchdog node state changed from [INITIALIZING] to [LEADER] Sep 30 13:19:11 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:11.860: watchdog pid 8748: LOCATION: watchdog.c:7221 Sep 30 13:19:11 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:11.860: watchdog pid 8748: LOG: I am announcing my self as leader/coordinator watchdog node Sep 30 13:19:11 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:11.860: watchdog pid 8748: LOCATION: watchdog.c:6024 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.864: watchdog pid 8748: LOG: I am the cluster leader node Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.864: watchdog pid 8748: DETAIL: our declare coordinator message is accepted by all nodes Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.864: watchdog pid 8748: LOCATION: watchdog.c:6060 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.864: watchdog pid 8748: LOG: setting the local node "proxy-psql0-stage-cn1.psqldb-stage.example.com:9999 Linux proxy-psql0-stage-cn1" as watchdog cluster leader Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.864: watchdog pid 8748: LOCATION: watchdog.c:7958 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.864: watchdog pid 8748: LOG: signal_user1_to_parent_with_reason(1) Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.864: watchdog pid 8748: LOCATION: pgpool_main.c:611 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.865: watchdog pid 8748: LOG: I am the cluster leader node. Starting escalation process Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.865: watchdog pid 8748: LOCATION: watchdog.c:6080 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.865: watchdog pid 8748: LOG: escalation process started with PID:8751 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.865: watchdog pid 8748: LOCATION: watchdog.c:6736 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.867: main pid 8745: LOG: watchdog process is initialized Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.867: main pid 8745: DETAIL: watchdog messaging data version: 1.2 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.867: main pid 8745: LOCATION: pgpool_main.c:344 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.868: main pid 8745: LOG: Pgpool-II parent process received SIGUSR1 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.868: main pid 8745: LOCATION: pgpool_main.c:1292 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.868: main pid 8745: LOG: Pgpool-II parent process received watchdog state change signal from watchdog Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.868: main pid 8745: LOCATION: pgpool_main.c:1336 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.869: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.869: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.870: main pid 8745: LOG: Setting up socket for 0.0.0.0:5432 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.870: main pid 8745: LOCATION: pgpool_main.c:812 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.870: main pid 8745: LOG: Setting up socket for :::5432 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.870: main pid 8745: LOCATION: pgpool_main.c:812 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.878: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:15.878: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8751]: 2022-09-30 13:19:15.881: watchdog_utility pid 8751: LOG: watchdog: escalation started Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8751]: 2022-09-30 13:19:15.881: watchdog_utility pid 8751: LOCATION: wd_escalation.c:93 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.883: life_check pid 8752: LOG: 2 watchdog nodes are configured for lifecheck Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.883: life_check pid 8752: LOCATION: wd_lifecheck.c:494 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.883: life_check pid 8752: LOG: watchdog nodes ID:0 Name:"proxy-psql0-stage-cn1.psqldb-stage.example.com:9999 Linux proxy-psql0-stage-cn1" Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.883: life_check pid 8752: DETAIL: Host:"proxy-psql0-stage-cn1.psqldb-stage.example.com" WD Port:9000 pgpool-II port:9999 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.883: life_check pid 8752: LOCATION: wd_lifecheck.c:498 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.883: life_check pid 8752: LOG: watchdog nodes ID:1 Name:"Not_Set" Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.883: life_check pid 8752: DETAIL: Host:"proxy-psql0-stage-cn2.psqldb-stage.example.com" WD Port:9000 pgpool-II port:9999 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.883: life_check pid 8752: LOCATION: wd_lifecheck.c:498 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.884: life_check pid 8752: LOG: watchdog lifecheck trusted server "10.10.20.1" added for the availability check Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8752]: 2022-09-30 13:19:15.884: life_check pid 8752: LOCATION: wd_lifecheck.c:1099 Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.942: main pid 8745: LOG: find_primary_node_repeatedly: waiting for finding a primary node Sep 30 13:19:15 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:15.942: main pid 8745: LOCATION: pgpool_main.c:3417 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.006: main pid 8745: LOG: find_primary_node: standby node is 0 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.006: main pid 8745: LOCATION: pgpool_main.c:3343 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.006: main pid 8745: LOG: find_primary_node: primary node is 1 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.006: main pid 8745: LOCATION: pgpool_main.c:3337 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8792]: 2022-09-30 13:19:16.011: sr_check_worker pid 8792: LOG: process started Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8792]: 2022-09-30 13:19:16.011: sr_check_worker pid 8792: LOCATION: pgpool_main.c:728 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8793]: 2022-09-30 13:19:16.011: health_check pid 8793: LOG: process started Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8793]: 2022-09-30 13:19:16.012: health_check pid 8793: LOCATION: pgpool_main.c:728 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:16.013: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:16.013: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:16.014: pcp_main pid 8791: LOG: PCP process: 8791 started Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:16.014: pcp_main pid 8791: LOCATION: pcp_child.c:161 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8794]: 2022-09-30 13:19:16.016: health_check pid 8794: LOG: process started Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8794]: 2022-09-30 13:19:16.016: health_check pid 8794: LOCATION: pgpool_main.c:728 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.245: main pid 8745: LOG: pgpool-II successfully started. version 4.3.3 (tamahomeboshi) Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.245: main pid 8745: LOCATION: pgpool_main.c:489 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.245: main pid 8745: LOG: node status[0]: 2 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.245: main pid 8745: LOCATION: pgpool_main.c:500 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.245: main pid 8745: LOG: node status[1]: 1 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:19:16.245: main pid 8745: LOCATION: pgpool_main.c:500 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8759]: 2022-09-30 13:19:16.893: heart_beat_receiver pid 8759: LOG: set SO_REUSEPORT option to the socket Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8759]: 2022-09-30 13:19:16.893: heart_beat_receiver pid 8759: LOCATION: wd_heartbeat.c:690 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8759]: 2022-09-30 13:19:16.893: heart_beat_receiver pid 8759: LOG: creating watchdog heartbeat receive socket. Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8759]: 2022-09-30 13:19:16.893: heart_beat_receiver pid 8759: DETAIL: set SO_REUSEPORT Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8759]: 2022-09-30 13:19:16.893: heart_beat_receiver pid 8759: LOCATION: wd_heartbeat.c:229 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8760]: 2022-09-30 13:19:16.894: heart_beat_sender pid 8760: LOG: set SO_REUSEPORT option to the socket Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8760]: 2022-09-30 13:19:16.894: heart_beat_sender pid 8760: LOCATION: wd_heartbeat.c:690 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8760]: 2022-09-30 13:19:16.894: heart_beat_sender pid 8760: LOG: creating socket for sending heartbeat Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8760]: 2022-09-30 13:19:16.894: heart_beat_sender pid 8760: DETAIL: set SO_REUSEPORT Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8760]: 2022-09-30 13:19:16.894: heart_beat_sender pid 8760: LOCATION: wd_heartbeat.c:146 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8751]: 2022-09-30 13:19:16.969: watchdog_utility pid 8751: LOG: failed to acquire the delegate IP address Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8751]: 2022-09-30 13:19:16.969: watchdog_utility pid 8751: DETAIL: 'if_up_cmd' failed Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8751]: 2022-09-30 13:19:16.969: watchdog_utility pid 8751: LOCATION: wd_if.c:182 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8751]: 2022-09-30 13:19:16.969: watchdog_utility pid 8751: WARNING: watchdog escalation failed to acquire delegate IP Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8751]: 2022-09-30 13:19:16.969: watchdog_utility pid 8751: LOCATION: wd_escalation.c:140 Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:16.971: watchdog pid 8748: LOG: watchdog escalation process with pid: 8751 exit with SUCCESS. Sep 30 13:19:16 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:16.971: watchdog pid 8748: LOCATION: watchdog.c:3267 Sep 30 13:19:26 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:26.087: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:19:26 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:26.087: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:19:36 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:36.166: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:19:36 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:36.166: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:19:37 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:37.818: pcp_main pid 8791: LOG: forked new pcp worker, pid=8796 socket=7 Sep 30 13:19:37 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:37.818: pcp_main pid 8791: LOCATION: pcp_child.c:297 Sep 30 13:19:37 proxy-psql0-stage-cn1 pgpool[8796]: 2022-09-30 13:19:37.819: pcp_child pid 8796: FATAL: authentication failed for user "pcpadm" Sep 30 13:19:37 proxy-psql0-stage-cn1 pgpool[8796]: 2022-09-30 13:19:37.819: pcp_child pid 8796: DETAIL: username and/or password does not match Sep 30 13:19:37 proxy-psql0-stage-cn1 pgpool[8796]: 2022-09-30 13:19:37.819: pcp_child pid 8796: LOCATION: pcp_worker.c:517 Sep 30 13:19:37 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:37.821: pcp_main pid 8791: LOG: PCP process with pid: 8796 exit with SUCCESS. Sep 30 13:19:37 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:37.821: pcp_main pid 8791: LOCATION: pcp_child.c:354 Sep 30 13:19:37 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:37.821: pcp_main pid 8791: LOG: PCP process with pid: 8796 exits with status 256 Sep 30 13:19:37 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:37.821: pcp_main pid 8791: LOCATION: pcp_child.c:368 Sep 30 13:19:46 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:46.233: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:19:46 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:46.233: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:19:50 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:50.856: pcp_main pid 8791: LOG: forked new pcp worker, pid=8798 socket=7 Sep 30 13:19:50 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:50.856: pcp_main pid 8791: LOCATION: pcp_child.c:297 Sep 30 13:19:50 proxy-psql0-stage-cn1 pgpool[8798]: 2022-09-30 13:19:50.859: pcp_child pid 8798: FATAL: authentication failed for user "pcpadm" Sep 30 13:19:50 proxy-psql0-stage-cn1 pgpool[8798]: 2022-09-30 13:19:50.859: pcp_child pid 8798: DETAIL: username and/or password does not match Sep 30 13:19:50 proxy-psql0-stage-cn1 pgpool[8798]: 2022-09-30 13:19:50.859: pcp_child pid 8798: LOCATION: pcp_worker.c:517 Sep 30 13:19:50 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:50.864: pcp_main pid 8791: LOG: PCP process with pid: 8798 exit with SUCCESS. Sep 30 13:19:50 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:50.864: pcp_main pid 8791: LOCATION: pcp_child.c:354 Sep 30 13:19:50 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:50.864: pcp_main pid 8791: LOG: PCP process with pid: 8798 exits with status 256 Sep 30 13:19:50 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:19:50.864: pcp_main pid 8791: LOCATION: pcp_child.c:368 Sep 30 13:19:56 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:56.306: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:19:56 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:19:56.306: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:20:06 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:06.413: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:20:06 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:06.413: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:20:16 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:16.523: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:20:16 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:16.523: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:20:25 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:25.415: pcp_main pid 8791: LOG: forked new pcp worker, pid=8813 socket=7 Sep 30 13:20:25 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:25.415: pcp_main pid 8791: LOCATION: pcp_child.c:297 Sep 30 13:20:25 proxy-psql0-stage-cn1 pgpool[8813]: 2022-09-30 13:20:25.416: pcp_child pid 8813: FATAL: authentication failed for user "pcpadm" Sep 30 13:20:25 proxy-psql0-stage-cn1 pgpool[8813]: 2022-09-30 13:20:25.416: pcp_child pid 8813: DETAIL: username and/or password does not match Sep 30 13:20:25 proxy-psql0-stage-cn1 pgpool[8813]: 2022-09-30 13:20:25.416: pcp_child pid 8813: LOCATION: pcp_worker.c:517 Sep 30 13:20:25 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:25.418: pcp_main pid 8791: LOG: PCP process with pid: 8813 exit with SUCCESS. Sep 30 13:20:25 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:25.418: pcp_main pid 8791: LOCATION: pcp_child.c:354 Sep 30 13:20:25 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:25.418: pcp_main pid 8791: LOG: PCP process with pid: 8813 exits with status 256 Sep 30 13:20:25 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:25.418: pcp_main pid 8791: LOCATION: pcp_child.c:368 Sep 30 13:20:26 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:26.619: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:20:26 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:26.619: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:20:36 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:36.694: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:20:36 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:36.694: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:20:46 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:46.804: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:20:46 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:46.804: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:20:47 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:47.813: pcp_main pid 8791: LOG: forked new pcp worker, pid=8817 socket=7 Sep 30 13:20:47 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:47.813: pcp_main pid 8791: LOCATION: pcp_child.c:297 Sep 30 13:20:47 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:47.815: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:20:47 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:47.815: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:20:47 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:47.819: pcp_main pid 8791: LOG: PCP process with pid: 8817 exit with SUCCESS. Sep 30 13:20:47 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:47.819: pcp_main pid 8791: LOCATION: pcp_child.c:354 Sep 30 13:20:47 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:47.819: pcp_main pid 8791: LOG: PCP process with pid: 8817 exits with status 0 Sep 30 13:20:47 proxy-psql0-stage-cn1 pgpool[8791]: 2022-09-30 13:20:47.819: pcp_main pid 8791: LOCATION: pcp_child.c:368 Sep 30 13:20:56 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:56.901: watchdog pid 8748: LOG: new IPC connection received Sep 30 13:20:56 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:56.901: watchdog pid 8748: LOCATION: watchdog.c:3438 Sep 30 13:20:57 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:20:57.098: main pid 8745: LOG: shutting down by signal 2 Sep 30 13:20:57 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:20:57.098: main pid 8745: LOCATION: pgpool_main.c:1184 Sep 30 13:20:57 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:20:57.098: main pid 8745: LOG: terminating all child processes Sep 30 13:20:57 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:20:57.098: main pid 8745: LOCATION: pgpool_main.c:1194 Sep 30 13:20:57 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:57.134: watchdog pid 8748: LOG: Watchdog is shutting down Sep 30 13:20:57 proxy-psql0-stage-cn1 pgpool[8748]: 2022-09-30 13:20:57.134: watchdog pid 8748: LOCATION: watchdog.c:3292 Sep 30 13:20:57 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:20:57.144: main pid 8745: LOG: Pgpool-II system is shutdown Sep 30 13:20:57 proxy-psql0-stage-cn1 pgpool[8745]: 2022-09-30 13:20:57.144: main pid 8745: LOCATION: pgpool_main.c:1222