Re: Lock up, but not deadlock?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Lock up, but not deadlock?
Дата
Msg-id 14547.1015532995@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Lock up, but not deadlock?  (Daniel Åkerud <zilch@home.se>)
Список pgsql-general
=?iso-8859-1?Q?Daniel_=C5kerud?= <zilch@home.se> writes:
> Is there a possibility that there will be a lock in a transaction, but it i=
> s not a deadlock?
> I have N functions (about 20-25) interacting in a system. They are like: se=
> tUserOnline(...) setUserOffline(...) setServerOnline(...) and so forth. We =
> have found out that there are sometimes deadlocks.

What PG version?

There used to be some bugs in the deadlock detector, but there are no
known bugs there as of 7.2.

            regards, tom lane

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

Предыдущее
От: Darren Ferguson
Дата:
Сообщение: Re: Problem with Subquery
Следующее
От: Daniel Åkerud
Дата:
Сообщение: Re: Lock up, but not deadlock?