Re: Some sql query got stuck in poll.

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Some sql query got stuck in poll.
Дата
Msg-id 5425AF72.1010105@vmware.com
обсуждение исходный текст
Ответ на Some sql query got stuck in poll.  (Pavan <pavan.pandey@globallogic.com>)
Ответы Re: Some sql query got stuck in poll.  (Pavan Pandey <pavan.pandey@globallogic.com>)
Список 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 по дате отправления:

Предыдущее
От: Pavan
Дата:
Сообщение: Some sql query got stuck in poll.
Следующее
От: Pavan Pandey
Дата:
Сообщение: Re: Some sql query got stuck in poll.