Re: [GENERAL] 8.2.4 signal 11 with large transaction - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] 8.2.4 signal 11 with large transaction
Date
Msg-id 29933.1185212643@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] 8.2.4 signal 11 with large transaction  ("Sibte Abbas" <sibtay@gmail.com>)
Responses Re: [GENERAL] 8.2.4 signal 11 with large transaction
List pgsql-hackers
"Sibte Abbas" <sibtay@gmail.com> writes:
> I think printing the first 1K would make more sense.

> If I understand you correctly, the code path which you are referring
> to is the send_message_to_server_log() function in elog.c?

No, the place that has to change is where errstart() detects that we're
recursing.  We could possibly have it first try to make a shorter string
and only give up entirely if recursion happens again, but given that
this is such a corner case I don't think it's worth the complexity and
risk of further bugs.  I've made it just drop the statement at the same
time that it decides to give up on printing other context (which can
also be a source of out-of-memory problems btw).
http://archives.postgresql.org/pgsql-committers/2007-07/msg00215.php

            regards, tom lane

pgsql-hackers by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: Full page images in WAL & Cache Invalidation
Next
From: Alvaro Herrera
Date:
Subject: Re: 8.2 is 30% better in pgbench than 8.3