SSL connection has been closed unexpectedly
Dear community
We have a problem on our development database server, which supports a PHP
application, which connects to it from a different server. Sometimes,
around 1 in 4 page loads, it fails and reports the following error message:
FATAL: terminating connection due to administrator command SSL connection
has been closed unexpectedly
Reloading the page usually works, sometimes doesn't, sometimes it requires
several more refresh attempts before it magically works again. The odd
thing is that we also have a live platform that is set up in the same way,
and this does not occur, thankfully, but I expect it could.
I've tried turning off all SSL features on the development platform, but
oddly, the same problem persists. I've also tried whacking the logging
level up to debug5, but still nothing appears in the PG logs when the
problem occurs.
Does anybody have any idea what could be happening here?
Many thanks in advance
Stuart Ford
This email and any attachments contain confidential and proprietary information of Glide Utilities Limited intended only for the use of the person to whom it is addressed. Unauthorised disclosure, copying or distribution of the email or its content may result in legal liability. If you have received the email in error, please immediately notify us by telephone on +44 333 666 5555 or email glide@glide.uk.com
The sender does not accept liability for any loss or damage from receipt or use thereof which arises as a result of internet transmission. Any views/opinions expressed within this email and any attachments are that of the individual and not necessarily that of Glide Utilities Limited.
Glide is a registered trademark of Glide Utilities Limited. Registered Office: Alpha Tower, Suffolk Street Queensway, Birmingham, B1 1TT. Registered in England & Wales. Registered Company No. 06194523.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 15 August 2013 12:41, Stuart Ford <stuart.ford@glide.uk.com> wrote:
Dear community
We have a problem on our development database server, which supports a PHP
application, which connects to it from a different server. Sometimes,
around 1 in 4 page loads, it fails and reports the following error message:FATAL: terminating connection due to administrator command SSL connection
has been closed unexpectedly
This has nothing to do with SSL. You have an "administrator" who's issuing
commands to close database connections. Those just happen to be SSL
connections.
Perhaps the Linux OOM killer is at work here?
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
Alban
I would agree with you, except it still happens even after I have disabled
all SSL related stuff in postgresql.conf and pg_hba.conf. I've also no
evidence of any out of memory events on the server.
Stuart
--
From: Alban Hertroys <haramrae@gmail.com>
Date: Thursday, 15 August 2013 13:31
To: Stuart Ford <stuart.ford@glide.uk.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] SSL connection has been closed unexpectedly
On 15 August 2013 12:41, Stuart Ford <stuart.ford@glide.uk.com> wrote:
Dear community
We have a problem on our development database server, which supports a PHP
application, which connects to it from a different server. Sometimes,
around 1 in 4 page loads, it fails and reports the following error message:
FATAL: terminating connection due to administrator command SSL connection
has been closed unexpectedly
This has nothing to do with SSL. You have an "administrator" who's issuing
commands to close database connections. Those just happen to be SSL
connections.
Perhaps the Linux OOM killer is at work here?
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
This email and any attachments contain confidential and proprietary information of Glide Utilities Limited intended only for the use of the person to whom it is addressed. Unauthorised disclosure, copying or distribution of the email or its content may result in legal liability. If you have received the email in error, please immediately notify us by telephone on +44 333 666 5555 or email glide@glide.uk.com
The sender does not accept liability for any loss or damage from receipt or use thereof which arises as a result of internet transmission. Any views/opinions expressed within this email and any attachments are that of the individual and not necessarily that of Glide Utilities Limited.
Glide is a registered trademark of Glide Utilities Limited. Registered Office: Alpha Tower, Suffolk Street Queensway, Birmingham, B1 1TT. Registered in England & Wales. Registered Company No. 06194523.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 15 August 2013 15:29, Stuart Ford <stuart.ford@glide.uk.com> wrote:
Alban
I would agree with you, except
...that you misread what I wrote ;)
it still happens even after I have disabled
all SSL related stuff in postgresql.conf and pg_hba.conf.
Well, of course. Why would that make any difference? Your problem is not
SSL related. It would probably happen with a normal connection as well.
That is, unless some SSL-related process on your server is crashing or
something like that.
I've also no
evidence of any out of memory events on the server.
That's only one of the candidates for processes that kill your connections.
Something or someone is doing that.
There's probably some evidence about this in log files, if you're on an OS
that logs stuff.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
On Aug 15, 2013, at 5:41 AM, Stuart Ford <stuart.ford@glide.uk.com> wrote:
Dear community
We have a problem on our development database server, which supports a PHP
application, which connects to it from a different server. Sometimes,
around 1 in 4 page loads, it fails and reports the following error message:FATAL: terminating connection due to administrator command SSL connection
has been closed unexpectedlyReloading the page usually works, sometimes doesn't, sometimes it requires
several more refresh attempts before it magically works again. The odd
thing is that we also have a live platform that is set up in the same way,
and this does not occur, thankfully, but I expect it could.I've tried turning off all SSL features on the development platform, but
oddly, the same problem persists. I've also tried whacking the logging
level up to debug5, but still nothing appears in the PG logs when the
problem occurs.Does anybody have any idea what could be happening here?
Many thanks in advance
Stuart Ford
Any chance you are using HP ProCurve switches? I believe we have seen these switches corrupt SSL connections when systems use flow control signaling. Utterly bizarre behavior, but we've seen it at multiple customer sites.
Guy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Guy
No, we don't. It's also not happening on another platform which uses the
same switch stack (and indeed VMWare cluster), so these aren't factors.
Stuart
On 15/08/2013 16:59, "Guy Helmer" <ghelmer@palisadesystems.com> wrote:
On Aug 15, 2013, at 5:41 AM, Stuart Ford <stuart.ford@glide.uk.com> wrote:
Dear community
We have a problem on our development database server, which supports a
PHP
application, which connects to it from a different server. Sometimes,
around 1 in 4 page loads, it fails and reports the following error
message:FATAL: terminating connection due to administrator command SSL
connection
has been closed unexpectedlyReloading the page usually works, sometimes doesn't, sometimes it
requires
several more refresh attempts before it magically works again. The odd
thing is that we also have a live platform that is set up in the same
way,
and this does not occur, thankfully, but I expect it could.I've tried turning off all SSL features on the development platform, but
oddly, the same problem persists. I've also tried whacking the logging
level up to debug5, but still nothing appears in the PG logs when the
problem occurs.Does anybody have any idea what could be happening here?
Many thanks in advance
Stuart Ford
Any chance you are using HP ProCurve switches? I believe we have seen
these switches corrupt SSL connections when systems use flow control
signaling. Utterly bizarre behavior, but we've seen it at multiple
customer sites.Guy
This email and any attachments contain confidential and proprietary information of Glide Utilities Limited intended only for the use of the person to whom it is addressed. Unauthorised disclosure, copying or distribution of the email or its content may result in legal liability. If you have received the email in error, please immediately notify us by telephone on +44 333 666 5555 or email glide@glide.uk.com
The sender does not accept liability for any loss or damage from receipt or use thereof which arises as a result of internet transmission. Any views/opinions expressed within this email and any attachments are that of the individual and not necessarily that of Glide Utilities Limited.
Glide is a registered trademark of Glide Utilities Limited. Registered Office: Alpha Tower, Suffolk Street Queensway, Birmingham, B1 1TT. Registered in England & Wales. Registered Company No. 06194523.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 08/15/2013 10:05 AM, Stuart Ford wrote:
Guy
No, we don't. It's also not happening on another platform which uses the
same switch stack (and indeed VMWare cluster), so these aren't factors.
For completeness sake:
When you reset the SSL values did you restart the server?
Left field category:
Is there a replication server in the mix?
Stuart
--
Adrian Klaver
adrian.klaver@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Stuart Ford wrote:
We have a problem on our development database server, which supports a PHP
application, which connects to it from a different server. Sometimes,
around 1 in 4 page loads, it fails and reports the following error message:FATAL: terminating connection due to administrator command SSL connection
has been closed unexpectedly
Funny - that error message (with the SSL part included) does not
appear in PostgreSQL source.
Could you dig the exact error messages out of the database log?
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general