Search Postgresql Archives

Re: Invalid Page Header Error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Carlo Curatolo wrote:
> When I lauch a vacuumdb, I have an error :  ERREUR: en-tête de page invalide
> dans le bloc 39639 de la relation base/16384/599662
> 
> With a
> SELECT * FROM  pg_catalog.pg_largeobject
> 
> Result is
> ERREUR: en-tête de page invalide dans le bloc 39639 de la relation
> base/16384/599662
> 
> I suppose that the data of LargeObject 599662 are corrupted...

That is not the OID of a large object, but of a table.

What do you get for
SELECT oid, relname, relkind FROM pg_class WHERE relfilenode = 599662;

> Question is : How I could I know where this LargeObject is used ?
> 
> I can, of course, use the "zero_damaged_pages = on" option in
> postgresql.conf. Then dump/restore.
> But in this case I didn't know where this corrupted LargeObject is used...

That could result in *all* your large objects or something else
to get destroyed...

You have some kind of data corruption.
Have there been any crashes or unusual occurrences lately?

The best thing would be to check your hardware thoroughly
and restore the database from a backup.

Yours,
Laurenz Albe

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux