Re: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: lists <lists01(at)dds(dot)uconn(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000
Date: 2004-07-16 06:13:25
Message-ID: 20040716061325.GB22512@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jul 16, 2004 at 02:09:33PM +0800, Christopher Kings-Lynne wrote:
> >>LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment
> >>5, offset 3817472
> >>LOG: redo is not required
> >>PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000
> >>LOG: startup process (pid 16068) was terminated by signal 6
> >>LOG: aborting startup due to startup process failure
> >>
> >>this is 7.3.3 (PGDG rpm's) on red hat 7.2
> >
> >
> >Get 7.3.6 and try again. IIRC this is a known bug that was repaired in
> >7.3.4.
>
> That won't help him start up his DB though will it?

AFAIU it should ...

> It will just prevent the problem in the future? Is it the same fix as
> for me? Appending zeros to a file?

As far as I remember, your problem was much worse ... This is a strange
bug where the Xlog code would refuse to replay a record that starts just
at the start of the segment. A later version deals with this situation
correctly.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Este mail se entrega garantizadamente 100% libre de sarcasmo.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2004-07-16 06:22:38 Re: ODBC Developers
Previous Message Alvaro Herrera 2004-07-16 06:10:34 Re: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000