Re: ERROR: invalid page header in block

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Alexandru Coseru <alexcos(at)dristor(dot)ro>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: invalid page header in block
Date: 2006-06-26 18:25:45
Message-ID: 1151346346.2479.49.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 2006-06-26 at 16:28 +0300, Alexandru Coseru wrote:

> billing=> select sum(duration)/60 from cdr__2006 where
> callstarttime<'2006-06-19 00:00:00';
> ERROR: invalid page header in block 3527 of relation "cdr__2006_04_22";
>
> Table cdr__2006_04_22 is a child of cdr__2006_04 , which is a child to
> cdr__2006.
>
> Can somebody explain this error ? What should I do ?

Backup your database immediately. You may have corrupted data blocks.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-06-26 18:32:59 Re: vacuum, performance, and MVCC
Previous Message Alvaro Herrera 2006-06-26 18:21:07 Re: [PATCHES] Non-transactional pg_class, try 2