More SSL crash woes

From: Jeff Amiel <jamiel(at)istreamimaging(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: More SSL crash woes
Date: 2008-04-08 18:32:43
Message-ID: 47FBBA4B.5050407@istreamimaging.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<pre><tt><tt><tt><tt>"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:
<a target="_blank"
href="http://archives.postgresql.org/pgsql-general/2007-08/msg01911.php"><span
class="yshortcuts" id="lw_1207670543_0">http://archives.postgresql.org/pgsql-general/2007-08/msg01911.php</span></a>

I never found a real answer except to disable SSL on the connections between my master and
subscriber nodes (instead shuttling data over a secure tunnel)

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) and force connectivity over secure tunnel?
punt?

Looks like this box does not have postgres compiled with --enable-debug....but dunno if it would help anyway being
that crash occurs in libcrypto....

Any help would be appreciated.</tt></tt></tt></tt></pre>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.7 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mikko Partio 2008-04-08 18:37:29 Re: "too many trigger records found for relation xyz"
Previous Message Tom Lane 2008-04-08 18:30:48 Re: "too many trigger records found for relation xyz"