Re: [7.4.1] signal 11 while accesing DB - Mailing list pgsql-general

From Tom Lane
Subject Re: [7.4.1] signal 11 while accesing DB
Date
Msg-id 24184.1106596131@sss.pgh.pa.us
Whole thread Raw
In response to [7.4.1] signal 11 while accesing DB  (Marcin <migor@op.pl>)
List pgsql-general
Marcin <migor@op.pl> writes:
> Okay, then pg_filedump 1262:

> and suddenly:
> Block    4 ********************************************************
> <Header> -----
>  Block Offset: 0x00008000         Offsets: Lower       0 (0x0000)
>  Block: Size    0  Version    0            Upper       0 (0x0000)
>  LSN:  logid      0 recoff 0x00000000      Special     0 (0x0000)
>  Items:    0                   Free Space:    0
>  Length (including item array): 24

>  Error: Invalid header information.

Ah-hah.  This case should be coped with by 7.4.3 and later, due to this patch:

2004-06-05 13:42  tgl

    * src/include/storage/: bufpage.h (REL7_4_STABLE), bufpage.h:
    Adjust PageGetMaxOffsetNumber to ensure sane behavior on
    uninitialized pages, even when the macro's result is stored into an
    unsigned variable.

In the meantime a VACUUM of pg_database should get you out of trouble.

            regards, tom lane

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: number of rown in a cursor.
Next
From: Tom Lane
Date:
Subject: Re: Bug report in 7.4