__PostgreSQL中文社区: 世界上功能最强大的开源数据库....

PG中文社区 /

mdi-home

首页

社区新闻

中文文档

加入ACE

mdi-home

首页

mdi-chat-processing

社区新闻

mdi-book-open-variant

中文文档

mdi-account-multiple-check

加入ACE

mdi-file-multiple-outline

相关资料

mdi-blank

mdi-exit-to-app

退出账号

liuluhao	所有从节点无故进程被依次杀掉（集群使用pgpool-ii管理） ... ... 2019-08-15 18:09:28+08...1楼
	Aug 15 09:44:51 pgsql_7 pgpool[189881]: [37-1] 2019-08-15 09:44:51: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:44:51 pgsql_7 pgpool[189879]: [24-1] 2019-08-15 09:44:51: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:44:51 pgsql_7 pgpool[189879]: [25-1] 2019-08-15 09:44:51: pid 189879: LOG: Pgpool-II parent process received sync backend signal from watchdog Aug 15 09:44:51 pgsql_7 pgpool[189881]: [38-1] 2019-08-15 09:44:51: pid 189881: LOG: new IPC connection received Aug 15 09:44:51 pgsql_7 pgpool[189879]: [26-1] 2019-08-15 09:44:51: pid 189879: LOG: master watchdog has performed failover Aug 15 09:44:51 pgsql_7 pgpool[189879]: [26-2] 2019-08-15 09:44:51: pid 189879: DETAIL: syncing the backend states from the MASTER watchdog node Aug 15 09:44:51 pgsql_7 pgpool[189881]: [39-1] 2019-08-15 09:44:51: pid 189881: LOG: new IPC connection received Aug 15 09:44:51 pgsql_7 pgpool[189881]: [40-1] 2019-08-15 09:44:51: pid 189881: LOG: received the get data request from local pgpool-II on IPC interface Aug 15 09:44:51 pgsql_7 pgpool[189881]: [41-1] 2019-08-15 09:44:51: pid 189881: LOG: get data request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:44:51 pgsql_7 pgpool[189881]: [41-2] 2019-08-15 09:44:51: pid 189881: DETAIL: waiting for the reply... Aug 15 09:44:51 pgsql_7 pgpool[189879]: [27-1] 2019-08-15 09:44:51: pid 189879: LOG: master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" returned status for 5 backend nodes Aug 15 09:44:51 pgsql_7 pgpool[189879]: [28-1] 2019-08-15 09:44:51: pid 189879: LOG: backend nodes status remains same after the sync from "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:44:51 pgsql_7 pgpool[189881]: [42-1] 2019-08-15 09:44:51: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:44:51 pgsql_7 pgpool[189879]: [29-1] 2019-08-15 09:44:51: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:44:51 pgsql_7 pgpool[189881]: [43-1] 2019-08-15 09:44:51: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:44:51 pgsql_7 pgpool[189879]: [30-1] 2019-08-15 09:44:51: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:44:51 pgsql_7 pgpool[190803]: [16-1] 2019-08-15 09:44:51: pid 190803: ERROR: failed to authenticate Aug 15 09:44:51 pgsql_7 pgpool[190803]: [16-2] 2019-08-15 09:44:51: pid 190803: DETAIL: the database system is in recovery mode Aug 15 09:44:51 pgsql_7 pgpool[190803]: [17-1] 2019-08-15 09:44:51: pid 190803: LOG: health check retrying on DB node: 2 (round:1) Aug 15 09:44:52 pgsql_7 pgpool[189879]: [31-1] 2019-08-15 09:44:52: pid 189879: LOG: Pgpool-II parent process received sync backend signal from watchdog Aug 15 09:44:52 pgsql_7 pgpool[189881]: [44-1] 2019-08-15 09:44:52: pid 189881: LOG: new IPC connection received Aug 15 09:44:52 pgsql_7 pgpool[189879]: [32-1] 2019-08-15 09:44:52: pid 189879: LOG: master watchdog has performed failover Aug 15 09:44:52 pgsql_7 pgpool[189879]: [32-2] 2019-08-15 09:44:52: pid 189879: DETAIL: syncing the backend states from the MASTER watchdog node Aug 15 09:44:52 pgsql_7 pgpool[189881]: [45-1] 2019-08-15 09:44:52: pid 189881: LOG: new IPC connection received Aug 15 09:44:52 pgsql_7 pgpool[189881]: [46-1] 2019-08-15 09:44:52: pid 189881: LOG: received the get data request from local pgpool-II on IPC interface Aug 15 09:44:52 pgsql_7 pgpool[189881]: [47-1] 2019-08-15 09:44:52: pid 189881: LOG: get data request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:44:52 pgsql_7 pgpool[189881]: [47-2] 2019-08-15 09:44:52: pid 189881: DETAIL: waiting for the reply... Aug 15 09:44:52 pgsql_7 pgpool[189879]: [33-1] 2019-08-15 09:44:52: pid 189879: LOG: master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" returned status for 5 backend nodes Aug 15 09:44:52 pgsql_7 pgpool[189879]: [34-1] 2019-08-15 09:44:52: pid 189879: LOG: backend nodes status remains same after the sync from "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:44:52 pgsql_7 pgpool[189879]: [35-1] 2019-08-15 09:44:52: pid 189879: LOG: Pgpool-II parent process received sync backend signal from watchdog Aug 15 09:44:52 pgsql_7 pgpool[189881]: [48-1] 2019-08-15 09:44:52: pid 189881: LOG: new IPC connection received Aug 15 09:44:52 pgsql_7 pgpool[189879]: [36-1] 2019-08-15 09:44:52: pid 189879: LOG: master watchdog has performed failover Aug 15 09:44:52 pgsql_7 pgpool[189879]: [36-2] 2019-08-15 09:44:52: pid 189879: DETAIL: syncing the backend states from the MASTER watchdog node Aug 15 09:44:52 pgsql_7 pgpool[189881]: [49-1] 2019-08-15 09:44:52: pid 189881: LOG: new IPC connection received Aug 15 09:44:52 pgsql_7 pgpool[189881]: [50-1] 2019-08-15 09:44:52: pid 189881: LOG: received the get data request from local pgpool-II on IPC interface Aug 15 09:44:52 pgsql_7 pgpool[189881]: [51-1] 2019-08-15 09:44:52: pid 189881: LOG: get data request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:44:52 pgsql_7 pgpool[189881]: [51-2] 2019-08-15 09:44:52: pid 189881: DETAIL: waiting for the reply... Aug 15 09:44:52 pgsql_7 pgpool[189879]: [37-1] 2019-08-15 09:44:52: pid 189879: LOG: master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" returned status for 5 backend nodes Aug 15 09:44:52 pgsql_7 pgpool[189879]: [38-1] 2019-08-15 09:44:52: pid 189879: LOG: backend nodes status remains same after the sync from "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:44:52 pgsql_7 pgpool[189879]: [39-1] 2019-08-15 09:44:52: pid 189879: LOG: Pgpool-II parent process received sync backend signal from watchdog Aug 15 09:44:52 pgsql_7 pgpool[189881]: [52-1] 2019-08-15 09:44:52: pid 189881: LOG: new IPC connection received Aug 15 09:44:52 pgsql_7 pgpool[189879]: [40-1] 2019-08-15 09:44:52: pid 189879: LOG: master watchdog has performed failover Aug 15 09:44:52 pgsql_7 pgpool[189879]: [40-2] 2019-08-15 09:44:52: pid 189879: DETAIL: syncing the backend states from the MASTER watchdog node Aug 15 09:44:52 pgsql_7 pgpool[189881]: [53-1] 2019-08-15 09:44:52: pid 189881: LOG: new IPC connection received Aug 15 09:44:52 pgsql_7 pgpool[189881]: [54-1] 2019-08-15 09:44:52: pid 189881: LOG: received the get data request from local pgpool-II on IPC interface Aug 15 09:44:52 pgsql_7 pgpool[189881]: [55-1] 2019-08-15 09:44:52: pid 189881: LOG: get data request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:44:52 pgsql_7 pgpool[189881]: [55-2] 2019-08-15 09:44:52: pid 189881: DETAIL: waiting for the reply... Aug 15 09:44:52 pgsql_7 pgpool[189879]: [41-1] 2019-08-15 09:44:52: pid 189879: LOG: master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" returned status for 5 backend nodes Aug 15 09:44:52 pgsql_7 pgpool[189879]: [42-1] 2019-08-15 09:44:52: pid 189879: LOG: backend nodes status remains same after the sync from "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:44:53 pgsql_7 pgpool[190799]: [16-1] 2019-08-15 09:44:53: pid 190799: ERROR: unable to read data from DB node 1 Aug 15 09:44:53 pgsql_7 pgpool[190799]: [16-2] 2019-08-15 09:44:53: pid 190799: DETAIL: socket read failed with an error "Connection reset by peer" Aug 15 09:44:53 pgsql_7 pgpool[190801]: [16-1] 2019-08-15 09:44:53: pid 190801: ERROR: unable to read data from DB node 1 Aug 15 09:44:53 pgsql_7 pgpool[190801]: [16-2] 2019-08-15 09:44:53: pid 190801: DETAIL: socket read failed with an error "Connection reset by peer" Aug 15 09:44:53 pgsql_7 pgpool[190801]: [17-1] 2019-08-15 09:44:53: pid 190801: LOG: health check retrying on DB node: 1 (round:1) Aug 15 09:44:53 pgsql_7 pgpool[190799]: [17-1] 2019-08-15 09:44:53: pid 190799: LOG: failed to connect to PostgreSQL server on "node_2:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:53 pgsql_7 pgpool[190799]: [18-1] 2019-08-15 09:44:53: pid 190799: ERROR: failed to make persistent db connection Aug 15 09:44:53 pgsql_7 pgpool[190799]: [18-2] 2019-08-15 09:44:53: pid 190799: DETAIL: connection to host:"node_2:5432" failed Aug 15 09:44:53 pgsql_7 pgpool[190799]: [19-1] 2019-08-15 09:44:53: pid 190799: LOG: failed to connect to PostgreSQL server on "node_3:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:53 pgsql_7 pgpool[190799]: [20-1] 2019-08-15 09:44:53: pid 190799: ERROR: failed to make persistent db connection Aug 15 09:44:53 pgsql_7 pgpool[190799]: [20-2] 2019-08-15 09:44:53: pid 190799: DETAIL: connection to host:"node_3:5432" failed Aug 15 09:44:53 pgsql_7 pgpool[190799]: [21-1] 2019-08-15 09:44:53: pid 190799: ERROR: unable to read data from DB node 4 Aug 15 09:44:53 pgsql_7 pgpool[190799]: [21-2] 2019-08-15 09:44:53: pid 190799: DETAIL: socket read failed with an error "Connection reset by peer" Aug 15 09:44:53 pgsql_7 pgpool[190806]: [16-1] 2019-08-15 09:44:53: pid 190806: ERROR: unable to read data from DB node 4 Aug 15 09:44:53 pgsql_7 pgpool[190806]: [16-2] 2019-08-15 09:44:53: pid 190806: DETAIL: socket read failed with an error "Connection reset by peer" Aug 15 09:44:53 pgsql_7 pgpool[190806]: [17-1] 2019-08-15 09:44:53: pid 190806: LOG: health check retrying on DB node: 4 (round:1) Aug 15 09:44:54 pgsql_7 pgpool[190803]: [18-1] 2019-08-15 09:44:54: pid 190803: LOG: failed to connect to PostgreSQL server on "node_2:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:54 pgsql_7 pgpool[190803]: [19-1] 2019-08-15 09:44:54: pid 190803: ERROR: failed to make persistent db connection Aug 15 09:44:54 pgsql_7 pgpool[190803]: [19-2] 2019-08-15 09:44:54: pid 190803: DETAIL: connection to host:"node_2:5432" failed Aug 15 09:44:54 pgsql_7 pgpool[190803]: [20-1] 2019-08-15 09:44:54: pid 190803: LOG: health check retrying on DB node: 2 (round:2) Aug 15 09:44:55 pgsql_7 pgpool[190805]: [16-1] 2019-08-15 09:44:55: pid 190805: LOG: failed to connect to PostgreSQL server on "node_3:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:55 pgsql_7 pgpool[190805]: [17-1] 2019-08-15 09:44:55: pid 190805: ERROR: failed to make persistent db connection Aug 15 09:44:55 pgsql_7 pgpool[190805]: [17-2] 2019-08-15 09:44:55: pid 190805: DETAIL: connection to host:"node_3:5432" failed Aug 15 09:44:55 pgsql_7 pgpool[190805]: [18-1] 2019-08-15 09:44:55: pid 190805: LOG: health check retrying on DB node: 3 (round:1) Aug 15 09:44:56 pgsql_7 pgpool[190801]: [18-1] 2019-08-15 09:44:56: pid 190801: LOG: failed to connect to PostgreSQL server on "node_1:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:56 pgsql_7 pgpool[190801]: [19-1] 2019-08-15 09:44:56: pid 190801: ERROR: failed to make persistent db connection Aug 15 09:44:56 pgsql_7 pgpool[190801]: [19-2] 2019-08-15 09:44:56: pid 190801: DETAIL: connection to host:"node_1:5432" failed Aug 15 09:44:56 pgsql_7 pgpool[190801]: [20-1] 2019-08-15 09:44:56: pid 190801: LOG: health check retrying on DB node: 1 (round:2) Aug 15 09:44:56 pgsql_7 pgpool[190806]: [18-1] 2019-08-15 09:44:56: pid 190806: LOG: failed to connect to PostgreSQL server on "node_4:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:56 pgsql_7 pgpool[190806]: [19-1] 2019-08-15 09:44:56: pid 190806: ERROR: failed to make persistent db connection Aug 15 09:44:56 pgsql_7 pgpool[190806]: [19-2] 2019-08-15 09:44:56: pid 190806: DETAIL: connection to host:"node_4:5432" failed Aug 15 09:44:56 pgsql_7 pgpool[190806]: [20-1] 2019-08-15 09:44:56: pid 190806: LOG: health check retrying on DB node: 4 (round:2) Aug 15 09:44:57 pgsql_7 pgpool[190803]: [21-1] 2019-08-15 09:44:57: pid 190803: LOG: failed to connect to PostgreSQL server on "node_2:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:57 pgsql_7 pgpool[190803]: [22-1] 2019-08-15 09:44:57: pid 190803: ERROR: failed to make persistent db connection Aug 15 09:44:57 pgsql_7 pgpool[190803]: [22-2] 2019-08-15 09:44:57: pid 190803: DETAIL: connection to host:"node_2:5432" failed Aug 15 09:44:57 pgsql_7 pgpool[190803]: [23-1] 2019-08-15 09:44:57: pid 190803: LOG: health check retrying on DB node: 2 (round:3) Aug 15 09:44:58 pgsql_7 pgpool[190805]: [19-1] 2019-08-15 09:44:58: pid 190805: LOG: failed to connect to PostgreSQL server on "node_3:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:58 pgsql_7 pgpool[190805]: [20-1] 2019-08-15 09:44:58: pid 190805: ERROR: failed to make persistent db connection Aug 15 09:44:58 pgsql_7 pgpool[190805]: [20-2] 2019-08-15 09:44:58: pid 190805: DETAIL: connection to host:"node_3:5432" failed Aug 15 09:44:58 pgsql_7 pgpool[190805]: [21-1] 2019-08-15 09:44:58: pid 190805: LOG: health check retrying on DB node: 3 (round:2) Aug 15 09:44:59 pgsql_7 pgpool[190801]: [21-1] 2019-08-15 09:44:59: pid 190801: LOG: failed to connect to PostgreSQL server on "node_1:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:59 pgsql_7 pgpool[190801]: [22-1] 2019-08-15 09:44:59: pid 190801: ERROR: failed to make persistent db connection Aug 15 09:44:59 pgsql_7 pgpool[190801]: [22-2] 2019-08-15 09:44:59: pid 190801: DETAIL: connection to host:"node_1:5432" failed Aug 15 09:44:59 pgsql_7 pgpool[190801]: [23-1] 2019-08-15 09:44:59: pid 190801: LOG: health check retrying on DB node: 1 (round:3) Aug 15 09:44:59 pgsql_7 pgpool[190806]: [21-1] 2019-08-15 09:44:59: pid 190806: LOG: failed to connect to PostgreSQL server on "node_4:5432", getsockopt() detected error "Connection refused" Aug 15 09:44:59 pgsql_7 pgpool[190806]: [22-1] 2019-08-15 09:44:59: pid 190806: ERROR: failed to make persistent db connection Aug 15 09:44:59 pgsql_7 pgpool[190806]: [22-2] 2019-08-15 09:44:59: pid 190806: DETAIL: connection to host:"node_4:5432" failed Aug 15 09:44:59 pgsql_7 pgpool[190806]: [23-1] 2019-08-15 09:44:59: pid 190806: LOG: health check retrying on DB node: 4 (round:3) Aug 15 09:45:00 pgsql_7 pgpool[190803]: [24-1] 2019-08-15 09:45:00: pid 190803: LOG: failed to connect to PostgreSQL server on "node_2:5432", getsockopt() detected error "Connection refused" Aug 15 09:45:00 pgsql_7 pgpool[190803]: [25-1] 2019-08-15 09:45:00: pid 190803: ERROR: failed to make persistent db connection Aug 15 09:45:00 pgsql_7 pgpool[190803]: [25-2] 2019-08-15 09:45:00: pid 190803: DETAIL: connection to host:"node_2:5432" failed Aug 15 09:45:00 pgsql_7 pgpool[190803]: [26-1] 2019-08-15 09:45:00: pid 190803: LOG: health check failed on node 2 (timeout:0) Aug 15 09:45:00 pgsql_7 pgpool[190803]: [27-1] 2019-08-15 09:45:00: pid 190803: LOG: received degenerate backend request for node_id: 2 from pid [190803] Aug 15 09:45:00 pgsql_7 pgpool[189881]: [56-1] 2019-08-15 09:45:00: pid 189881: LOG: new IPC connection received Aug 15 09:45:00 pgsql_7 pgpool[189881]: [57-1] 2019-08-15 09:45:00: pid 189881: LOG: failover request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:00 pgsql_7 pgpool[189881]: [57-2] 2019-08-15 09:45:00: pid 189881: DETAIL: waiting for the reply... Aug 15 09:45:00 pgsql_7 pgpool[189881]: [58-1] 2019-08-15 09:45:00: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:00 pgsql_7 pgpool[189879]: [43-1] 2019-08-15 09:45:00: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:00 pgsql_7 pgpool[190803]: [28-1] 2019-08-15 09:45:00: pid 190803: LOG: degenerate backend request for node_id: 2 from pid [190803], will be handled by watchdog, which is building consensus for request Aug 15 09:45:00 pgsql_7 pgpool[189881]: [59-1] 2019-08-15 09:45:00: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:00 pgsql_7 pgpool[189879]: [44-1] 2019-08-15 09:45:00: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:00 pgsql_7 pgpool[189881]: [60-1] 2019-08-15 09:45:00: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:00 pgsql_7 pgpool[189879]: [45-1] 2019-08-15 09:45:00: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:01 pgsql_7 pgpool[189881]: [61-1] 2019-08-15 09:45:01: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:01 pgsql_7 pgpool[189879]: [46-1] 2019-08-15 09:45:01: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:01 pgsql_7 pgpool[189881]: [62-1] 2019-08-15 09:45:01: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:01 pgsql_7 pgpool[189879]: [47-1] 2019-08-15 09:45:01: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:01 pgsql_7 pgpool[189879]: [48-1] 2019-08-15 09:45:01: pid 189879: LOG: Pgpool-II parent process received sync backend signal from watchdog Aug 15 09:45:01 pgsql_7 pgpool[189881]: [63-1] 2019-08-15 09:45:01: pid 189881: LOG: new IPC connection received Aug 15 09:45:01 pgsql_7 pgpool[189879]: [49-1] 2019-08-15 09:45:01: pid 189879: LOG: master watchdog has performed failover Aug 15 09:45:01 pgsql_7 pgpool[189879]: [49-2] 2019-08-15 09:45:01: pid 189879: DETAIL: syncing the backend states from the MASTER watchdog node Aug 15 09:45:01 pgsql_7 pgpool[189881]: [64-1] 2019-08-15 09:45:01: pid 189881: LOG: new IPC connection received Aug 15 09:45:01 pgsql_7 pgpool[189881]: [65-1] 2019-08-15 09:45:01: pid 189881: LOG: received the get data request from local pgpool-II on IPC interface Aug 15 09:45:01 pgsql_7 pgpool[189881]: [66-1] 2019-08-15 09:45:01: pid 189881: LOG: get data request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:01 pgsql_7 pgpool[189881]: [66-2] 2019-08-15 09:45:01: pid 189881: DETAIL: waiting for the reply... Aug 15 09:45:01 pgsql_7 pgpool[189879]: [50-1] 2019-08-15 09:45:01: pid 189879: LOG: master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" returned status for 5 backend nodes Aug 15 09:45:01 pgsql_7 pgpool[189879]: [51-1] 2019-08-15 09:45:01: pid 189879: LOG: backend:2 is set to down status Aug 15 09:45:01 pgsql_7 pgpool[189879]: [51-2] 2019-08-15 09:45:01: pid 189879: DETAIL: backend:2 is DOWN on cluster master "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:01 pgsql_7 pgpool[189879]: [52-1] 2019-08-15 09:45:01: pid 189879: LOG: 1 backend node(s) were detached because of backend status sync from "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:01 pgsql_7 pgpool[189879]: [52-2] 2019-08-15 09:45:01: pid 189879: DETAIL: restarting the children processes Aug 15 09:45:01 pgsql_7 pgpool[189879]: [53-1] 2019-08-15 09:45:01: pid 189879: LOG: Node 0 is not down (status: 1) Aug 15 09:45:01 pgsql_7 pgpool[190799]: [22-1] 2019-08-15 09:45:01: pid 190799: ERROR: Failed to check replication time lag Aug 15 09:45:01 pgsql_7 pgpool[190799]: [22-2] 2019-08-15 09:45:01: pid 190799: DETAIL: No persistent db connection for the node 1 Aug 15 09:45:01 pgsql_7 pgpool[190799]: [22-3] 2019-08-15 09:45:01: pid 190799: HINT: check sr_check_user and sr_check_password Aug 15 09:45:01 pgsql_7 pgpool[190799]: [22-4] 2019-08-15 09:45:01: pid 190799: CONTEXT: while checking replication time lag Aug 15 09:45:01 pgsql_7 pgpool[190799]: [23-1] 2019-08-15 09:45:01: pid 190799: LOG: worker process received restart request Aug 15 09:45:01 pgsql_7 pgpool[190805]: [22-1] 2019-08-15 09:45:01: pid 190805: LOG: failed to connect to PostgreSQL server on "node_3:5432", getsockopt() detected error "Connection refused" Aug 15 09:45:01 pgsql_7 pgpool[190805]: [23-1] 2019-08-15 09:45:01: pid 190805: ERROR: failed to make persistent db connection Aug 15 09:45:01 pgsql_7 pgpool[190805]: [23-2] 2019-08-15 09:45:01: pid 190805: DETAIL: connection to host:"node_3:5432" failed Aug 15 09:45:01 pgsql_7 pgpool[190805]: [24-1] 2019-08-15 09:45:01: pid 190805: LOG: health check retrying on DB node: 3 (round:3) Aug 15 09:45:01 pgsql_7 pgpool[189879]: [54-1] 2019-08-15 09:45:01: pid 189879: LOG: worker child process with pid: 190799 exits with status 256 Aug 15 09:45:01 pgsql_7 pgpool[189879]: [55-1] 2019-08-15 09:45:01: pid 189879: LOG: fork a new worker child process with pid: 354973 Aug 15 09:45:01 pgsql_7 pgpool[354973]: [55-1] 2019-08-15 09:45:01: pid 354973: LOG: failed to connect to PostgreSQL server on "node_1:5432", getsockopt() detected error "Connection refused" Aug 15 09:45:02 pgsql_7 pgpool[354973]: [56-1] 2019-08-15 09:45:01: pid 354973: ERROR: failed to make persistent db connection Aug 15 09:45:02 pgsql_7 pgpool[354973]: [56-2] 2019-08-15 09:45:01: pid 354973: DETAIL: connection to host:"node_1:5432" failed Aug 15 09:45:02 pgsql_7 pgpool[354973]: [57-1] 2019-08-15 09:45:01: pid 354973: LOG: failed to connect to PostgreSQL server on "node_3:5432", getsockopt() detected error "Connection refused" Aug 15 09:45:02 pgsql_7 pgpool[354973]: [58-1] 2019-08-15 09:45:01: pid 354973: ERROR: failed to make persistent db connection Aug 15 09:45:02 pgsql_7 pgpool[354973]: [58-2] 2019-08-15 09:45:01: pid 354973: DETAIL: connection to host:"node_3:5432" failed Aug 15 09:45:02 pgsql_7 pgpool[354973]: [59-1] 2019-08-15 09:45:01: pid 354973: LOG: failed to connect to PostgreSQL server on "node_4:5432", getsockopt() detected error "Connection refused" Aug 15 09:45:02 pgsql_7 pgpool[354973]: [60-1] 2019-08-15 09:45:01: pid 354973: ERROR: failed to make persistent db connection Aug 15 09:45:02 pgsql_7 pgpool[354973]: [60-2] 2019-08-15 09:45:01: pid 354973: DETAIL: connection to host:"node_4:5432" failed Aug 15 09:45:02 pgsql_7 pgpool[190801]: [24-1] 2019-08-15 09:45:02: pid 190801: LOG: failed to connect to PostgreSQL server on "node_1:5432", getsockopt() detected error "Connection refused" Aug 15 09:45:02 pgsql_7 pgpool[190801]: [25-1] 2019-08-15 09:45:02: pid 190801: ERROR: failed to make persistent db connection Aug 15 09:45:02 pgsql_7 pgpool[190801]: [25-2] 2019-08-15 09:45:02: pid 190801: DETAIL: connection to host:"node_1:5432" failed Aug 15 09:45:02 pgsql_7 pgpool[190801]: [26-1] 2019-08-15 09:45:02: pid 190801: LOG: health check failed on node 1 (timeout:0) Aug 15 09:45:02 pgsql_7 pgpool[190801]: [27-1] 2019-08-15 09:45:02: pid 190801: LOG: received degenerate backend request for node_id: 1 from pid [190801] Aug 15 09:45:02 pgsql_7 pgpool[189881]: [67-1] 2019-08-15 09:45:02: pid 189881: LOG: new IPC connection received Aug 15 09:45:02 pgsql_7 pgpool[189881]: [68-1] 2019-08-15 09:45:02: pid 189881: LOG: failover request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:02 pgsql_7 pgpool[189881]: [68-2] 2019-08-15 09:45:02: pid 189881: DETAIL: waiting for the reply... Aug 15 09:45:02 pgsql_7 pgpool[189881]: [69-1] 2019-08-15 09:45:02: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:02 pgsql_7 pgpool[190801]: [28-1] 2019-08-15 09:45:02: pid 190801: LOG: degenerate backend request for node_id: 1 from pid [190801], will be handled by watchdog, which is building consensus for request Aug 15 09:45:02 pgsql_7 pgpool[189879]: [56-1] 2019-08-15 09:45:02: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:02 pgsql_7 pgpool[189881]: [70-1] 2019-08-15 09:45:02: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:02 pgsql_7 pgpool[189879]: [57-1] 2019-08-15 09:45:02: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:02 pgsql_7 pgpool[189881]: [71-1] 2019-08-15 09:45:02: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:02 pgsql_7 pgpool[189879]: [58-1] 2019-08-15 09:45:02: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:02 pgsql_7 pgpool[190806]: [24-1] 2019-08-15 09:45:02: pid 190806: LOG: failed to connect to PostgreSQL server on "node_4:5432", getsockopt() detected error "Connection refused" Aug 15 09:45:02 pgsql_7 pgpool[190806]: [25-1] 2019-08-15 09:45:02: pid 190806: ERROR: failed to make persistent db connection Aug 15 09:45:02 pgsql_7 pgpool[190806]: [25-2] 2019-08-15 09:45:02: pid 190806: DETAIL: connection to host:"node_4:5432" failed Aug 15 09:45:02 pgsql_7 pgpool[190806]: [26-1] 2019-08-15 09:45:02: pid 190806: LOG: health check failed on node 4 (timeout:0) Aug 15 09:45:02 pgsql_7 pgpool[190806]: [27-1] 2019-08-15 09:45:02: pid 190806: LOG: received degenerate backend request for node_id: 4 from pid [190806] Aug 15 09:45:02 pgsql_7 pgpool[189881]: [72-1] 2019-08-15 09:45:02: pid 189881: LOG: new IPC connection received Aug 15 09:45:02 pgsql_7 pgpool[189881]: [73-1] 2019-08-15 09:45:02: pid 189881: LOG: failover request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:02 pgsql_7 pgpool[189881]: [73-2] 2019-08-15 09:45:02: pid 189881: DETAIL: waiting for the reply... Aug 15 09:45:02 pgsql_7 pgpool[189881]: [74-1] 2019-08-15 09:45:02: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:02 pgsql_7 pgpool[190806]: [28-1] 2019-08-15 09:45:02: pid 190806: LOG: degenerate backend request for node_id: 4 from pid [190806], will be handled by watchdog, which is building consensus for request Aug 15 09:45:02 pgsql_7 pgpool[189879]: [59-1] 2019-08-15 09:45:02: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:02 pgsql_7 pgpool[189881]: [75-1] 2019-08-15 09:45:02: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:02 pgsql_7 pgpool[189879]: [60-1] 2019-08-15 09:45:02: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:02 pgsql_7 pgpool[189879]: [61-1] 2019-08-15 09:45:02: pid 189879: LOG: Pgpool-II parent process received sync backend signal from watchdog Aug 15 09:45:02 pgsql_7 pgpool[189881]: [76-1] 2019-08-15 09:45:02: pid 189881: LOG: new IPC connection received Aug 15 09:45:02 pgsql_7 pgpool[189879]: [62-1] 2019-08-15 09:45:02: pid 189879: LOG: master watchdog has performed failover Aug 15 09:45:02 pgsql_7 pgpool[189879]: [62-2] 2019-08-15 09:45:02: pid 189879: DETAIL: syncing the backend states from the MASTER watchdog node Aug 15 09:45:02 pgsql_7 pgpool[189881]: [77-1] 2019-08-15 09:45:02: pid 189881: LOG: new IPC connection received Aug 15 09:45:02 pgsql_7 pgpool[189881]: [78-1] 2019-08-15 09:45:02: pid 189881: LOG: received the get data request from local pgpool-II on IPC interface Aug 15 09:45:02 pgsql_7 pgpool[189881]: [79-1] 2019-08-15 09:45:02: pid 189881: LOG: get data request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:02 pgsql_7 pgpool[189881]: [79-2] 2019-08-15 09:45:02: pid 189881: DETAIL: waiting for the reply... Aug 15 09:45:02 pgsql_7 pgpool[189879]: [63-1] 2019-08-15 09:45:02: pid 189879: LOG: master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" returned status for 5 backend nodes Aug 15 09:45:02 pgsql_7 pgpool[189879]: [64-1] 2019-08-15 09:45:02: pid 189879: LOG: backend:1 is set to down status Aug 15 09:45:02 pgsql_7 pgpool[189879]: [64-2] 2019-08-15 09:45:02: pid 189879: DETAIL: backend:1 is DOWN on cluster master "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:02 pgsql_7 pgpool[189879]: [65-1] 2019-08-15 09:45:02: pid 189879: LOG: backend:3 is set to down status Aug 15 09:45:02 pgsql_7 pgpool[189879]: [65-2] 2019-08-15 09:45:02: pid 189879: DETAIL: backend:3 is DOWN on cluster master "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:02 pgsql_7 pgpool[189879]: [66-1] 2019-08-15 09:45:02: pid 189879: LOG: 2 backend node(s) were detached because of backend status sync from "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:02 pgsql_7 pgpool[189879]: [66-2] 2019-08-15 09:45:02: pid 189879: DETAIL: restarting the children processes Aug 15 09:45:02 pgsql_7 pgpool[189879]: [67-1] 2019-08-15 09:45:02: pid 189879: LOG: Node 0 is not down (status: 1) Aug 15 09:45:02 pgsql_7 pgpool[354973]: [61-1] 2019-08-15 09:45:02: pid 354973: ERROR: Failed to check replication time lag Aug 15 09:45:02 pgsql_7 pgpool[354973]: [61-2] 2019-08-15 09:45:02: pid 354973: DETAIL: No persistent db connection for the node 1 Aug 15 09:45:02 pgsql_7 pgpool[354973]: [61-3] 2019-08-15 09:45:02: pid 354973: HINT: check sr_check_user and sr_check_password Aug 15 09:45:02 pgsql_7 pgpool[354973]: [61-4] 2019-08-15 09:45:02: pid 354973: CONTEXT: while checking replication time lag Aug 15 09:45:02 pgsql_7 pgpool[354973]: [62-1] 2019-08-15 09:45:02: pid 354973: LOG: worker process received restart request Aug 15 09:45:02 pgsql_7 pgpool[189879]: [68-1] 2019-08-15 09:45:02: pid 189879: LOG: worker child process with pid: 354973 exits with status 256 Aug 15 09:45:02 pgsql_7 pgpool[189879]: [69-1] 2019-08-15 09:45:02: pid 189879: LOG: fork a new worker child process with pid: 354977 Aug 15 09:45:02 pgsql_7 pgpool[354977]: [69-1] 2019-08-15 09:45:02: pid 354977: LOG: failed to connect to PostgreSQL server on "node_4:5432", getsockopt() detected error "Connection refused" Aug 15 09:45:02 pgsql_7 pgpool[354977]: [70-1] 2019-08-15 09:45:02: pid 354977: ERROR: failed to make persistent db connection Aug 15 09:45:02 pgsql_7 pgpool[354977]: [70-2] 2019-08-15 09:45:02: pid 354977: DETAIL: connection to host:"node_4:5432" failed Aug 15 09:45:02 pgsql_7 pgpool[189879]: [70-1] 2019-08-15 09:45:02: pid 189879: LOG: Pgpool-II parent process received sync backend signal from watchdog Aug 15 09:45:02 pgsql_7 pgpool[189881]: [80-1] 2019-08-15 09:45:02: pid 189881: LOG: new IPC connection received Aug 15 09:45:02 pgsql_7 pgpool[189879]: [71-1] 2019-08-15 09:45:02: pid 189879: LOG: master watchdog has performed failover Aug 15 09:45:02 pgsql_7 pgpool[189879]: [71-2] 2019-08-15 09:45:02: pid 189879: DETAIL: syncing the backend states from the MASTER watchdog node Aug 15 09:45:02 pgsql_7 pgpool[189881]: [81-1] 2019-08-15 09:45:02: pid 189881: LOG: new IPC connection received Aug 15 09:45:02 pgsql_7 pgpool[189881]: [82-1] 2019-08-15 09:45:02: pid 189881: LOG: received the get data request from local pgpool-II on IPC interface Aug 15 09:45:02 pgsql_7 pgpool[189881]: [83-1] 2019-08-15 09:45:02: pid 189881: LOG: get data request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:02 pgsql_7 pgpool[189881]: [83-2] 2019-08-15 09:45:02: pid 189881: DETAIL: waiting for the reply... Aug 15 09:45:02 pgsql_7 pgpool[189879]: [72-1] 2019-08-15 09:45:02: pid 189879: LOG: master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" returned status for 5 backend nodes Aug 15 09:45:02 pgsql_7 pgpool[189879]: [73-1] 2019-08-15 09:45:02: pid 189879: LOG: backend:4 is set to down status Aug 15 09:45:02 pgsql_7 pgpool[189879]: [73-2] 2019-08-15 09:45:02: pid 189879: DETAIL: backend:4 is DOWN on cluster master "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:02 pgsql_7 pgpool[189879]: [74-1] 2019-08-15 09:45:02: pid 189879: LOG: 1 backend node(s) were detached because of backend status sync from "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:02 pgsql_7 pgpool[189879]: [74-2] 2019-08-15 09:45:02: pid 189879: DETAIL: restarting the children processes Aug 15 09:45:02 pgsql_7 pgpool[189879]: [75-1] 2019-08-15 09:45:02: pid 189879: LOG: Node 0 is not down (status: 1) Aug 15 09:45:02 pgsql_7 pgpool[354977]: [71-1] 2019-08-15 09:45:02: pid 354977: ERROR: Failed to check replication time lag Aug 15 09:45:03 pgsql_7 pgpool[354977]: [71-2] 2019-08-15 09:45:02: pid 354977: DETAIL: No persistent db connection for the node 4 Aug 15 09:45:03 pgsql_7 pgpool[354977]: [71-3] 2019-08-15 09:45:02: pid 354977: HINT: check sr_check_user and sr_check_password Aug 15 09:45:03 pgsql_7 pgpool[354977]: [71-4] 2019-08-15 09:45:02: pid 354977: CONTEXT: while checking replication time lag Aug 15 09:45:03 pgsql_7 pgpool[354977]: [72-1] 2019-08-15 09:45:02: pid 354977: LOG: worker process received restart request Aug 15 09:45:03 pgsql_7 pgpool[189879]: [76-1] 2019-08-15 09:45:02: pid 189879: LOG: worker child process with pid: 354977 exits with status 256 Aug 15 09:45:03 pgsql_7 pgpool[189879]: [77-1] 2019-08-15 09:45:02: pid 189879: LOG: fork a new worker child process with pid: 354982 Aug 15 09:45:03 pgsql_7 pgpool[189879]: [78-1] 2019-08-15 09:45:02: pid 189879: LOG: Pgpool-II parent process received sync backend signal from watchdog Aug 15 09:45:03 pgsql_7 pgpool[189881]: [84-1] 2019-08-15 09:45:02: pid 189881: LOG: new IPC connection received Aug 15 09:45:03 pgsql_7 pgpool[189879]: [79-1] 2019-08-15 09:45:02: pid 189879: LOG: master watchdog has performed failover Aug 15 09:45:03 pgsql_7 pgpool[189879]: [79-2] 2019-08-15 09:45:02: pid 189879: DETAIL: syncing the backend states from the MASTER watchdog node Aug 15 09:45:03 pgsql_7 pgpool[189881]: [85-1] 2019-08-15 09:45:02: pid 189881: LOG: new IPC connection received Aug 15 09:45:03 pgsql_7 pgpool[189881]: [86-1] 2019-08-15 09:45:02: pid 189881: LOG: received the get data request from local pgpool-II on IPC interface Aug 15 09:45:03 pgsql_7 pgpool[189881]: [87-1] 2019-08-15 09:45:02: pid 189881: LOG: get data request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:03 pgsql_7 pgpool[189881]: [87-2] 2019-08-15 09:45:02: pid 189881: DETAIL: waiting for the reply... Aug 15 09:45:03 pgsql_7 pgpool[189879]: [80-1] 2019-08-15 09:45:02: pid 189879: LOG: master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" returned status for 5 backend nodes Aug 15 09:45:03 pgsql_7 pgpool[189879]: [81-1] 2019-08-15 09:45:02: pid 189879: LOG: backend nodes status remains same after the sync from "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:03 pgsql_7 pgpool[189881]: [88-1] 2019-08-15 09:45:03: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:03 pgsql_7 pgpool[189879]: [82-1] 2019-08-15 09:45:03: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:03 pgsql_7 pgpool[189881]: [89-1] 2019-08-15 09:45:03: pid 189881: LOG: remote node "node_1:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:03 pgsql_7 pgpool[189879]: [83-1] 2019-08-15 09:45:03: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:45:04 pgsql_7 pgpool[190805]: [25-1] 2019-08-15 09:45:04: pid 190805: LOG: failed to connect to PostgreSQL server on "node_3:5432", getsockopt() detected error "Connection refused" Aug 15 09:45:04 pgsql_7 pgpool[190805]: [26-1] 2019-08-15 09:45:04: pid 190805: ERROR: failed to make persistent db connection Aug 15 09:45:04 pgsql_7 pgpool[190805]: [26-2] 2019-08-15 09:45:04: pid 190805: DETAIL: connection to host:"node_3:5432" failed Aug 15 09:45:04 pgsql_7 pgpool[190805]: [27-1] 2019-08-15 09:45:04: pid 190805: LOG: health check failed on node 3 (timeout:0) Aug 15 09:45:04 pgsql_7 pgpool[190805]: [28-1] 2019-08-15 09:45:04: pid 190805: LOG: received degenerate backend request for node_id: 3 from pid [190805] Aug 15 09:45:04 pgsql_7 pgpool[189881]: [90-1] 2019-08-15 09:45:04: pid 189881: LOG: new IPC connection received Aug 15 09:45:04 pgsql_7 pgpool[189881]: [91-1] 2019-08-15 09:45:04: pid 189881: LOG: failover request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "node_1:9999 Linux pgsql_8.yyap.com" Aug 15 09:45:04 pgsql_7 pgpool[189881]: [91-2] 2019-08-15 09:45:04: pid 189881: DETAIL: waiting for the reply... Aug 15 09:45:04 pgsql_7 pgpool[189881]: [92-1] 2019-08-15 09:45:04: pid 189881: LOG: remote node "ip:9999 Linux pgsql_8.yyap.com" is asking to inform about quarantined backend nodes Aug 15 09:45:04 pgsql_7 pgpool[190805]: [29-1] 2019-08-15 09:45:04: pid 190805: LOG: degenerate backend request for node_id: 3 from pid [190805], will be handled by watchdog, which is building consensus for request Aug 15 09:45:04 pgsql_7 pgpool[189879]: [84-1] 2019-08-15 09:45:04: pid 189879: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog Aug 15 09:50:01 pgsql_7 systemd: Started Session 3489 of user root.
	我的签名：
