Hi all,
I'm having a problem with my pool connections to Oracle. My setup is
as follows:
Oracle 8.1.7
RedHat 7.2
AOLserver/3.3.1+ad13
ArsDigita Oracle Driver version 2.6
OpenACS 4.5.1b
Basically, I started my web-process, and had it running for a few
days. My site began to get very slow, so I ran "top" to see what
was going on. I had an Oracle process which had been running for
1708 minutes and was taking up 99% of the CPU, 5% of Memory.
I downed the webserver to see if that would fix it. It didn't.
I checked my v$session table in oracle to see what connections were
being made to Oracle, and there were three entries for OpenACS, one
of which was performing a high number of Physical Reads and a high
number of Block Gets. This process had the same process ID as the
one from my "top".
I did a few tests. I ran the following TCL commands through a tcl
page on my server:
set pool [db_nth_pool_name $db_state(n_handles_used)]
ns_log Notice $pool
set dba [ns_db gethandle pool1]
ns_log Notice $dba
set dbc [ns_db gethandle pool3]
ns_log Notice $dbc
#Notice I rearranged the pools because pool2 fails
set dbb [ns_db gethandle pool2]
ns_log Notice $dbb
set output "Results: Pool: $pool, DB: $dba $dbb $dbc"
ns_return 200 text/html $output
had the following results:
[05/Apr/2002:12:45:54][8196.7176][-conn4-] Notice: pooln
[05/Apr/2002:12:45:54][8196.7176][-conn4-] Notice: nsdb1
[05/Apr/2002:12:45:54][8196.7176][-conn4-] Notice: nsdb2
[05/Apr/2002:12:45:54][8196.7176][-conn4-] Notice: RP (280.098 ms):
error in rp_handler: serving GET /pooltest.tcl
ad_url "/pooltest.tcl" maps to
file "/web/demo/www/pooltest.tcl"
errmsg is no access to pool: "pool2"
[05/Apr/2002:12:45:54][8196.7176][-conn4-] Error: GET /pooltest.tcl
no access to pool: "pool2"
while executing
"ns_db gethandle pool2"
invoked from within
"set dbb [ns_db gethandle pool2]"
Looking at top, the oracle process was still there.
Next I edited my Aolserver tcl file and changed my tcl library to
point to an empty directory, i.e. such that it would not source
OpenACS Tcl files, and switched on EnableTclPages.
I reran the above code(without the set pool), and all handles were
obtained without errors.
This time the oracle process disappeared when I checked it
with "top", thus fixing the problem.
It looks like somewhere along the way, pool2 is being allocated and
not released. I found it strange that when I downed my web-server
and restarted, the same process was there, and pool2 was still not
available.
