ERROR:invalid page header in block 500 of relation base

[jpdpoker]

windows said there was a problem with my drive and it ran fsdisk now I get this error
pg_dump: Error message from server: ERROR: invalid page header in block 500 of relation base/17711/18022

Paul Davidson

[kraada]

There are two main reasons for this error. The first is a result of data corruption from a computer crash that requires reindexing your database. You can reindex your database from the Housekeeping menu.

The second reason for this error is a result of faulty hardware. You can set PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text "zero_damaged_pages = on" on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data. If you continue to have problems with that hard drive, you should consider replacing it.

[pasita]

My DB got pretty messed up, both HE and Omaha. Had the invalid page header stuff show up on almost every page.
Reindexing failed immediately, but after I did the zero_damaged_pages thing I was able to run it further. Now the reindex fails at a later stage and it would seem my HE hands were somewhat salvaged but Omaha side of PT still shows the errors, i.e. it's useless.

Currently the reindex fails with "could not access status of transation 3840440577 DETAIL: Could not open file "pg_clog/0E4E": no such file or directory. (In deed, in pg_clog there's only file 0000).

Also, postgres service started stopping at this point (getting "Connection Lost to Database: mydb"). I can restart via task manager but it stops again at some point when I try to reindex.

Is there anything else left but to restore from backup? I have a dozen of those from this year, but obviously the latest one is 4 months back

EDIT: Also, is it only me or has PT forums started September already? I believe I changed my TZ settings at some point but didn't realize the effect would be that big...

[kraada]

If files are missing in pg_clog there isn't anything we can do to recover them. You might want to check to see if they were quarantined by your antivirus - if so and you can restore them, things should be able to complete successfully. If you can't find them, you won't be able to salvage this database. The best you can hope for is to export the hands played for the last 4 months, restore from backup, and then reimport those hands. On the bright side, the odds of being able to export those hands successfully is fairly high so you will likely have success with this method.

Regarding September - I'm not seeing post dates in September 2011 yet. Where are you seeing these dates?

[pasita]

Ok,
I'll go for a restore if I can't find the stuff in quarantine.

For example the post dates in this thread

Post by jpdpoker » 05 Sep 2011 04:53

Post by kraada » 05 Sep 2011 05:33

Post by pasita » 14 Sep 2011 12:54

Post by kraada » 14 Sep 2011 13:54

or the forums front page, for example:

Technical Support / Bug Reports
Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.
Moderator: Moderators
11739 Topics
56425 Posts
Last post by WhiteRider View the latest post
on 14 Sep 2011 23:42

[pasita]

Re: dates

I'm not actually sure whether it was this forum or another where I recently changed my TZ settings. How ever, when I now checked my board preferences, I was as UTC -12 Baker island time. Changed that to UTC +2 and the dates now make sense, for example the ones I copied above are now showing the correct date.

So this is fine for me now... funny stuff seems to happen at the date change line, reminds me of a Stephen King story

[kraada]

Thanks for following up on the dates issue - I'm glad to hear you got everything working properly now.