Query: select id from project limit 100 seems to hang

Description

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:

Environment

180.0-12x/180.0-4x

Activity

Show:
Xavier Schildwachter
May 4, 2017, 4:42 PM

R client handles error fine.

Ziming Dong
May 4, 2017, 8:36 PM

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.

Xavier Schildwachter
May 4, 2017, 8:40 PM

Is not the retry logic limited to HTTP 500s?

Ziming Dong
May 4, 2017, 8:53 PM
Edited

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

Ziming Dong
May 9, 2017, 12:52 AM

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

Won't Fix

Assignee

Ziming Dong

Reporter

Xavier Schildwachter

Labels

None

Validator

Xavier Schildwachter

Development Area

None

Release Version History

None

Components

Fix versions

Affects versions

Priority

Blocker
Configure