[source.coop] Query execution exceeded 5-minute duration limit

Open
#291 12 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
35/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Active
Tech stack
typescript
Domain
api, backend, database

Research direction

No specific file, test, query, or entry point is identified. Start by using the linked logs to identify the operation that exceeds five minutes, then trace its query or external call and determine whether the timeout can be reproduced. Done means the cause is addressed and the operation returns a meaningful timeout response instead of failing with HTTP status 0.

Written by the indexing model from the issue text.

Description

sourcebot

Error Summary

A query duration limit of 5 minutes was exceeded, causing the operation to fail. This suggests a long-running query is not completing within the allowed execution window.

Details

  • Occurrences (last window): 1
  • Release version: 1895870
  • HTTP Status: 0 (no HTTP response — likely a client-side timeout or network-level abort)
  • Fingerprint: 038d2f9d023cd80e
  • Sample Stack Trace: Not available (unknown)

Probable Cause

A database or API query is taking longer than the enforced 5-minute timeout threshold. This could be caused by:

  • An unoptimized or expensive query running against a large dataset
  • Missing indexes on frequently queried columns
  • A resource-intensive operation (e.g., full table scan, complex join, or aggregation) that lacks proper pagination or filtering
  • An external service call that is hanging or slow to respond

The HTTP status of 0 suggests the connection may have been terminated before a response was received, which is consistent with a timeout being enforced at the network or client level rather than returning a proper error response.

Recommended Actions:

  1. Identify the specific query or operation triggering this timeout.
  2. Review query execution plans and add indexes where appropriate.
  3. Consider adding query pagination, result limits, or breaking the operation into smaller chunks.
  4. Evaluate whether the 5-minute limit is appropriate or needs adjustment for certain query types.
  5. Add better error handling to return a meaningful HTTP status (e.g., 504 Gateway Timeout) instead of dropping the connection.

Dashboard links:

Dominant language
TypeScript
Stars
26
Forks
9
Avg merge
1d 7h
Merged PRs (30d)
42

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from source-cooperative/source.coop

All issues in source-cooperative/source.coop

Similar issues

More TypeScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.