[HUD] Holdem Manager Support
05-25-2014
, 05:20 PM
Pacific's 70/30 SNGs 6max aren't tagging automatically (at least on the WSOP NJ skin). Let me know if you need HHs.
Also it would be nice if the blind level could be pulled from the hand header instead of the BB that is actually posted so we wouldn't end up with this:
Also it would be nice if the blind level could be pulled from the hand header instead of the BB that is actually posted so we wouldn't end up with this:
05-25-2014
, 05:30 PM
All original hands that are auto-imported get moved to an archive for performance reasons. Your \HM2Archive is in C:\HM2Archive by default, but you may have put it anywhere. The archive should be organized by \Month\DayOfMonth (example: D:\HM2Archive\2009\07\31) or if it was auto-imported with 7283+ it would be in \HM2Archive\SiteName\YYYY\MM\DD.
When sending any hand history files please zip them (right-click > send to > compressed folder) before attaching them to an email. If the attachment is too big to attach to an email please upload them to a file hosting site like dropbox or filedropper and send us the download link.
Quote:
Also it would be nice if the blind level could be pulled from the hand header instead of the BB that is actually posted so we wouldn't end up with this:
The previously assigned internal ticket # on this issue is HM-8131: Hands View Columns Stakes Blinds showing game type instead of blinds in Tournament Reports
If you want to be notified when it is fixed please send an email to support@holdemmanager.com and include "Notify Me When HM-8131 Is Resolved" in the subject line and body of the email.
Quote:
What exactly am I looking at here? Is this the Winnings Summary report? Is it related to one of your questions above?
05-26-2014
, 12:57 PM
Hi,
Hi,
recently I started configuring postgres.conf file and looking for troubleshoots of my issues. The main issue was that after some time of session PG/HM2 freezes and I have to restart it every time. I'm unable to play 30 tables in stack cuz I have difficulties with slowing down when I'm playin 14-16 tables. The more tables I play the faster issue occurs. After I changed shared_buffers = 1024MB effective_cache_size = 2048MB wal_buffers = 16MB it was working so perfectly smoothly and fast it turned me on ^^ . Unfortunately after one hour it freezes so much I had to restore conf file.
I found a lot of errors in Events Viewer (few per minute) and all of them looks like this:
May it be HM/PG is leaking connections? Failing to close connections after use, instead opening a new connection.
And:
May it be connected with: http://support.microsoft.com/kb/184802 ?
Now the most important question, so simply makes me laugh, I have 64-bit OS so I did installer postgres 64-bit but HM2 is 32-bit application so maybe here is the problem?
If this may cause the issue after I will install 32-bit postgres do I have also instal PostgreSQL ODBC driver?
What is exactly difference between PG 8.4 and 9.0/9.2? I mean difference in compatibility with HM2? 9.0 and 9.2 are much better for modern OS (Win7, Win8) and for better performance so am I loosing anything by using 9.0? Did u heard about any issues? I'm using pgadmin anyway so I don't care abut vacuuming issues (except that shouldn't HM2 auto-vacuum DB during a sessions?). I'm fishy in that area so I'm just asking
If I want to install postgres before installing HM2 do I have configure authentications?
shared_buffers
is it true also true for my purposes?
work_mem - how big are queries and is that a much or no? I mean am I should going to increase or more to decrease value of it?
effective_cache_size - is it reasonable to set it to 2/3 of available RAM? and what should I thnik when thinkin about available RAM, whole RAM, available RAM when I'm running my PC in normal way (turing the sessions with HM2 turned of)? Or available RAM is ram left after dedicating some values to other processes?
autovacuum - should I have turned it on or off? Other way, is writes constant or batch?
How much tables is using when I play at 30-40 9-max MTT tables ? Should I have turned on also analyze?
multiple_autovacuum_workers - what should I understand by advice to set it to no more than 1/2 cores?
what's about pgbouncer?
For big DBs, what's the best way to use (create?) SSD space as a catche when RAM is too small? Or maybe autovacuum is troubleshoot for HM2 freezing during the sessions?
Edit: now when server is unable where I can download HM2?
Hi,
recently I started configuring postgres.conf file and looking for troubleshoots of my issues. The main issue was that after some time of session PG/HM2 freezes and I have to restart it every time. I'm unable to play 30 tables in stack cuz I have difficulties with slowing down when I'm playin 14-16 tables. The more tables I play the faster issue occurs. After I changed shared_buffers = 1024MB effective_cache_size = 2048MB wal_buffers = 16MB it was working so perfectly smoothly and fast it turned me on ^^ . Unfortunately after one hour it freezes so much I had to restore conf file.
I found a lot of errors in Events Viewer (few per minute) and all of them looks like this:
Code:
<?xml version="1.0" encoding="UTF-8" standalone="true"?> -<Events> -<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> -<System> <Provider Name="PostgreSQL"/> <EventID Qualifiers="0">0</EventID> <Level>2</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2014-05-24T21:49:00.000000000Z"/> <EventRecordID>22564</EventRecordID> <Channel>Application</Channel> <Computer>ktos-Komputer</Computer> <Security/> </System> -<EventData> <Data>2014-05-24 23:49:00 CEST BŁĄD: przygotowane wyrażenie "insertplayer" już istnieje 2014-05-24 23:49:00 CEST POLECENIE:PREPARE INSERTPLAYER (text,smallint,integer,integer,smallint) AS Insert into players (playername,pokersite_id,cashhands,tourneyhands,optimizationstatus) values ($1,$2,$3,$4,$5) RETURNING player_id; PREPARE CSUpdate (integer,integer,smallint,smallint,smallint,integer, integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer) as Update CompiledPlayerResults set totalhands = totalhands + $6 , TotalAmountWonincents = TotalAmountWonincents + $7 , TotalRakeincents = TotalRakeincents + $8 , TotalBBsWon = TotalBBsWon + $9 , VPIPHands = VPIPHands + $10 , PFRHands = PFRHands + $11 , CouldColdCall = CouldColdCall + $12 , DidColdCall = DidColdCall + $13 , CouldThreeBet = CouldThreeBet + $14 , DidThreeBet = DidThreeBet + $15 , CouldSqueeze = CouldSqueeze + $16 , DidSqueeze = DidSqueeze + $17 , FacingTwoPreflopRaisers = FacingTwoPreflopRaisers + $18 , CalledTwoPreflopRaisers = CalledTwoPreflopRaisers + $19 , RaisedTwoPreflopRaisers = RaisedTwoPreflopRaisers + $20 , SmallBlindStealAttempted = SmallBlindStealAttempted + $21 , SmallBlindStealDefended = SmallBlindStealDefended + $22 , SmallBlindStealReraised = SmallBlindStealReraised + $23 , BigBlindStealAttempted = BigBlindStealAttempted + $24 , BigBlindStealDefended = BigBlindStealDefended + $25 , BigBlindStealReraised = BigBlindStealReraised + $26 , SawNonSmallShowdown = SawNonSmallShowdown + $27 , WonNonSmallShowdown = WonNonSmallShowdown + $28 , SawLargeShowdown = SawLargeShowdown + $29 , WonLargeShowdown = WonLargeShowdown + $30 , SawNonSmallShowdownLimpedFlop = SawNonSmallShowdownLimpedFlop + $31 , WonNonSmallShowdownLimpedFlop = WonNonSmallShowdownLimpedFlop + $32 , SawLargeShowdownLimpedFlop = SawLargeShowdownLimpedFlop + $33 , WonLargeShowdownLimpedFlop = WonLargeShowdownLimpedFlop + $34 , WonHand = WonHand + $35 , WonHandWhenSawFlop = WonHandWhenSawFlop + $36 , WonHandWhenSawTurn = WonHandWhenSawTurn + $37 , WonHandWhenSawRiver = WonHandWhenSawRiver + $38 , FacedThreeBetPreflop = FacedThreeBetPreflop + $39 , FoldedToThreeBetPreflop = FoldedToThreeBetPreflop + $40 , CalledThreeBetPreflop = CalledThreeBetPreflop + $41 , RaisedThreeBetPreflop = RaisedThreeBetPreflop + $42 , FacedFourBetPreflop = FacedFourBetPreflop + $43 , FoldedToFourBetPreflop = FoldedToFourBetPreflop + $44 , CalledFourBetPreflop = CalledFourBetPreflop + $45 , RaisedFourBetPreflop = RaisedFourBetPreflop + $46 , TurnFoldIPPassOnFlopCB = TurnFoldIPPassOnFlopCB + $47 , TurnCallIPPassOnFlopCB = TurnCallIPPassOnFlopCB + $48 , TurnRaiseIPPassOnFlopCB = TurnRaiseIPPassOnFlopCB + $49 , RiverFoldIPPassOnTurnCB = RiverFoldIPPassOnTurnCB + $50 , RiverCallIPPassOnTurnCB = RiverCallIPPassOnTurnCB + $51 , RiverRaiseIPPassOnTurnCB = RiverRaiseIPPassOnTurnCB + $52 , SawFlop = SawFlop + $53 , SawShowdown = SawShowdown + $54 , WonShowdown = WonShowdown + $55 , TotalBets = TotalBets + $56 , TotalCalls = TotalCalls + $57 , FlopContinuationBetPossible = FlopContinuationBetPossible + $58 , FlopContinuationBetMade = FlopContinuationBetMade + $59 , TurnContinuationBetPossible = TurnContinuationBetPossible + $60 , TurnContinuationBetMade = TurnContinuationBetMade + $61 , RiverContinuationBetPossible = RiverContinuationBetPossible + $62 , RiverContinuationBetMade = RiverContinuationBetMade + $63 , FacingFlopContinuationBet = FacingFlopContinuationBet + $64 , FoldedToFlopContinuationBet = FoldedToFlopContinuationBet + $65 , CalledFlopContinuationBet = CalledFlopContinuationBet + $66 , RaisedFlopContinuationBet = RaisedFlopContinuationBet + $67 , FacingTurnContinuationBet = FacingTurnContinuationBet + $68 , FoldedToTurnContinuationBet = FoldedToTurnContinuationBet + $69 , CalledTurnContinuationBet = CalledTurnContinuationBet + $70 , RaisedTurnContinuationBet = RaisedTurnContinuationBet + $71 , FacingRiverContinuationBet = FacingRiverContinuationBet + $72 , FoldedToRiverContinuationBet = FoldedToRiverContinuationBet + $73 , CalledRiverContinuationBet = CalledRiverContinuationBet + $74 , RaisedRiverContinuationBet = RaisedRiverContinuationBet + $75 , TotalPostFlopStreetsSeen = TotalPostFlopStreetsSeen + $76 , totalaggressivepostflopstreetsseen = totalaggressivepostflopstreetsseen + $77 where compiledplayerresults_id = (select compiledplayerresults_id from compiledplayerresults where player_id = $1 and playedyearandmonth = $2 and numberofplayers = $3 and gametype_id = $4 and bbgroup_id = $5 limit 1); </Data> </EventData> -<RenderingInfo Culture="pl-PL"> <Message>2014-05-24 23:49:00 CEST BŁĄD: przygotowane wyrażenie "insertplayer" już istnieje 2014-05-24 23:49:00 CEST POLECENIE:PREPARE INSERTPLAYER (text,smallint,integer,integer,smallint) AS Insert into players (playername,pokersite_id,cashhands,tourneyhands,optimizationstatus) values ($1,$2,$3,$4,$5) RETURNING player_id; PREPARE CSUpdate (integer,integer,smallint,smallint,smallint,integer, integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer,integer,integer,integer, integer,integer) as Update CompiledPlayerResults set totalhands = totalhands + $6 , TotalAmountWonincents = TotalAmountWonincents + $7 , TotalRakeincents = TotalRakeincents + $8 , TotalBBsWon = TotalBBsWon + $9 , VPIPHands = VPIPHands + $10 , PFRHands = PFRHands + $11 , CouldColdCall = CouldColdCall + $12 , DidColdCall = DidColdCall + $13 , CouldThreeBet = CouldThreeBet + $14 , DidThreeBet = DidThreeBet + $15 , CouldSqueeze = CouldSqueeze + $16 , DidSqueeze = DidSqueeze + $17 , FacingTwoPreflopRaisers = FacingTwoPreflopRaisers + $18 , CalledTwoPreflopRaisers = CalledTwoPreflopRaisers + $19 , RaisedTwoPreflopRaisers = RaisedTwoPreflopRaisers + $20 , SmallBlindStealAttempted = SmallBlindStealAttempted + $21 , SmallBlindStealDefended = SmallBlindStealDefended + $22 , SmallBlindStealReraised = SmallBlindStealReraised + $23 , BigBlindStealAttempted = BigBlindStealAttempted + $24 , BigBlindStealDefended = BigBlindStealDefended + $25 , BigBlindStealReraised = BigBlindStealReraised + $26 , SawNonSmallShowdown = SawNonSmallShowdown + $27 , WonNonSmallShowdown = WonNonSmallShowdown + $28 , SawLargeShowdown = SawLargeShowdown + $29 , WonLargeShowdown = WonLargeShowdown + $30 , SawNonSmallShowdownLimpedFlop = SawNonSmallShowdownLimpedFlop + $31 , WonNonSmallShowdownLimpedFlop = WonNonSmallShowdownLimpedFlop + $32 , SawLargeShowdownLimpedFlop = SawLargeShowdownLimpedFlop + $33 , WonLargeShowdownLimpedFlop = WonLargeShowdownLimpedFlop + $34 , WonHand = WonHand + $35 , WonHandWhenSawFlop = WonHandWhenSawFlop + $36 , WonHandWhenSawTurn = WonHandWhenSawTurn + $37 , WonHandWhenSawRiver = WonHandWhenSawRiver + $38 , FacedThreeBetPreflop = FacedThreeBetPreflop + $39 , FoldedToThreeBetPreflop = FoldedToThreeBetPreflop + $40 , CalledThreeBetPreflop = CalledThreeBetPreflop + $41 , RaisedThreeBetPreflop = RaisedThreeBetPreflop + $42 , FacedFourBetPreflop = FacedFourBetPreflop + $43 , FoldedToFourBetPreflop = FoldedToFourBetPreflop + $44 , CalledFourBetPreflop = CalledFourBetPreflop + $45 , RaisedFourBetPreflop = RaisedFourBetPreflop + $46 , TurnFoldIPPassOnFlopCB = TurnFoldIPPassOnFlopCB + $47 , TurnCallIPPassOnFlopCB = TurnCallIPPassOnFlopCB + $48 , TurnRaiseIPPassOnFlopCB = TurnRaiseIPPassOnFlopCB + $49 , RiverFoldIPPassOnTurnCB = RiverFoldIPPassOnTurnCB + $50 , RiverCallIPPassOnTurnCB = RiverCallIPPassOnTurnCB + $51 , RiverRaiseIPPassOnTurnCB = RiverRaiseIPPassOnTurnCB + $52 , SawFlop = SawFlop + $53 , SawShowdown = SawShowdown + $54 , WonShowdown = WonShowdown + $55 , TotalBets = TotalBets + $56 , TotalCalls = TotalCalls + $57 , FlopContinuationBetPossible = FlopContinuationBetPossible + $58 , FlopContinuationBetMade = FlopContinuationBetMade + $59 , TurnContinuationBetPossible = TurnContinuationBetPossible + $60 , TurnContinuationBetMade = TurnContinuationBetMade + $61 , RiverContinuationBetPossible = RiverContinuationBetPossible + $62 , RiverContinuationBetMade = RiverContinuationBetMade + $63 , FacingFlopContinuationBet = FacingFlopContinuationBet + $64 , FoldedToFlopContinuationBet = FoldedToFlopContinuationBet + $65 , CalledFlopContinuationBet = CalledFlopContinuationBet + $66 , RaisedFlopContinuationBet = RaisedFlopContinuationBet + $67 , FacingTurnContinuationBet = FacingTurnContinuationBet + $68 , FoldedToTurnContinuationBet = FoldedToTurnContinuationBet + $69 , CalledTurnContinuationBet = CalledTurnContinuationBet + $70 , RaisedTurnContinuationBet = RaisedTurnContinuationBet + $71 , FacingRiverContinuationBet = FacingRiverContinuationBet + $72 , FoldedToRiverContinuationBet = FoldedToRiverContinuationBet + $73 , CalledRiverContinuationBet = CalledRiverContinuationBet + $74 , RaisedRiverContinuationBet = RaisedRiverContinuationBet + $75 , TotalPostFlopStreetsSeen = TotalPostFlopStreetsSeen + $76 , totalaggressivepostflopstreetsseen = totalaggressivepostflopstreetsseen + $77 where compiledplayerresults_id = (select compiledplayerresults_id from compiledplayerresults where player_id = $1 and playedyearandmonth = $2 and numberofplayers = $3 and gametype_id = $4 and bbgroup_id = $5 limit 1); </Message> <Level>Błędy</Level> <Task/> <Opcode>Informacje</Opcode> <Channel/> <Provider/> -<Keywords> <Keyword>Klasyczny</Keyword> </Keywords> </RenderingInfo> </Event>
And:
Quote:
When running as a service, you may experience failures with more than approximately 125 simultaneous connections. This can happen because some of the libraries that PostgreSQL is dependent on are dependent on user32.dll which allocates memory from an area known as the Desktop Heap. The desktop heap is assigned to each logon session, with non-interactive sessions typically being assigned 512KB. Each postgres process that runs typically consumes approximately 3.2KB of desktop heap, which coupled with other overhead can exhaust the allocated heap at somewhere around 125 connections. This doesn't happen when running from the command line (or more precisely, happens with much higher numbers of connections) because the interactive logon session is typically allocated 3MB of Desktop Heap.
May it be connected with: http://support.microsoft.com/kb/184802 ?
Now the most important question, so simply makes me laugh, I have 64-bit OS so I did installer postgres 64-bit but HM2 is 32-bit application so maybe here is the problem?
If this may cause the issue after I will install 32-bit postgres do I have also instal PostgreSQL ODBC driver?
Quote:
Because 32-bit versions of the PostgreSQL server only install a 32-bit libpq and pgsqlODBC, only 32-bit programs on the computer the server was installed on can use the database unless a 64-bit ODBC driver or libpq is installed as an add-on.
Quote:
Unless you've also installed a 64-bit version of psqlODBC, a 32-bit install of PostgreSQL will only have a 32-bit ODBC driver. The 32-bit ODBC driver may only be used by 32-bit programs, and will not show up in the 64-bit ODBC administrator.
This gets confusing because on 64-bit windows c:\windows\system32\odbcad32 is the 64-bit ODBC driver administrator, despite the name. This is a historical artifact of Windows development. Apparently many apps and installers depend on odbcad32.exe having that name and path, so Microsoft landed up being stuck with it despite the now-stupid name, which made sense back in the 16- to 32-bit transition but makes none now
This gets confusing because on 64-bit windows c:\windows\system32\odbcad32 is the 64-bit ODBC driver administrator, despite the name. This is a historical artifact of Windows development. Apparently many apps and installers depend on odbcad32.exe having that name and path, so Microsoft landed up being stuck with it despite the now-stupid name, which made sense back in the 16- to 32-bit transition but makes none now
What is exactly difference between PG 8.4 and 9.0/9.2? I mean difference in compatibility with HM2? 9.0 and 9.2 are much better for modern OS (Win7, Win8) and for better performance so am I loosing anything by using 9.0? Did u heard about any issues? I'm using pgadmin anyway so I don't care abut vacuuming issues (except that shouldn't HM2 auto-vacuum DB during a sessions?). I'm fishy in that area so I'm just asking
If I want to install postgres before installing HM2 do I have configure authentications?
Quote:
Who is allowed to connect to the database is controlled by a file in the root of your database directory named. pg_hba.conf. A default file is created when you run initdb to create a database cluster.
Quote:
should be as big as it is possible (1/4 RAM)
work_mem - how big are queries and is that a much or no?
I mean am I should going to increase or more to decrease value of it?effective_cache_size - is it reasonable to set it to 2/3 of available RAM? and what should I thnik when thinkin about available RAM, whole RAM, available RAM when I'm running my PC in normal way (turing the sessions with HM2 turned of)? Or available RAM is ram left after dedicating some values to other processes?
autovacuum - should I have turned it on or off? Other way, is writes constant or batch?
How much tables is using when I play at 30-40 9-max MTT tables ? Should I have turned on also analyze?
multiple_autovacuum_workers - what should I understand by advice to set it to no more than 1/2 cores?
what's about pgbouncer?
For big DBs, what's the best way to use (create?) SSD space as a catche when RAM is too small? Or maybe autovacuum is troubleshoot for HM2 freezing during the sessions?
Edit: now when server is unable where I can download HM2?
Last edited by exculibrus; 05-26-2014 at 12:58 PM.
Reason: ask question
05-26-2014
, 02:35 PM
Quote:
Our server has not been down.
I have 8GB RAM, i7 860 2.8GHz CPU, Samsung 840 EVO (if that changes anything). I know I should buy more RAM but for now I have to do something with that what I have - I'm almost bankrupt.
05-26-2014
, 08:01 PM
Thank you guys for answers, I will reply tommorow cuz now I'm mentally exhausted after installing new OS. Just one thing, I still can't connect to holdemmenager website (sick ) ans now I'm sure it's not your fault 
Tommorow I'm going to reset my router but if it would not help me could you share HM2 and TN2 installation files anywhere?
Tommorow I'm going to reset my router but if it would not help me could you share HM2 and TN2 installation files anywhere?
05-26-2014
, 08:42 PM
Quote:
Thank you guys for answers, I will reply tommorow cuz now I'm mentally exhausted after installing new OS. Just one thing, I still can't connect to holdemmenager website (sick ) ans now I'm sure it's not your fault Tommorow I'm going to reset my router but if it would not help me could you share HM2 and TN2 installation files anywhere?
Tommorow I'm going to reset my router but if it would not help me could you share HM2 and TN2 installation files anywhere?
HM2 Installer - https://drive.google.com/file/d/0B5J...it?usp=sharing