aws, aurora,

How to resolve AWS Aurora ERROR 3024 (HY000)

Nov 02, 2021 · 1 min read · Post a comment
How to resolve AWS Aurora ERROR 3024 (HY000)

If you hold some heavy-load AWS Aurora database tables and you are trying to export some of the 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 gonna explain how can you quickly get rid of it.

Prerequisites

  • AWS account

Solution

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 Parameter groups pic1

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 max_execution_time pic1

Step 6. You can see that the default is 300000ms. So to increase it click on Edit Parameters

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 tables data without getting ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded

Conclusion

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.