Forum OpenACS Q&A: Warning: Query dbqd.www.index-orig.index-oracle.site_nodes has rdbms info oracle 8.1.6

Startup hangs for up to 10 min at this point, spits out this warning, and then starts up (OpenACS 4.6.3, PG 7.2.3).

hangs here...

[18/Jan/2004:07:24:02][14963.1024][-main-] Notice: Executing initialization code block procs_register in /home/nsadmin/web/james/packages/acs-tcl/tcl/request-processor-init.tcl
[18/Jan/2004:07:29:57][14963.1024][-main-] Warning: Query dbqd.www.index-orig.index-oracle.site_nodes has rdbms info oracle 8.1.6 which is not compatible with system rdbms postgresql 7.2

...here's the same thing with more context...

[18/Jan/2004:07:24:02][14963.1024][-main-] Notice: Done loading OpenACS.
[18/Jan/2004:07:24:02][14963.1024][-main-] Notice: Sourcing files for postload...
[18/Jan/2004:07:24:02][14963.1024][-main-] Notice: Done.
[18/Jan/2004:07:24:02][14963.1024][-main-] Notice: Executing initialization code blocks...
[18/Jan/2004:07:24:02][14963.1024][-main-] Notice: Executing initialization code block filters_register in /home/nsadmin/web/james/packages/acs-tcl/tcl/request-processor-init.tcl
[18/Jan/2004:07:24:02][14963.1024][-main-] Notice: Executing initialization code block procs_register in /home/nsadmin/web/james/packages/acs-tcl/tcl/request-processor-init.tcl
[18/Jan/2004:07:29:57][14963.1024][-main-] Warning: Query dbqd.www.index-orig.index-oracle.site_nodes has rdbms info oracle 8.1.6 which is not compatible with system rdbms postgresql 7.2
[18/Jan/2004:07:29:58][14963.1024][-main-] Notice: tcl: generating interp init script
[18/Jan/2004:07:29:59][14963.1024][-main-] Notice: nsmain: AOLserver/3.3.1+ad13 running
[18/Jan/2004:07:29:59][14963.1024][-main-] Notice: nsmain: security info: uid=501, euid=501, gid=501, egid=501
[18/Jan/2004:07:29:59][14963.2051][-sched-] Notice: sched: starting
[18/Jan/2004:07:29:59][14963.1024][-main-] Notice: serv: waiting for warmup
[18/Jan/2004:07:29:59][14963.1024][-main-] Notice: serv: warmed up
[18/Jan/2004:07:29:59][14963.1024][-main-] Notice: socks: idle
[18/Jan/2004:07:29:59][14963.1024][-main-] Notice: sched: waiting for idle

I'm not sure that it's hanging. I think that OpenACS is loading all the query files into memory during that time. You can set debug to true in your nsd.tcl file to see more detail.

I'm not sure why that is taking 5 minutes for you. OpenACS 4.6.3 used ns_xml which is much slower than tDOM, and I think there was a bug in 4.6 where the query files got loaded twice instead of once, so maybe that's it.

The oracle warning is a red herring.