Re: Problem with PITR Past Particular WAL File - Mailing list pgsql-admin

From Craig McElroy
Subject Re: Problem with PITR Past Particular WAL File
Date
Msg-id 1FAEADD9-FE4A-444E-9B45-D6192B0265E5@contegix.com
Whole thread Raw
In response to Re: Problem with PITR Past Particular WAL File  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Problem with PITR Past Particular WAL File  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Problem with PITR Past Particular WAL File  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom:
  Thanks for your help on this.  The trace details are as follows:

Core was generated by `/usr/local/pgsql/bin/postgres -D /pgdata01/data'.
Program terminated with signal 11, Segmentation fault.

#0  0x080b8ee0 in entrySplitPage ()
#1  0x080baccf in ginInsertValue ()
#2  0x080b81b7 in gin_xlog_cleanup ()
#3  0x080af4ce in StartupXLOG ()
#4  0x080c04ca in BootstrapMain ()
#5  0x08186b2f in StartChildProcess ()
#6  0x081889eb in PostmasterMain ()
#7  0x0814ee9e in main ()

Cheers,
-craig

---
Craig A. McElroy
Contegix
Beyond Managed Hosting(r) for Your Enterprise


On Oct 24, 2007, at 1:26 PM, Tom Lane wrote:

Craig McElroy <craig.mcelroy@contegix.com> writes:
Can you get a stack trace from the core dump reported here?

  Certainly, how can that be obtained?

$ gdb /path/to/postgres-executable /path/to/core-file
gdb> bt
gdb> quit

If you don't find a corefile in $PGDATA (or wherever your system puts
core files) then you probably need to restart the postmaster with
"ulimit -c unlimited" to allow producing a core.

If the "bt" output is just numbers and no symbols then it won't be of
any use; in that case you'll need to find or build non-stripped Postgres
executables.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

pgsql-admin by date:

Previous
From: Adam Radlowski
Date:
Subject: sending data with COPY SQL command, libpq and structure of SELECT resulting buffer
Next
From: Alvaro Herrera
Date:
Subject: Re: Problem with PITR Past Particular WAL File