Unable to import hand

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Re: Unable to import hand

Postby MDAlex » Tue Sep 02, 2014 11:39 am

kraada wrote:It's hard to be certain without knowing more about your computer usage over the last few days. Clearing up space will definitely make PostgreSQL happier - you don't even have enough free space on your drive for a second copy of your database.

now I have 13 GB free space and the problem is the same: Error: PokerStars: Unable to import hand (#120948980707). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: out of memory DETAIL: Failed on request of size 8. CONTEXT: PL/pgSQL function "update_tourney_custom_cache" line 8 at FOR over SELECT rows )
MDAlex
 
Posts: 6
Joined: Sun Aug 31, 2014 11:19 am

Re: Unable to import hand

Postby kraada » Tue Sep 02, 2014 11:55 am

Please try rebuilding the custom cache via Database -> Database Management -> Housekeeping -> Rebuild Custom Cache and let me know if that completes successfully.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to import hand

Postby MDAlex » Tue Sep 02, 2014 1:48 pm

do u know how time this reindex will take? 2 hours and it's still working
MDAlex
 
Posts: 6
Joined: Sun Aug 31, 2014 11:19 am

Re: Unable to import hand

Postby kraada » Tue Sep 02, 2014 2:06 pm

It can take a while, though I wouldn't expect it to take a whole lot longer on a 3G database, you'll want to let it run to completion regardless.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to import hand

Postby MDAlex » Tue Sep 02, 2014 4:35 pm

ty, this solved my problem
MDAlex
 
Posts: 6
Joined: Sun Aug 31, 2014 11:19 am

Re: Unable to import hand

Postby kraada » Tue Sep 02, 2014 5:07 pm

Glad to hear it! Thanks for following up.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 24 guests

cron