Re: Invalid headers and xlog flush failures

Tom Lane wrote:
> Bricklen Anderson <BAnderson@PresiNET.com> writes:
>
>>Feb  1 11:17:50 dev94 postgres[4959]: [472-1] 2005-02-01 11:17:50 PST> ERROR:  xlog flush request
>>972/FC932854 is not satisfied --- flushed only to 73/86D2640
>
>
> Hmm, have you perhaps played any games with pg_resetxlog in this database?
>
> I would have suggested that maybe this represented on-disk data
> corruption, but the appearance of two different but not-too-far-apart
> WAL offsets in two different pages suggests that indeed the end of WAL
> was up around segment 972 or 973 at one time.  And now it's evidently
> ending at 73.  Not good.  What file names do you see in pg_xlog/, and
> what does pg_controldata show?
>
>             regards, tom lane

Hi Tom,

Nope, never touched pg_resetxlog.
My pg_xlog list ranges from 000000010000007300000041 to 0000000100000073000000FE, with no breaks.
There are also these: 000000010000007400000000 to 00000001000000740000000B

$ pg_controldata
pg_control version number:            74
Catalog version number:               200411041
Database system identifier:           4738750823096876774
Database cluster state:               in production
pg_control last modified:             Wed 02 Feb 2005 12:38:22 AM PST
Current log file ID:                  115
Next log file segment:                66
Latest checkpoint location:           73/419A4BDC
Prior checkpoint location:            73/419A4B80
Latest checkpoint's REDO location:    73/419A4BDC
Latest checkpoint's UNDO location:    0/0
Latest checkpoint's TimeLineID:       1
Latest checkpoint's NextXID:          4161807
Latest checkpoint's NextOID:          176864
Time of latest checkpoint:            Wed 02 Feb 2005 12:38:22 AM PST
Database block size:                  8192
Blocks per segment of large relation: 131072
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum number of function arguments: 32
Date/time type storage:               floating-point numbers
Maximum length of locale name:        128
LC_COLLATE:                           en_CA
LC_CTYPE:                             en_CA