[Explorer] Execution failed for question ae6e531c-f57d-4cf1-9b33-ec9c47740f97: rising small repos

[slick-daddy]

Hi, It's failed to execute the question ae6e531c-f57d-4cf1-9b33-ec9c47740f97 rising small repos (errorType = error-query-execute):

• executedAt: 2025-07-07T05:17:15.000+00:00
• requestedAt: 2025-07-07T05:17:15.000+00:00

Error message

other error for mpp stream: Code: 0, e.displayText() = DB::Exception: Receiver state: ERROR, error message: Code: 0, e.displayText() = DB::TiFlashException: Memory limit (total) exceeded caused by 'RSS(Resident Set Size) much larger than limit' : process memory size would be 50.82 GiB for (attempt to allocate chunk of 1073741824 bytes), limit of memory for data computing : 44.80 GiB. Memory Usage of Storage: non-query: peak=0.00 B, amount=0.00 B; kvstore: peak=0.00 B, amount=0.00 B; query-storage-task: peak=0.00 B, amount=0.00 B; fetch-pages: peak=0.00 B, amount=0.00 B; shared-column-data: peak=0.00 B, amount=0.00 B., e.what() = DB::TiFlashException,, e.what() = DB::Exception,

Generated SQL

SELECT
  gr.repo_name,
  gr.stars,
  gr.forks,
  COUNT(ge.repo_id) AS activity_count
FROM
  github_repos gr
  LEFT JOIN github_events ge ON gr.repo_id = ge.repo_id
WHERE
  gr.stars < 50
  AND ge.created_at > DATE_SUB(NOW(), INTERVAL 3 MONTH)
GROUP BY
  gr.repo_name
ORDER BY
  activity_count DESC
LIMIT
  20