PDA

View Full Version : Villains Hands missing



JPonline
04-26-2011, 10:35 AM
Hi.

Additionally to Holdemmanager I use a tablescanner.

Today I came upon something odd:

I scanned some tables and i found a fish at one of those. The tablescanner reported that I had about 1000 hands from the fish.

After a orbit at the table, I only had 5 Hands in my HUD.

I checked my "advanced Hud filters", but they were all set to "2 to 10 players" and all boxes checked and maximum age of hands was set to 96 months by me.

Still I have only5 Hands from the fish.
Why doesnt HEM take all hands out of the DB ? (scanner an hem access the same DB!)

Kind Regards
Julius

Patvs
04-26-2011, 08:20 PM
hud options--> additional HUD filters--> do you also have turned on "include hands from other limits" and " mix FTP RUSH and non RUSH stats"?


Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe


Try creating a NEW empty database and reimport all the hands from your archive folder.

JPonline
04-27-2011, 06:12 AM
Hi

thanks for your answer.


I am already using version 1.11.06d.
As I already said, all the boxes in my HUD Filters are checked.

http://img26.imageshack.us/img26/7382/hudfilters.jpg (http://img26.imageshack.us/i/hudfilters.jpg/)



Reimporting my Hands (into a new DB) from the Archive folder wont do much good, because I imported Tons of Hand Histories, which I bought.

Help please ! :)

Julius

Patvs
04-27-2011, 08:28 AM
After a orbit at the table, I only had 5 Hands in my HUD.


Did it show the full 1000 hands the first hands at the table, and then suddenly jumped to only showing 5 hands? Despite all your filters being correct, did this happen when a player left the table? On which site are you playing?

Which SQL version are you using?
How did you backup all the hands you bought?
Try exporting your hands in database management:
-reimport the archive folder first into a new database
-followed by the exported hands, exported in database management

JPonline
04-27-2011, 09:27 AM
Did it show the full 1000 hands the first hands at the table, and then suddenly jumped to only showing 5 hands?

No, HEM showed me first 0 Hands, then 1 and so on. (business as usual, versus a completely unknown player)

But my Tablescanner (Tablescan Turbo) reported me about 1000 Hands on this particular player.


Despite all your filters being correct, did this happen when a player left the table? On which site are you playing?

No, i sat down at the table and was dealt in. The table was always full, and no players changed during the first 2 or 3 orbits.
I am playing on Pokerstars


Which SQL version are you using?

I am running POstgreSQL 9.0


How did you backup all the hands you bought?

On the one Hand i still have the .zip archives. And I also do a backup of my Database every 5 Days, using pgAdmin.


Try exporting your hands in database management:
-reimport the archive folder first into a new database
-followed by the exported hands, exported in database management

I can try this, but to be honest this will literally take ages.

Will this prevent me from the same error, in the future ? I import about 1.2-1.7 million Hands every day.



By the way: Almost the same problem appears quite often in this scenario:

I go in HEM to the "players" tab, and filter out all players with VPIP < 40 and Min. Hands 40, Site "pokerstars" and Date range from Jan. 2000 till Dec 2011.
After that I get about 28k Players. I make a Note in the Pokerstars Software on every player (so i can see them, lets say green, in the Lobby and at the tables).

But my tablescanner shows me players I seem to have 200 hands on, with a VPIP of 50. (so very well covered by my filters from above), but they were never exported by the HEM players tab! !


It seems HEM does not get all the Data from my DB ? But the Data is apparently there, since TableScan turbo has access to it !???

any Ideas ?

Kind Regards Julius


P.S: I do the Analyze, Vacuum and Reindex routine within pgAdmin, on a two to three days basis, always without any errors.

Patvs
04-27-2011, 10:35 AM
Most logical cause would be if TableScan Turbo is wrongly misreading the info from one of the indexes of the PostgreSQL database.

Can you email sales@holdemmanager.com, request a free temporary license key for TableScanner, so you can check if the same error occurs when using our TableScaner.

JPonline
04-27-2011, 10:40 AM
Hi.

