I hate to think that there is possibly a flaw in ColdFusion…it pains me to say it. But I think there might just be a problem.
One of our latest projects was an object oriented application (lots of objects stored in memory) that sees a pretty decent load. For example, one day when we noticed a problem we had in the neighborhood of 20k connections.
After getting everything as smoothed out as possible, we are still seeing some pretty strange exceptions coming through. And for the most part they seem to deal with invalid SQL syntax of some sort of another.
Our system has quite a bit of dynamic querying going on, but I would say probably significantly less actual queries to the DB server on an average request.
It seems, that around a heavy traffic period we begin to see these SQL errors coming through. So, we feel that it could very possibly be related to memory issues…but, being pretty shorthanded we have not been able to really dig as deep into the issue as we would like.
Some of the more common exceptions:
Message: Error Executing Database Query
Detail: … Syntax error at token 0, line 0, offset 0.
OR
Message: Error Executing Database Query
Detail: … Invalid parameter binding(s).
And a handful of actual corrupted SQL statements that make its way through.
Something like when querying a Users table… it might say
Message: Error Executing Database Query
Detail: … Table ‘Use’ not found.
…basically truncating (maybe?) the SQL statement itself.
Initially the code was suspect, but we cannot find the source of the problem and so we hit Google for some commiseration.
Notice the last few comments on this blog post
And this forum thread on Adobe.com
Is anybody else experiencing this on their applications? The rumor is this issue is not present in Scorpio, but it would be nice if we could get a fix for MX7 if it truly is a CF bug.
***EDIT*** Link to the HotFix :http://kb.adobe.com/selfservice/viewContent.do?externalId=kb402002&sliceId=1
