Error message
Hello.
After I have performed several queries by an external program on the
database, an error message appeared:
"hard limit on result handles reached is not a valid query result"
May I know how to solve the problem?
Thank you
On 3 Mar 2004, Eric wrote:
Hello.
After I have performed several queries by an external program on the
database, an error message appeared:
"hard limit on result handles reached is not a valid query result"May I know how to solve the problem?
Sounds like an application issue, not postgresql. What language are you
using, and might you share some code?
This is in Tcl, right?
You are creating queries without clearing the result handles. Make sure you always clear the result handles after getting the data. I noticed this problem too when I upgraded to latest version of Tcl, where the number of open handles are limited. When I found that bug and fixed it, my app suddenly stopped its bad habit of slowly eating up memory and slowing down... :)
/Mattias
----- Original Message -----
From: "Eric" <hehe88hk@yahoo.com.hk>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, March 03, 2004 4:57 PM
Subject: [GENERAL] Error message
Show quoted text
Hello.
After I have performed several queries by an external program on the
database, an error message appeared:
"hard limit on result handles reached is not a valid query result"May I know how to solve the problem?
Thank you---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?