As Scott has been blogging here, we recently released a new Alagad.com website built ontop of Farcry. The thing is, since we released the site we have been having intermitant problems with errors cropping up in the admin interface which simply say "corrupt table". We quickly discovered a few points about this:
- There are no corrupt tables. Or, more to the point, our data in our database was not corrupt.
- If you restart ColdFusion the errors went away.
I initially assumed this was a but with Farcry and put it on my list of things to fix. Today I spent some time actually looking into the problem and, after trying to rewrite a part of the Farcry core, I realised that Farcry has nothing to do with this. It turns out to be a bug in ColdFusion 8.
I found a discussion related to this on the Adobe forums.
It seems that the cachedWithin attribute on cfquery has a bug which will eventually produce this problem in some sites.
The problem was supposed to be addressed in the first cumlative update, but for some reason was not. It is now slated to be released in the second cumlative update. Watch this page for more information.