Re: Problem running "ALTER TABLE...", ALTER TABLE waiting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian McNally <bmcnally(at)uw(dot)edu>
Cc: Sergey Konoplev <sergey(dot)konoplev(at)postgresql-consulting(dot)com>, raghu ram <raghuchennuru(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem running "ALTER TABLE...", ALTER TABLE waiting
Date: 2012-08-09 00:58:52
Message-ID: 27601.1344473932@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brian McNally <bmcnally(at)uw(dot)edu> writes:
> Ok, I'm running with all available updates and kernel 2.6.18-308.4.1.el5
> but am still having the same problem.

It's fairly clearly blocked on a lock ... have you looked into the
pg_locks view to see what is holding the lock?

(I'm wondering about a prepared transaction, myself. There isn't much
else that could hold a lock across a server restart.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geert Mak 2012-08-09 05:57:25 Re: processing large amount of rows with plpgsql
Previous Message Fanbin Meng 2012-08-08 20:35:20 postgresql service stoped