Page 1 of 2

Unable to import hand

PostPosted: Sat Jun 14, 2014 2:24 pm
by jpdpoker
started after upgrade to 4.11.7 only in tournaments also at party I have plenty of ram

Error: 888 Poker: Unable to import hand (#593949161). 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_cache" line 8 at FOR over

SELECT rows )

Re: Unable to import hand

PostPosted: Sun Jun 15, 2014 10:04 am
by kraada
How large is your database as listed in Database Management?

Re: Unable to import hand

PostPosted: Sun Jun 15, 2014 3:04 pm
by jpdpoker
Whole install on HD is 2.5 gb

Re: Unable to import hand

PostPosted: Mon Jun 16, 2014 7:17 am
by kraada
Is that what it says in PT4 in Database -> Database Management?

Re: Unable to import hand

PostPosted: Tue Sep 02, 2014 8:13 am
by MDAlex
I have the same problem, plss help
Error: PokerStars: Unable to import hand (#120948254298). 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

PostPosted: Tue Sep 02, 2014 8:53 am
by kraada
How large is your database, how much RAM do you have, and how much free space is there on your hard drive?

Re: Unable to import hand

PostPosted: Tue Sep 02, 2014 10:34 am
by MDAlex
kraada wrote:How large is your database, how much RAM do you have, and how much free space is there on your hard drive?

8023 MB RAM 4.00GB free space on disc C: 3GB

Re: Unable to import hand

PostPosted: Tue Sep 02, 2014 10:36 am
by kraada
You only have 4G of hard disk space free on the database drive? That is likely part of the problem then -- try freeing up some space and that may well get things working for you.

Re: Unable to import hand

PostPosted: Tue Sep 02, 2014 10:40 am
by MDAlex
kraada wrote:You only have 4G of hard disk space free on the database drive? That is likely part of the problem then -- try freeing up some space and that may well get things working for you.

ok, but why this start today? yesterday and all rest of the time work fine

Re: Unable to import hand

PostPosted: Tue Sep 02, 2014 11:03 am
by kraada
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.