Done
Pinned fields
Click on the next to a field label to start pinning.
Details
Details
Assignee
David Irving
David IrvingReporter
David Irving
David IrvingLabels
Reviewers
Tim Jenness
Story Points
4
RubinTeam
Ops Middleware
Components
Checklist
Checklist
Created August 21, 2024 at 11:18 PM
Updated August 31, 2024 at 12:09 AM
Resolved August 31, 2024 at 12:09 AM
https://lsstc.slack.com/archives/C2JPT1KB7/p1724191775201719
Tim ran this query on IDF prod:
It failed with this error:
This indicates that the client’s httpx timed out after 10 seconds. The server logs show that the server detected the client disconnect and stopped the query.
httpx’s default timeout is very aggressive and needs to be tuned. We may also need to tweak the server to always send some data promptly, or add keep-alives. In some cases the database may need to crunch on a query for a long time before it can start returning rows (e.g. doing an
ORDER BY
on a column without an index may need a full table scan before rows start being returned.)If we don’t end up completely changing the way queries work at some point, WebSockets may be more appropriate than HTTP chunked transfer for this application.