Re: WAL failure?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jim(at)spectrumtelecorp(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL failure?
Date: 2001-06-21 18:58:31
Message-ID: 22377.993149911@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jim Buttafuoco" <jim(at)spectrumtelecorp(dot)com> writes:
> My system crashed today (don't know why yet.) After i started the
> postmaster the log file this entry in it.
> DEBUG: ReadRecord: invalid magic number 0000 in logfile 4 seg 34 off
> 15777792
> Is this a problem???

This looks like a fairly normal WAL-log-recovery situation: the code is
going to hit an invalid WAL record when it falls off the end of what was
correctly logged, and right now it's set up to write DEBUG messages
about any sort of invalid record. Possibly when WAL is mature we'll
consider suppressing most of the DEBUG output it currently generates...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2001-06-21 19:00:10 Re: newbie primary key problem
Previous Message Bruce Momjian 2001-06-21 18:54:45 Re: [Help] Temporary Table: Implicitely created index not shown in \d i