Re: WAL ends before end time of backup dump

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL ends before end time of backup dump
Date: 2006-11-07 22:24:19
Message-ID: 1162938259.31124.420.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2006-11-07 at 11:15 -0800, Jeff Davis wrote:
> Version: 8.1.4
>

[ snip ]

> OG: restored log file "00000001000000170000002B" from archive
> LOG: record with zero length at 17/2B6EACC8
> LOG: redo done at 17/2B6EAC84
> LOG: restored log file "00000001000000170000002B" from archive
> LOG: archive recovery complete
> LOG: database system is ready
> LOG: transaction ID wrap limit is 1094453440, limited by database
> "postgres"
>

>From the 8.1.4 source I see that:

/*
* Currently, xl_len == 0 must be bad data, but that might not be true

Does that mean that I must have a corrupt WAL segment file
00000001000000170000002B?

Is it possible this was caused by a bug? Would an already known bug
possibly cause this problem?

I am sending the transaction logs to an NFS mount. I consider it to be
reliable storage, so I can't see how that would have been corrupted
unless it was sent that way by PostgreSQL.

Regards,
Jeff Davis

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2006-11-07 22:37:49 Re: WAL ends before end time of backup dump
Previous Message Tom Lane 2006-11-07 22:20:56 Re: WAL ends before end time of backup dump