We create application.variables from queries in application.cfm using
CFLOCK. Here's a snippet:
<cfapplication name="FreeCatalog"
clientmanagement="No"
sessionmanagement="Yes"
setclientcookies="No"
applicationtimeout = "#CreateTimeSpan(1,0,0,0)#">
. . .
<cfif not isdefined("Application.CountryMstr")>
<cflock name="#Application.applicationname#" type="EXCLUSIVE"
timeout="30">
<CFQUERY NAME="Application.CountryMstr"
DATASOURCE="#Application.IUDATA#">
SELECT COUNTRY_CODE, COUNTRY_NAME
FROM COUNTRY_MSTR
ORDER BY COUNTRY_NAME
</CFQUERY>
</cflock>
</cfif>
This usually works fine. Yesterday, *something* happened in our development
environment and CFLOCK in application.cfm now "Timed out while waiting to
obtain exclusive access". So apparently the application.variable is locked
and staying locked. The lock is not timing out.
We're on 4.5.1. Could leaving off the scope <cfapplication
name="FreeCatalog" be the problem?
Is there a way to view locked resources?
Thanks,
Greg Gibbons
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
