db. Sorry - but there's just not a lot you can do about it. The sequence driver just hangs under a heavy load. Second,
if you are using JDBC drivers (for MS SQL for example), make sure an enter a fully qualified domain name in the "server"
spot. Don't use an IP address. If you don't know it or don't have one for the db server add an entry to the host file
(sql.mydomain.com) and use that. The JDBC service will waist time with reverse lookups otherwise. Make sure and use the
JDBC Drivers by the way - an odbc socket connection is not going to benefit you much in the long run.
Third, watch out for that "timeout" issue that relates to long running queries. These can cause DB requests to build on
themselves exponentially. This issue is detailed in a technote - but basically, if your query exceeds the timeout for db
connections and is still running it is not released. The workaround is to instantiate 2 datasources - one with
"maintained connections" set true and one with "maintain connnections" set false - then use the second DSN for long
running queries - keeping your pool more tightly managed. This error might be fixed in 6.1 (don't recall).
Finally there are several issues list related to dbs at macromedia support - some with hotfixes. If you aren't using
the DD 3.3 drivers I'd move to them unless you have a reason not to.
-Mark
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 7:45 AM
To: CF-Talk
Subject: Server Errors - CPU spike swsoc.exe
I normally wouldn't post this, but I'm having some crashing server issues. I've optimized the CF settings, but it
seems that the ColdFusion MX ODBC Server is eating up resources on our server
until it crashes. (Windows Task Manager - Processes) Here's an error I got in the event viewer.
I've also done a stack trace dump when starting the server and got the attached results.
The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) cannot be found. The local computer may not
have the necessary registry information or message DLL files to display messages from a remote computer. The following
information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection
reset by peer.
Thank you.
DStarting Macromedia JRun 4 (Build 63824), default server
07/06 17:29:15 warning Unable to open D:\CFusionMX\runtime/lib/license.properties
07/06 17:29:18 info JRun Naming Service listening on *:2901
Running on JRun4...
Starting ColdFusion services...
07/06 17:29:19 info No JDBC data sources have been configured for this server (see jrun-resources.xml)
- Starting logging...
0 [main] INFO coldfusion.server - Starting logging...
07/06 17:29:23 info JRun Proxy Server listening on *:51010
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
