OK .. I switched the database connection to TCP/IP, but that didn't help :(
Todd
----- Original Message -----
From: "Herman Cremer" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, July 26, 2001 3:02 AM
Subject: RE: Serious issues with connectstring causing CF server threads to
hang
| I'll take shot in the dark and try the following.
|
| You said the two machines are connected with NetBios,
| because the IIS server has a live IP.
|
| Here is what I would do.
| Pop in another NIC, assign it a IP
| on the same subnet as the 2000 server,
| and make the connection via TCP/IP.
|
| I once had a similar problem, and this fixed it.
| I also did this as a last, hopeless resort....and BOOM !
|
| I also got a connection to the DB, but it
| timed out due to "high traffic"....
| it was as if some of the return packets
| was going out on the IP and not back to the LAN.
|
| ....just an idea....
|
|
|
|
| Hemmin
|
| -----Original Message-----
| From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
| Sent: Thursday, July 26, 2001 4:59 AM
| To: CF-Server
| Subject: Serious issues with connectstring causing CF server threads to
| hang
|
|
| I have posed this question on CF-Talk and on the Forums and even opened a
| ticket with Macromedia tech support, but I still don't have an answer.
Tech
| support is still working on a resolution (if there is one), but after 16
| months of development, we are ready to deploy this app. for Beta testing
and
| this show-stopping problem is really throwing off our schedule. It is soo
| frustrating to finish a long project only to be held up at the last moment
| by a problem that can't be developed around! I'm hoping someone on the
| cf-server list might have some ideas.
|
| Here we go ...
|
| I am using connectstring to connect to a Saybase database. I can normaly
get
| the queries to run fine, but if anything in the connectstring is wrong to
| the point that it causes CF not to be able to connect to the database, the
| current thread hangs 'permenantly'.
|
| This is a very serious problem for me because the application I am
| developing *has* to use connectstring. There is no way around it, that I
| know of. Also, end users will be providing some of the parameters that
make
| up the connect string, so the likelyhood of failed connection attempts is
| _very_ high. This could eaily kill performance on the server enough to
make
| the program unusable within a very short time (seconds even).
|
| Here's my setup:
|
| CF Server is running on NT 4.0 SP 6 using IIS 4.
| The database engine runs on Windows 2000 Pro SP 2.
| The database is Sybase ASA 7.02
| The 2 machines communicate via NetBIOS (the CF server has a public IP and
| the database server has a private one)
|
| I pretty sure that the error has something to do with ColdFusion. The
| database doesn't lock up in any way and actually returns an error message
| saying that the database connection attempt failed. The CF machine
actually
| recieves the error because we can log it in the datasource log we set up.
| ColdFusion is just missing this, or something.
|
| Here is the debug info from the datasource on the CF machine which
includes
| the connectstring (The invalid data in this connectstring is the password)
| .. notice the CONN messages:
|
| -----
| Wed Jul 18 2001 11:01
| CONN: Application information:
| "HOST=BUSINESSSAFE;OS=Windows NT 4.0 (Service Pack
|
6);PID=0x5d;THREAD=0xc9;EXE=C:\CFUSION\bin\cfserver.exe;VERSION=7.0.2.1402;A
| PI=ODBC"
| CONN: Attempting to connect using:
|
UID=3;PWD=******;DBF=e:\databases\gymtime\16.db;ENG=Saber;CON=SQL_DBC_4889cf
|
8;ASTOP=YES;INT=NO;CBSIZE=4096;DBG=YES;LTO=10;LOG=c:\gymbob.log;DMRF=NO;LINK
| S=netbios
| NetBIOS -- Trying connection on lan adapter: 1
| NetBIOS -- Looking for name on lan adapter: 1
| NetBIOS -- Found name successfully on lan adapter: 1
| NetBIOS -- Trying connection on lan adapter: 1
| NetBIOS -- Found session connection on lan adapter: 1
| CONN: Connected to the server
| CONN: Database is running, but could not connect to it
| -----
|
| So, as you can see, the CF machine is being notified that the connection
| failed, it's just that CF doesn't seem to be getting the hint. The
| connectstring is 100% correct, except for the password, which I inserted
| incorrectly on purpose to generate the error. If the correct password is
| provided, the connection is made and the query runs and the results are
| returned .. everything performs perfectly.
|
| After further testing, I found that it does NOT have to be the
connectstring
| that is wrong. I moved the uid and pwd out of the connectstring and into
the
| username and password attributes of the <cfquery> tag. Now, if I provide
the
| wrong password, the connectstring is 100% correct, but I still get the
hung
| thread. This makes me think that anytime there is *any* type of database
| error while using the connectstring attribute, I will get a hung thread. I
| haven't tested this on access or SQL Server yet, though.
|
| I've included the query that I am calling.
|
| <cfquery name="qryValidateLogin" datasource="#Request.mainDSN#"
| username="#qryGetUserID.contactPK#" password="#Attributes.txtPassword#"
|
connectstring="dbf=e:\databases\gymtime\#Client.dbID#.db;eng=Saber;links=net
| bios;">
| SELECT 1
| FROM dummy
| </cfquery>
|
| I have tried using every "timeout" method available on all of the
machines,
| but the thread still hangs 'permenantly'.
|
| This is what I get in my application.log file, but I never get this error
on
| the screen:
|
| -----
| Mozilla/4.0 (compatible; MSIE 6.0b; Windows NT 5.0; COM+ 1.0.2204), ODBC
| Error Code = 08S01 (Communication link failure) [Sybase][ODBC
| Driver][Adaptive Server Anywhere]Communication link failure: Communication
| errorDate/Time: 07/18/01 10:59:53
| -----
|
| Here is what I get in my server.log file:
|
| A request exceeded the timeout. The unresponsive thread count is up to 1.
| [C:\Inetpub\wwwroot\gymtime_2\index.cfm]
|
| 2001-07-18 11:03:05 Error 202
|
|
| !! CFTrace::logThread(201) has no entry for thread 201
|
| 2001-07-18 10:59:53 Warning 199
|
|
| Template: C:\Inetpub\wwwroot\gymtime_2\index.cfm, Ran: 1977 seconds.
|
| 2001-07-18 10:59:53 Error 201
|
|
| Error number 232 occurred attempting to close connection to web server.
|
|
| 2001-07-18 10:59:53 Error 201
|
|
| Windows NT error number 232 occurred.
|
| 2001-07-18 10:59:53 Error 201
|
|
| Windows NT error number 232 occurred.
|
| 2001-07-18 10:59:53 Error 201
|
| Error number 232 occurred while attempting to write the reply to the web
| server.
| -----
|
| and I just have pages of this in my webserver.log file:
|
| -----
| Request canceled or ignored by server Server busy or unable to fulfill
| request. The server is unable to fulfill your request due to extremely
high
| traffic or an unexpected internal error. Please attempt your request again
| (if you are repeatedly unsuccessful you should notify the site
| administrator). (Location Code: 26)
| -----
|
| Does anyone have ANY ideas?
|
| Todd
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
