Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks
Дата
Msg-id 34867911-3DC4-48F9-BD73-975AE9748CCD@silentmedia.com
обсуждение исходный текст
Ответ на Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения

On Apr 25, 2012, at 1:31 PM, Tom Lane wrote:

I don't have all the details in my head, but if you deliberately provoke
a deadlock by making two transactions update the same two rows in
opposite orders, you'll soon find out what it looks like in the log.

Heh, duh. Looks like your first guess was correct, as usual. Conflicting updates in two transactions show up in the logs as a ShareLock deadlock.

Thanks!

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks