Yes, I wrapped a cftry/cfcatch specifficly around the query and set the page
timeout to 15 seconds .. no good.
Todd
----- Original Message -----
From: "Johnson, Russell" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, July 26, 2001 4:04 PM
Subject: RE: Serious issues with connectstring causing CF server threads t o
hang
> Are you using any type of error handling on the query attempts? This along
> with the Timeout attribute can kill the thread if the request runs too
long.
>
> Russ Johnson
> Web Environment Services
> Blue Cross Blue Shield of Florida
> Work: 904-905-7130
> Mobile: 904-534-8162
> [EMAIL PROTECTED]
>
> "Great thinkers have always encountered violent opposition from mediocre
> minds." -- Albert Einstein
>
>
> -----Original Message-----
> From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 25, 2001 10:59 PM
> 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
