View Issue Details

IDProjectCategoryView StatusLast Update
0000585Pgpool-IIBugpublic2020-04-14 15:40
ReportertiennguyenAssigned Tohoshiai 
PriorityhighSeveritymajorReproducibilityhave not tried
Status feedbackResolutionopen 
PlatformOSCentOSOS Version7.7
Product Version4.1.0 
Target VersionFixed in Version 
Summary0000585: Can't connect to virtual ip (VIP) on cluster node
DescriptionHello,

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
TagsNo tags attached.

Activities

hoshiai

2020-02-18 17:30

developer   ~0003217

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.

hoshiai

2020-04-14 15:40

developer   ~0003319

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.

Issue History

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