Re: [hensa22@yahoo.es: Re: [pgsql-es-ayuda] SLL error 100% cpu]

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Trevor Talbot <quension(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [hensa22@yahoo.es: Re: [pgsql-es-ayuda] SLL error 100% cpu]
Date: 2008-03-21 19:34:22
Message-ID: 200803211934.m2LJYMT04196@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Added to TODO:

o Prevent SSL from sending network packets to avoid interference
with Win32 signal emulation

http://archives.postgresql.org/pgsql-hackers/2007-12/msg00455.php

---------------------------------------------------------------------------

Magnus Hagander wrote:
> On Wed, Dec 12, 2007 at 12:30:50AM -0500, Tom Lane wrote:
> > "Trevor Talbot" <quension(at)gmail(dot)com> writes:
> > > On 12/11/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > >> I dunno anything about how to fix the real problem (what's winsock error
> > >> 10004?),
> >
> > > WSAEINTR, "A blocking operation was interrupted by a call to
> > > WSACancelBlockingCall."
> >
> > Oh, then it's exactly the same thing as our bug #2829.
> >
> > I opined in that thread that OpenSSL was broken because it failed to
> > treat this as a retryable case like EINTR. But not being much of a
> > Windows person, that might be mere hot air. Someone with a Windows
> > build environment should try patching OpenSSL to treat WSAEINTR
> > the same as Unix EINTR and see what happens ...
>
> When I last looked at this (and this was some time ago), I suspected (and
> still do) that the problem is in the interaction between our
> socket-emulation-stuff (for signals) and openssl. I'm not entirely sure,
> but I wanted to rewrite the SSL code so that *our* code is responsible for
> aclling the actuall send()/recv(), and not OpenSSL. This would also fix the
> fact that if an OpenSSL network operation ends up blocking, that process
> can't receive any signals...
>
> I didn't have time to get this done before feature-freeze though, and I
> beleive the changes are large enough to qualify as such..
>
> //Magnus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message alfranio 2008-03-21 19:58:44 Re: Proposal for db level triggers
Previous Message Andrew Dunstan 2008-03-21 19:21:11 Re: Commit Fest (was Re: Sort Refinement)