Re: [GENERAL] Deadlock in libpq

2011-03-26 Thread Erik Hesselink
On Fri, Mar 25, 2011 at 21:21, Merlin Moncure wrote: > On Fri, Mar 25, 2011 at 3:26 AM, Erik Hesselink wrote: >>> hm, ISTM (I don't know haskell) that the hdbc driver isn't doing any >>> type of synchronization at all unless it is using a non thread safe >>

Re: [GENERAL] Deadlock in libpq

2011-03-25 Thread Erik Hesselink
On Thu, Mar 24, 2011 at 20:38, Merlin Moncure wrote: > On Thu, Mar 24, 2011 at 11:57 AM, Merlin Moncure wrote: >> On Thu, Mar 24, 2011 at 11:52 AM, Merlin Moncure wrote: As far as connections getting dropped: yes, this sounds reasonable, but given that both the client and the server ar

Re: [GENERAL] Deadlock in libpq

2011-03-24 Thread Erik Hesselink
On Thu, Mar 24, 2011 at 17:18, Merlin Moncure wrote: > On Thu, Mar 24, 2011 at 10:54 AM, Erik Hesselink wrote: >> On Thu, Mar 24, 2011 at 16:43, Merlin Moncure wrote: >>> He needs to rule out the most obvious problem first -- PQInitSSL being >>> called improperly or a

Re: [GENERAL] Deadlock in libpq

2011-03-24 Thread Erik Hesselink
s without SSL though. I think if my threads were dying, I'd see a log message: there are top level exception handlers that log to email, file and the console. The connection code also has a handler that closes the connection in case of an exception. -- Erik Hesselink http://silkapp.com --

Re: [GENERAL] Deadlock in libpq

2011-03-24 Thread Erik Hesselink
e for HDBC-postgresql, and it also creates a new connection each time I ask it to (i.e. no caching/pooling etc) by calling PQconnectdb. So I'm pretty sure I'm not sharing a connection between two threads. This is a web application, so there is pretty good isolation between different thre

Re: [GENERAL] Deadlock in libpq

2011-03-24 Thread Erik Hesselink
On Thu, Mar 24, 2011 at 15:21, Merlin Moncure wrote: > On Thu, Mar 24, 2011 at 9:07 AM, Erik Hesselink wrote: >> On Thu, Mar 24, 2011 at 14:23, Merlin Moncure wrote: >>> On Thu, Mar 24, 2011 at 4:17 AM, Erik Hesselink wrote: >>>> Hi, >>>> >>>&

Re: [GENERAL] Deadlock in libpq

2011-03-24 Thread Erik Hesselink
On Thu, Mar 24, 2011 at 14:23, Merlin Moncure wrote: > On Thu, Mar 24, 2011 at 4:17 AM, Erik Hesselink wrote: >> Hi, >> >> We're getting a deadlock in our application (a web application with a >> PostgreSQL backend) which I've traced to libpq. I've star

[GENERAL] Deadlock in libpq

2011-03-24 Thread Erik Hesselink
is no further context around these messages. Any help would be greatly appreciated. Sincerely, -- Erik Hesselink http://silkapp.com [1] http://hackage.haskell.org/package/HDBC [2] http://hackage.haskell.org/package/HDBC-postgresql -- Sent via pgsql-general mailing list (pgsql-general@post