Re: postgresql and sockets

[Corinna Vinschen <corinna-cygwin at cygwin dot com>]

On May  3 01:26, Krzysztof Duleba wrote:
> Hi
> 
> I am using Cygwin postgresql as my db engine for high load jboss/Hibernate
> web app. It works fine, but after some 10k transactions socket seems
> broken and I get this message:
> 
> $ psql
> psql: could not connect to server: Bad file descriptor
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> 
> $ cat /tmp/.s.PGSQL.5432
> !<socket >1304 s D872D6B4-84B51718-5811C571-3E0793C6
> 
> However, `psql -h localhost -p 5432' succeeds. So in fact the socket is
> still there, but the link stored in /tmp/.s.PGSQL.5432 is broken.

That's rather unlikely.  Could you show us an strace of the above failing
psql call?  Perhaps there's some interesting information in there.


Corinna

-- 
Corinna Vinschen                  Please, send mails regarding Cygwin to
Cygwin Project Co-Leader          mailto:cygwin@cygwin.com
Red Hat, Inc.

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/