Database update ?

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Database update ?

Postby beck2night » Wed Nov 29, 2017 6:40 am

Hey I downloaded the new update yesterday and got prompted to also update the database. It's been about 15 hours since that database update started and when I click the close button PT4 says I should wait for the process to complete on its own. There is also not a real progress bar so I'm not sure if the update is even going anywhere.
https://imgur.com/5fZtg0u
I have about 1.8m hands and use i5 processor. Both PT4 and PostgresQ are on SSD hard drive. Should I wait more or is it bugged?
beck2night
 
Posts: 11
Joined: Wed May 20, 2015 11:59 am

Re: Database update ?

Postby Flag_Hippo » Wed Nov 29, 2017 6:59 am

If you open your Windows Task Manager are any PostgreSQL processes still using CPU?
Flag_Hippo
Moderator
 
Posts: 15192
Joined: Tue Jan 31, 2012 7:50 am

Re: Database update ?

Postby beck2night » Wed Nov 29, 2017 7:13 am

Yes. The first process varies from 0-5% .
https://imgur.com/tZ8Kz2o
beck2night
 
Posts: 11
Joined: Wed May 20, 2015 11:59 am

Re: Database update ?

Postby Flag_Hippo » Wed Nov 29, 2017 4:04 pm

I've asked for clarification on this as it seems like this is taking longer than it should. Is the database update/PostgreSQL process still running?
Flag_Hippo
Moderator
 
Posts: 15192
Joined: Tue Jan 31, 2012 7:50 am

Re: Database update ?

Postby beck2night » Wed Nov 29, 2017 5:02 pm

Yes it's been around 25 hours now. BTW in this screenshot you can see that the new NoteCaddy is actually running as a background process aswell taking some resources aswell even though im not using it and I ended the task earlier from task manager and its started again.

https://imgur.com/8iVM2ST
beck2night
 
Posts: 11
Joined: Wed May 20, 2015 11:59 am

Re: Database update ?

Postby Mette » Thu Nov 30, 2017 5:42 am

hello, I have the same problem. It's running for 12 hours now and the database update/PostgreSQL process is still running.
Mette
 
Posts: 1
Joined: Thu Nov 30, 2017 5:39 am

Re: Database update ?

Postby beck2night » Thu Nov 30, 2017 6:40 am

40+ hours here. The problem is if I force shut it down I know im gonna have huge problems configuring PT4 after that.
beck2night
 
Posts: 11
Joined: Wed May 20, 2015 11:59 am

Re: Database update ?

Postby Flag_Hippo » Thu Nov 30, 2017 9:45 am

beck2night wrote:40+ hours here. The problem is if I force shut it down I know im gonna have huge problems configuring PT4 after that.

If you have signed up for the NoteCaddy Beta and have unprocessed notes before doing the database update then PokerTracker 4 will not open until all notes have been processed. We are investigating why that's happening and I suspect that the database update has completed so if you go ahead and shutdown PokerTracker 4 and restart it things should go back to normal.
Mette wrote:hello, I have the same problem. It's running for 12 hours now and the database update/PostgreSQL process is still running.

How big is your database? Are you signed up for NoteCaddy and is that running in task manager also?
Flag_Hippo
Moderator
 
Posts: 15192
Joined: Tue Jan 31, 2012 7:50 am

Re: Database update ?

Postby beck2night » Thu Nov 30, 2017 11:20 am

Restarted the pc. Ran PT4 and got prompted to update the database. Declined and clicked on the show notecaddy. Turns out it actually has imported only 1/2 my hands till now. I clicked the vacuum database option as Notecaddy suggests in the screenshot.

https://imgur.com/KC6t0Y8

Can I somehow stop that because its gonna take another full day and update the database for PT4 and start using it?

P.S. Just checked when I click on database management the PostgresQL version is 9.3.9.
beck2night
 
Posts: 11
Joined: Wed May 20, 2015 11:59 am

Re: Database update ?

Postby Flag_Hippo » Thu Nov 30, 2017 2:50 pm

In NoteCaddy go to 'File -> Settings' and disable 'Automatically start note taking process at launch', restart PokerTracker 4 and then try the database update again.
Flag_Hippo
Moderator
 
Posts: 15192
Joined: Tue Jan 31, 2012 7:50 am

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 8 guests

cron
highfalutin