Ian Harding wrote:
> [05/Sep/2001:14:08:54][19325.21][-conn2-] Error: dbinit: db handle limit exceeded:
>thread already owns 1 handle from pool 'pgpool'
> [05/Sep/2001:14:08:54][19325.21][-conn2-] Error: could not allocate 1 handle from
>pool "pgpool"
I believe you probably did something like this:
set db [ns_db gethandle pgpool]
.... (any code except ns_db releasehandle $db)
set db2 [ns_db gethandle pgpool]
The second call results in an error. If you need two handles,
set db_list [ns_db gethandle pgpool 2]
set db [lindex $db_list 0]
set db2 [lindex $db_list 1]
If a filter which runs before your script is also using a handle, it
might not be returning the handle to the pool, resulting in the same
error.
connsperthread has nothing to do with this error.
--Tom Jackson