From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: How would I "close" a atble?
Date: Mon, 17 Dec 2007 23:25:33 -0500
Message-ID: <20791.1197951933@sss.pgh.pa.us> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C03062E2E@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C03062E2C@egcrc-ex01.egcrc.org>
<27986.1197936710@sss.pgh.pa.us>
<FE44E0D7EAD2ED4BB2165071DB8E328C03062E2E@egcrc-ex01.egcrc.org>
"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> That pid 6697 caught my interest and I fished it out of "ps -ef":
> postgres 6697 4916 0 Dec15 ? 00:19:45 postgres: postgres canon [local] REINDEX waiting
> (and for the sake of completeness...)
> postgres 12930 4916 0 11:24 ? 00:00:00 postgres: gbrush canon 172.16.1.106(37819) SELECT waiting
> postgres 18177 4916 0 Dec15 ? 00:00:02 postgres: gbrush canon 172.16.1.106(53874) SELECT waiting
> postgres 18825 4916 0 12:55 ? 00:00:00 postgres: tsakai canon 127.0.0.1(44558) SELECT waiting
The deal here is that the REINDEX is blocked trying to get exclusive
lock on table 16496, while those other guys are (apparently) stacked
up behind it. What you have not shown us is what transaction has
actually *got* a lock on 16496.
> I could kill this process from unix
> level, but before I do so, would you please comment as to why
> this might have happened and what repercussion might I have
> from killing it, if any?
kill -INT would probably be safe enough, but you should first look into
what is blocking the REINDEX from going through.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, tsakai@gallo.ucsf.edu
Subject: Re: How would I "close" a atble?
In-Reply-To: <20791.1197951933@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox