Re: Some sql query got stuck in poll.

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