PDA

View Full Version : Invalid page header



Blert
12-20-2009, 08:10 PM
Hi,

on the players tab, if I run the report for Nov '09 to Dec '09 there are no problems. But if I run the report from earlier dates (ie oct '09 to dec '09) I get the following error pop up...

XX001: invalid page header in block 579 of relation "compiledplayerresults_month"

Any ideas on how to fix this ?

Patvs
12-20-2009, 08:17 PM
Sounds like a corrupt database.
You can try to FIX the compiledplayerresults_month INDEX in Database Control Panel, but it's suggested you start a new database.

Blert
12-20-2009, 08:25 PM
Tried that and it seems to have done the job.

Many thanks for speedy and helpful advice

:)

ProsperousOne
12-22-2009, 06:17 PM
I have a similar error message

ERROR: invalid page header in block 3835 of relation "postflopactions_month_idx1"

What's frustrating is I had a corrupt database, so I've just spent the last 2 weeks reimporting all my hands into a new db. And then purged all the observed hands, and tried to vacuum it to reduce db size, and that's when I got the error.

I assume you fix the INDEX by selecting the postflopactions_month_idx1 (under the "+" of the postflopactions_month table), then click Maintence and select "Reindex."?

thx

fozzy71
12-22-2009, 09:31 PM
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168