its relatively evident what caused it in regards to the site going down. what the inquiry was, is what caused this, and how to prevent it from happening in the future?
That should have caused because of some error in the cache creation. If your problem comes again, you need to look the files for any change from the original build package.
the answer to that lies in the deleted file which was a cached instance of something in the sys_options table that was not liked well by the server. what that means, is that something was modified on the site, which instantiated a query on the database. based on the query on the database from the modification, your cache file was deemed inadequate.
most probably is that the file had some issues, so in the event you reversed your changes on the database, the file was not writable, in the cache directory.
you can disable database cache and file block cache from your admin panel and this may prevent situations such as this.
When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support