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

Re: Problem with PITR Past Particular WAL File

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Craig McElroy <craig(dot)mcelroy(at)contegix(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problem with PITR Past Particular WAL File
Date: 2007-10-26 12:53:09
Message-ID: 4721E335.8090601@sigaev.ru (view raw or flat)
Thread:
Lists: pgsql-admin

Craig McElroy wrote:
> Teodor:
>   Thanks for the followup.  We will be upgrading this system to 8.2.5 in 
> the next day or so and will test it on that anyways just to be sure it 
> isn't related.  Let me know if there is anything else we can provide to 
> help track down the bug.  We will be keeping this base backup and WAL 
> files around so that we can use them for testing.
If I'm right then 8.2.5 will not help you. Attached patch should fix your 
problem, but I suppose that there is an another bug. Test specially developed 
for reproduce your problem discovers another issue. The diagnostic is:
FATAL:  failed to add item to index page in 1663/10819/16460
CONTEXT:  xlog redo Insert item, node: 1663/10819/16460 blkno: 514 offset: 78 
nitem: 1 isdata: F isleaf F isdelete F updateBlkno:1551

Now I'm working on fixing it.
-- 
Teodor Sigaev                                   E-mail: teodor(at)sigaev(dot)ru
                                                    WWW: http://www.sigaev.ru/

Attachment: fix_ginstate_usage.patch
Description: text/plain (2.8 KB)

In response to

pgsql-admin by date

Next:From: David LowryDate: 2007-10-26 18:10:58
Subject: way to turn off epochs in log_filename
Previous:From: Dawid KuroczkoDate: 2007-10-26 09:54:13
Subject: Re: 32-bit to 64-bit migration screwup

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