Skip site navigation (1) Skip section navigation (2)

Re: Problem with PITR Past Particular WAL File

From: Craig McElroy <craig(dot)mcelroy(at)contegix(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problem with PITR Past Particular WAL File
Date: 2007-10-25 07:34:35
Message-ID: 1FAEADD9-FE4A-444E-9B45-D6192B0265E5@contegix.com (view raw or flat)
Thread:
Lists: 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(dot)mcelroy(at)contegix(dot)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(at)postgresql(dot)org so that  
> your
>        message can get through to the mailing list cleanly

In response to

Responses

pgsql-admin by date

Next:From: Vishal AroraDate: 2007-10-25 07:37:12
Subject: Postgres SQL Client for Suse Linux
Previous:From: Tom LaneDate: 2007-10-25 04:51:20
Subject: Re: l need help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group