lost most of my stats
Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Member
    Join Date
    Sep 2009
    Posts
    60

    Default lost most of my stats

    I was playing when my computer froze, I had to reboot it in order to continue playing, during the reboot my computer said it had an hard drive error and went into a screen that took three stages of some kind of coded that repaired about 20K of files on my hard drive. After the reboot I noticed that I had a lot less hands on player I know I had 4k plus hands on. I'm most cases I had only a few hundred hands on them instead of a few thousand. When I try to pull a report on myself or other players I get this error message.

    The following error occured when running this report:ERROR:XX002:index"playerhandstourneykeycolu ms_idx1" contains unexpected zero page at block 0

    just wanted to know if there is any way to get these hands back? I am not that computer savy so I exsplained it the best way I can
    Last edited by Jaybear; 03-30-2011 at 11:37 AM.

  2. #2
    Moderator RDB's Avatar
    Join Date
    Feb 2011
    Posts
    444

    Default

    Your database is corrupt. The 2 most common causes of these problems are 1) powering off your computer or having your computer lose power while the database is doing something and 2) an old drive with bad sectors on it. You can try to do a full vacuum/reindex manually using PGAdmin to fix

    http://faq.holdemmanager.com/questio...lyze+Database+

    (but I would suggest you just create a new database. I wouldn't trust a database myself once I get bad index errors) This is what you will need to do;

    Export your Hand Histories
    http://faq.holdemmanager.com/questio...6+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 http://faq.holdemmanager.com/questio...elete+Database
    Finally reimport all your hands/notes/summaries into the new database and delete the old one.

  3. #3
    Member
    Join Date
    Sep 2009
    Posts
    60

    Default

    How do you delete the old one?

  4. #4
    Moderator RDB's Avatar
    Join Date
    Feb 2011
    Posts
    444

    Default

    Instructions on how to delete your old database can be found here.

    http://faq.holdemmanager.com/questio...elete+Database

  5. #5
    Member
    Join Date
    Feb 2009
    Posts
    73

    Default

    I have similar problem. My computer lost power while the HM database was doing something. After rebooting I got a message that some file in Postgre folder is corrupted and advice to fix it by Chckdsk. Chkdsk fixed the NTFS by removing orphane chains. I supposed my base was totally broken. But HM works! I can see my old data. But it can't import new hands anymore. In the SQLErrors.txt file there is a bunch of messages:

    The Error: ERROR: XX002: index "pokerhands_pkey" contains unexpected zero page at block 0

    Occurred when trying to save the game

    I'd like to recreate this index and maybe other ones in case they are corrupted too.

  6. #6
    Member
    Join Date
    Feb 2009
    Posts
    73

    Default

    I have

    WINDOWS XP
    SERVICE PACK 3

    HM 1 VERSION 1.12.09

    I am Trying to Analyse the database using pgadmin3 console. It is frosen on 1 table for several hours.

    http://gyazo.com/1d931b009ee057db0c9df454f3bd8fa5

    I'm going to kill pgadmin3.exe process and try to Vacuum as that was suggested to OP in the 1st reply.

  7. #7
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Reindex the database in pgadminIII.
    Ignore any "not responding" message, pgadminIII will unfreeze when the reindex is finished.

    If that doesn't resolve it:
    run dbcontrolpanel.exe from the HoldemManager folder--> export all your hands.
    Update to: http://www.holdemmanager.com/Downloa...25Jun2012a.exe
    run dbcontrolpanel.exe--> create a new database: Database Management--> Connect--> Create New Database--> (set it as default)--> Start HoldemManager
    And reimport your hands.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  8. #8
    Member
    Join Date
    Feb 2009
    Posts
    73

    Default

    Meanwhile performing of VACUUM as was suggested in the 1st reply is finished now. It was Not Responding again for a long time at this point
    bd44e680748ce5fc12a6329749f51a4c.png

    DB size almost not changed by vacuuming it's still 44GB, so I don't want to export/import it.
    Now I have got this:

    INFO: index "pokerhands_pkey" now contains 431 row

    versions in 60059 pages
    DETAIL: 2 index row versions were removed.
    60055 index pages have been deleted, 60055 are currently

    reusable.
    CPU 0.68s/0.53u sec elapsed 70.73 sec.
    WARNING: index "pokerhands_pkey" contains 431 row

    versions, but table contains 6591557 row versions
    HINT: Rebuild the index with REINDEX.

    How can I Reindex only index "pokerhands_pkey", but not all the indices?

  9. #9
    Member
    Join Date
    Feb 2009
    Posts
    73

    Default

    Would this be ok?


    DROP INDEX pokerhands_idx1;

    CREATE INDEX pokerhands_idx1
    ON pokerhands
    USING btree
    (handtimestamp);

  10. #10
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    I would just reindex ALL.

    Dropping the index, will potentially delete all info in that index, making the database unusable.
    If you're experimenting with that, EXPORT the hands FIRST.

    And export your notes!

    If you don't have notes and/or have a proper backup of ALL your original handhistories (in your archive folder).
    Just create a NEW empty database and reimport your hands.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

Similar Threads

  1. HUD stats lost its positions
    By maXXmilian in forum Manager General
    Replies: 1
    Last Post: 03-02-2011, 06:53 PM
  2. Purged hands lost stats
    By agarn in forum Manager General
    Replies: 7
    Last Post: 06-23-2010, 09:03 PM
  3. patch updat stats lost
    By admonsali in forum Manager General
    Replies: 3
    Last Post: 08-16-2009, 06:11 AM
  4. Lost all stats and hud bug
    By Alias19 in forum Manager General
    Replies: 3
    Last Post: 04-09-2009, 09:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •