AccessExclusiveLock on tuple?

Поиск
Список
Период
Сортировка
Искать
От
Christophe Pettus
Тема
AccessExclusiveLock on tuple?
Дата
Msg-id
2FC07A26-BEEB-4E49-B75B-2D5F1FC1DE81@thebuild.com
Список
Дерево обсуждения
AccessExclusiveLock on tuple? Christophe Pettus <xof@thebuild.com>
Re: AccessExclusiveLock on tuple? Bill Moran <wmoran@potentialtech.com>
Re: AccessExclusiveLock on tuple? Christophe Pettus <xof@thebuild.com>
Re: AccessExclusiveLock on tuple? Bill Moran <wmoran@potentialtech.com>
Re: AccessExclusiveLock on tuple? Christophe Pettus <xof@thebuild.com>
Re: AccessExclusiveLock on tuple? Tom Lane <tgl@sss.pgh.pa.us>
Re: AccessExclusiveLock on tuple? Christophe Pettus <xof@thebuild.com>
Re: AccessExclusiveLock on tuple? rob stone <floriparob@gmail.com>
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.045 ms

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


В списке pgsql-general по дате отправления
От: David Kensiski
Дата:
От: CS DBA
Дата:
FAQ