Re: Alter command getting stuck on a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Shrikant Bhende <shrikantpostgresql(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Alter command getting stuck on a table
Date: 2020-01-07 12:44:34
Message-ID: 4965.1578401074@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> writes:
> On Tue, 2020-01-07 at 14:58 +0530, Shrikant Bhende wrote:
>> I am trying to add a column to a table but it's not working, I have also tried
>> reindex and drop on the same table but those commands are also getting stuck.

> There is a concurrent session which has an open transaction which
> holds some lock on the table in question.

Yes, that looks like the cause. The pg_locks view could help you
find the culprit session.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2020-01-07 18:53:48 Moving child tables to partitions?
Previous Message Laurenz Albe 2020-01-07 09:57:41 Re: Alter command getting stuck on a table