Postgres Pro
Downloads
Home   >   mailing lists

AccessExclusiveLock on tuple? - Mailing list pgsql-general

From Christophe Pettus
Subject AccessExclusiveLock on tuple?
Date
Msg-id 2FC07A26-BEEB-4E49-B75B-2D5F1FC1DE81@thebuild.com
Whole thread Raw
Responses Re: AccessExclusiveLock on tuple?  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
Tree view 
On 9.4, I've encountered a locking message I've not seen before:

    process 5293 still waiting for AccessExclusiveLock on tuple (88636,15) of relation 18238 of database 16415 after
5000.045ms 

What conditions produce an "AccessExclusiveLock on tuple"?  Attempting to lock a tuple when another process has done an
explicitLOCK ACCESS EXCLUSIVE? 
--
-- Christophe Pettus
   xof@thebuild.com

pgsql-general by date:

Previous
From: David Kensiski
Date:
Subject: Re: XID wraparound with huge pg_largeobject
Next
From: CS DBA
Date:
Subject: Re: XID wraparound with huge pg_largeobject