Import Issues

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Import Issues

Postby ZakWray » Wed Dec 28, 2016 4:38 pm

Hello, when i click import all hands to start the HUD the app itself freezes after the import starts (directory of hand histories is correct), i can't close it without pressing ctrl alt delete and forcing shut down. I tried to rebuild cache and full vacuum but get the following errors (please see attached screenshots) so I don't know what I can do next.

My database is a few years old and has many hands - would creating a new database work? At the moment I can't play without the HUD crashing, Zak
Attachments
Screen Shot 2016-12-28 at 20.30.40.png
Screen Shot 2016-12-28 at 20.30.32.png
ZakWray
 
Posts: 45
Joined: Mon Apr 04, 2011 10:20 am

Re: Import Issues

Postby ZakWray » Wed Dec 28, 2016 7:20 pm

Just to also add: i created a new database and the app does not crash now after clicking "get hands while playing" and "stop getting hands" and the HUD works, but if i revert back to my default database the problem still exists.
ZakWray
 
Posts: 45
Joined: Mon Apr 04, 2011 10:20 am

Re: Import Issues

Postby Flag_Hippo » Thu Dec 29, 2016 7:56 am

There is a PostgreSQL restriction on the number of columns in a table so you will need to restrict the number of custom columns which are cached to 1600 before attempting the cache rebuild again. Each custom column has a "Cache" checkbox - you can turn this off to prevent a column from being cached, and you will need to reduce the number of cached columns to less than 1600. The custom cache in PT4 is separate from the built in cache - you don't get the full 1600 columns as we need identifiers but you get something like 1585. You can alter what is and isn't cached in the custom cache by going to Configure -> Statistics and in the Players section you can untick "cache" for custom columns you don't want cached. So you can pick the 1580-odd columns you do want cached. The rest can be used in the HUD (or reports) they'll just take longer to return data as it needs to be calculated on the fly.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Import Issues

Postby ZakWray » Thu Dec 29, 2016 9:06 am

So I need to work my way through the custom built stats and untick cache for each of them, then try to rebuild cache again?
ZakWray
 
Posts: 45
Joined: Mon Apr 04, 2011 10:20 am

Re: Import Issues

Postby Flag_Hippo » Thu Dec 29, 2016 1:17 pm

Yes that would be the first thing to do. The easiest to check how many columns you are currently using is to use PGAdmin III, browse to your database's tables and look at the cache_custom_cache (or tourney_custom_cache) table in the Schemas -> Public section.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Import Issues

Postby ZakWray » Thu Dec 29, 2016 1:27 pm

sorry i don't know what PGAdmin III is
ZakWray
 
Posts: 45
Joined: Mon Apr 04, 2011 10:20 am

Re: Import Issues

Postby ZakWray » Fri Dec 30, 2016 8:10 am

Is there another solution because I'm going to struggle doing that on my own
ZakWray
 
Posts: 45
Joined: Mon Apr 04, 2011 10:20 am

Re: Import Issues

Postby Flag_Hippo » Fri Dec 30, 2016 9:40 am

Click your Windows Start button then type the following:

pgadmin

and click on it when it appears. Double click on "PostgreSQL x.y" (where x.y is your PostgreSQL version) and if your prompted for a password the default is "dbpass" (without the quotes). Next double click on "Databases -> YOUR_DATABASE_NAME -> Schemas -> Public -> Tables -> cash_custom_cache (and/or tourney custom cache for tournaments) and the number in brackets is the number of custom columns which should look like this.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Import Issues

Postby ZakWray » Sat Dec 31, 2016 9:03 am

Okay this is what it says: see attached, so there are 855 columns?
Attachments
Screen Shot 2016-12-31 at 13.01.47.png
Screen Shot 2016-12-31 at 13.01.47.png (9.82 KiB) Viewed 943 times
ZakWray
 
Posts: 45
Joined: Mon Apr 04, 2011 10:20 am

Re: Import Issues

Postby Flag_Hippo » Sun Jan 01, 2017 8:18 am

Yes however in some cases that number doesn't correlate directly to the number of cached columns which depends on the custom content you are using - you can see more about this in this thread and this thread.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 59 guests

cron
highfalutin