Skip site navigation (1) Skip section navigation (2)

Re: error message and documentation

From: Ivano Luberti <luberti(at)archicoop(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: error message and documentation
Date: 2009-09-30 16:30:46
Message-ID: 4AC387B6.2030908@archicoop.it (view raw or flat)
Thread:
Lists: pgsql-general
I don't know: I'm not subscribed to the anno9unce list so I was not
aware 8.4 has now a production release.
In the past upgrading from 8.2 to 8.3 solved a big issues but at the
time the application is not in production.
So we are going to evaluate this option.

Anyway after reading the manual in the section you pointed out I have
been able to identify the other process involved in deadlock: we are
going to analyze when the two threads can conflict. I suspect we will
have to use the list again...

Regards

Tom Lane ha scritto:
> Ivano Luberti <luberti(at)archicoop(dot)it> writes:
>   
>> My problem is I know what query has failed , but I don't know the other
>> one that caused the deadlock condition.
>>     
>
> Ah.  Is it practical for you to upgrade to PG 8.4?  IIRC the deadlock
> reporting code got improved in 8.4 to log all the queries involved.
>
> 			regards, tom lane
>
>   

-- 
==================================================
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

pgsql-general by date

Next:From: Daniel FDate: 2009-09-30 17:35:51
Subject: Weird behavior with "sensitive" cursors.
Previous:From: Tom LaneDate: 2009-09-30 16:24:10
Subject: Re: error message and documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group