Re: Alter command getting stuck on a table

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Shrikant Bhende <shrikantpostgresql(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: Alter command getting stuck on a table
Date: 2020-01-07 09:57:41
Message-ID: 70527e5e5ca140cd0950c1e8c63e19221a207ddc.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Look for old "active" or "idle in transaction" sessions in "pg_stat_activity"
and see that they get closed. Then the ALTER TABLE will work fine.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2020-01-07 12:44:34 Re: Alter command getting stuck on a table
Previous Message Shrikant Bhende 2020-01-07 09:36:07 Re: Alter command getting stuck on a table