Forum OpenACS Q&A: Re: nsoracle error?
I restarted the AOLserver and tryed to acess the clob-test.tcl page again. All logs from AOLserver, since the restart, are here:
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: nsmain: security info: uid=30, euid=30, gid=8, egid=8
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 8192, rl_max = 8192
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Warning: nsmain: rl_max > FD_SETSIZE
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: encoding: loaded: utf-8
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: fastpath[server1]: mapped GET /
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: fastpath[server1]: mapped HEAD /
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: fastpath[server1]: mapped POST /
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: adp[server1]: mapped GET /*.adp
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: adp[server1]: mapped HEAD /*.adp
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: adp[server1]: mapped POST /*.adp
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssock.so'
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nslog.so'
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: nslog: opened '/usr/local/aolserver/servers/server1/modules/nslog/access.log'
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nsdb.so'
[06/Aug/2012:10:24:48][25854.3074164416][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nsoracle.so'
[06/Aug/2012:10:24:49][25854.3074164416][-main-] Notice: ora11 driver LobBufferSize = 32768
[06/Aug/2012:10:24:49][25854.3074164416][-main-] Notice: ora11 driver PrefetchRows = 0
[06/Aug/2012:10:24:49][25854.3074164416][-main-] Notice: ora11 driver PrefetchMemory = 0
[06/Aug/2012:10:24:50][25854.3074164416][-main-] Notice: Loaded ArsDigita Oracle Driver version 2.7, built on 15:01:46/Aug 2 2012
[06/Aug/2012:10:24:50][25854.3074164416][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nscache.so'
[06/Aug/2012:10:24:50][25854.3074164416][-main-] Notice: nscache module version 1.5 server: server1
[06/Aug/2012:10:24:50][25854.3074164416][-main-] Notice: conf: [ns/server/server1]enabletclpages = 1
[06/Aug/2012:10:24:50][25854.3074164416][-main-] Notice: tcl: enabling .tcl pages
[06/Aug/2012:10:24:50][25854.3074164416][-main-] Notice: default thread pool: minthreads 5 maxthreads 20 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[06/Aug/2012:10:24:51][25854.3074164416][-main-] Notice: XOTcl version 1.6.6 loaded
[06/Aug/2012:10:24:51][25854.3074164416][-main-] Notice: nsmain: AOLserver/4.5.1 running
[06/Aug/2012:10:24:51][25854.3074164416][-main-] Notice: nsmain: security info: uid=30, euid=30, gid=8, egid=8
[06/Aug/2012:10:24:51][25854.3065711472][-sched-] Notice: sched: starting
[06/Aug/2012:10:24:51][25854.3074164416][-main-] Notice: driver: starting: nssock
[06/Aug/2012:10:24:51][25854.3025562480][-default:0-] Notice: random: generating 1 seed
[06/Aug/2012:10:24:51][25854.3024538480][-nssock:driver-] Notice: starting
[06/Aug/2012:10:24:51][25854.3024538480][-nssock:driver-] Notice: nssock: listening on 200.179.110.80:84
[06/Aug/2012:10:25:06][25854.3025562480][-default:0-] Notice: dbdrv: opening database 'ora11:snw'
[06/Aug/2012:10:25:09][25854.3025562480][-default:0-] Error: Tcl exception:
while executing
"ns_ora clob_get_file $db "select chunks from markd_lob_test where lob_id=100" ${empty_file_name}-back"
(file "/srv/www/aolserver/server1/www/nsoracle/clob-test.tcl" line 492)
invoked from within
"source $file"
invoked from within
"ns_sourceproc cns0 {}"
Above are all logs genereted since the AOLserver restart and a try to run clob-test.tcl again.
The only error message in the log are about "ns_ora clob_get_file".
I'm doing something wrong?
