Re: Some sql query got stuck in poll. - Mailing list pgsql-odbc

From Heikki Linnakangas
Subject Re: Some sql query got stuck in poll.
Date
Msg-id 5425AF72.1010105@vmware.com
Whole thread Raw
In response to Some sql query got stuck in poll.  (Pavan <pavan.pandey@globallogic.com>)
Responses Re: Some sql query got stuck in poll.  (Pavan Pandey <pavan.pandey@globallogic.com>)
List pgsql-odbc
On 09/25/2014 01:42 PM, Pavan wrote:
> Hi,
>
> I have application running in multi-threaded architecture and application
> updates DB from data in cache periodically . But unfortunately we are
> getting some query got stuck in poll for indefinite time. This behavior is
> happened some time with application but not any particular scenario. We can
> not reproduce it always it's random issue. We have design to restart
> application if it got stuck for more than specified time period.
>
> I have attached some back trace for query processing as below:

It looks like the driver is waiting for a reply from the server. In
other words, it looks like the server is busy executing the query, and
the client is waiting for it. How long did you wait? Did you check
what's happening in the server when that happens?

- Heikki



pgsql-odbc by date:

Previous
From: Pavan
Date:
Subject: Some sql query got stuck in poll.
Next
From: Pavan Pandey
Date:
Subject: Re: Some sql query got stuck in poll.