I can try to reproduce the error, using your tablescanner. I do have a license key.


BUT :

The problem i described with the player list, that is exported by HEM (and then saved by me as a .csv file) is even more odd, as i just discovered:

I export player names all with VPIP < 40 and Hands < 40 and date range Jan. 2000 till Dec. 2011 and Site "pokerstars".

Then I sit down at a table, and as soon as the HUD appears i see some times players with 120 hands and VPIP 45.

(No import of new hands inbetween the "player list" and the showing of the HUD)

Any ideas ?

Meanwhile i will try to reproduce the error, using the HEM Tablescanner.

Kind Regards

Julius

Patvs
04-27-2011, 11:09 AM
You mean you run a filter for:
VPIP > 40 and Hands > 40
mark ALL those players, and then you still find unmarked players that match those criteria.

I think the filters are somewhat limited: meaning if you run a filter for VPIP <100, Hands >1 (which should result in ALL the players of your database).... it won't show all the players. Either it will CRASH HoldemManager, or only show a small portion of them.

It's likely with your current VPIP > 40 and Hands > 40 filter, the 28k players are also not all of them, because the query crashes at some point.

JPonline
04-27-2011, 12:04 PM
Yes, I meant VPIP over 40. (for the obvious reasons :-) )

Okay, so I wont worry about that player list anymore, or try to do it in smaller steps. (maybe first vpip 40-41 and maybe different date ranges)


However, I will be able to try to reproduce the Scanner/HUD error in a few hours.

Thanks so far.

Julius

JPonline
04-27-2011, 02:28 PM
I was able to reproduce the error, to some degree. (Also with HEM Scanner)

I attached two screenshots.

http://img832.imageshack.us/img832/2782/errorfx.th.jpg (http://img832.imageshack.us/i/errorfx.jpg/)


http://img689.imageshack.us/img689/120/error2dn.th.png (http://img689.imageshack.us/i/error2dn.png/)


I was not able to find a player/table, where the scanner reports 1k hands, and HUD 0 (I didnt have the time to search for hours) but at least you can see, that the error I mentioned, does exist, and please be assured, it does even exist to such an extreme degree, that Scanner reports 1k+ Hands and HUD = 0.

(HUD Filters obviously are still the same as in my Screenshot from an earlier post)


Please help !

Kind Regards Julius


Edit: I just reuploaded the Pictures, with a better resolution.

