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: Dmitriy Savricov <y4gr5rzn(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6101: ALTER TABLE hangs with AccessExclusiveLock
Date: 2011-07-09 08:14:12
Message-ID: 4E180DD4.7050601@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-bugs
On 9/07/2011 4:05 PM, Dmitriy Savricov wrote:
> As i figured out, the reason is in "<IDLE>  in transaction" process,
> which hangs after table filling. From yestaday, I could not understand
> what the process keeps the lock, and thinked that reason was inside
> FTS - from system tables (pg_class) it was impossible to determine who
> has locked the database. Today, I accidentally found the python
> process in transaction.
>
> Thank you very much for your help, and sorry for false report.
>
No worries. In future it'd be best to submit a test case that can be run 
as an SQL file, along with things like the contents of pg_locks and 
pg_stat_activity during the suspected fault, log excerpts, etc etc if 
you find something that you think might be a bug. If in doubt, ask on 
the pgsql-general mailing list, providing as much detail as you can.

Thanks for following up.

--
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

pgsql-bugs by date

Next:From: Jon C.Date: 2011-07-10 13:53:06
Subject: BUG #6105: Failed to load Main-Class manifest attribute
Previous:From: Robert HaasDate: 2011-07-09 03:28:32
Subject: Re: make_greater_string() does not return a string in some cases

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