tracker issue : CF-3587061

Problem Description:

I cannot clear the query cache. Using <cfobjectcache action="clear"> does not work and neither does clearing the query cache from the CF administrator.

Steps to Reproduce:

I run a query on my MySQL database and use the attribute cachedwithin="#createtimespan(5,0,0,0)#" to cache the query. Sometimes I need to clear the query cache and so I run <cfobjectcache action="clear">. 

Actual Result:

After running  <cfobjectcache action="clear"> the cache has not cleared and the out-of-date cached data is still used. Even when I try to clear the query cache from within the CF administrator it does not work.

Expected Result:

After running  <cfobjectcache action="clear"> the cache should be cleared and the data retrieved anew from the database.

Any Workarounds:

Running this code on CF9 works perfectly but this is not an option for my live environment.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3587061

External Customer Info:
External Company:  
External Customer Name: Michael51986
External Customer Email:  
External Test Config: My Hardware and Environment details:



Windows Server 2008 r2 SP1 64 bit

MySQL 5.6.12

Attachments:

Comments: