Debug logging doesn't seem to be useful in this case:
2004-10-11 15:20:26 STATUS : Retrieving server properties...
2004-10-11 15:20:26 INFO : Displaying properties for Server
172.16.2.47:5432
2004-10-11 15:20:26 INFO : Displaying properties for server
172.16.2.47:5432
2004-10-11 15:20:26 STATUS : Retrieving server properties... (0.00 secs)
2004-10-11 15:20:26 INFO : Attempting to create a connection object...
2004-10-11 15:20:26 INFO : Creating a connect dialogue
2004-10-11 15:20:30 INFO : Destroying a connect dialogue
2004-10-11 15:20:30 STATUS : Connecting to database...
2004-10-11 15:20:30 INFO : Creating pgConn object
2004-10-11 15:20:30 INFO : Server name: 172.16.2.47 (resolved to:
172.16.2.47)
2004-10-11 15:20:30 INFO : Opening connection with connection string:
hostaddr='172.16.2.47' dbname='ts' user='test' password='password' port=5432
I've attached tcpdump's output of crashing session. Last client's
(172.16.2.49) packet is a TCP reset. My database has client_encoding =
'UNICODE'.
Virgil
> > pgAdmin3 ver. 1.2.0 Post Beta2 (Oct 09 2004) crashes when I'm trying to
> > connect to a postgresql 7.4.2 database.
>
> Please enable full logging to trace down the reason.
15:24:54.055703 IP 172.16.2.49.1480 > 172.16.2.47.5432: S 3565288264:3565288264(0) win
65535 <mss 1460,nop,nop,sackOK>
0x0000 000c 2918 0996 0003 4772 1aea 0800 4500 ..).....Gr....E.
0x0010 0030 339a 4000 8006 6aad ac10 0231 ac10 [EMAIL PROTECTED]
0x0020 022f 05c8 1538 d481 fb48 0000 0000 7002 ./...8...H....p.
0x0030 ffff 3bd4 0000 0204 05b4 0101 0402 ..;...........
15:24:54.148126 IP 172.16.2.47.5432 > 172.16.2.49.1480: S 2087404964:2087404964(0) ack
3565288265 win 5840 <mss 1460,nop,nop,sackOK>
0x0000 0003 4772 1aea 000c 2918 0996 0800 4500 ..Gr....).....E.
0x0010 0030 0000 4000 4006 de47 ac10 022f ac10 [EMAIL PROTECTED]@..G.../..
0x0020 0231 1538 05c8 7c6b 45a4 d481 fb49 7012 .1.8..|kE....Ip.
0x0030 16d0 62e3 0000 0204 05b4 0101 0402 ..b...........
15:24:54.163185 IP 172.16.2.49.1480 > 172.16.2.47.5432: . ack 1 win 65535
0x0000 000c 2918 0996 0003 4772 1aea 0800 4500 ..).....Gr....E.
0x0010 0028 339b 4000 8006 6ab4 ac10 0231 ac10 .([EMAIL PROTECTED]
0x0020 022f 05c8 1538 d481 fb49 7c6b 45a5 5010 ./...8...I|kE.P.
0x0030 ffff a677 0000 0000 0000 0000 ...w........
15:24:54.179114 IP 172.16.2.49.1480 > 172.16.2.47.5432: P 1:32(31) ack 1 win 65535
0x0000 000c 2918 0996 0003 4772 1aea 0800 4500 ..).....Gr....E.
0x0010 0047 339c 4000 8006 6a94 ac10 0231 ac10 [EMAIL PROTECTED]
0x0020 022f 05c8 1538 d481 fb49 7c6b 45a5 5018 ./...8...I|kE.P.
0x0030 ffff cf62 0000 0000 001f 0003 0000 7573 ...b..........us
0x0040 6572 0074 6573 7400 6461 7461 6261 7365 er.test.database
0x0050 0074 7300 00 .ts..
15:24:54.201307 IP 172.16.2.47.5432 > 172.16.2.49.1480: . ack 32 win 5840
0x0000 0003 4772 1aea 000c 2918 0996 0800 4500 ..Gr....).....E.
0x0010 0028 829a 4000 4006 5bb5 ac10 022f ac10 .([EMAIL PROTECTED]@.[..../..
0x0020 0231 1538 05c8 7c6b 45a5 d481 fb68 5010 .1.8..|kE....hP.
0x0030 16d0 8f88 0000 ......
15:24:54.071599 IP 172.16.2.47.5432 > 172.16.2.49.1480: P 1:14(13) ack 32 win 5840
0x0000 0003 4772 1aea 000c 2918 0996 0800 4500 ..Gr....).....E.
0x0010 0035 829b 4000 4006 5ba7 ac10 022f ac10 [EMAIL PROTECTED]@.[..../..
0x0020 0231 1538 05c8 7c6b 45a5 d481 fb68 5018 .1.8..|kE....hP.
0x0030 16d0 d6f8 0000 5200 0000 0c00 0000 0546 ......R........F
0x0040 b833 9d .3.
15:24:54.072264 IP 172.16.2.49.1480 > 172.16.2.47.5432: P 32:73(41) ack 14 win 65522
0x0000 000c 2918 0996 0003 4772 1aea 0800 4500 ..).....Gr....E.
0x0010 0051 339d 4000 8006 6a89 ac10 0231 ac10 [EMAIL PROTECTED]
0x0020 022f 05c8 1538 d481 fb68 7c6b 45b2 5018 ./...8...h|kE.P.
0x0030 fff2 924f 0000 7000 0000 286d 6435 6665 ...O..p...(md5fe
0x0040 3931 3335 3262 3365 6236 3436 3639 3466 91352b3eb646694f
0x0050 3831 3731 6136 6666 3933 3531 3832 00 8171a6ff935182.
15:24:54.086525 IP 172.16.2.47.5432 > 172.16.2.49.1480: P 14:175(161) ack 73 win 5840
0x0000 0003 4772 1aea 000c 2918 0996 0800 4500 ..Gr....).....E.
0x0010 00c9 829c 4000 4006 5b12 ac10 022f ac10 [EMAIL PROTECTED]@.[..../..
0x0020 0231 1538 05c8 7c6b 45b2 d481 fb91 5018 .1.8..|kE.....P.
0x0030 16d0 16b7 0000 5200 0000 0800 0000 0053 ......R........S
0x0040 0000 001c 636c 6965 6e74 5f65 6e63 6f64 ....client_encod
0x0050 696e 6700 554e 4943 4f44 4500 5300 0000 ing.UNICODE.S...
0x0060 1744 6174 6553 7479 6c65 0049 534f 2c20 .DateStyle.ISO,.
0x0070 4d44 5900 5300 0000 1569 735f 7375 7065 MDY.S....is_supe
0x0080 7275 7365 7200 6f66 6600 5300 0000 1973 ruser.off.S....s
0x0090 6572 7665 725f 7665 7273 696f 6e00 372e erver_version.7.
0x00a0 342e 3200 5300 0000 1f73 6573 7369 6f6e 4.2.S....session
0x00b0 5f61 7574 686f 7269 7a61 7469 6f6e 0074 _authorization.t
0x00c0 6573 7400 4b00 0000 0c00 000d be7e 7831 est.K........~x1
0x00d0 eb5a 0000 0005 49 .Z....I
15:24:54.174484 IP 172.16.2.49.1480 > 172.16.2.47.5432: . ack 175 win 65361
0x0000 000c 2918 0996 0003 4772 1aea 0800 4500 ..).....Gr....E.
0x0010 0028 33da 4000 8006 6a75 ac10 0231 ac10 .([EMAIL PROTECTED]
0x0020 022f 05c8 1538 d481 fb91 7c6b 4653 5010 ./...8....|kFSP.
0x0030 ff51 a62f 0000 0000 0000 0000 .Q./........
15:24:57.510733 IP 172.16.2.49.1480 > 172.16.2.47.5432: R 3565288337:3565288337(0) win 0
0x0000 000c 2918 0996 0003 4772 1aea 0800 4500 ..).....Gr....E.
0x0010 0028 3410 4000 8006 6a3f ac10 0231 ac10 .([EMAIL PROTECTED]
0x0020 022f 05c8 1538 d481 fb91 5f12 7778 5004 ./...8...._.wxP.
0x0030 0000 91c1 0000 0000 0000 0000 ............
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
