Re: "invalid page header in block 597621 of relation..."error

On 24/11/05 3:52 pm, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Adam Witney <awitney(at)sgul(dot)ac(dot)uk> writes:
>> bugasbase2=# vacuum;
>> WARNING: relation "mba_data_base" page 597621 is uninitialized --- fixing
>
> This is the expected result of what you did.
>
>> WARNING: relation "mba_data_base" page 640793 is uninitialized --- fixing
>> WARNING: relation "mba_data_base" page 640794 is uninitialized --- fixing
>> WARNING: relation "mba_data_base" page 640795 is uninitialized --- fixing
>> WARNING: relation "mba_data_base" page 640796 is uninitialized --- fixing
>> WARNING: relation "mba_data_base" page 640797 is uninitialized --- fixing
>> WARNING: relation "mba_data_base" page 640798 is uninitialized --- fixing
>
> That's a bit odd. There are scenarios where all-zero pages can
> legitimately appear in a PG file --- specifically, if PG extends
> the table and the OS completes that task, but then there's a crash
> before PG gets to write any data into the new page. Conceivably a
> crash during a bulk data load process could result in half a dozen
> such pages together, but it seems improbable. Try looking at the
> data on the preceding and following pages --- does it look like there's
> something missing?

If you mean by that, this:

select * from mba_data_base where ctid = '(640792,12)';
select * from mba_data_base where ctid = '(640799,1)';

Then the data looks normal... Of course everything in between that is now
blank.

Is that what you meant?

Thanks

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.