OK, we have (finally) solved our error and I thought I would share the lesson we learned with the group. The underlying problem was being masked by CF restarting by itself. We had "Restart when requests terminate abnormally" turned on, but when we turned it off the true error started showing up:
208.8.78.17, Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705), CWebException: Error: Cannot add value to query Explanation: The operation you have requested is invalid. Only query columns can be added to query objects. It is likely that you have omitted the indexing brackets of a query column you are trying to set.For example, can produce this error message. The correct syntax is unknown error while executing a tag.Date/Time: 03/05/03 16:32:23Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)Remote Address: 208.8.78.17 This error was found to be caused by a scoped, non-query var trying to set AFTER its scoped counterpart was already set. In other words, we had a query named "User" and within that query there was a field named "UserGUID". A piece of code elsewhere in the system was being set simply called "User.UserGUID" without a structure or query being created first. This simple bug was causing hundreds/thousands of people on the server to be booted off because "Restart when requests terminate abnormally" was set to on. Once we turned that setting to off, the error starting showing up in the logs and everyone else (besides the offending user) was able to work normally. THE LESSON: Always turn off "Restart when requests terminate abnormally" to help diagnose a severe server problem. Hope this helps someone someday! Jason Nokes, Director of Internet Development DistributorCentral, LLC 888-516-7401 http://www.distributorcentral.com [EMAIL PROTECTED] ----- Original Message ----- From: "Jason Nokes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 4:25 PM Subject: [KCFusion] CF mysteriously stopping/starting > We are having some serious problems with a CF 5 SP3 server that keeps > stopping and starting its CF service. The stops/starts will happen in > clusters, usually 4-5 times within 1-2 minutes at different times during the > day. In one 20 minute block, it did this 17 times. > > The server itself is extremely beefy (Win2K Server, 4GB RAM, dual 1.6Ghz > processors, lots of drive space), so it is not being caused by too much > load. We have been through the IIS and CF logs, but there is no pattern > whatsoever. Also, we cannot duplicate the errors internally and all of other > servers (dev, testing, hot spare) work fine. > > THE QUESTION: Has anyone experienced CF doing this? If so, what was the > cause and how did you fix it? > > ADDITIONAL CLUES: > -We recently switched from a session var environment passing CFID/CFTOKEN in > the URL to a cookie-based, client var environment. (But the CF services > problem did not start until 3 1/2 days later.) We are using no application, > server, or session vars. > -Also, we switched our CFTOKEN from using the usual number to using a UUID. > (http://www.macromedia.com/v1/Handlers/index.cfm?ID=22427&Method=Full) > > Any new ideas would be great! > > Jason Nokes, Director of Internet Development > DistributorCentral, LLC > 888-516-7401 > http://www.distributorcentral.com > [EMAIL PROTECTED] > > > > ______________________________________________________________________ > The KCFusion.org list and website is hosted by Humankind Systems, Inc. > List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED] > Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] > To Subscribe.................... mailto:[EMAIL PROTECTED] > To Unsubscribe................ mailto:[EMAIL PROTECTED] > > ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
