Query: select id from project limit 100 seems to hang
Following simple queries execute quickly on prod
but seem to hang on staging.
Might be an issue with the client, I don't see a query executing
on the RDS side.
Output on kill:
The problem was that the python client was retrying on responses that contained "try again" in the error message. Should be fixed by which removes the "try again".
400 is not listed as one of the retry codes but it is still retrying for some reason. I printed out the response code on each response and saw multiple 400's so there might be a bug in the retry logic that's not limiting it to the listed ones
Is not the retry logic limited to HTTP 500s?
The python client has retry logic if it ever encounters an error. I think its hanging because It hasn't reached the maximum number of retries yet. If this is an error that should fail immediately, I can add an special case for the client to not retry on error.
R client handles error fine.