Skip site navigation (1) Skip section navigation (2)

Re: BUG #6101: ALTER TABLE hangs with AccessExclusiveLock

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Dmitry <y4gr5rzn(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6101: ALTER TABLE hangs with AccessExclusiveLock
Date: 2011-07-09 02:19:29
Message-ID: 4E17BAB1.2020806@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-bugs
On 8/07/2011 7:33 PM, Dmitry wrote:
> The following bug has been logged online:
>
> Bug reference:      6101
> Logged by:          Dmitry
> Email address:      y4gr5rzn(at)gmail(dot)com
> PostgreSQL version: 9.0.4
> Operating system:   Debian i686 2.6.32-5-686-bigmem
> Description:        ALTER TABLE hangs with AccessExclusiveLock
> Details:
>
> ALTER locks the table AccessExclusiveLock and hangs.
> I can break it with Ctrl-C in psql, but it 100% reproduces in any session.

Are there any other sessions running concurrently? Is a lock on the 
table you are trying to ALTER already held by another transaction 
according to pg_locks ?

So far there's no evidence that this is anything except locking doing 
its job.

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088     Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/

In response to

Responses

pgsql-bugs by date

Next:From: Robert HaasDate: 2011-07-09 03:28:32
Subject: Re: make_greater_string() does not return a string in some cases
Previous:From: Craig RingerDate: 2011-07-09 02:17:41
Subject: Re: BUG #6099: Does pgcluster support hibernate?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group