Coldfusion MX 7 Hangs

[Nebu24]

Hi there,

Last Thursday the coldfusion server stopped responding on our websites. The
funny thing was that not only the .cfm documents were unreachable, also images
could not be loaded (e.g. [url]www.[site].com/[/url][image name].gif). I looked into the
logfiles of windows 2003 and of coldfusion but I could not find an error. I
restarted the coldfusion server (btw it did not respond well to the stop and
start function in the services menu) and everything was up and running again. I
hoped this was a 1 time incident. Well it was not, sunday all our websites were
unreachable again. Nothing interesting in the logfiles again. I tried to find a
solution for our problem but i did not find any article on this issue. I did
find an article here on Macromedia describing server Hangs but this didn't seem
to apply to my problem.

Here are some details on our webserver at the time of the hanging:
- Coldfusion MX 7
- Dual processor Intel Xeon 3,00 GHZ
- 1 GB Ram
- ODBC with microsoft Access 2003
- Hanging occured 2 times and does not seem to be a heavy load issue
- Webserver does not use any cfx tags or com objects
- Maximum number of simultaneous requests = 8
- timeout requests [not set]

Sunday I updated coldfusion with the coldfusion update program, i updated our
OS with all the latest patches and i set the timeoutrequest at 60 seconds.

Has anyone else had this problem with Coldfusion mx 7 and what could cause the
coldfusion server to crash.

Greeting and hope to hear from you,

Nebu

[tzimmerman]

Your problem probably has to do with the fact that you are using Microsoft
Access. Access is not intendended to be used with production sites. See
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18772[/url] is the
article you mentioned on hanging conditions. You should be able to locate a
thread lock if you take a series of stack traces when the application is
unresponsive.

HTH

Ted Zimmerman

[Nebu24]

Thanks for the answer, i was completely unaware of the problem with access. Not to happy about it but at least now i can fix it.

Thanks again and greetings,

Nebu

[sdupre]

We have no information from which to finger MS Access.

In general, Ted is right about large sites (MS Access isn't a good choice) but
if you don't make sure this is the problem, it might repeat itself going to
another database.

Please get some thread dumps [url]http://www.macromedia.com/go/tn_18339[/url] to confirm.
Do the thread dumps at 20-30 second intervals during the hang.

Stephen Dupre
Macromedia QA

[Nebu24]

Thanks for the reply, if I am correct i have to wait untill the problem occurs
again and then do a thread dump to see what is causing the problem. This does
leave me with another question, is it possible to automatically restart
coldfusion when a hang occures? If not i would strongly suggest such a function
;-) . If so how can i activate this function or program.

Greetings Nebu;)