05a35955ad
Some checks are pending
Backend tests / test (push) Waiting to run
A single request with 194 studio_slugs + 23 tag filters (each tag = a correlated EXISTS) plus an ILIKE search built a query heavy enough that the OOM killer killed the Postgres backend, triggering a full crash-recovery (~1s prod-wide outage, all in-flight connections dropped). Any user could do this with a big enough filter. Cap studios to 50, tags to 15, performers to 15 (far above any real UI usage) and return 422 instead of executing — bounding query complexity regardless of the planner's choice. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com> |
||
|---|---|---|
| .. | ||
| __init__.py | ||
| admin.py | ||
| admin_html.py | ||
| blacklist.py | ||
| bug_reports.py | ||
| device.py | ||
| expo_updates.py | ||
| favorites.py | ||
| me.py | ||
| movies.py | ||
| playback.py | ||
| playback_events.py | ||
| saved_searches.py | ||
| scene_favorites.py | ||
| scenes.py | ||
| schemas.py | ||
| seo.py | ||
| sources.py | ||
| stream_proxy.py | ||
| taxonomies.py | ||
| watch.py | ||