How To Fix Query Execution Was Interrupted With AWS Rds

under Devops

During recent application deployment which involved a schema update to the database, we ran into the following error:

1Query execution was interrupted (SQL: alter table `upload_records` add `row_index` int null)

What turned out to be the problem was that our AWS RDS instance was actually out of storage space. There was enough storage to continue daily operations, but not enough to add a new column to this table which has 20MM rows in it.

So the fix was easy: increase the available storage space for the RDS instance.


Thanks for reading this article!

Hopefully you found this article useful! If you did, share it on Twitter!

Found an issue with the article? Submit your edits against the repository.