Are you using connection pooling? “Maintain Connections” setting. What’s your connection timeout and reap interval?
~Brad
Are you using connection pooling? “Maintain Connections” setting. What’s your connection timeout and reap interval?
~Brad
It was all set to defaults, I changed the timeouts here to 2 mins, being development I don’t care about it that much. After sticking it on a production server, it seems to run fine on there. I can still get the page requests to blow out to 8 secs by just hitting refresh all the time.
I am sure when I go live, and there is a major issue they will let me know.
But I am sure when I did this Load Tests with another site a few months ago, I never had this issue, although I was using MS SQL then and not mySQL, doubt that would make any difference.
Ok,
Not sure if this is related or not, but I am seeing these errors in the CF logs
“Error”,“cfthread-20”,“03/30/12”,“14:33:58”,"CACHEBOXPROVIDER.REAP_25F72CEC526C4630A12ACA128B532C8D: A timeout occurred while attempting to lock CacheBoxProvider.reap.1333648976. "
“Error”,“cfthread-22”,“03/30/12”,“14:33:58”,"CACHEBOXPROVIDER.REAP_158124CCE89348128C11C0DF63CF45C6: A timeout occurred while attempting to lock CacheBoxProvider.reap.1333648976. "
“Error”,“cfthread-21”,“03/30/12”,“14:33:58”,"CACHEBOXPROVIDER.REAP_4057D788DB0D490A9145C20A21194E50: A timeout occurred while attempting to lock CacheBoxProvider.reap.1333648976. "
“Error”,“cfthread-23”,“03/30/12”,“14:33:58”,"CACHEBOXPROVIDER.REAP_5522A289030F4DC4AC1671A95B9BD7AD: A timeout occurred while attempting to lock CacheBoxProvider.reap.1333648976. "
“Error”,“cfthread-26”,“03/30/12”,“14:33:58”,"CACHEBOXPROVIDER.REAP_8A3BD076716C4B548F2A2A3C4F6C6D20: A timeout occurred while attempting to lock CacheBoxProvider.reap.1333648976. "
“Error”,“cfthread-25”,“03/30/12”,“14:33:58”,"CACHEBOXPROVIDER.REAP_29D1F3DEFD5D4265B728E427C0FA8D78: A timeout occurred while attempting to lock CacheBoxProvider.reap.1333648976. "
“Error”,“cfthread-19”,“03/30/12”,“14:33:58”,"CACHEBOXPROVIDER.REAP_11806DAED00A45F2AB7B37112805C867: A timeout occurred while attempting to lock CacheBoxProvider.reap.1333648976. "
“Error”,“cfthread-24”,“03/30/12”,“14:33:58”,"CACHEBOXPROVIDER.REAP_0C09AB966A2D487DBB298EBB885B2C73: A timeout occurred while attempting to lock CacheBoxProvider.reap.1333648976. "
“Error”,“cfthread-14”,“03/30/12”,“14:34:02”,"CACHEBOXPROVIDER.REAP_29CF83D8BFEB469DBB228EB62002FA92: A timeout occurred while attempting to lock CacheBoxProvider.reap.1333648976. "
And the stack trace for it
“Error”,“cfthread-1”,“03/30/12”,“07:25:43”,"CACHEBOXPROVIDER.REAP_D0B9FD2ACA76499A9A7583F33CB0FD70: A timeout occurred while attempting to lock CacheBoxProvider.reap.243623768. "
coldfusion.tagext.lang.LockTag$TimeoutException: A timeout occurred while attempting to lock CacheBoxProvider.reap.243623768.
at coldfusion.tagext.lang.LockTag.doStartTag(LockTag.java:220)
at cfCacheBoxProvider2ecfc1453773481$func_REAP.runFunction(E:\projects\ColdFusion\ContentBox\coldbox\system\cache\providers\CacheBoxProvider.cfc:583)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2383)
at cfCacheBoxProvider2ecfc1453773481$func_CFFUNCCFTHREAD_CFCACHEBOXPROVIDER2ECFC14537734812.runFunction(E:\projects\ColdFusion\ContentBox\coldbox\system\cache\providers\CacheBoxProvider.cfc:559)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.UDFMethod.invokeCFThread(UDFMethod.java:201)
at coldfusion.thread.Task.invokeFunction(Task.java:287)
at coldfusion.thread.Task.run(Task.java:140)
at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:211)
at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:71)
What is your reap frequency?
All settings are default to what ContentBox has set up.