PDA

View Full Version : Serious problem



live4yng
06-23-2010, 07:55 PM
I have been using HEM and TableNinja for a little under a year now, 24 tabling cash games. I did not have any problems until last week...

While playing in a session, all of the sudden everything went extremely choppy. If I clicked, there would be a lag of 1-3 seconds, and it wouldn't stop. I eventually timed-banked out of every table, losing some pots that I was in the middle of.

I thought that this might be an isolated incident, so I rebooted my computer and everything went fine until the next day when it happened again. After the third time, I decided to reset my computer to its original factory settings (My computer is six months old and top of the line. I only use it for poker).

After reformatting my computer, I reinstalled HEM, Tableninja and Pokerstars ONLY, and about half an hour into my session, the same thing happened.

I am assuming this is a problem with either HEM or Tableninja. It is also very weird that it is a SUDDEN change while I am in the middle of my session as opposed to my computer gradually getting slower as I open more and more tables.

Please, if anyone has experienced a similar problem or has a suggestion, I would be most grateful

Mike

morny
06-24-2010, 09:47 AM
Hi,

Can you make sure your Opacity slider in Hud options > Player Preferences> Appearance TAB is 100% to the right and also do the same for the mucked cards Opacity

Also keep task manager running and have it sort by CPU in the Processes TAB and see what is using the most CPU when the lagging happens.

Try disabling as many programs as possible such as AHK scripts,Firewall, limewire,Mikogo etc and Antiviruses and if they cant be disabled make sure you add all these programs to the exceptions list such as HMhud.exe,DBcontrol panel.exe and holdemmanager.exe from the Holdem Manager folder aswell as any of the other programs that happen to be running, sometimes for example the antivirus/firewall etc scan every file thats been processed and it can slow things down so running with as few programs as possible.

Also going to control panel > Admin Tools > Event Viewer and copy and paste any description if there are any error or information events that coincide with the time of the lagging.

Go to Hud Options > Site Options and disable all the prefetch/track live hands options

Lastly make sure your graphics driver is up to date as this can make a big difference to lagging even with a brand new PC.
FAQ - Hold'em Manager Poker Tracking Software :: How To Update Your Graphics Card Driver (http://faq.holdemmanager.com/questions/362/How+To+Update+Your+Graphics+Card+DriverOn)

Also try the top 10 performance tips in my sig and if the problem persists try some older versions and see if the problem persists FAQ - Hold'em Manager Poker Tracking Software :: Download Links For Past Builds (http://faq.holdemmanager.com/questions/426/Download+Links+For+Past+Builds)

jaydeez40oz
06-26-2010, 12:56 AM
I have been using HEM and TableNinja for a little under a year now, 24 tabling cash games. I did not have any problems until last week...

While playing in a session, all of the sudden everything went extremely choppy. If I clicked, there would be a lag of 1-3 seconds, and it wouldn't stop. I eventually timed-banked out of every table, losing some pots that I was in the middle of.

I thought that this might be an isolated incident, so I rebooted my computer and everything went fine until the next day when it happened again. After the third time, I decided to reset my computer to its original factory settings (My computer is six months old and top of the line. I only use it for poker).

After reformatting my computer, I reinstalled HEM, Tableninja and Pokerstars ONLY, and about half an hour into my session, the same thing happened.

I am assuming this is a problem with either HEM or Tableninja. It is also very weird that it is a SUDDEN change while I am in the middle of my session as opposed to my computer gradually getting slower as I open more and more tables.

Please, if anyone has experienced a similar problem or has a suggestion, I would be most grateful

Mike


SAME PROBLEMS HERE. It isn't only you...or me, THANK GOD.

It's frustrating though, I'm thinking of uninstalling everything !

morny
06-26-2010, 03:16 PM
Hi, sorry to hear your having issues, have you tried any of my suggestions, i know it appears there is an issue but it could just be coincidental either so please try those and let me know if it helps.

In the meantime ill ask Table Ninja support have they been having any other reports and if so well get this fixed asap if the problem is on our end.

Also can you confirm what version of HM you have

Fool
06-26-2010, 04:30 PM
This is likely caused by a configuration error thats causing the program to work harder than it needs to. Please post in the TN forums and I'll be happy to sort out the problem or schedule a teamview session. Those of you with TableNinja problems should make a new thread here:

