Open Side Menu Go to the Top

05-02-2010 , 12:42 PM
Hello,

i've just downloaded the 3.07 beta version. And PT forced me "to update pokertracker"...does this mean the complete and full dbchk (updata cache, cluster and so on)?? Which in my case means running 14 hours....

I look fwd to an answer...
Beta 3.07 update
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards ? Splash Pots ? CoinRaces
Beta 3.07 update
05-02-2010 , 12:47 PM
For that update you should not need to cluster, but you should vacuum/analyze and update cache. These will take some time but should not take nearly as long as if you did need to cluster.
05-02-2010 , 01:28 PM
Ah many thanks for the answer; I Really appreciate the hard work you're pulling off with your team!! I am very curious about he beta -and of course the next real patch-

keep up the good work!
05-02-2010 , 03:58 PM
PT3 quits running after about a minute when i do manual import from files (the process just goes away). manual import from folder and autoimport works tho, but i have problems with the hud not showing up also. Have done full housekeeping, but no change.
05-02-2010 , 07:55 PM
Did an manual import (from folder) of 150k hands now, and several programs (firefox and stars) started to lag and quit working, never experencied this before. Dunno if it is PT3 who is causing this, but seems so. My computer have good hardware, so that aint the problem..

Win7 64bit
7GB RAM
AMD Phenom II X4 940 3ghz processor
7200 rpm hdd

Help?
05-02-2010 , 10:09 PM
I'm in the same boat as the previous two posters. Have done full housekeeping and am now trying to rebuild cache. Help would be appreciated!
05-03-2010 , 06:44 AM
Quote:
Stats: SQL comments are now checked for and not permitted
What exactly does that mean?
05-03-2010 , 10:30 AM
PokerChick and Rolly Fingas if you could both please report this problem we would appreciate it. This is the first I've heard of these sorts of issues in the new beta.

Quote:
Originally Posted by Gunner171
What exactly does that mean?
The use of '--' in columns was causing problems as '--' indicates a comment in SQL. For the most part, this is not something you need to worry about.
05-07-2010 , 12:20 PM
Quote:
Originally Posted by PokerChick90
Did an manual import (from folder) of 150k hands now, and several programs (firefox and stars) started to lag and quit working, never experencied this before. Dunno if it is PT3 who is causing this, but seems so. My computer have good hardware, so that aint the problem..

Win7 64bit
7GB RAM
AMD Phenom II X4 940 3ghz processor
7200 rpm hdd

Help?
This is still happening, could you please look into it? I have enabled logging now, hopefully i will understand how to report it.
05-07-2010 , 02:04 PM
There's a detailed tutorial on how to report these things available here, if you need.
05-07-2010 , 05:43 PM
Ok, think i got it. ticket_id=89302

Please fix asap
05-07-2010 , 06:41 PM
We'll be investigating and get back to you in your ticket.
05-07-2010 , 06:46 PM
Quote:
Originally Posted by Kraada
For that update you should not need to cluster, but you should vacuum/analyze and update cache. These will take some time but should not take nearly as long as if you did need to cluster.
NOTE: if your SQL DB is on an SSD, you should never cluster (IMO).
05-08-2010 , 12:11 PM
I would agree with that assessment, fwiw.
05-09-2010 , 02:15 PM
The HUD is really slow to update also now, sometimes it doesnt show up at all when i join a table..
05-09-2010 , 03:04 PM
Btw, i got 118k players and 2.7M hands in the database, could that be the case? How many hands do one database support?
05-09-2010 , 06:51 PM
The PT3.exe process now using 1.2GB(!!) RAM, its been running for 6 hours at autoimport while i have been playing, HUD hasnt worked at all.
05-09-2010 , 08:24 PM
Pokerchick I solved my problem by making another database.
My problem was with my computer tho.
If PT3.exe is running then the hud isnt.
I found that as long as I didnt screw with PT the hud would work fine. If you ae looking back at PT while playing then PT takes presedence over postgres. Postgres runs the HUD. The bigger the current database the more memory PT3 eats up. Postgres doesnt use much mem at all.
Use the smaller DB when playing and have the hud to "look" at both. The stats will reflect both databases or as many as you tell it to.
05-09-2010 , 08:25 PM
That doesn't sound normal. If you stop the auto import does the RAM used drop significantly?
05-10-2010 , 08:40 AM
Kraada: I dont remember 100% for sure, but i think the RAM didnt drop down very much when i turned off auto import. Testing now - 67k MB when PT3 is opened without doing anything. 88k MB when running auto import, and HUD is working atm on all four tables. Testing rushpoker - 97k MB when running auto import, HUD is working but after only a few hands it doesnt update quick enough, so it shows players from tables i have folded 2-3 rounds ago. PokerTrackerHud.exe using 35k MB. It seems like the process activity increases very much when i play for a while.

phjjr: I think i may have to do as you say, create new databases and importing everything once again into several databases. But do the HUD work any faster when you do it like that? Cause i still want all the hands I have in my database to show up in the HUD when playing. I assume there is no easier method than creating brand new databases and importing all hands again into several databases? That will take a looooong time, but if it solves my problem i just have to do it, cause i cant keep it going like this..
05-10-2010 , 10:38 AM
I'm a bit confused by your terminology - are those in MB of RAM used or KB of RAM used? 67k MB would be 67GB of RAM used and surely that's not right.

It used to help a lot to keep new smaller databases around but that shouldn't be an issue any longer so long as you keep your cache at 100% unless your computer is quite old.
05-10-2010 , 02:06 PM
67000 kB RAM used, sorry about that

I do housekeeping after manual import each time, and the cache is at 100% atm.

As said earlier my computer is fairly good, so that shouldnt be the case.

Win7 64bit
7GB RAM
AMD Phenom II X4 940 3ghz processor
7200 rpm hdd

Edit: just opened PT3 and FTP, sat down at 4 rushtables and the HUD is still updating way too slow. Maybe i should enable logging when playing a few hands and submitting the log?

Last edited by PokerChick90; 05-10-2010 at 02:12 PM.
05-10-2010 , 03:16 PM
Yes please do that. For more on exactly which files to send us, see this tutorial.
05-10-2010 , 07:22 PM
PokerChick like I said my main problem is computer related.
I have no problems on a 2nd computer.
Yes the multible databases seem to help "but" I have many less hands and do not multitable as much as you have indicated.
I also have a database strickly for rush and notice a definate improvement in "lag" When using only this DB. I also think people play different when 'Rushing" so 2fold reason for an additional DB.
These are workarounds Ive found effective for my barely adequate computer. I'm sure Kradda and the PT team will help you.
05-10-2010 , 07:37 PM
Ok, i understand phjjr. Thanks for the explanation

I'm gonna build some new fresh databases and import everything again, hopefully that will help.
Beta 3.07 update
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards ? Splash Pots ? CoinRaces
Beta 3.07 update

      
m