Unable to import hand

[MDAlex]

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 )

[kraada]

Please try rebuilding the custom cache via Database -> Database Management -> Housekeeping -> Rebuild Custom Cache and let me know if that completes successfully.

[MDAlex]

do u know how time this reindex will take? 2 hours and it's still working

[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.

[MDAlex]

ty, this solved my problem

[kraada]

Glad to hear it! Thanks for following up.