pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Fuhr <mike@fuhr.org>
Cc: Tim Jackson <tim.jackson@ints.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: C set return function differences on 8.0?
Date: Fri, 08 Jul 2005 22:13:23 -0400
Message-ID: <331.1120875203@sss.pgh.pa.us> (raw)
In-Reply-To: <20050709015800.GA11641@winnie.fuhr.org>
References: <42CDCFB4.2030908@ints.com>
	<20050708152339.GA81341@winnie.fuhr.org>
	<42CF168A.4080007@ints.com>
	<20050709015800.GA11641@winnie.fuhr.org>

Michael Fuhr <mike@fuhr.org> writes:
> On Fri, Jul 08, 2005 at 05:12:58PM -0700, Tim Jackson wrote:
>> The backend crashes, in pgadmin  attempting to display the view simple 
>> says aborting.  There is no core dump, and the log only seems to reflect 
>> the standard
>> WARNING:  terminating connection because of crash of another server process

> Where did you look for a core dump?

"There is no core dump" is not an acceptable answer: if there isn't one,
the first item on your agenda must be to get one (or else run the
problem case under gdb so you don't need a dump to get a stack trace).

Usually if there's no dump it's because the default configuration on
your system is "ulimit -c 0" to suppress core dumps from daemons.
Put "ulimit -c unlimited" (or local equivalent) into your postmaster
start script and restart the postmaster.

On the whole though I'd recommend learning how to attach gdb to a live
backend, since then not only can you get a stack trace from the point of
the fault, but you can then work backwards by setting breakpoints ahead
of the crash and stepping through the code to see where it goes wrong.

			regards, tom lane



view thread (7+ messages)  latest in thread

Message-ID: <331.1120875203@sss.pgh.pa.us>
Permalink:  ../331.1120875203@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/331.1120875203@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: tgl@sss.pgh.pa.us, mike@fuhr.org, tim.jackson@ints.com
  Subject: Re: C set return function differences on 8.0?
  In-Reply-To: <331.1120875203@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox