One more chunk of info to add to this mystery:
This OpenBD app has a 10Mb log file called querybatch.log - which is
filled with 207,159 repeating lines: java.lang.NullPointerException
Are OpenBD-specific cfquery tag attributes (like cachename) required?
Al
On 8/18/2011 9:45 AM, Alan Holden wrote:
The error continues to occur, about twice a day or as volume goes up.
The app appears to choke on unfulfilled requests - or open connections
or something: "When connecting to the Database this error was
reported: failed to verify remote server/socket".
The Postgres 7.3.4 database is still working, as the CFMX 6.1 server
continues to use it without issue. All the machines involved are on
the same rack, there's only a router between them. The datasource is
set Per-Request Connections=false, Max Connections=24, Timeouts=20.
It looks like the Tomcat apps get hosed as well... the OpenBD
administrator for THIS deployment stops responding, and OpenBD
administrators for OTHER deployments start throwing directory and file
not found errors... weird stuff.
Would you suggest I try a newer Postgres driver? OpenBD 1.4 is on
postgresql-8.4-701.jdbc4.jar - and the latest is
postgresql-9.0-801.jdbc4.jar. Besides dropping the newer jar into
/WEB-INF/lib - what else needs to be changed?
Was there any general improvements to OpenBD 1.5 in this area? Would
you suggest trying that jar as the next step?
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