liuluhao	回复： ... ... 2019-08-15 18:10:16+08...2楼
	请大佬帮忙看看，谢谢
	我的签名：
liuluhao	回复： ... ... 2019-08-15 18:13:30+08...3楼
	集群采用异步流复制，读写分离（使用pgpool-ii），四个从节点进程每日都会被杀掉一次，未曾找到是什么原因,多谢各位大佬了，我的联系方式：15001200903
	我的签名：
Yangcf	回复： ... ... 2019-10-06 17:40:07+08...4楼
	您好，是不是跑定时任务时，占用比较多的内存被linux 的OOM杀死了。我在pgpool初学者，请教个问题，pgpool如果配置分发？我在主库安装pgpool后，按博客上的配置，结果并没将请求发送到其他的节点上，日志如： Oct 6 17:20:21 localhost pgpool[10414]: [363-6] #011SELECT * FROM dms_sys_user;#015 请前辈分享下配置经验，谢谢！
	我的签名：
xcvxcvsdf	回复： ... ... 2025-04-20 19:09:48+08...5楼
	https://wh.tiancebbs.cn/pzhhs/495826.html https://su.tiancebbs.cn/hjzl/463433.html https://www.tiancebbs.cn/store/20/album.html https://zulin.tiancebbs.cn/sh/6298.html https://zulin.tiancebbs.cn/sh/3423.html https://www.tiancebbs.cn/store/2338/contactus.html https://changshushi.tiancebbs.cn/qthdch/523846.html https://www.tiancebbs.cn/store/532/info.html https://www.tiancebbs.cn/news/40187.html https://www.tiancebbs.cn/news/45341.html https://www.tiancebbs.cn/store/1945/contactus.html https://www.tiancebbs.cn/news/41419.html https://jincheng.tiancebbs.cn/b2bjzjc/57140.html https://taicang.tiancebbs.cn/hjzl/465157.html https://cd.tiancebbs.cn/news/44499.html https://cd.tiancebbs.cn/news/37521.html https://www.tiancebbs.cn/store/4397/goods.html
	我的签名：
