Forum OpenACS Q&A: Re: nsoracle error?

Collapse
2: Re: nsoracle error? (response to 1)
Posted by Dave Bauer on
Hi, can you provide some more surrounding context from the error log, especially before the part you posted? There is not enough information to help.
Collapse
3: Re: nsoracle error? (response to 2)
Posted by Abrantes Filho on
Hi, thanks for you help.

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?