From: Gerald Gutierrez <gutz@kalador.com>
To: pgsql-sql@postgresql.org
Subject: Can a SELECT block?
Date: Wed, 28 Mar 2001 16:10:58 -0800
Message-ID: <IIEOKIIOJMELMIFMMEBFGEGCCAAA.gutz@kalador.com> (raw)
Hi all.
I'm trying to track down a deadlock problem caused by some automatically
generated SQL code. It seems I'm deadlocking on a table that is actually
quite rarely modified. I'm unsure, but it appears that maybe something is
blocking on a SELECT call.
Under what situations can a SELECT block?
I'm assuming that a simple INSERT probably cannot block anywhere.
Under what situations, aside from two UPDATEs to the same row, can an UPDATE
block?
I'd appreciate any time. To give some details, it appears that my
application server (Orion) is holding connections to the database, some of
which are not in transactions, and some of which are "primed" for
connections (meaning that a BEGIN is always issued, and waits till
transactional work needs to be done, at which point it issues a COMMIT and
then another BEGIN and waits again). It seems to always issue the command
"SET TRANSACTION ISOLATION LEVEL READ COMMITTED" after each BEGIN.
I'd appreciate any help that anyone can give.
Thanks.
Gerald.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: gutz@kalador.com
Subject: Re: Can a SELECT block?
In-Reply-To: <IIEOKIIOJMELMIFMMEBFGEGCCAAA.gutz@kalador.com>
References: <IIEOKIIOJMELMIFMMEBFGEGCCAAA.gutz@kalador.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox