I am load testing my app. I discovered that the AWS RDS server sometimes gets overloaded and i get a 500, internal server error back from the server during high throughput. This only happens when the load is fairly high. The error I get is "table doesn't exist", error 1146. I'd tried to use a try-catch around my function (in the model). I plan to offer a popup saying the "the system is congested, would you like to try again?". It will take a user a few seconds to make this choice, allowing time for the system to clear.
All of the errors are due to various temp files not existing. Is there perhaps a limit on how many temp files can existing at a single time or is that an RDS server question?
I could probably get this to work much better with a larger RDS server (and optimized code) but that is way too expensive for me.
The try-catch is around the entire body of the function (probably 70 lines of code). Even with the Try/Catch I am still getting the 500 error. The try/catch doesn't seem to be working?
proof that an old dog can learn new tricks