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

From Chris Hoover
Subject Re: [GENERAL] 8.2.4 signal 11 with large transaction
Date
Msg-id 1d219a6f0707211836g7a152e3fm69a645ee022617fe@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] 8.2.4 signal 11 with large transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 7/20/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
I guess what we need to do is hack the emergency-recovery path for
error-during-error-processing such that it will prevent trying to print
a very long debug_query_string.  Maybe we should just not try to print
the command at all in this case, or maybe there's some intermediate
possibility like only printing the first 1K or so.  Thoughts?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


I know my 2 cents are not worth that much, but as a DBA, I would really like for you to print at least some of the string causing the abend.  This would greatly assist in the tracing of the offending query.

Chris


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Query plan and execution time of a query
Next
From: "Sibte Abbas"
Date:
Subject: Re: [GENERAL] 8.2.4 signal 11 with large transaction