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. :)
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.