Re: deadlocks - sharelocks on transactions

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Tim McAuley <tech-lists(at)mothy(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: deadlocks - sharelocks on transactions
Date: 2004-01-07 16:16:42
Message-ID: 20040107081551.U18778@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Wed, 7 Jan 2004, Tim McAuley wrote:

> Hi,
>
> I have a stored procedure that is causing deadlocks when called multiple
> times synchronously. The odd issue is that the deadlock seems to be
> happening on different threads waiting for locks on transactions. What
> exactly is this transaction lock?

My first guess would be waiting on row level locks. Are you doing
anything with FOR UPDATE or foreign keys?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2004-01-07 16:41:36 Re: problems with transaction blocks
Previous Message Bruno Wolff III 2004-01-07 15:46:55 Re: Paypal WAS: PostgreSQL speakers needed for OSCON