Re: "PANIC: cannot make new WAL entries during recovery" in the wild

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: "PANIC: cannot make new WAL entries during recovery" in the wild
Date: 2009-08-06 21:37:19
Message-ID: 20090806213719.GS7769@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark wrote:
> 2009/8/6 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> >> 2009-08-05 11:58:19 COTLOG:  la dirección de página 0/6D374000 en el
> >> archivo de registro 0, segmento 117, posición 3620864 es inesperada
> >
>
> Incidentally, Google's translate gives me the impression that the
> above message corresponds to:
>
> if (!XLByteEQ(hdr->xlp_pageaddr, recaddr))
> {
> ereport(emode,
> (errmsg("unexpected pageaddr %X/%X in log file %u, segment %u, offset %u",
> hdr->xlp_pageaddr.xlogid, hdr->xlp_pageaddr.xrecoff,
> readId, readSeg, readOff)));
> return false;
> }

Yes, that's correct. (It would be great to have a system to
reverse-translate the messages based on the PO files ...)

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-08-06 22:13:03 Re: compilation with libeditpreferred is broken
Previous Message Tom Lane 2009-08-06 21:36:00 Re: "PANIC: cannot make new WAL entries during recovery" in the wild