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

Re: BUG #6741: ExclusiveLock on extension of relation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ryseq(at)hotmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6741: ExclusiveLock on extension of relation
Date: 2012-07-17 17:09:24
Message-ID: 12878.1342544964@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
ryseq(at)hotmail(dot)com writes:
> i have  been getting the  message below in the  logs  whats causes these
> statements to appear in the logs?
 
>   process 11812 acquired ExclusiveLock on extension of relation 60777 of
> database 16387 after 1392.303 ms
> LOG:  process 24079 still waiting for ExclusiveLock on extension of relation
> 60777 of database 16387 after 1000.183 ms

Apparently you've got log_lock_waits turned on.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Chan PhamDate: 2012-07-17 18:53:55
Subject: Re: log_truncate_on_rotation=on is not truncating
Previous:From: ryseqDate: 2012-07-17 15:04:10
Subject: BUG #6741: ExclusiveLock on extension of relation

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