If you hold some heavy-load AWS Aurora database tables, and you are trying to export some tables or import data, there is a big chance to face the following error
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded. Here I’m going to explain how can you quickly get rid of it.
- AWS account
Step 1. This issue is happening cause the
max_execution_time parameter is set to 300000ms by default. So to fix the issue you need to increase it.
Step 2. Login to your AWS account and navigate to the RDS service.
Step 3. On the left side there is a listing panel. Click on
Step 4. Now you will get a list of the parameter groups. So you need to choose the right one.
Step 5. Once the step 4 is done, you will get a list of all
parameters, but you need to filter and search for the
Step 6. You can see that the default is 300000ms. So to increase it click on
Step 7. Increase the number depending on your needs and save the changes.
Step 8. That’s it. Now you can try to re-export or re-upload your table’s data without getting
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded.
Increasing the max_execution_time through the AWS Management Console is a much easier and effective method. So, once you are done with the SQL operations you can get back the default value to avoid further security issues. Feel free to leave a comment below and if you find this tutorial useful, follow our official channel on Telegram.