Re: Lock up, but not deadlock?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Åkerud <zilch(at)home(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Lock up, but not deadlock?
Date: 2002-03-07 20:29:55
Message-ID: 14547.1015532995@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?Q?Daniel_=C5kerud?= <zilch(at)home(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Åkerud 2002-03-07 20:40:25 Re: Lock up, but not deadlock?
Previous Message Darren Ferguson 2002-03-07 19:57:04 Re: Problem with Subquery