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