tracker issue : CF-4131909

select a category, or use search below
(searches all categories and all time range)
Title:

Clear Query Cache breaks

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Chris Bristow / Chris Bristow (Chris Bristow)

Created: 03/24/2016

Components: Caching

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 0

Listed in the version 2016.0.02.299200 Issues Fixed doc
Verification notes: verified_possibly_fixed on February 03, 2020 using build 2016.0.02.299200 
Problem Description:  Whenever we try clear the query cache we get the following error:

Error Occurred While Processing Request
Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed

Steps to Reproduce:  Simple as going to CFADMIN > Caching > Clear Query Cache Now

Actual Result: Error:

Error Occurred While Processing Request
Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed

Expected Result: Query cache cleared

Any Workarounds: None found so far

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

Watson Bug ID:	4131909

External Customer Info:
External Company:  
External Customer Name: Chris Bristow
External Customer Email:  
External Test Config: My Hardware and Environment details:  We've found this issue on two types of machine:



1) Amazon EC2 Hosted instance of Ubuntu 

Version	11,0,07,296330

Tomcat Version	7.0.64.0

Edition	Enterprise  

Operating System	UNIX  

OS Version	3.13.0-53-generic  

Update Level	opt/coldfusion11/cfusion/lib/updates/chf11000007.jar  

Adobe Driver Version	5.1.3 (Build 000094)



2) Amazon EC2 Instance of Windows Server 2012

Version	11,0,07,296330

Tomcat Version	7.0.64.0

Edition	Enterprise  

Operating System	Windows Server 2012  

OS Version	6.2  

Update Level	D:/ColdFusion11/cfusion/lib/updates/chf11000007.jar  

Adobe Driver Version	5.1.3 (Build 000094)

Attachments:

  1. March 24, 2016 00:00:00: 1_adobebug1.png

Comments:

Hey Chris, Can you add the complete stacktrace for the exception that you are getting? It would be helpful for us to repro your case at our end. Thanks, Suchika.
Comment by Suchika S.
3227 | March 29, 2016 12:36:24 AM GMT
Hi Suchika, All the stacktrace says is: Stack Trace java.lang.ClassCastException
Comment by External U.
3228 | March 29, 2016 04:10:37 AM GMT
Hi Chris, Is the setting " Enable Robust Exception Information" in CF admin enabled? Also you can check your exception logs and send the log files to us. Thanks, Suchika
Comment by Suchika S.
3229 | March 29, 2016 04:18:35 AM GMT
Hi Suchika, I deleted the logs and restarted ColdFusion because it was enabled but I wasn't getting the robust exception information. At first the clear query cache worked and then after a minute or so I started getting the error with more information: Error Occurred While Processing Request Error casting an object of type coldfusion.sql.QueryDetails cannot be cast to java.lang.String to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed. coldfusion.sql.QueryDetails cannot be cast to java.lang.String The error occurred in caching.cfm: line 199 -1 : Unable to display error's location in a CFML template.
Comment by External U.
3230 | March 29, 2016 07:05:16 AM GMT
Stack Trace: at cfcaching2ecfm501570882._factor14(/CFIDE/administrator/settings/caching.cfm:199) at cfcaching2ecfm501570882.runPage(/CFIDE/administrator/settings/caching.cfm:1) java.lang.ClassCastException: coldfusion.sql.QueryDetails cannot be cast to java.lang.String at coldfusion.tagext.io.cache.ehcache.GenericEhcache.remove(GenericEhcache.java:249) at coldfusion.tagext.io.cache.CacheTagHelper.remove(CacheTagHelper.java:675) at coldfusion.tagext.io.cache.CacheTagHelper.purgeAllQueryCache(CacheTagHelper.java:615) at coldfusion.sql.Executive.purgeQueryCache(Executive.java:1861) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at coldfusion.runtime.StructBean.invoke(StructBean.java:508) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2553) at cfcaching2ecfm501570882._factor14(/CFIDE/administrator/settings/caching.cfm:199) at cfcaching2ecfm501570882.runPage(/CFIDE/administrator/settings/caching.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:142) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:219) ...
Comment by External U.
3231 | March 29, 2016 07:06:03 AM GMT
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.filter.ClickjackingProtectionFilter.doFilter(ClickjackingProtectionFilter.java:75) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:437) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Comment by External U.
3232 | March 29, 2016 07:06:15 AM GMT
Thanks Chris we will look into this.
Comment by Suchika S.
3233 | March 29, 2016 07:08:42 AM GMT
test note
Comment by CFwatson U.
3234 | June 07, 2016 04:17:55 AM GMT
The fix for this bug is available as part of the early-access build for ColdFusion 2016 Update 2.
Comment by CFwatson U.
3235 | June 07, 2016 04:24:35 AM GMT