[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