Page 2 of 2
Re: Unable to import hand
Posted:
Tue Sep 02, 2014 11:39 amby MDAlex
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 )
Re: Unable to import hand
Posted:
Tue Sep 02, 2014 11:55 amby kraada
Please try rebuilding the custom cache via Database -> Database Management -> Housekeeping -> Rebuild Custom Cache and let me know if that completes successfully.
Re: Unable to import hand
Posted:
Tue Sep 02, 2014 1:48 pmby MDAlex
do u know how time this reindex will take? 2 hours and it's still working
Re: Unable to import hand
Posted:
Tue Sep 02, 2014 2:06 pmby kraada
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.
Re: Unable to import hand
Posted:
Tue Sep 02, 2014 4:35 pmby MDAlex
ty, this solved my problem
Re: Unable to import hand
Posted:
Tue Sep 02, 2014 5:07 pmby kraada
Glad to hear it! Thanks for following up.
