[pgpool-general: 4866] pgpool 3.5.3 - psql \connect hangs
Bill
pgpool at aastral.net
Fri Aug 5 02:30:53 JST 2016
Hello,
I'm testing Pgpool-II-3.5.3 on OpenSUSE Leap 42.1 (x86_64) with the
default Postgreqsql 9.4 packages installed. Pgpool was compiled from
source with ssl enabled.
I can connect to pgpool with psql and if I specify the database to
connect to, things work fine.
However, if I attempt to change databases using the \connect command,
pgpool just hangs and doesn't return results.
I have duplicated the hang with psql 9.3, psql 9.4 and Navicat Lite clients.
Below is a pcap of the traffic between psql and pgpool. After I issue
the \connect command, only 5 packets are sent and then the connection
just hangs.
If I connect psql directly to postgresql, things work as expected.
Any thoughts on how to fix?
Thanks in advance.
22:08:43.105973 IP 10.0.1.63.47999 > 10.0.1.63.9999: Flags [S], seq
3891996301, win 43690, options [mss 65495,sackOK,TS val 5612672 ecr
0,nop,wscale 7], length 0
0x0000: 4500 003c 820d 4000 4006 a231 0a00 013f E..<.. at .@..1...?
0x0010: 0a00 013f bb7f 270f e7fb 268d 0000 0000 ...?..'...&.....
0x0020: a002 aaaa 16ac 0000 0204 ffd7 0402 080a ................
0x0030: 0055 a480 0000 0000 0103 0307 .U..........
22:08:43.105991 IP 10.0.1.63.9999 > 10.0.1.63.47999: Flags [S.], seq
1858569036, ack 3891996302, win 43690, options [mss 65495,sackOK,TS val
5612672 ecr 5612672,nop,wscale 7], length 0
0x0000: 4500 003c 0000 4000 4006 243f 0a00 013f E..<.. at .@.$?...?
0x0010: 0a00 013f 270f bb7f 6ec7 834c e7fb 268e ...?'...n..L..&.
0x0020: a012 aaaa 16ac 0000 0204 ffd7 0402 080a ................
0x0030: 0055 a480 0055 a480 0103 0307 .U...U......
22:08:43.106006 IP 10.0.1.63.47999 > 10.0.1.63.9999: Flags [.], ack 1,
win 342, options [nop,nop,TS val 5612672 ecr 5612672], length 0
0x0000: 4500 0034 820e 4000 4006 a238 0a00 013f E..4.. at .@..8...?
0x0010: 0a00 013f bb7f 270f e7fb 268e 6ec7 834d ...?..'...&.n..M
0x0020: 8010 0156 16a4 0000 0101 080a 0055 a480 ...V.........U..
0x0030: 0055 a480 .U..
22:08:43.106047 IP 10.0.1.63.47999 > 10.0.1.63.9999: Flags [P.], seq
1:9, ack 1, win 342, options [nop,nop,TS val 5612672 ecr 5612672], length 8
0x0000: 4500 003c 820f 4000 4006 a22f 0a00 013f E..<.. at .@../...?
0x0010: 0a00 013f bb7f 270f e7fb 268e 6ec7 834d ...?..'...&.n..M
0x0020: 8018 0156 16ac 0000 0101 080a 0055 a480 ...V.........U..
0x0030: 0055 a480 0000 0008 04d2 162f .U........./
22:08:43.106053 IP 10.0.1.63.9999 > 10.0.1.63.47999: Flags [.], ack 9,
win 342, options [nop,nop,TS val 5612672 ecr 5612672], length 0
0x0000: 4500 0034 27cd 4000 4006 fc79 0a00 013f E..4'. at .@..y...?
0x0010: 0a00 013f 270f bb7f 6ec7 834d e7fb 2696 ...?'...n..M..&.
0x0020: 8010 0156 16a4 0000 0101 080a 0055 a480 ...V.........U..
0x0030: 0055 a480 .U..
More information about the pgpool-general
mailing list