Thread: SSL failure, v7.3.6

SSL failure, v7.3.6

From
"John Madden"
Date:
Your name               : John Madden
Your email address      : jmadden@ivytech.edu


System Configuration
---------------------
  Architecture (example: Intel Pentium)         : Intel Xeon

  Operating System (example: Linux 2.0.26 ELF)  : Linux 2.4.26 (Debian 3.0)

  PostgreSQL version (example: PostgreSQL-7.3.6):   PostgreSQL-7.3.6

  Compiler used (example:  gcc 2.95.2)          : gcc version 2.95.4
20011002 (Debian prerelease)


Please enter a FULL description of your problem:
------------------------------------------------
Clients connecting over SSL fail consistently when pulling across certain
data right after a statement prepare (via perl's DBD::Pg).  The same
statement succeeds with different arguments, and it even succeeds from the
psql client with the arguments that cause failure via perl.  Error from
syslog follows:

LOG:  SSL SYSCALL error: EOF detected
LOG:  pq_recvbuf: recv() failed: Connection reset by peer


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
------------------------------------------------
Debian 3.0 apache, perl, postgresql-client, and libdbd-pg-perl packages
were used, I imagine it can be duplicated easily.  I should be able to
provide a pg_dump of that database if it would be helpful.


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------