Re: help with error "unexpected pageaddr" - Mailing list pgsql-general

From Tom Lane
Subject Re: help with error "unexpected pageaddr"
Date
Msg-id 23432.1284578894@sss.pgh.pa.us
Whole thread Raw
In response to help with error "unexpected pageaddr"  ("Scot Kreienkamp" <SKreien@la-z-boy.com>)
Responses Re: help with error "unexpected pageaddr"  ("Scot Kreienkamp" <SKreien@la-z-boy.com>)
List pgsql-general
"Scot Kreienkamp" <SKreien@la-z-boy.com> writes:
> I tried to take a new base backup about 45 minutes ago.  The master has
> rolled forward a number of WAL files since I last tried, but it still
> fails.

> LOG:  restored log file "0000000100000301000000FE" from archive
> LOG:  restored log file "000000010000030200000000" from archive
> LOG:  restored log file "000000010000030200000001" from archive
> LOG:  restored log file "000000010000030200000002" from archive
> LOG:  restored log file "000000010000030200000003" from archive
> LOG:  unexpected pageaddr 301/50000000 in log file 770, segment 3,
> offset 0

Hmmm ... is it possible that your WAL archive contains log files
numbered higher than where your master is?

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua J. Kugler"
Date:
Subject: Re: Getting FATAL: terminating connection due to administrator command
Next
From: Tom Lane
Date:
Subject: Re: Getting FATAL: terminating connection due to administrator command