Skip to content

Latest commit

 

History

History
19 lines (15 loc) · 871 Bytes

how-to-fix-query-execution-was-interrupted-with-aws-rds.md

File metadata and controls

19 lines (15 loc) · 871 Bytes
slug title type category_slug excerpt updated_at created_at
posts/how-to-fix-query-execution-was-interrupted-with-aws-rds
How To Fix Query Execution Was Interrupted With AWS RDS
post
devops
"Query execution was interrupted" can sometimes be solved by increasing the storage size of your database.
2022-10-09
2022-10-09

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

Query 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.