In final phase with the migration of www.civbox.com to a structured framework application running off ColdBox and Transfer ORM I encountered one recurring problem. No matter what paged was referenced or loaded the following error would be generated after a very long loading time.
A timeout occurred while attempting to lock DC5CF9189FA37B5CEE3AB11FD50F9E23. The error occurred in C:\x\x\coldbox\system\coldbox.cfc: line 66 Called from C:\x\x\Application.cfc: line 69 Called from C:\x\x\coldbox\system\coldbox.cfc: line 66 Called from C:\x\x\Application.cfc: line 69
After a bit of QA with the developers of ColdBox as well as with my shared hosting provider we all came to an agreement that Transfer ORM combined with ColdBox required too many Java Classes (CFCs) to be loaded at start-up. This would normally not be a problem but a bug with Sun’s Java 1.6, which is used by ColdFusion 8 by default, causes the applications’ start-up to grind to a halt. When a site has only limited resources to feed off, such as those in a shared hosting environment, this bug is then compounded more so.
Unfortunately there was no immediate solution available for this problem other than this blog entry at Compound Theory. My hosting provider was unable to downgrade the Java version to 1.5, and tie that to ColdFusion 8. So the only option for me, other than to replace all the code and database queries being referenced by Transfer was to downgrade the hosting server to ColdFusion MX 7. This required a bit of tweaking with some of the pages and functions using CF8 syntax shortcuts, but other than that the downgrade went without a hitch.
The site now runs at a brisk pace and is trouble free.