more SSL crash woes.... - Mailing list pgsql-general

From Jeff Amiel
Subject more SSL crash woes....
Date
Msg-id 589070.87477.qm@web65502.mail.ac4.yahoo.com
Whole thread Raw
List pgsql-general
"PostgreSQL 8.2.4 on i386-pc-solaris2.10, compiled by GCC gcc (GCC) 3.4.3
(csl-sol210-3_4-branch+sol_rpath)"

As the proud author of this previous post:
http://archives.postgresql.org/pgsql-general/2007-08/msg01911.php

I never found a real answer except to disable SSL on the connections between my master and
subscriber nodes.

Things have been peachy ever since.

Today....first db crash in quite some time...seemingly unrelated to slony

Stack trace looks eerily familiar:

Core was generated by `/usr/local/pgsql/bin/postgres -D /db'.
Program terminated with signal 11, Segmentation fault.
#0  0xfee8ec23 in sk_value () from /usr/local/ssl/lib/libcrypto.so.0.9.8

*grumble*

I have located nothing unusual occurring at the time of the event....
We have developers that connect from win32 and Fedora boxes via PGAdminIII and they use SSL
connections...but they have ALWAYS connected using SSL.....

Any suggestions?  I really need to try to either provide an explanation or make SOME change to
prevent....

upgrade openssl? (we are on 9.8e)
remove ALL encrypted connection capabilities (via pg_hba.conf)?
punt?

I'm dubious that that stack trace simply 'starts' in the middle of the libcrypto stuff.....
shouldn't I see some postgresql functions in there somewhere?
(postgres compiled with --enable-debug)

Any help would be appreciated.











      ____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com

pgsql-general by date:

Previous
From: Andrew Falanga
Date:
Subject: How does psql actually implement the \d commands
Next
From: otakarek@post.cz
Date:
Subject: Trouble with foreign key