ERROR: XX001: invalid page header in block 14218 of relation "playerhandscashkey.."

[Sinnerpl]

Hi all.
I have an issue with my HM - can't use Cash Games -> Reports/Sessions due to an error: XX001: invalid page header in block 14218 of relation "playerhandscashkeykolumns_hero". Tried reindexing DB in postgresql - didn't work out. I cant even export hands from this DB - when i try doing this an error pops up, no matter which DB i set as default.

Anyone knows how to fix this ?

[fozzy71]

You can try to do a full vacuum/reindex using the PG Tuning in HM or PGAdmin but I would suggest you just create a new database. I wouldn't trust a database myself once I get bad index errors.


FAQ - Hold'em Manager Poker Tracking Software :: Postgres Optimization

FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database


The export problem is a known bug and is already fixed internally for the next release. For now you can downgrade from the Help > Previous Releases link, export your hands, and then update to create a new database and import the hands.

Here are all the faq's to make sure you backup everything manually:

Export your Hand Histories
FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands

Export Your Notes
http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback – Options > Rakeback & Bonuses http://faq.holdemmanager.com/images/...bonuses-01.jpg

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

http://faq.holdemmanager.com/images/...ta-view-01.jpg

Then can you create a new database FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database

Finally reimport all your hands/notes/summaries into the new database

[Sinnerpl]

Thx for quick response, Fozzy71.

I exported notes, bonuses & RB, tournaments, downgraded HM to 1.11.05d and exported HH but.. All exported files have 0KB; i created a new DB, imported 3 thousands hands, exported it to another file and everything was ok, when i tried to do the same with entire old DB - all the files were empty.

Any idea what might be wrong?

[netsrak]

I guess your old database is damaged in a way that no hands can be exported.

You can try a selective export to save at least some hands:
http://forums.holdemmanager.com/mana...ncy-issue.html

[Sinnerpl]

Sorry to hear that :/

Anyway, great thx for Your time.