[Tracker-discuss] [issue326] Postgres error: invalid page header ...

Martin v. Löwis metatracker at psf.upfronthosting.co.za
Fri Mar 26 23:49:55 CET 2010


Martin v. Löwis <martin at v.loewis.de> added the comment:

I have now created a full database tgz if anybody wants to take a look.

I have then enabled the zero_damaged_pages setting, and vacuum'ed. That produced these messages:

invalid page header in block 0 of relation "_file"; zeroing out page
invalid page header in block 8 of relation "pg_type_typname_nsp_index"; zeroing out page

Dumping the database still failed with a missing pg_clog file. I created one that was zeroed out; this let me proceed. Postgres didn't decide to delete the log file afterwards; this worries me somewhat.

Dumping the database still doesn't work; it gives this error message:

ERROR:  invalid memory alloc request size 18446744073709551613

This happens when doing "select *" or "copy" on _file. Notice that this number is 0xfffffffffffffffd.

izak: can you please provide a copy of the latest backup of /home/roundup/backups/tracker-export where file.csv is not empty?

_______________________________________________________
PSF Meta Tracker <metatracker at psf.upfronthosting.co.za>
<http://psf.upfronthosting.co.za/roundup/meta/issue326>
_______________________________________________________


More information about the Tracker-discuss mailing list