2023-12-13 00:06:29.178: DBeaver 23.3.0 - Metadata pid 3301839: LOG: Sync message from frontend. 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: Parse message from frontend. 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: DETAIL: statement: "", query: "BEGIN" 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: Parse: BEGIN 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 3 backend pid: 3095827 statement: Parse: BEGIN 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: Bind message from frontend. 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: DETAIL: portal: "", statement: "" 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: Bind: BEGIN 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 3 backend pid: 3095827 statement: Bind: BEGIN 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: Execute message from frontend. 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: DETAIL: portal: "" 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: statement: BEGIN 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: Execute: BEGIN 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 3 backend pid: 3095827 statement: Execute: BEGIN 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: Parse message from frontend. 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: DETAIL: statement: "", query: "ALTER ROLE user_centralizador SUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS" 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: Parse: ALTER ROLE user_centralizador SUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOB YPASSRLS 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: Bind message from frontend. 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: DETAIL: portal: "", statement: "" 2023-12-13 00:06:40.765: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: Bind: ALTER ROLE user_centralizador SUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBY PASSRLS 2023-12-13 00:06:40.766: DBeaver 23.3.0 - Main pid 3297069: LOG: Describe message from frontend. 2023-12-13 00:06:40.766: DBeaver 23.3.0 - Main pid 3297069: DETAIL: portal: "" 2023-12-13 00:06:40.766: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: D message 2023-12-13 00:06:40.766: DBeaver 23.3.0 - Main pid 3297069: LOG: Execute message from frontend. 2023-12-13 00:06:40.766: DBeaver 23.3.0 - Main pid 3297069: DETAIL: portal: "" 2023-12-13 00:06:40.766: DBeaver 23.3.0 - Main pid 3297069: LOG: statement: ALTER ROLE user_centralizador SUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS 2023-12-13 00:06:40.766: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: Execute: ALTER ROLE user_centralizador SUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION N OBYPASSRLS 2023-12-13 00:06:40.766: DBeaver 23.3.0 - Main pid 3297069: LOG: Sync message from frontend. 2023-12-13 00:06:40.767: DBeaver 23.3.0 - Main pid 3297069: LOG: Error message from backend: DB node id: 1 message: "cannot execute ALTER ROLE in a read-only transaction" 2023-12-13 00:06:40.776: DBeaver 23.3.0 - Main pid 3297069: LOG: Parse message from frontend. 2023-12-13 00:06:40.776: DBeaver 23.3.0 - Main pid 3297069: DETAIL: statement: "", query: "ROLLBACK" 2023-12-13 00:06:40.776: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: Parse: ROLLBACK 2023-12-13 00:06:40.776: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 3 backend pid: 3095827 statement: Parse: ROLLBACK 2023-12-13 00:06:40.776: DBeaver 23.3.0 - Main pid 3297069: LOG: Bind message from frontend. 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: DETAIL: portal: "", statement: "" 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: Bind: ROLLBACK 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 3 backend pid: 3095827 statement: Bind: ROLLBACK 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: LOG: Execute message from frontend. 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: DETAIL: portal: "" 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: LOG: statement: ROLLBACK 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: Execute: ROLLBACK 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 3 backend pid: 3095827 statement: Execute: ROLLBACK 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: LOG: unset_tx_started_by_multi_statement_query is called in CommandComplete 2023-12-13 00:06:40.777: DBeaver 23.3.0 - Main pid 3297069: LOG: Sync message from frontend. 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Main pid 3297069: LOG: Error message from backend: DB node id: 1 message: "terminating connection due to conflict with recovery" 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Metadata pid 3301839: LOG: Error message from backend: DB node id: 1 message: "terminating connection due to conflict with recovery" 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Metadata pid 3301839: ERROR: unable to forward message to frontend 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Metadata pid 3301839: DETAIL: FATAL error occurred on backend 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Main pid 3297069: ERROR: unable to forward message to frontend 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Main pid 3297069: DETAIL: FATAL error occurred on backend 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Metadata pid 3301839: LOG: statement: DISCARD ALL 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Main pid 3297069: LOG: statement: DISCARD ALL 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Metadata pid 3301839: LOG: DB node id: 1 backend pid: 1286990 statement: DISCARD ALL 2023-12-13 00:07:48.267: DBeaver 23.3.0 - Main pid 3297069: LOG: DB node id: 1 backend pid: 1286988 statement: DISCARD ALL 2023-12-13 00:07:48.272: DBeaver 23.3.0 - Main pid 3297069: LOG: received degenerate backend request for node_id: 1 from pid [3297069] 2023-12-13 00:07:48.272: DBeaver 23.3.0 - Main pid 3297069: LOG: signal_user1_to_parent_with_reason(0) 2023-12-13 00:07:48.272: main pid 3286333: LOG: Pgpool-II parent process received SIGUSR1 2023-12-13 00:07:48.272: main pid 3286333: LOG: Pgpool-II parent process has received failover request 2023-12-13 00:07:48.272: main pid 3286333: LOG: === Starting degeneration. shutdown host 192.168.2.151(5432) === 2023-12-13 00:07:48.274: DBeaver 23.3.0 - Metadata pid 3301839: LOG: received degenerate backend request for node_id: 1 from pid [3301839] 2023-12-13 00:07:48.274: main pid 3286333: LOG: Restart all children 2023-12-13 00:07:48.373: main pid 3286333: LOG: find_primary_node_repeatedly: waiting for finding a primary node 2023-12-13 00:07:48.395: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:48.395: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:48.395: main pid 3286333: LOG: reaper handler 2023-12-13 00:07:49.423: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:49.423: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:50.449: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:50.449: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:51.475: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:51.475: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:52.502: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:52.502: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:53.528: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:53.529: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:54.555: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:54.555: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:55.581: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:55.581: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:56.606: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:56.606: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:57.632: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:57.633: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:58.660: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:58.660: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:07:59.686: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:07:59.686: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:00.712: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:00.712: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:01.738: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:01.738: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:02.764: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:02.765: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:03.790: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:03.790: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:04.815: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:04.815: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:05.840: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:05.841: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:06.868: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:06.868: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:07.894: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:07.894: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:08.919: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:08.919: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:09.945: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:09.945: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:10.972: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:10.972: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:11.998: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:11.998: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:13.025: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:13.025: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:14.053: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:14.053: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:15.078: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:15.078: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:16.105: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:16.105: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:17.131: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:17.131: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:18.157: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:18.157: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:19.182: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:19.183: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:20.209: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:20.209: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:21.234: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:21.234: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:22.262: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:22.262: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:23.287: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:23.287: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:24.313: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:24.313: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:25.339: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:25.339: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:26.365: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:26.365: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:27.391: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:27.391: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:28.417: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:28.417: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:29.445: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:29.445: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:30.471: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:30.471: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:31.497: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:31.497: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:32.524: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:32.524: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:33.551: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:33.551: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:34.577: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:34.577: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:35.604: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:35.604: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:36.629: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:36.629: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:37.656: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:37.656: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:38.681: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:38.682: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:39.709: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:39.709: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:40.735: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:40.735: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:41.761: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:41.761: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:42.788: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:42.788: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:43.815: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:43.815: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:44.840: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:44.841: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:45.866: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:45.866: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:46.893: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:46.893: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:47.919: main pid 3286333: LOG: find_primary_node: standby node is 2 2023-12-13 00:08:47.919: main pid 3286333: LOG: find_primary_node: standby node is 3 2023-12-13 00:08:48.920: main pid 3286333: LOG: failed to find primary node 2023-12-13 00:08:48.920: main pid 3286333: DETAIL: find_primary_node_repeatedly: expired after 60 seconds 2023-12-13 00:08:48.921: main pid 3286333: LOG: failover: set new primary node: -1 2023-12-13 00:08:48.921: main pid 3286333: LOG: failover: set new main node: 2 2023-12-13 00:08:49.047: sr_check_worker pid 3294538: LOG: worker process received restart request 2023-12-13 00:08:49.047: main pid 3286333: LOG: === Failover done. shutdown host 192.168.2.151(5432) === 2023-12-13 00:08:49.047: main pid 3286333: LOG: failover: no backends are degenerated 2023-12-13 00:08:50.048: pcp_main pid 3294537: LOG: restart request received in pcp child process 2023-12-13 00:08:50.050: main pid 3286333: LOG: PCP child 3294537 exits with status 0 in failover() 2023-12-13 00:08:50.052: main pid 3286333: LOG: fork a new PCP child pid 3335401 in failover() 2023-12-13 00:08:50.052: main pid 3286333: LOG: reaper handler 2023-12-13 00:08:50.052: pcp_main pid 3335401: LOG: PCP process: 3335401 started 2023-12-13 00:08:50.053: sr_check_worker pid 3335402: LOG: process started 2023-12-13 00:08:50.059: main pid 3286333: LOG: reaper handler: exiting normally 2023-12-13 00:10:31.738: child pid 3335390: LOG: new connection received 2023-12-13 00:10:31.738: child pid 3335390: DETAIL: connecting host=_gateway port=56767 2023-12-13 00:10:31.754: child pid 3335390: LOG: using clear text authentication with frontend 2023-12-13 00:10:31.754: child pid 3335390: DETAIL: backend will still use SCRAM auth 2023-12-13 00:10:31.754: child pid 3335390: HINT: you can disable this behavior by setting allow_clear_text_frontend_auth to off