Re: SSL SYSCALL error: A blocking operation was interrupted by a call to WSACancelBlockingCall

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: vyang <vyang(at)apt-cafm(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: SSL SYSCALL error: A blocking operation was interrupted by a call to WSACancelBlockingCall
Date: 2008-05-01 20:19:08
Message-ID: 481A25BC.8010102@hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> "vyang" <vyang(at)apt-cafm(dot)com> writes:
>> I'm having trouble with postgres filling the log with SSL SYSCALL error: A
>> blocking operation was interrupted by a call to WSACancelBlockingCall.
>
> That was fixed some time ago:
>
> 2007-05-17 21:20 tgl
>
> * src/backend/libpq/: be-secure.c (REL7_4_STABLE), be-secure.c
> (REL8_1_STABLE), be-secure.c (REL8_0_STABLE), be-secure.c
> (REL8_2_STABLE), be-secure.c: Remove redundant logging of send
> failures when SSL is in use. While pqcomm.c had been taught not to
> do that ages ago, the SSL code was helpfully bleating anyway.
> Resolves some recent reports such as bug #3266; however the
> underlying cause of the related bug #2829 is still unclear.
>
> Update to a newer release.

Actually, this only fixes the repeated logging that could take down your
entire server. The underlying issue is still there AFAIK, and can kill a
single connection.

Changing the SSL code to get around that is on my TODO for 8.4.

//Magnus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Osvaldo Kussama 2008-05-01 20:29:57 Re: question about join
Previous Message Ottavio Campana 2008-05-01 17:54:44 Re: question about join