Question
CF4.5 on Linux crashing
In the last week or so the service has started crashing
regularly. I'm new to CF so have looked into this like I would any
other web app. There haven't been any changes made to code on the
server since some time before this started happening. And the logs
don't seem to be very helpful.
Is it possible to increase the detail the CF logs include? There's an error right before the most recent time it died as follows:
"Error","TID=2257927","06/24/06","04:59:26","68.142.251.54","Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)","ODBC Error Code = 37000 (Syntax error or access violation)<P><P> [MERANT][ODBC MySql driver][MySql]You have an error in your SQL syntax near ':' at line 3<P><P><p>The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (30:1) to (30:58).</p><P><P>Date/Time: Sat Jun 24 04:59:26 2006<BR>Browser: Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)<BR>Remote Address: 68.142.251.54<BR>Query String: articleid=319:<P>"
This seems to suggest that someone's code maybe using badly formed queries but since nothing seems to have changed its a little strange that it would start happening out of the blue. Is there anything in the error above to suggest which site is causing the error, there are a couple of hundred sites on the server so without knowing which site has caused the error there's not a lot I can do.
Any help gratefully received!!!
john
Is it possible to increase the detail the CF logs include? There's an error right before the most recent time it died as follows:
"Error","TID=2257927","06/24/06","04:59:26","68.142.251.54","Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)","ODBC Error Code = 37000 (Syntax error or access violation)<P><P> [MERANT][ODBC MySql driver][MySql]You have an error in your SQL syntax near ':' at line 3<P><P><p>The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (30:1) to (30:58).</p><P><P>Date/Time: Sat Jun 24 04:59:26 2006<BR>Browser: Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)<BR>Remote Address: 68.142.251.54<BR>Query String: articleid=319:<P>"
This seems to suggest that someone's code maybe using badly formed queries but since nothing seems to have changed its a little strange that it would start happening out of the blue. Is there anything in the error above to suggest which site is causing the error, there are a couple of hundred sites on the server so without knowing which site has caused the error there's not a lot I can do.
Any help gratefully received!!!
john
AdChoices