Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavan Pandey
Subject Re: Some sql query got stuck in poll.
Date
Msg-id CAO38WBfTzFnmMepUVM2hiXjDKvonjk-b8GqnH8tuovHBPqQqFQ@mail.gmail.com
Whole thread Raw
In response to Re: Some sql query got stuck in poll.  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-odbc
Tree view
We have waited for ~45 seconds to wait for response from server and client is restarted after this time period to avoid situation to stuck application for indefinite time.
In further analysis i can see that some bad logic is done for coordination of retry_count and no_timeout in code of Wait_for_ready_socket function that is actually causing indefinite waiting in poll for case of non-zero value in retry_count. 

I think that logic should be corrected. Please let me know if there is any possibility to correct it.

 

On Fri, Sep 26, 2014 at 11:54 PM, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
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




--
Best Regards,

Pavan Kumar Pandey | Senior Software Engineer
GlobalLogic Inc. | Innovation by Design
Tower A, Oxygen Park SEZ, Plot No. 7, Sec - 144, Noida 201304, U.P. India 
Office: +91 120 406 2000 X2203 | Mobile: +91 931 027 0452 | www.globallogic.com

pgsql-odbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Some sql query got stuck in poll.
Next
From: pieri70
Date:
Subject: Win 7 x64 odbc call failed