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

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

From
lists
Date:
i had a lot of debugging enabled.  i went to create an index, and pgsql 
dumped on me.  i tried restarting several times - no luck.

starting postgresql gives:

LOG:  database system shutdown was interrupted at 2004-07-16 01:11:56 EDT
LOG:  checkpoint record is at 0/53A3FC0
LOG:  redo record is at 0/53A3FC0; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 44321; next oid: 111535
LOG:  database system was not properly shut down; automatic recovery in 
progress
LOG:  ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment 
5, offset 3817472
LOG:  redo is not required                                                           [  OK  ]
# 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



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

From
Alvaro Herrera
Date:
On Fri, Jul 16, 2004 at 01:32:01AM -0400, lists 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.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Al principio era UNIX, y UNIX habló y dijo: "Hello world\n".
No dijo "Hello New Jersey\n", ni "Hello USA\n".



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

From
lists
Date:
thank you for replying.

Alvaro Herrera 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.

do you know if there are rpm's for RH7.2 available?

to get the data back, is it a matter of just upgrading and starting the 
db (ie will it perform recovery)?


thanks


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

From
Christopher Kings-Lynne
Date:
  >>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?  It will just 
prevent the problem in the future?  Is it the same fix as for me? 
Appending zeros to a file?

Chris



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

From
Alvaro Herrera
Date:
On Fri, Jul 16, 2004 at 01:55:13AM -0400, lists wrote:
> thank you for replying.
> 
> Alvaro Herrera 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.
> 
> do you know if there are rpm's for RH7.2 available?

No idea, sorry.

> to get the data back, is it a matter of just upgrading and starting the 
> db (ie will it perform recovery)?

That should do.

Depending on how much you value your data, however, it might be
advisable to make a backup of the data directory just in case ...

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Pensar que el espectro que vemos es ilusorio no lo despoja de espanto,
sólo le suma el nuevo terror de la locura" (Perelandra, CSLewis)



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

From
Alvaro Herrera
Date:
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.



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

From
Tom Lane
Date:
lists <lists01@dds.uconn.edu> writes:
> Alvaro Herrera wrote:
>>> 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.

> to get the data back, is it a matter of just upgrading and starting the 
> db (ie will it perform recovery)?

Yes.  There's nothing wrong with your data, it's just a corner case that
was not correctly handled by the recovery code in 7.3.3.

You could actually use any version 7.3.4-7.3.6, but you might as well go
to 7.3.6 while you're at it.
        regards, tom lane