Re: REINDEX deadlock - Postgresql -9.1

On 2/6/2013 1:28 AM, Anoop K wrote:
> 3 connections are going in to some dead lock state.
>
>  1. *idle in transaction *
>  2. *REINDEX waiting *
>  3. *SELECT waiting *
>

you need to track down what resources are being locked by those
processes, by joining pg_stat_activity against pg_locks and.... (been
awhile, I forget the magic join query that gives you useful info here)

IDLE in Transaction means that connection did a BEGIN;  but isn't
executing any commands at all at present and is just sitting there. This
should never happen, and is generally a sign of buggy application
software, or poorly designed ORM or something.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast