On October 13, 2022, at approximately 10:58 UTC, we received multiple synthetic alerts that indicated an issue preventing customers from accessing the Anaplan Platform. Initial investigations identified an issue with a job that was running on one of the database nodes as part of a data migration. This issue caused the node to lock. The purpose of the migration was to backfill a new database for future functionality. The migration had been planned in a phased approach, and five steps had been successfully carried out previously.
We attempted to stop both the job and the node to restore service, but the issue persisted. The issue then started to cause the remaining nodes to also lock due to thread exhaustion. We, therefore, made the decision to rebuild the database cluster to restore service.
The rebuild of the first node completed at 12:27 UTC. Customers would have been able to access the platform, but service performance was still degraded, and Cloudworks and Plan IQ services were not available. We initiated the rebuild of the second node immediately. However, the rebuild failed halfway through due to a network blip caused by transferring a file. The build had to be initiated again. The rebuild of the second node completed successfully at 14:21 UTC. We were then able to balance the workload between both nodes, and service was fully restored at 14:42 UTC.
To avoid a reoccurrence of this issue, we have reviewed the migration process. We have enhanced the performance testing metrics. The migrations will be completed in smaller deliverables. Queries have been optimized to ensure jobs run more efficiently. We will also add stop gaps throughout the migrations to ensure each deliverable completes before another deliverable starts. Furthermore, we are reviewing alternative opportunities to restore service more quickly outside of rebuilding the database cluster.
We deeply apologize for the impact this had on your business operations. We understand the disruption these issues can cause to your business and users, and we are continuously strengthening our systems and procedures to avoid similar issues from happening again in the future. If you have any further questions or concerns, please contact Anaplan Support. Thank you for your patience during this situation and thank you for being an Anaplan customer.