From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
To: pgsql-general@postgresql.org
To: ptharmaraj@sirahu.com
Subject: Re: Postgres 8.3.10 Alter Table Waiting issue
Date: Fri, 17 Jun 2011 08:55:22 -0500
Message-ID: <4DFB167A020000250003E7C2@gw.wicourts.gov> (raw)
References: <4DFB154B020000250003E7B8@gw.wicourts.gov>
<4DFB167A020000250003E7C2@gw.wicourts.gov>
[please don't send a post to multiple lists]
Pratheeban Jebasingh Tharmaraj <ptharmaraj@sirahu.com> wrote:
> I am trying to add column to the table that's hanging.
>
> alter table hr_firms add column_name biginit;
>
> This is the lock I see in the db
>
> relation | 564709 | 586888 | | | |
> | | | | 1/8 | 1871 |
> AccessExclusiveLock | f
So it's temporarily blocking, waiting for conflicting access to
complete.
> Is it known issue or any fix available?
Don't modify the structure of the table at the same time as
conflicting access against the table, or wait for the transactions
performing the conflicting access to commit?
You haven't described the other activity on the table or shown the
other lock(s) involved in the blocking. Without more information,
it's hard to be more specific.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
-Kevin
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: Kevin.Grittner@wicourts.gov, pgsql-general@postgresql.org, ptharmaraj@sirahu.com
Subject: Re: Postgres 8.3.10 Alter Table Waiting issue
In-Reply-To: <4DFB167A020000250003E7C2@gw.wicourts.gov>
* 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