From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Anoop K *EXTERN*" <anoopk6(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Cc: | Venkatraju TV <venkatraju(at)gmail(dot)com> |
Subject: | Re: REINDEX deadlock - Postgresql -9.1 |
Date: | 2013-02-07 07:53:33 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B057B0716@ntex2010a.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Anoop K wrote:
> We are hitting a situation where REINDEX is resulting in postgresql to go to dead lock state for ever.
> On debugging the issue we found that
> 3 connections are going in to some dead lock state.
>
> 1. idle in transaction
> 2. REINDEX waiting
> 3. SELECT waiting
>
> All these connections are made in the same minute. Once in deadlock state we are not able to make new
> connections to db.(So not able to view pg_locks also). New connections appears as 'startup waiting' in
> ps output. Initially we suspected <idle in transaction> is the result of not closing a connection. But
> it seems it got stuck after creating a connection and is not able to proceed.
>
> Any clues ..
Check the contents of pg_locks:
What locks does the "idle in transaction" session hold?
Who holds the locks that block SELECT, REINDEX and new connections?
Turn on log_statement='all' to see what the "idle in transaction"
session did since it started.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Travers | 2013-02-07 08:11:24 | Re: DEFERRABLE NOT NULL constraint |
Previous Message | Ben Madin | 2013-02-07 07:50:51 | Re: ERROR: invalid input syntax for integer: "" |