Re: Lock partitions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Lock partitions
Дата
Msg-id 16984.1158277524@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Lock partitions  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Lock partitions  (markw@osdl.org)
Re: Lock partitions  (Mark Wong <markw@osdl.org>)
Список pgsql-hackers
Mark Wong <markw@osdl.org> writes:
> Curious, I'm still seeing the same behavior.  Maybe I'll take another 
> snapshot from CVS.

Hm, maybe I need to try a bit harder here.  Does the "not registered"
error happen immediately/reliably for you, or do you need to run the
test awhile?

> As for the deadlock issue you mention I've been told 
> I have some seeding/random number generation problems in the kit. 
> Perhaps that is related to the deadlock at least.

The nature of the locks suggests that you have two transactions trying
to update the same two rows in opposite orders.  The usually recommended
fix is to ensure you use a consistent processing order within a
transaction (eg, ascending primary keys --- but any well-defined row
ordering will work).
        regards, tom lane


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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: [ADMIN] Vacuum error on database postgres
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] Vacuum error on database postgres