Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DBC0A9FBF02 for ; Thu, 25 Oct 2007 09:59:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 00595-08 for ; Thu, 25 Oct 2007 09:58:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id EBEB69FBF9D for ; Thu, 25 Oct 2007 09:58:49 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-215-196.bk12-dsl.surnet.cl [201.221.215.196]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l9PCvTDM000987; Thu, 25 Oct 2007 05:57:30 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 8E66347C79; Thu, 25 Oct 2007 09:57:27 -0300 (CLST) Date: Thu, 25 Oct 2007 09:57:27 -0300 From: Alvaro Herrera To: Craig McElroy Cc: Tom Lane , PostgreSQL Admin List Subject: Re: Problem with PITR Past Particular WAL File Message-ID: <20071025125727.GH5661@alvh.no-ip.org> References: <10123.1193250394@sss.pgh.pa.us> <1FAEADD9-FE4A-444E-9B45-D6192B0265E5@contegix.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1FAEADD9-FE4A-444E-9B45-D6192B0265E5@contegix.com> User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: ClamAV 0.91.1/4593/Thu Oct 25 00:03:02 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Thu, 25 Oct 2007 05:57:30 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/249 X-Sequence-Number: 27163 Craig McElroy wrote: > 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 () So it looks like a bug in the gin xlog code, which makes sense because it's new. Can you please execute in that gdb session the command "bt full" and send the output? -- Alvaro Herrera http://www.advogato.org/person/alvherre "La realidad se compone de muchos sueños, todos ellos diferentes, pero en cierto aspecto, parecidos..." (Yo, hablando de sueños eróticos)