Re: Lock up, but not deadlock?
От | Daniel Åkerud |
---|---|
Тема | Re: Lock up, but not deadlock? |
Дата | |
Msg-id | 000f01c1c618$5144e970$6400a8c0@studio обсуждение исходный текст |
Ответ на | Lock up, but not deadlock? (Daniel Åkerud <zilch@home.se>) |
Список | pgsql-general |
We use 7.1.3, an upgrade is due next thing in the morning :-) thanks. ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Daniel Åkerud" <zilch@home.se> Cc: <pgsql-general@postgresql.org> Sent: Thursday, March 07, 2002 9:29 PM Subject: Re: [GENERAL] Lock up, but not deadlock? > =?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 по дате отправления: