View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000585 | Pgpool-II | Bug | public | 2020-02-18 04:07 | 2020-04-14 15:40 |
| Reporter | tiennguyen | Assigned To | hoshiai | ||
| Priority | high | Severity | major | Reproducibility | have not tried |
| Status | feedback | Resolution | open | ||
| OS | CentOS | OS Version | 7.7 | ||
| Product Version | 4.1.0 | ||||
| Summary | 0000585: Can't connect to virtual ip (VIP) on cluster node | ||||
| Description | Hello, I have problem when i trying to connect postgres over Virutal IP (VIP) and pgpool port Command: `psql -h VIP -p 9999 -U pgpool -d postgres -w -c 'SHOW POOL_NODES;'` Log output: ``` psql: error: could not connect to server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. ``` Here is log pgpool contain Virutal IP up: ``` Feb 18 01:59:23 tiennm-dev pgpool[1264]: [42-1] 2020-02-18 01:59:23: pid 1264: ERROR: backend authentication failed Feb 18 01:59:23 tiennm-dev pgpool[1264]: [42-2] 2020-02-18 01:59:23: pid 1264: DETAIL: backend response with kind 'G' when expecting 'R' ``` I am work on vmware machine it still working fine, but when i move it to my local system on my company, it has the problem as above Please help me explain error in pgpool log and help me fix it thanks very much | ||||
| Tags | No tags attached. | ||||
|
|
What postgresql version do you use? If you can replicate this problem, you set log_min_messages = 'debug1' log_client_messages='on' in pgpool, and share pgpool.conf and pgpool.log during problem happend. |
|
|
It's been more than a month since I replay to you ... Is your problem solved? If you don't have any problems, I would like to close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-02-18 04:07 | tiennguyen | New Issue | |
| 2020-02-18 17:15 | hoshiai | Assigned To | => hoshiai |
| 2020-02-18 17:15 | hoshiai | Status | new => assigned |
| 2020-02-18 17:30 | hoshiai | Status | assigned => feedback |
| 2020-02-18 17:30 | hoshiai | Note Added: 0003217 | |
| 2020-04-14 15:40 | hoshiai | Note Added: 0003319 |
