Updated to new beta and now housekeeping is running forever!

General discussion of PokerTracker 3.

Moderator: Moderators

Updated to new beta and now housekeeping is running forever!

Postby jyeager » Thu Apr 01, 2010 11:40 am

On a win 7, i7. Just yesterday the housekeeping ran in less than 30 mins, now over 9 hours! It seems to be stuck updating cache.
jyeager
 
Posts: 43
Joined: Mon May 25, 2009 9:33 pm

Re: Updated to new beta and now housekeeping is running forever!

Postby kraada » Thu Apr 01, 2010 11:54 am

There were new built in stats added to Beta 30.9 so the first cache update is likely going to take a whole lot longer. Do you see a postgres.exe process using a fair amount of CPU time in Task Manager?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Updated to new beta and now housekeeping is running forever!

Postby jyeager » Thu Apr 01, 2010 12:30 pm

No postgres.exe or any other postgres processes. There are 4 PT3 processes but they are the program and 3 hud related processes. Would it hurt it if forced it to quit mid cache update?
jyeager
 
Posts: 43
Joined: Mon May 25, 2009 9:33 pm

Re: Updated to new beta and now housekeeping is running forever!

Postby kraada » Thu Apr 01, 2010 1:20 pm

You'd definitely need to rebuild your cache afterwards if you did that - forcing PT3 to quit in the middle of a cache update will leave you with an incomplete cache and that would result in the wrong stats appearing in your HUD at the table.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Updated to new beta and now housekeeping is running forever!

Postby jyeager » Thu Apr 01, 2010 1:26 pm

right now at 11.5 hours, still spinning wheels. Since there is no postgres process running should I force it to quit, and then do this cache rebuild?
Thanks!
jyeager
 
Posts: 43
Joined: Mon May 25, 2009 9:33 pm

Re: Updated to new beta and now housekeeping is running forever!

Postby kraada » Thu Apr 01, 2010 1:52 pm

How big is your database?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Updated to new beta and now housekeeping is running forever!

Postby jyeager » Thu Apr 01, 2010 2:05 pm

maybe 1.5 - 2 M hands.
jyeager
 
Posts: 43
Joined: Mon May 25, 2009 9:33 pm

Re: Updated to new beta and now housekeeping is running forever!

Postby kraada » Thu Apr 01, 2010 2:22 pm

That definitely shouldn't have taken that long then. You can end the process, but then I'd recommend restarting PT3 with the Logging Enabled link - that way you can follow the progress in the PokerTracker.log file - it tells you in percentage of players complete so 50% isn't actually 50% in terms of time (the cache update for players with more hands will always take longer), but it will give you an idea roughly how much is done and how much is left to go.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Updated to new beta and now housekeeping is running forever!

Postby jyeager » Thu Apr 01, 2010 6:20 pm

I enabled the logging and restarted PT, then I started rebuilding the database.

How do I utilize the logging to monitor progress? is there a how to guide for this? Am I correct to assume that rebuilding takes a lot longer than updating?
jyeager
 
Posts: 43
Joined: Mon May 25, 2009 9:33 pm

Re: Updated to new beta and now housekeeping is running forever!

Postby jyeager » Thu Apr 01, 2010 8:20 pm

I learned something new, opening up the pokertracker log file is pretty damn cool. Thanks! Rebuilding the database took about 1.5 hours. Everything seems to be working fine now.
jyeager
 
Posts: 43
Joined: Mon May 25, 2009 9:33 pm

Next

Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests