HUD does not work anymore

[P41N]

Hi, i´m using HM for a year and I never had any problems with it. Since a few days my HUD is not working anymore. Settings are all correct, the table manager shows all tables. Even table finder cant find any attached hands.
I already read the FAQ´s, but they dont really help in this case.
I installed avira10 a few days ago, could this may cause this problem?
Thx for any help.


Andreas

[Patvs]

If it started when you installed Avira, that's probably causing it.
Make sure you set axceptions to Avira for the HoldemManager and Postgres folder and for port 5432.



Which Operating System, Firewall?

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab. If you have Vista and the checkboxes are greyed out and you can't select it, please turn UAC on, reboot, and then set the files to run as administrator.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily

[P41N]

Operation system is XP and i´m using Sygate firewall.

Avira was running already on my system before, I just updated to avira10.

Now I updated to the latest version of HM.
When I start the Auto-Import now, the table-manager opens and in the same second I get the system-message, that the HM-HUD hast to been stopped, cause a problem ocurred.
Finally I get the HUD started, but it shows only stats that I already have in my database. New hands will not be added. Also "reports" and "sessions" don´t show any new hands.
I tryed on ipoker and Ongame, both the same.
I never canged anything in the Import settings.

[netsrak]

Uninstall Avira 10 (disabling is not enough)
Delete all files in the handhistory folders of your pokerclients or move them to a different folder.
Reboot your computer and try again.

If it works now the problems are caused by Avira10.

Reinstall it and try to configure it correctly for Postgresql and Holdemmanager to work.
http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29

[P41N]

All done. HUD shows only elder stats.
I had a look on Import while playing some hands. It shows after a played hand: 1 hand imported / import errors: 1

[netsrak]

Please create a new database and test some hands.

If this works try a reindex of your old database via pgadminIII.

If that doesn't help your database seems to be corrupt.

[P41N]

Creating a new database worked, hands will be imported.
How can I reindex my old database? Is there anywhere an instruction for it? I´m not a PC-Specialist. :)

[fozzy71]

There is a Reindex option on the same Maintenance window of PGAdmin as the Vacuum/Analyze option.

FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)

[P41N]

Done. But didn´t help.

Here is the report:

NOTICE: table "pg_class" was reindexedNOTICE: table "sql_features" was reindexedNOTICE: table "sql_implementation_info" was reindexedNOTICE: table "pg_statistic" was reindexedNOTICE: table "sql_languages" was reindexedNOTICE: table "sql_packages" was reindexedNOTICE: table "sql_parts" was reindexedNOTICE: table "sql_sizing" was reindexedNOTICE: table "sql_sizing_profiles" was reindexedNOTICE: table "pg_ts_config" was reindexedNOTICE: table "pg_ts_config_map" was reindexedNOTICE: table "pg_ts_dict" was reindexedNOTICE: table "pg_ts_parser" was reindexedNOTICE: table "pg_ts_template" was reindexedNOTICE: table "pg_type" was reindexedNOTICE: table "pg_attribute" was reindexedNOTICE: table "pg_proc" was reindexedNOTICE: table "pg_autovacuum" was reindexedNOTICE: table "pg_attrdef" was reindexedNOTICE: table "pg_constraint" was reindexedNOTICE: table "pg_inherits" was reindexedNOTICE: table "pg_index" was reindexedNOTICE: table "pg_operator" was reindexedNOTICE: table "pg_opfamily" was reindexedNOTICE: table "pg_opclass" was reindexedNOTICE: table "pg_am" was reindexedNOTICE: table "pg_amop" was reindexedNOTICE: table "pg_amproc" was reindexedNOTICE: table "pg_language" was reindexedNOTICE: table "pg_largeobject" was reindexedNOTICE: table "pg_aggregate" was reindexedNOTICE: table "pg_rewrite" was reindexedNOTICE: table "pg_trigger" was reindexedNOTICE: table "pg_description" was reindexedNOTICE: table "pg_cast" was reindexedNOTICE: table "pg_enum" was reindexedNOTICE: table "pg_namespace" was reindexedNOTICE: table "pg_conversion" was reindexedNOTICE: table "pg_depend" was reindexedNOTICE: table "compiledplayerresults_month" was reindexedNOTICE: table "actiontypes" was reindexedNOTICE: table "pokersites" was reindexedNOTICE: table "handhistories" was reindexedNOTICE: table "playerhandstourneykeycolumns" was reindexedNOTICE: table "specialholecardactions" was reindexedNOTICE: table "importedfiles" was reindexedNOTICE: table "holecards" was reindexedNOTICE: table "playerhandscashkeycolumns" was reindexedNOTICE: table "compiledplayerresultspositionaction_month" was reindexedNOTICE: table "compiledresults_month" was reindexedNOTICE: table "allinsituations" was reindexedNOTICE: table "playerhandscashmisc" was reindexed
ERROR: invalid page header in block 1446 of relation "playerhandstourneymisc"

ERROR: invalid page header in block 1446 of relation "playerhandstourneymisc"

[Patvs]

Your old database is corrupt. And a reindex of the index "playerhandstourneymisc" didn't solve it. So you'll have to use a NEW database.

[P41N]

Damn, 30000 Players and nearly 1 Mio. hands.:mad:

How can I avoid those problems in future?

[Patvs]

After you've imported ALL your hands..... do a vacuum/analyse---> no errors = no corrupt database--->

Backup that database in pgAdminIII, so you can always easily restore that database, without having to reimport the actual .txt handhistories.

[P41N]

Thanks for your professional help guys. In future I will be more patient with my database.:)

[fozzy71]

Regular DB maintenance can go a long way to preventing corrupt DB's. I am overly nitty about DB maintenance and I have never had a corrupt DB.

1 - Close HM and Open PGAdmin

2 - connect to postgresql server and then to the DB. Password is postgrespass in case you ever need it.

3 - Right-Click > Maintenance on the DB.

4 - Vacuum, Full, Analyze > OK

Wait for it to finish and change the greyed out OK button to a Done button.

Do that ever 10 -30k hands.

Every 50 - 100k hands, after finishing the steps above:


A - Right-Click > Maintenance on the DB.

B - Reindex > OK

Wait for it to finish and change the greyed out OK button to a Done button.



Next we need to Stop the PostgreSQL service so the Defragmenter can Defrag the Database.

Start > Programs > PostgreSQL 8,4 > Stop Server


Open Smart Defrag > Select both drive letter checkboxes > Analyze

Pick suggested Defrag process > Start Defrag



After Smart Defrag finishes you should restart your computer.

If you need to use HM before you restart your PC, then you need to Start Server.

Start > Programs > PostgreSQL 8,4 > Start Server

[P41N]

Thank you, I will do this in future for sure.
Great program and great work guys, thanks a lot.