TableNinja - Holdem Manager Forums (http://forums.holdemmanager.com/tableninja/)

For TableNinjaFT please go here:

TableNinjaFT - Holdem Manager Forums (http://forums.holdemmanager.com/tableninjaft/)

jaydeez40oz
06-26-2010, 07:08 PM
My TN and HEM seem to be working fine now.

I reinstaleld HEM and PostgreSQL and deleted all my hand histories....basically started from scratch.

So far so good!!

live4yng
06-29-2010, 11:37 PM
Hi,

Can you make sure your Opacity slider in Hud options > Player Preferences> Appearance TAB is 100% to the right and also do the same for the mucked cards Opacity

Also keep task manager running and have it sort by CPU in the Processes TAB and see what is using the most CPU when the lagging happens.

Try disabling as many programs as possible such as AHK scripts,Firewall, limewire,Mikogo etc and Antiviruses and if they cant be disabled make sure you add all these programs to the exceptions list such as HMhud.exe,DBcontrol panel.exe and holdemmanager.exe from the Holdem Manager folder aswell as any of the other programs that happen to be running, sometimes for example the antivirus/firewall etc scan every file thats been processed and it can slow things down so running with as few programs as possible.

Also going to control panel > Admin Tools > Event Viewer and copy and paste any description if there are any error or information events that coincide with the time of the lagging.

Go to Hud Options > Site Options and disable all the prefetch/track live hands options

Lastly make sure your graphics driver is up to date as this can make a big difference to lagging even with a brand new PC.
FAQ - Hold'em Manager Poker Tracking Software :: How To Update Your Graphics Card Driver (http://faq.holdemmanager.com/questions/362/How+To+Update+Your+Graphics+Card+DriverOn)

Also try the top 10 performance tips in my sig and if the problem persists try some older versions and see if the problem persists FAQ - Hold'em Manager Poker Tracking Software :: Download Links For Past Builds (http://faq.holdemmanager.com/questions/426/Download+Links+For+Past+Builds)

Hey thanks for the feedback. I was in Chicago for the weekend, but I am going to try all of these things before my session tonight and let you know how it goes.

I am running HEM 1.11.02

live4yng
07-01-2010, 02:58 PM
It happened again...

Here is the list of processes when it happened.

http://i50.tinypic.com/9ifwbt.png


Also, I checked my Event Viewer and there were 160 instances of an Error with PostgreSQL which all occurred at the same time.

So I assume the problem is with Postgres, how should I go about fixing it?

morny
07-02-2010, 12:07 AM
Hi,

Can you post the details of the postgreSQL errors in event viewer. If there is more than 1 error please post those errors too

live4yng
07-02-2010, 04:49 AM
Most of them say something like this:

2010-07-01 13:57:04 EDTERROR: duplicate key value violates unique constraint "uniqueserial"
2010-07-01 13:57:04 EDTSTATEMENT: EXECUTE PKHEXECUTE(46204188639,2,to_timestamp('07/01/2010 05:11:46','MM/DD/YYYY HH24:MI:SS'),7837,53,8,2,2,0,0,3,29,15,30,16,0,104 0,35,325,725,0,0,0,32,-1,2,2,True,-1,0,0,0,4,4,-1,-1,2,-1,0); select currval('pokerhands_pokerhand_id_seq')

netsrak
07-02-2010, 07:10 AM
Are you sure that this is the event viewer log?
For me it looks like the contents of files in the importing\logs.

The first error just means that you tried to import a hand the 2nd time. Its not unusual.
The 2nd seems to be fine too.

Can you please try to disable live-tracking and prefetch for stars in the site options.

And please attach the file config\holdemmanager.config

live4yng
07-06-2010, 04:23 PM
Okay, how about this error:

2010-07-06 05:13:23 EDTERROR: canceling statement due to user request
2010-07-06 05:13:23 EDTCONTEXT: SQL statement "select P.PlayerName,(Select netamountwon from playerhandscashkeycolumns where playerhandscashkeycolumns.pokerhand_id = PKH.pokerhand_ID and playerhandscashkeycolumns.Player_ID = PVP.player_id) as NetAmountWon,(select holecard1int from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard1int, (select holecard2int from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard2int, (select coalesce(holecard3int,0) from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard3int, (select coalesce(holecard4int,0) from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard4int from pokerhands PKH, playervsplayer PVP join Players p on pvp.player_id = p.player_id where PKH.Pokerhand_Id = PVP.PokerHand_id and PVP.Amount = (Select Max(Amount) from PLayerVsPlayer where pokerhand_id = PKH.PokerHand_ID) and PKH.Pokerhand_id = $1 limit 1"
PL/pgSQL function "getwinningplayerjoincashver2" line 4 at SQL statement
2010-07-06 05:13:23 EDTSTATEMENT: select ph.pokerhand_id,ph.preflopplayeractiontype_id,ph.s treetwentallin,ph.handtimestamp,gt.gametypedescrip tion, gt.pokergame,ph.holecard1int,ph.holecard2int,ph.ho lecard3int,ph.holecard4int,pkh.flopcard1int,pkh.fl opcard2int,pkh.flopcard3int,pkh.turncardint,pkh.ri vercardint,ph.flopplayeractiontype_id,ph.turnplaye ractiontype_id,ph.riverplayeractiontype_id,ph.neta mountwon,gt.bigblind,ph.positiontype_id,ph.preflop action_id,ph.didpfr,ph.didvpip,ev.sklanskybucks,ev .equitypct,getwinningplayerjoincashver2(ph.pokerha nd_id) as winningplayerjoin from playerhandscashkeycolumns_hero ph join pokerhands_hero pkh on pkh.pokerhand_id = ph.pokerhand_id join gametypes gt on gt.gametype_id = ph.gametype_id left join allinsituations_hero ev on ph.playerhand_id = ev.playerhand_id where (ph.player_id = 8) and (ph.gametype_id = 1 or ph.gametype_id = 2 or ph.gametype_id = 3 or ph.gametype_id = 4 or ph.gametype_id = 52 or ph.gametype_id = 53 or ph.gametype_id = 73 or ph.gametype_id = 74 or ph.gametype_id = 75 or ph.gametype_id = 76 or ph.gametype_id = 91 or ph.gametype_id = 92 or ph.gametype_id = 93 or ph.gametype_id = 101) and gt.pokergame = 1 and ph.handtimestamp between to_timestamp('07/06/2010 00:40:15','MM/DD/YYYY HH24:MI:SS') and to_timestamp('07/06/2010 04:46:10','MM/DD/YYYY HH24:MI:SS') order by ph.handtimestamp desc limit 100

morny
07-06-2010, 06:50 PM
Ok, thats just a query, i meant the error from the Event Viewer. Can you go to Control Panel > Admin Tools > Event Viewer and then into applications and you may see an error for postgreSQL that corresponds to the time of the problem, also Can you attach your holdemmanager.config file from C:/Program Files/RVGSoftware/HoldemManager/Config folder please and ill take a look as it looks like you may have dblogging running