Re: [GENERAL] SOCK_wait_for_ready function call caused a query to get stuck

2011-03-18 Thread Merlin Moncure
On Fri, Mar 18, 2011 at 11:39 AM, tamanna madaan wrote: > Thanks for your reply Merlin . > > If I am getting you correctly, you mean to say that I should check for > waiting queries in pg_stat_activity table > while my application is hung at SOCK_wait_for_ready function call  . Right > ?? correct

Re: [GENERAL] SOCK_wait_for_ready function call caused a query to get stuck

2011-03-18 Thread tamanna madaan
application is multi threaded . Tamanna From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Fri 3/18/2011 8:56 PM To: tamanna madaan Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] SOCK_wait_for_ready function call caused a query to get stuck On Fri, Mar

Re: [GENERAL] SOCK_wait_for_ready function call caused a query to get stuck

2011-03-18 Thread Merlin Moncure
On Fri, Mar 18, 2011 at 4:31 AM, tamanna madaan wrote: > Hi All > >  I am using postgres-8.4.0 and psqlodbc-08.03.0400-1 and > unixODBC-2.2.14-000.01 driver to connect > to the database. One of the queries I executed from my application have got > stuck for an > indefinite amount of time causing m