PDA

View Full Version : Trouble Optimizing Players..



Lefort
02-16-2011, 02:55 PM
I recently had some computer issues and had to shut down the computer manually with HM running as well as a bunch of clients and other software.

Upon restart, HM forced me to re-connect to my database. And a couple funny things have happened since. First off, one of the many clients stopped auto-importing.. as in the auto-import no longer looked for that folder as it had vanished off the list. No big deal, I just added it again. But it has me a bit paranoid that I'm missing hands on some sites somewhere or something.

More importantly (of the bugs), I'm now getting an "Optimize Reports" window every time I start HM and it tries to optimize 3 players. It's 3 players that have used my computer to play before so they may have more hands than most players in my DB. It says "processing.." and then I get the following error after about 1-2 minutes: "The following error occurred: ERROR: XX001: invalid page header in block 40387 of relation "playerhandsflop"." This happens for each name, so it takes me ~5 minutes before I can use the program after opening it. And it happens every time.

Normally, I wouldn't care much. But I'm just paranoid that my whole DB is going to crash or become corrupt or something while all I had to do was a quick-fix of some sort.

Note that I've had problems with Analyzing/Vacuuming and Backup/Restore with pgAdmin with my database in the past, as seen here: http://forums.holdemmanager.com/manager-general/41916-database-back-up-restore-attempt.html

Thanks for any help, it's much appreciated.

RDB
02-16-2011, 03:30 PM
The error means your database is corrupt. You will need to create a new database and reimport your hands.

Export your Hand Histories
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
http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database

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

Lefort
02-16-2011, 08:52 PM
What exactly does a corrupt DB imply? I'm just curious because it seems to be working fine and I'm guessing its going to be a big ordeal to move it seeing how its a few million hands.

Patvs
02-17-2011, 04:50 AM
You have a corrupt index "playerhandsflop".
It just means the SQL server can't read all the files in that index. (either because the info is MISSING, or the info literally is corrupt and doesn't make any sense)

You can try a REINDEX in pgadminIII of your database.

Only if that DOESN'T resolve it, you'll have to create a new empty database and reimport your hands.