Re: and waiting
| От | Tom Lane |
|---|---|
| Тема | Re: |
| Дата | |
| Msg-id | 24901.1201991330@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на |
Re: |
| Ответы |
Re: |
| Список | pgsql-hackers |
I wrote:
> "Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
>> I saw a strange behaviour on one of the production boxes. The
>> pg_stat_activity shows a process as <IDLE> and yet 'waiting' !!! On top of
>> it (understandably, since its IDLE), there are no entries for this pid in
>> pg_locks!
> Hmm, I can reproduce something like this by aborting a wait for lock.
> It seems the problem is that WaitOnLock() is ignoring its own good
> advice, assuming that it can do cleanup work after waiting.
I've committed a fix for this. (Too late for 8.3.0, unfortunately.)
regards, tom lane
В списке pgsql-hackers по дате отправления: