Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX deadlock - Postgresql -9.1 - Mailing list pgsql-general

From Kevin Grittner
Subject Re: REINDEX deadlock - Postgresql -9.1
Date
Msg-id 1360246364.52493.YahooMailNeo@web162905.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: REINDEX deadlock - Postgresql -9.1  (Anoop K <anoopk6@gmail.com>)
List pgsql-general
Tree view 
Anoop K <anoopk6@gmail.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

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Hot Standby has PANIC: WAL contains references to invalid pages
Next
From: Albe Laurenz
Date:
Subject: Re: DEFERRABLE NOT NULL constraint