lost most of my stats

[Jaybear]

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"playerhandstourneykeycolums_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

[RDB]

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/questions/88/Vacuum+Analyze+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/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 and delete the old one.

[Jaybear]

How do you delete the old one?

[RDB]

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

http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database

[Hurricane]

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.

[Hurricane]

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.

[Patvs]

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/Downloads/HmUpdate_Release_1.12.11_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.

[Hurricane]

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 (http://gyazo.com/bd44e680748ce5fc12a6329749f51a4c)

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?

[Hurricane]

Would this be ok?


DROP INDEX pokerhands_idx1;

CREATE INDEX pokerhands_idx1
ON pokerhands
USING btree
(handtimestamp);

[Patvs]

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.

[Hurricane]

Ok. I gonna reindex in the PGAdminIII REINDEX. What does Option FORCE mean? And the option RECREATE unavailable unfortunatelly. Why?

[netsrak]

FORCE is obsolete. Just use REINDEX.
For further infos you should look for a postgresql doku :)