For those of you folks surveying away last night between the hours of 7 p.m. and 2 a.m. PST, you would’ve noticed that you weren’t able to access our site. The technical explanation is that due to a minor bug in the way we insert records, we hit an obscure limit in SQL Server for very large tables–row sizes in the billions.
For the Database Administrator (DBA) crowd, search “SQL server error 666” and “index uniquifier”. Dropping and rebuilding the index solved the issue. The rebuilding process doesn’t lose any data, but it does take a lot of time when you have the huge amount of data we store.
So what does this mean? Simply put, the site was unavailable for survey creators and takers for several hours. Our team diagnosed the problem quickly and worked through the night to find the quickest resolution possible.
We’re happy to report that all SurveyMonkey services are now up and running, with all the surveys and data in your account fully intact. Survey respondents should now be able to access any live survey URLs.
Normally, when we need to perform any kind of site maintenance that’ll prevent you from being able to access any of your accounts, we alert you well in advance. This was anything but normal however!
We sincerely apologize for any inconvenience this may have caused you. A big thanks to everyone for your patience as we worked to resolve the situation. Again, we’re so sorry about this.
Don’t hesitate to reach out with any questions or concerns, we’re here to help!