Обсуждение: 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 onlyfor the use of the person to whom it is addressed. Unauthorised disclosure, copying or distribution of the email or itscontent may result in legal liability. If you have received the email in error, please immediately notify us by telephoneon +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 internettransmission. Any views/opinions expressed within this email and any attachments are that of the individual and notnecessarily 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.
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 onlyfor the use of the person to whom it is addressed. Unauthorised disclosure, copying or distribution of the email or itscontent may result in legal liability. If you have received the email in error, please immediately notify us by telephoneon +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 internettransmission. Any views/opinions expressed within this email and any attachments are that of the individual and notnecessarily 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.
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.
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
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.
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 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 > >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 onlyfor the use of the person to whom it is addressed. Unauthorised disclosure, copying or distribution of the email or itscontent may result in legal liability. If you have received the email in error, please immediately notify us by telephoneon +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 internettransmission. Any views/opinions expressed within this email and any attachments are that of the individual and notnecessarily 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.
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
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
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 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 Any chance you are using HP ProCurve switches? I believe we have seen these switches corrupt SSL connections when systemsuse flow control signaling. Utterly bizarre behavior, but we've seen it at multiple customer sites. Guy