Thread: Re: [pgsql-es-ayuda] Error SSL en Postgresql

Re: [pgsql-es-ayuda] Error SSL en Postgresql

From
Alvaro Herrera
Date:
Just got the report below in pgsql-es-ayuda.  He says his logs files are
filled with 50 MB of the error message

LOG:  SSL SYSCALL error: Unknown winsock error 10004

I looked up 10004 and apparently it's WSAEINTR, according to
http://msdn2.microsoft.com/en-us/library/aa924071.aspx
Interrupted function call. This error is returned when a socketis closed or a process is terminated, on a pending
Winsockoperationfor that socket.
 

I wonder if the SSL code should be rather interpreting this error code
as one of those for which it must retry.  It seems strange that it be
named EINTR (which sounds to me like "operation interrupted") and then
talk about closed sockets and terminated processes.

This is Windows XP, Postgres 8.2.3.


Henry escribió:
> hola ke tal,
> estoy en una bd de prueba con postgresql 8.2.3 y Winxp, y he generado un certificado SSL con nombre server.crt y
server.keyen la carpeta Data, y establecido la opcion a  SSL=True 
 
> no se como de la nada comenzo a darme malos resultados las funciones de postgres, me refiero a los valores de
retorno
> 
> cuando doy una ojeada en los log y me doy con la sorpresa que tengo como 5 archivos .txt que pesan 10MB
> y cada linea que ocupa un archivo dice:
> 
> LOG:  SSL SYSCALL error: Unknown winsock error 10004
> LOG:  SSL SYSCALL error: Unknown winsock error 10004
> LOG:  SSL SYSCALL error: Unknown winsock error 10004
> LOG:  SSL SYSCALL error: Unknown winsock error 10004

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: [pgsql-es-ayuda] Error SSL en Postgresql

From
Magnus Hagander
Date:
Alvaro Herrera wrote:
> Just got the report below in pgsql-es-ayuda.  He says his logs files are
> filled with 50 MB of the error message
> 
> LOG:  SSL SYSCALL error: Unknown winsock error 10004
> 
> I looked up 10004 and apparently it's WSAEINTR, according to
> http://msdn2.microsoft.com/en-us/library/aa924071.aspx
> 
>     Interrupted function call. This error is returned when a socket
>     is closed or a process is terminated, on a pending Winsock
>     operation for that socket.
> 
> I wonder if the SSL code should be rather interpreting this error code
> as one of those for which it must retry.  It seems strange that it be
> named EINTR (which sounds to me like "operation interrupted") and then
> talk about closed sockets and terminated processes.
> 
> This is Windows XP, Postgres 8.2.3.

We've seen this one before, but it hasn't been fixed. See for example
bug report #2829.

Also, I wonder if this can be related to the just-reported bug #3266,
only with a different error code on win32?

//Magnus