Search Postgresql Archives

Re: Recovering data from table show corruption with "invalid page header in block X"

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

 



On Feb 9, 2010, at 3:28 PM, Erik Jones wrote:

> Greetings,
> 
> We've recently had database server crash due to a heavy duty disk failure and upon rebooting we now have a table showing corruption via the "invalid page header in block X" message when querying one table in particular, the rest have all checked out via full table dumps with no errors.
> 
> Here is what we've done so far to try to fix the table and/or recover the good data from it:
> 
> * REINDEX -- no good.
> 
> * Set zero_damaged_pages=on, run query that originally showed the corruption.  This reports 3 different blocks with invalid page headers and reports that they are being zero'd out.  Unfortunately, subsequently querying the table the same blocks show as corrupt.  Well, after running the query twice with zero_damaged_pages=on the first one did go away but the other two remain.
> 
> * Set zero_damaged_pages=on for pg_dump.  Same results as above.
> 
> I'm unsure what to do next to get those damaged pages cleared out...

Scratch that about the first damaged page going away, after a server restart it popped up again.

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k






-- 
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