Re: [GENERAL] SSL connection has been closed unexpectedly
On Aug 15, 2013, at 5:41 AM, Stuart Ford 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] SSL connection has been closed unexpectedly
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
Re: [GENERAL] SSL connection has been closed unexpectedly
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.kla...@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
Re: [GENERAL] SSL connection has been closed unexpectedly
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" wrote: >On Aug 15, 2013, at 5:41 AM, Stuart Ford 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 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 or email gl...@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
Re: [GENERAL] SSL connection has been closed unexpectedly
On 15 August 2013 15:29, Stuart Ford 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.
Re: [GENERAL] SSL connection has been closed unexpectedly
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 Date: Thursday, 15 August 2013 13:31 To: Stuart Ford Cc: "pgsql-general@postgresql.org" Subject: Re: [GENERAL] SSL connection has been closed unexpectedly On 15 August 2013 12:41, Stuart Ford 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 or email gl...@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
Re: [GENERAL] SSL connection has been closed unexpectedly
On 15 August 2013 12:41, Stuart Ford 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.