PDA

View Full Version : Needed to pg_resetxlog my db and now the reports don't show



punter11235
09-26-2012, 10:25 PM
So my postgres db collapsed because of power outage. I needed to pg_resetxlog it to even make the windows service start. Now HM is working perfectly, it's importing hands and showing the stats in HUD. I can even see reports in sessions tab filtered for last 24 hours etc.
However when I go to cash games -> reports tag then nothing is showing there.
The hands are clearly imported. I can even see the hhs themselves when I go to "preflop cards", filter there and then click on individual hands. It's just something with reports tab. I play ZOOM if that matters.

Any ideas how to fix that ?

EDIT: I just discovered it only doesn't show my stats; If I go to any other player it works ok.
Also Hands and vs Players tabs are working perfectly. I updated to 1.12.10b version but it didn't work in 1.12.10a either.

EDIT2: I've noticed that aliases are gone and maybe it has something to do with it. Still Hands/Preflop Cards/Sessions tabs are working when I filter for my sn only the Reports tab isn't.

fozzy71
09-27-2012, 01:50 PM
If you had a power outage while your database was being used/accessed it is possible (and probable from your description) that it was damaged beyond repair.

You can try to vacuum, analyze, and reindex your database - http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

If you continue to have problems:

*Try creating a new UTF DB - http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB - http://faq.holdemmanager.com/questions/372/Reinstalling+on+a+new+PC+-+Backup+Tips

punter11235
10-01-2012, 05:44 PM
Thanks.

I wasn't able to fix the problem but the database were functional enough to let me export all the hands.
I am now importing them to new database and it works ok (checked on small sample).
I saw some people having problems with their db's so this pg_resetxlog is hope for them. In my case it saved the day as all other things didn't work (including reinstalling postgres etc. etc.).
I found the message about invalid checkpoints in postgres error logs.
Thanks again I hope it can be useful for someone else.

fozzy71
10-01-2012, 07:43 PM
Thank you for letting us know what solved your problems. I am not familiar with this command but it may certainly come in handy for someone in the future.