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.


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.key en 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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match