error message and documentation

From: Ivano Luberti <luberti(at)archicoop(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: error message and documentation
Date: 2009-09-30 15:34:43
Message-ID: 4AC37A93.1070302@archicoop.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all, I use PostgresSQL 8.3 through JDBC
Recently one transaction has failed with the following error message:

Detail: Process 10660 waits for AccessShareLock on relation 36036 of
database 34187; blocked by process 2212.
Process 2212 waits for AccessExclusiveLock on relation 36044 of database
34187; blocked by process 10660.

I'm trying to understand why I can have this kind or error (it is
probably some programming mistake) but reading the PostgresSQL manual I
cannot find any trace of AccessExclusiveLock , while I have found
explanation of what AccessShareLock is.
First question: is there a problem in the documentation or in
PostgresSQL error messages ?

Another question. The message above was reported to explain why a query
sent to the db server has failed: am I right saying that, looking at the
above error message, Process 10660 was the one executing the query that
has failed and Process 2212 was executing something else and kept going
its way ?

Final question: is there a way to know what query a Process has executed
? I'm thinking of some logging configuration for PostgresSQL.

TIA to all of you.

--
==================================================
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==================================================

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-09-30 15:45:09 Re: error message and documentation
Previous Message Tom Lane 2009-09-30 15:27:38 Re: ms-sql -> pg 8.x