PDA

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



Sinnerpl
01-19-2011, 11:22 AM
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.
http://img193.imageshack.us/img193/2232/error1yh.png
Anyone knows how to fix this ?

fozzy71
01-19-2011, 02:19 PM
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 (http://faq.holdemmanager.com/questions/437/Postgres+Optimization)

FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/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 (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+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/rakeback-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/tourney-data-view-01.jpg

Then can you create a new database FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)

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

Sinnerpl
01-20-2011, 07:43 AM
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
01-20-2011, 10:47 AM
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/manager-bugs/40495-currency-issue.html

Sinnerpl
01-20-2011, 11:55 AM
Sorry to hear that :/

Anyway, great thx for Your time. :)