xcvxcvsdf	回复： ... ... 2025-04-20 20:35:35+08...6楼
	https://zulin.tiancebbs.cn/sh/4978.html https://cd.tiancebbs.cn/qths/505445.html https://zj.tiancebbs.cn/qths/504628.html https://su.tiancebbs.cn/jyhs/525091.html https://www.tiancebbs.cn/store/4141/ https://su.tiancebbs.cn/hjzl/469230.html https://www.tiancebbs.cn/store/1207/ https://www.tiancebbs.cn/store/1804/comment.html https://taicang.tiancebbs.cn/hjzl/459779.html https://zulin.tiancebbs.cn/sh/4152.html https://jmgd.tiancebbs.cn/qths/494894.html https://jq.tiancebbs.cn/qths/504847.html https://cd.tiancebbs.cn/news/44104.html https://www.tiancebbs.cn/store/76/album.html https://su.tiancebbs.cn/hjzl/462287.html https://cd.tiancebbs.cn/news/40315.html https://zulin.tiancebbs.cn/sh/4325.html
	我的签名：
xcvxcvsdf	回复： ... ... 2025-04-21 12:17:50+08...7楼
	https://mdj.tiancebbs.cn/qths/504849.html https://www.tiancebbs.cn/b2bhg/525202.html https://zulin.tiancebbs.cn/sh/3316.html https://zulin.tiancebbs.cn/sh/5567.html https://cd.tiancebbs.cn/news/42852.html https://www.tiancebbs.cn/store/4735/contactus.html https://su.tiancebbs.cn/hjzl/467125.html https://zulin.tiancebbs.cn/sh/7385.html https://cd.tiancebbs.cn/news/43366.html https://zulin.tiancebbs.cn/sh/7188.html https://www.tiancebbs.cn/store/2528/info.html https://taicang.tiancebbs.cn/hjzl/459838.html https://www.tiancebbs.cn/store/532/album.html https://zulin.tiancebbs.cn/sh/7791.html https://fs.tiancebbs.cn/xiujiandian/54823.html https://nj.tiancebbs.cn/qtlphs/495110.html https://su.tiancebbs.cn/hjzl/470112.html
	我的签名：
xcvxcvsdf	回复： ... ... 2025-04-21 12:45:07+08...8楼
	https://cd.tiancebbs.cn/news/39528.html https://www.tiancebbs.cn/store/259/ https://taicang.tiancebbs.cn/hjzl/465274.html https://www.tiancebbs.cn/wangzhantuiguang/298465.html https://dg.tiancebbs.cn/qths/505495.html https://zulin.tiancebbs.cn/sh/7326.html https://www.tiancebbs.cn/store/2179/goods.html https://www.tiancebbs.cn/store/4473/document-typeid-1.html http://subangke.jxtcbmw.cn/author-534.html https://www.tiancebbs.cn/store/2532/contactus.html https://cd.tiancebbs.cn/news/37017.html https://zulin.tiancebbs.cn/sh/4711.html https://bb.tiancebbs.cn/qths/505714.html https://zz.tiancebbs.cn/b2bjxsb/57494.html https://su.tiancebbs.cn/hjzl/460885.html https://changshushi.tiancebbs.cn/qdch/522942.html https://zaozhuang.tiancebbs.cn/jzfcwy/55642.html
	我的签名：