Re: REINDEX deadlock - Postgresql -9.1

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Anoop K <anoopk6(at)gmail(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Venkatraju TV <venkatraju(at)gmail(dot)com>
Subject: Re: REINDEX deadlock - Postgresql -9.1
Date: 2013-02-07 14:12:44
Message-ID: 1360246364.52493.YahooMailNeo@web162905.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Anoop K <anoopk6(at)gmail(dot)com> wrote:

>I will try. Here are the gdb stacktraces of hung processes.

>
>
><idle in transaction>

Have you tried `kill -SIGTERM` on the "idle in transaction" pid?

-Kevin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-02-07 14:42:38 Re: DEFERRABLE NOT NULL constraint
Previous Message Magnus Hagander 2013-02-07 12:48:40 Re: Hot Standby has PANIC: WAL contains references to invalid pages