| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | tamanna madaan <tamanna(dot)madan(at)globallogic(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SOCK_wait_for_ready function call caused a query to get stuck |
| Date: | 2011-03-18 18:09:47 |
| Message-ID: | AANLkTinmB1uiSRk0xAR8uy4dZWiGaP2Wc5RrKZEzXHu3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Mar 18, 2011 at 11:39 AM, tamanna madaan
<tamanna(dot)madan(at)globallogic(dot)com> 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. let's hope the problem is here (look for waiting = true).
Also take note of any sessions idle in transaction if there are any.
> Yes I am opening multiple seesions with ODBC driver and my application is
> multi threaded .
The worst and possibly the most likely case is that you have some sort
of threading/synchronization problem in your application or possibly
the odbc driver itself.
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben Chobot | 2011-03-18 18:17:53 | multi-tenant vs. multi-cluster |
| Previous Message | Steve Crawford | 2011-03-18 18:04:47 | Re: why does extract ( HOUR FROM TIMESTAMP '2010-01-01 00:00:00' at time zone 'utc' ) == 16? |