jdbc pool fail on cfmx 6.1 with jrun

[EOIN HICKEY]

Hello,
This is essentially a FYI; as I cannot get any answers on this problem, but if
you are running a similar setup to this:
- Windows 2003 v5.2,
- ColdFusion MX 6,1,0,8376 with multiple instances on JRun 4 Updater 5 version
92909
- Apache 2.0.52
- Oracle 8i
and experiencing problems as per:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=f7736ad[/url]

(though I can't be sure if this article is "exactly" the cause of this
problem, but it looks related as this problem occurs during VERY VERY light
loads - basically nothing at all)

Then the problem appears to be related to JDBC connection pooling. When the db
goes offline for scheduled maintenance, the JDBC connections in the pool appear
to "get broken" and then all the proceeding coldfusion query calls start to
mount up until the CPU reaches 100% and thus making all future access to the
box very very slow with eventual timeouts.

You will recieve occasionaly errors like this in the JRun logs:
ORA-01033: ORACLE initialization or shutdown in progress

A few like these:
Error establishing socket. Connection timed out: connect

And most definitely a lot of these:
Request timed out waiting for an available thread to run. You may want to
consider increasing the number of active threads in the thread pool.

As it is multiple instances install, a quick restart the coldfusion/ jrun
services without restarting the box flushs out the broken connections, but I
would have thought the drivers should be able to handle this.

Anyway, let me know if anyone has any thoughts.

[sdupre]

I'm assuming you're using ColdFusion datasources not JRun (J2EE) datasources.

It's best that you use the latest 3.4 build 50 drivers. I believe this set
fixes the problem you describe.

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0[/url]

Stephen Dupre
Macromedia QA