On 8/07/2011 7:33 PM, Dmitry wrote:
The following bug has been logged online:
Bug reference: 6101
Logged by: Dmitry
Email address: y4gr5...@gmail.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/
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
