problem with libpq7.3.3/encrypted

I believe we have a problem with libpq 7.3.3 with encryption. I
currently don't have a 7.3.3/ssl system running, but this has been
reported by Christian Ruediger Bahls, who traced it, and Dave Page.

When running pgAdmin3 over a ssl encrypted connection, it will hang,
even for very small queries with a single result. As soon as
postgresql.conf ssl=false is set, or a 7.3.2 non-encrypting libpq is
used, everything's working fine. There's a complete gdb dump at

http://dmv.math.uni-rostock.de/downloads/gdb_trace.txt

The query string is truncated in that log, it should read like this:

SELECT rw.oid, rw.ev_class, rulename, relname, nspname, description,
is_instead, ev_type, ev_action, ev_qual
pg_get_ruledef(rw.oid) AS definition
FROM pg_rewrite rw
JOIN pg_class cl ON cl.oid=rw.ev_class
JOIN pg_namespace nsp ON nsp.oid=cl.relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=rw.oid
WHERE ev_class = 12345
ORDER BY rulename

Regards,
Andreas

Christian Ruediger Bahls wrote:

it could be because of the encryption layer
that postgresql uses .. i think this is because i use the encrypted
layer
an uncomplete stacktrace i have from one
of these runs:
#0 0x407659c4 in read () from /lib/libc.so.6
#1 0x4066db50 in __JCR_LIST__ () from /lib/libpthread.so.0
#2 0x40668f53 in read () from /lib/libpthread.so.0
#3 0x400c31cc in BIO_new_socket () from /usr/lib/libcrypto.so.0.9.7
#4 0x0000000a in ?? ()
#5 0x08aec778 in ?? ()
#6 0x00000005 in ?? ()
#7 0x400c31b6 in BIO_new_socket () from /usr/lib/libcrypto.so.0.9.7
#8 0x4013bc60 in KRB5_AUTHENT_it () from /usr/lib/libcrypto.so.0.9.7
#9 0x08ac3e48 in ?? ()

but still i guess i cant trust these traces
as i got stuff like that as well:
#0 0x40667a71 in __errno_location () from /lib/libpthread.so.0
#1 0x40032430 in ssl3_read () from /usr/lib/libssl.so.0.9.7
#2 0x4004c130 in ssl3_undef_enc_method () from /usr/lib/libssl.so.0.9.7
#3 0xffffffff in ?? ()
#4 0x08ad6b80 in ?? ()
#5 0xbfffee58 in ?? ()
#6 0x4004c130 in ssl3_undef_enc_method () from /usr/lib/libssl.so.0.9.7
#7 0x08b77e38 in ?? ()
#8 0xbfffee18 in ?? ()
#9 0x4003b7ea in SSL_read () from /usr/lib/libssl.so.0.9.7
#10 0x08ac0ed8 in ?? ()
#11 0x08b814f6 in ?? ()
#12 0x00006942 in ?? ()
#13 0x4003b795 in SSL_read () from /usr/lib/libssl.so.0.9.7
#14 0x40153860 in pg_enc2name_tbl () from /usr/lib/libpq.so.3
#15 0xffffffff in ?? ()
#16 0x08ad6b80 in ?? ()
#17 0x40717438 in realloc () from /lib/libc.so.6

And Dave wrote:

Interestingly, I've just tried this on Linux, and when viewing
pg_description, the empty edit grid appears with 'Refreshing data,
please wait...' in the task bar and then hangs.
The pg console shows:

LOG: SSL SYSCALL error: EOF detected
LOG: pq_recvbuf: Unexpected EOF on client connection

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match