[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>
More information about the Tracker-discuss