Re: PG 7.3.1 with ssl on linux hangs (testcase available) - Mailing list pgsql-bugs

Tom Lane wrote:

>Bizarre.  I looked through the recent sslmode patch, and while I found
>some things I didn't like, none of them explain this.  Could you perhaps
>get a trace of the server-to-client interaction?  Either strace'ing psql
>or watching the IP traffic with a packet sniffer should do --- but make
>sure you get the full contents of each packet sent and received.
>
>
Hi Tom,

the attached file is a tcpdump of a connect attempt.

Regards,
Andreas

00:14:21.128861 localhost.32821 > localhost.postgresql: F 2173273900:2173273900(0) ack 2168553850 win 32767
<nop,nop,timestamp108609 106946> (DF) 
             4500 0034 0340 4000 4006 3982 7f00 0001
             7f00 0001 8035 1538 8189 872c 8141 817a
             8011 7fff 0dd5 0000 0101 080a 0001 a841
             0001 a1c2
00:14:21.131604 localhost.postgresql > localhost.32821: F 1:1(0) ack 1 win 32767 <nop,nop,timestamp 108609 108609> (DF)
             4500 0034 0341 4000 4006 3981 7f00 0001
             7f00 0001 1538 8035 8141 817a 8189 872d
             8011 7fff 0755 0000 0101 080a 0001 a841
             0001 a841
00:14:21.131635 localhost.32821 > localhost.postgresql: . ack 2 win 32767 <nop,nop,timestamp 108609 108609> (DF)
             4500 0034 0342 4000 4006 3980 7f00 0001
             7f00 0001 8035 1538 8189 872d 8141 817b
             8010 7fff 0755 0000 0101 080a 0001 a841
             0001 a841
00:14:21.132540 localhost.32822 > localhost.postgresql: S 2177528657:2177528657(0) win 32767 <mss
16396,sackOK,timestamp108609 0,nop,wscale 0> (DF) 
             4500 003c 0343 4000 4006 3977 7f00 0001
             7f00 0001 8036 1538 81ca 7351 0000 0000
             a002 7fff 5ce0 0000 0204 400c 0402 080a
             0001 a841 0000 0000 0103 0300
00:14:21.132565 localhost.postgresql > localhost.32822: S 2176273229:2176273229(0) ack 2177528658 win 32767 <mss
16396,sackOK,timestamp108609 108609,nop,wscale 0> (DF) 
             4500 003c 0344 4000 4006 3976 7f00 0001
             7f00 0001 1538 8036 81b7 4b4d 81ca 7352
             a012 7fff e787 0000 0204 400c 0402 080a
             0001 a841 0001 a841 0103 0300
00:14:21.132582 localhost.32822 > localhost.postgresql: . ack 1 win 32767 <nop,nop,timestamp 108609 108609> (DF)
             4500 0034 0345 4000 4006 397d 7f00 0001
             7f00 0001 8036 1538 81ca 7352 81b7 4b4e
             8010 7fff 50a5 0000 0101 080a 0001 a841
             0001 a841
00:14:21.132638 localhost.32822 > localhost.postgresql: P 1:9(8) ack 1 win 32767 <nop,nop,timestamp 108609 108609> (DF)
             4500 003c 0346 4000 4006 3974 7f00 0001
             7f00 0001 8036 1538 81ca 7352 81b7 4b4e
             8018 7fff 358c 0000 0101 080a 0001 a841
             0001 a841 0000 0008 04d2 162f
00:14:21.132647 localhost.postgresql > localhost.32822: . ack 9 win 32767 <nop,nop,timestamp 108609 108609> (DF)
             4500 0034 0347 4000 4006 397b 7f00 0001
             7f00 0001 1538 8036 81b7 4b4e 81ca 735a
             8010 7fff 509d 0000 0101 080a 0001 a841
             0001 a841
00:14:21.132833 localhost.filenet-tms > localhost.filenet-tms: udp 24
             6000 0000 0020 1140 0000 0000 0000 0000
             0000 0000 0000 0001 0000 0000 0000 0000
             0000 0000 0000 0001 8000 8000 0020 4aa6
             0200 0000 1800 0000 0000 0000 9b05 0000
             0000 0000 0000 0000
00:14:21.134264 localhost.postgresql > localhost.32822: P 1:2(1) ack 9 win 32767 <nop,nop,timestamp 108609 108609> (DF)
             4500 0035 0348 4000 4006 3979 7f00 0001
             7f00 0001 1538 8036 81b7 4b4e 81ca 735a
             8018 7fff 0294 0000 0101 080a 0001 a841
             0001 a841 4e
00:14:21.134284 localhost.32822 > localhost.postgresql: . ack 2 win 32767 <nop,nop,timestamp 108609 108609> (DF)
             4500 0034 0349 4000 4006 3979 7f00 0001
             7f00 0001 8036 1538 81ca 735a 81b7 4b4f
             8010 7fff 509c 0000 0101 080a 0001 a841
             0001 a841