| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2011-07-09 03:28:32 | Re: make_greater_string() does not return a string in some cases |
| Previous Message | Craig Ringer | 2011-07-09 02:17:41 | Re: BUG #6099: Does pgcluster support hibernate? |