Yup. The search index was corrupted and was being rebuilt over and over until the server said, "Fuck it!" and just crashed instead. I had a hard time getting into it to repair and when I tried it hung on me. I had to have the host kill the process. Once that was done I emptied the table so that the db was working, rolled back the files to last night's backup, and we were up. Search will be wonky until we finish rebuilding the cache, but it's nearly done.[DOUBLEPOST=1364485591][/DOUBLEPOST]Good morning!
As close as we've ever been! Worst case scenario is we would have lost everything from last night until this morning. We have daily backups of the DB and site so we will never lose more than 24 hours at the most.
I seriously thought that's what happened, but then I started getting the SQL errors while still being able to hit the server. So it wasn't a connectivity issue. When I went to the database directly, the table was hung and not moving. Which is a problem. Or was. Hopefully was.