Patvs
04-28-2011, 07:31 AM
Can you replay a hand of such a player in the replayer. (a player TableScanner/TableScan Turbo says is a fish you have 1000 hands on.... whose hands don't show up in the HUD)
Does the replayer show all 1000 hands, or will show 0-5 hands on that player?

---If it shows 1000: for some reason your regular HUD isn't using the additional HUD filters.

Which Operating System, Firewall, and Anti-Virus are you using?

Please update to the latest beta - http://www.holdemmanager.com/Downloads/HmUpdate.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.

Add exceptions to the windows firewall for those files, even if the firewall is turned off. Run a Windows Update and install ALL updates.
If that doesn't resolve it, reinstall HoldemManager using the full installer @ http://www.holdemmanager.com/Downloads/Holdem_Manager_Setup.exe
Also set the filter by date to 12 (not to 96) months.

---If it shows 0-5:
Since both TableScanner... and TabeScan Turbo, both use the same PostgreSQL database, it's still very likely there is a corruption in one of the indexes. The fact you import 1.2 million hands daily makes this even more likely. And you really should consider, creating a new database--> reimporting all your hands.

Before you do that, assign more RAM to Postgresql by editing the PostgreSQL.conf file and turn off logging. Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

JPonline
04-28-2011, 08:21 AM
Can you replay a hand of such a player in the replayer. (a player TableScanner/TableScan Turbo says is a fish you have 1000 hands on.... whose hands don't show up in the HUD)
Does the replayer show all 1000 hands, or will show 0-5 hands on that player?

I just did that with a session from yesterday. And checked both players, I postet in the Screenshots yesterday.

I have all Hands in the Replayer HUD ! (+ 6 Hands, because I sat 1 orbit at each table)



Which Operating System, Firewall, and Anti-Virus are you using?

I am running Windows 7 Professional x64, I have no Software firewall installed (Windows FW diabled), and I am using Avira Antivir (Avira AntiVir Personal - Free Antivirus (http://www.avira.com/de/avira-free-antivirus)) as Anti Virus Program.

I have set all necessary folders (HEM, postgres, Pokersoftware, HEM Archive [...] ) to the Antivir exceptions. So those Folders are skipped by the "guard", and when Scanning my PC.



For W7 and Vista you must set holdem managerdbcontrolpanel.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.

Already done, directly after HEM/Postgresql install.



Add exceptions to the windows firewall for those files, even if the firewall is turned off. Run a Windows Update and install ALL updates.


Windows Updates are performed on daily basis, but I just checked for new ones and installed a "tiny" one :)

I did not have the HEM files in the exceptions of the WIN7 FW, because it was turned off.
But I just added them, and will see if this helps.



If that doesn't resolve it, reinstall HoldemManager using the full installer @ http://www.holdemmanager.com/Downloads/Holdem_Manager_Setup.exe
Also set the filter by date to 12 (not to 96) months.


I will try this asap.
I had set the Filter, to 96, just to make sure I am not missing 3 year old hands. (unlikely anyway)
But I have set the Filter to 12 now.



---If it shows 0-5:
Since both TableScanner... and TabeScan Turbo, both use the same PostgreSQL database, it's still very likely there is a corruption in one of the indexes. The fact you import 1.2 million hands daily makes this even more likely. And you really should consider, creating a new database--> reimporting all your hands.

As you can imagine, I would prefer to not reimport all Hands, since this is a lot of work, but I will do it anyways, if necessary, to find out the reason for the error.

Dont you think there should be an error Message by the PGadmin Maintainance, when i perform Vacuum, Analyze and Reindex, IF there was an corruption in one of the indexes ?


Edit: see above, all Hands are showing up in the Replayer, so I assume the DB is OK ? ? ?




Before you do that, assign more RAM to Postgresql by editing the PostgreSQL.conf file and turn off logging. Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

I "tuned" Postgres right after the install. Logging is turned off, since the very first start, I had postgres Tuned by the "postgres Tuning Wizard", offered by the postgres Company.

I can change those values manually, if you think the "Tuning Wizard" uses not suitable Values.
(although my Import speed is pretty OK, with about 100 hands/s, in a big DB)


Julius

JPonline
05-04-2011, 09:34 PM
I just did that with a session from yesterday. And checked both players, I postet in the Screenshots yesterday.

I have all Hands in the Replayer HUD ! (+ 6 Hands, because I sat 1 orbit at each table)




Any idea, how that can be ? Replayer and Scanner show the correct amount of Hands, but HUD does not. (No HUD Filters active !)


Julius

Patvs
05-04-2011, 11:07 PM
Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe

Did you already try to reimport a sample of hands into a new database?

JPonline
05-07-2011, 10:23 AM
Hi.


* I Exported all my Hands via "manage DB" -> Export Hands
* I updated to 1.11.06e-1
*Created a new DB and reimported about 50% of the Exported Hands. (Took 48h)


Today Scanned some Tables with the HEM- Table Scanner, and sat down at them/opened them.

The error unfortnuately still exists. I also found some samples, where I had more Hands on a Villain, in the HUD, than the Scanner showed me. (not only 1 or two, but also 40+ difference)
Maybe I did not see this error (HUD>Scanner) before, on the old DB, so I do not know if this is a new error.

Do you have any Ideas?

Kind regards
Julius


EDIT:

I jsut made a Screenshot :
I just saw, that the Hands are showing up in the "Active players" window, but not in the HUD or HUD-Pop UP. !?

http://img33.imageshack.us/img33/1231/mimimimimi.th.jpg (http://imageshack.us/photo/my-images/33/mimimimimi.jpg/)

netsrak
05-08-2011, 04:58 AM
I think we need to investigate this in detail: Please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer (http://www.holdemmanager.net/teamviewer) session.