Postgres Pro
Downloads
Home   >   mailing lists

Re: Logging conflicted queries on deadlocks - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Logging conflicted queries on deadlocks
Date
Msg-id 20080228133427.GF4764@alvh.no-ip.org
Whole thread Raw
In response to Logging conflicted queries on deadlocks  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Tree view 
ITAGAKI Takahiro wrote:

> There are some open issues. One of the issues is that the killed query is
> logged by log_min_error_statement, but conflicted query is logged in DETAIL.
> Killed query is logged only on server but conflicted queries are
> sent to both server and client. In addition, if log_min_error_statement
> is less than ERROR level, only the conflicted queries are logged.
> -- it's inconsistent and unsymmetric.

Hm, your patches crashes for me when there are 3 sessions deadlocked.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-hackers by date:

Previous
From: Aaron Spiteri
Date:
Subject: Silly Newbie question
Next
From: Jorgen Austvik - Sun Norway
Date:
Subject: Re: Buildfarm member gypsy_moth seems not to like alignment patch