View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000627 | Pgpool-II | Bug | public | 2020-07-19 16:54 | 2020-10-07 11:50 |
| Reporter | raj.pandey1982@gmail.com | Assigned To | pengbo | ||
| Priority | high | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | open | ||
| Platform | Linux | OS | Centos | OS Version | 7.5 |
| Product Version | 4.1.0 | ||||
| Summary | 0000627: Master and slave not able to connect each other to perform health check for few mints intermittently | ||||
| Description | PGPOOL-II: 4.1.0. 2 nodes running in Master slave mode.Same nodes have pgpool as mAster and standby as well. Master /Primary node :mwdp3prddm01 Slave/Secondry Node: mwdp3prdds01 Thew below issues comes parallel y at master and slave both sometimes and then gets resolved by it self. IS it due to Network issue between master and slave?:- Master Pgpool Log:- 2020-07-19 06:27:21: pid 22419:LOG: trying connecting to PostgreSQL server on "mwdp3prdds01.moh.gov.sa:5432" by INET socket 2020-07-19 06:27:21: pid 22419:DETAIL: timed out. retrying... 2020-07-19 06:27:21: pid 22421:LOG: failed to connect to PostgreSQL server on "mwdp3prdds01.moh.gov.sa:5432" using INET socket 2020-07-19 06:27:21: pid 22421:DETAIL: health check timer expired 2020-07-19 06:27:21: pid 22421:ERROR: failed to make persistent db connection 2020-07-19 06:27:21: pid 22421:DETAIL: connection to host:"mwdp3prdds01.moh.gov.sa:5432" failed 2020-07-19 06:27:21: pid 22421:LOG: health check retrying on DB node: 1 (round:1) 2020-07-19 06:27:24: pid 22421:LOG: health check retrying on DB node: 1 succeeded 2020-07-19 06:28:11: pid 22419:LOG: trying connecting to PostgreSQL server on "mwdp3prdds01.moh.gov.sa:5432" by INET socket 2020-07-19 06:28:11: pid 22419:DETAIL: timed out. retrying... 2020-07-19 06:28:19: pid 22421:LOG: failed to connect to PostgreSQL server on "mwdp3prdds01.moh.gov.sa:5432" using INET socket 2020-07-19 06:28:19: pid 22421:DETAIL: health check timer expired 2020-07-19 06:28:19: pid 22421:ERROR: failed to make persistent db connection 2020-07-19 06:28:19: pid 22421:DETAIL: connection to host:"mwdp3prdds01.moh.gov.sa:5432" failed 2020-07-19 06:28:19: pid 22421:LOG: health check retrying on DB node: 1 (round:1) 2020-07-19 06:28:20: pid 22421:LOG: health check retrying on DB node: 1 succeeded 2020-07-19 06:28:38: pid 22419:LOG: failed to connect to PostgreSQL server on "mwdp3prdds01.moh.gov.sa:5432", getsockopt() detected error "Connection timed out" 2020-07-19 06:28:38: pid 22419:ERROR: failed to make persistent db connection 2020-07-19 06:28:38: pid 22419:DETAIL: connection to host:"mwdp3prdds01.moh.gov.sa:5432" failed 2020-07-19 06:28:43: pid 22419:ERROR: Failed to check replication time lag 2020-07-19 06:28:43: pid 22419:DETAIL: No persistent db connection for the node 1 2020-07-19 06:28:43: pid 22419:HINT: check sr_check_user and sr_check_password 2020-07-19 06:28:43: pid 22419:CONTEXT: while checking replication time lag 2020-07-19 06:31:08: pid 22419:LOG: trying connecting to PostgreSQL server on "mwdp3prdds01.moh.gov.sa:5432" by INET socket 2020-07-19 06:31:08: pid 22419:DETAIL: timed out. retrying... 2020-07-19 06:32:37: pid 22419:LOG: trying connecting to PostgreSQL server on "mwdp3prdds01.moh.gov.sa:5432" by INET socket 2020-07-19 06:32:37: pid 22419:DETAIL: timed out. retrying... Slave Pgpool Log:- 2020-07-19 06:27:31: pid 12500:LOG: trying connecting to PostgreSQL server on "mwdp3prddm01.moh.gov.sa:5432" by INET socket 2020-07-19 06:27:31: pid 12500:DETAIL: timed out. retrying... 2020-07-19 06:27:53: pid 12501:LOG: failed to connect to PostgreSQL server on "mwdp3prddm01.moh.gov.sa:5432" using INET socket 2020-07-19 06:27:53: pid 12501:DETAIL: health check timer expired 2020-07-19 06:27:53: pid 12501:ERROR: failed to make persistent db connection 2020-07-19 06:27:53: pid 12501:DETAIL: connection to host:"mwdp3prddm01.moh.gov.sa:5432" failed 2020-07-19 06:27:53: pid 12501:LOG: health check retrying on DB node: 0 (round:1) 2020-07-19 06:28:25: pid 12501:LOG: health check retrying on DB node: 0 succeeded 2020-07-19 06:28:40: pid 12500:LOG: trying connecting to PostgreSQL server on "mwdp3prddm01.moh.gov.sa:5432" by INET socket 2020-07-19 06:28:40: pid 12500:DETAIL: timed out. retrying... 2020-07-19 06:30:34: pid 12501:LOG: failed to connect to PostgreSQL server on "mwdp3prddm01.moh.gov.sa:5432" using INET socket 2020-07-19 06:30:34: pid 12501:DETAIL: health check timer expired 2020-07-19 06:30:34: pid 12501:ERROR: failed to make persistent db connection 2020-07-19 06:30:34: pid 12501:DETAIL: connection to host:"mwdp3prddm01.moh.gov.sa:5432" failed 2020-07-19 06:30:34: pid 12501:LOG: health check retrying on DB node: 0 (round:1) 2020-07-19 06:31:07: pid 12501:LOG: health check retrying on DB node: 0 succeeded 2020-07-19 06:32:09: pid 12500:LOG: trying connecting to PostgreSQL server on "mwdp3prddm01.moh.gov.sa:5432" by INET socket 2020-07-19 06:32:09: pid 12500:DETAIL: timed out. retrying... 2020-07-19 06:32:22: pid 12501:LOG: failed to connect to PostgreSQL server on "mwdp3prddm01.moh.gov.sa:5432" using INET socket 2020-07-19 06:32:22: pid 12501:DETAIL: health check timer expired 2020-07-19 06:32:22: pid 12501:ERROR: failed to make persistent db connection 2020-07-19 06:32:22: pid 12501:DETAIL: connection to host:"mwdp3prddm01.moh.gov.sa:5432" failed 2020-07-19 06:32:22: pid 12501:LOG: health check retrying on DB node: 0 (round:1) 2020-07-19 06:32:54: pid 12501:LOG: health check retrying on DB node: 0 succeeded | ||||
| Tags | No tags attached. | ||||
|
|
Because health check fails intermittently, I think it is due to the network issue. ============== 2020-07-19 06:27:21: pid 22421:DETAIL: connection to host:"mwdp3prdds01.moh.gov.sa:5432" failed 2020-07-19 06:27:21: pid 22421:LOG: health check retrying on DB node: 1 (round:1) 2020-07-19 06:27:24: pid 22421:LOG: health check retrying on DB node: 1 succeeded ============== |
|
|
Have you resolved this issue? If you have resolved this issue, I am going to close this one. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-07-19 16:54 | raj.pandey1982@gmail.com | New Issue | |
| 2020-07-20 10:39 | pengbo | Assigned To | => pengbo |
| 2020-07-20 10:39 | pengbo | Status | new => assigned |
| 2020-07-20 10:45 | pengbo | Note Added: 0003433 | |
| 2020-07-20 10:46 | pengbo | Status | assigned => feedback |
| 2020-09-01 09:47 | administrator | Note Added: 0003553 | |
| 2020-10-07 11:50 | pengbo | Status | feedback => closed |
