Updated to 4.11 now stuck "updating database"

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Re: Updated to 4.11 now stuck "updating database"

Postby Seitz333 » Tue May 20, 2014 5:07 pm

kraada wrote:Chuck,

Thanks for the update.

Seitz,

How much activity are we talking for PT4?


On carbon I play about 600-800 tourney hands per night. I'm also using/testing on PokerStars Alpha 7 once a week for a league tourney, about 200 hands/week.

Chuck
Seitz333
 
Posts: 71
Joined: Sun Feb 24, 2008 8:14 pm

Re: Updated to 4.11 now stuck "updating database"

Postby kraada » Tue May 20, 2014 5:11 pm

I meant how much CPU activity are you seeing in the CPU Monitor for PT4 . . .
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Updated to 4.11 now stuck "updating database"

Postby spitznspots » Tue May 20, 2014 6:27 pm

kraada wrote:I meant how much CPU activity are you seeing in the CPU Monitor for PT4 . . .


not sure if you are referring to me?

~14 threads, ~3%cpu ~30 idle wake ups

been running 7hrs now
spitznspots
 
Posts: 35
Joined: Tue Aug 11, 2009 4:38 pm

Re: Updated to 4.11 now stuck "updating database"

Postby Seitz333 » Tue May 20, 2014 8:46 pm

kraada wrote:I meant how much CPU activity are you seeing in the CPU Monitor for PT4 . . .


lol DUH

CPU - pretty much nothing, 2% for everything.
Seitz333
 
Posts: 71
Joined: Sun Feb 24, 2008 8:14 pm

Re: Updated to 4.11 now stuck "updating database"

Postby WhiteRider » Wed May 21, 2014 2:49 am

Seitz333 wrote:
kraada wrote:I meant how much CPU activity are you seeing in the CPU Monitor for PT4 . . .


lol DUH

CPU - pretty much nothing, 2% for everything.

PT4 won't be doing much during the update as the work is primarily done by PostgreSQL. It's hard to predict how long it would take even if we knew the size of your database and the specs of your computer, but if it hasn't finished by now and PostgreSQL isn't doing any work then I'd reboot and try it again. If the database doesn't update when you run PT4 then go to Database > Database Management and click Rebuild Cache to complete the process.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Updated to 4.11 now stuck "updating database"

Postby TwoDolphins » Wed May 21, 2014 5:13 am

My (large) database run an update during night. In the morning, the import didn't work. It said can't import hands to an outdated database. After restarting PT4 it wanted to update the database again. Waste of time I suppose. Now I'm in progress of building a new database and reimporting hands.
TwoDolphins
 
Posts: 1
Joined: Sun Sep 07, 2008 3:57 pm

Re: Updated to 4.11 now stuck "updating database"

Postby TRNSLTR » Wed May 21, 2014 6:26 am

My 31GB database is now updating for over 30 hours. There is just pokertracker process running, no postgresql process in the task manager, but the Postgresql service is running. What should I do?
TRNSLTR
 
Posts: 70
Joined: Fri Feb 12, 2010 3:24 pm

Re: Updated to 4.11 now stuck "updating database"

Postby kraada » Wed May 21, 2014 7:42 am

TRNSLTR: Make sure you click Show Processes From All Users in Task Manager; the PostgreSQL service is run by the postgres user and won't be visible without clicking that button.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Updated to 4.11 now stuck "updating database"

Postby TRNSLTR » Wed May 21, 2014 8:32 am

Ok, right you are - 10 postgres.exe processes appeared. So I should let it keep updating the database even though it already has been going on for such a long time?
TRNSLTR
 
Posts: 70
Joined: Fri Feb 12, 2010 3:24 pm

Re: Updated to 4.11 now stuck "updating database"

Postby kraada » Wed May 21, 2014 9:16 am

Are some of those 10 processes still actively using CPU?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

PreviousNext

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 68 guests

cron