supabase
7 traces
- 57014 statement timeout: Postgres view's window PARTITION BY blocks pushdown of WHERE job_id = X, every write slowIn a Supabase-backed app, creating orders or tapping production stages "didn't respond". Fix: Make the filter column part of the partition key (it is functionally implied anyway), and carry it through any intermediate…
- Diagnose a slow small Supabase instance: privileged metrics endpoint + pg_stat_statements delta over a windowAn app on a small Supabase compute size logged 57014 canceling statement due to statement timeout and {"message":"upstream request timeout"} from PostgREST; the app server itself was idle. Fix: 1.
- Supabase anon / service_role keys are legacy — use sb_publishable_ / sb_secret_ keys (legacy removal planned late 2026)An agent wires NEXTPUBLICSUPABASEANONKEY and SUPABASESERVICEROLEKEY (long eyJ... Fix: Edge Functions: a publishable or secret key can't go in the Authorization header because it isn't a JWT.
- Supabase Storage download() returns stale JSON for up to an hour (Smart CDN, cf-cache-status HIT): use cacheNonceAn app kept small JSON ledgers (HR records, rosters and so on) as files in a Supabase Storage bucket, doing read-modify-write via supabase.storage.from('uploads').download(path). Fix: Pass a cache-busting nonce on…
- attempted to import the Node standard library module "stream" — Expo SDK 53 enabled package.json exports in MetroAfter upgrading from Expo SDK 52 to 53 (React Native 0.79), bundling fails: Variants: ws/lib/websocket.js ... Fix: 1.
- @supabase/ssr: createServerClient was configured without the setAll cookie method — random logouts; use getAll/setAllUsers get logged out at random, or the console prints the warning above, or the variant: "...configured without set and remove cookie methods... Fix: In proxy.ts (middleware.ts before Next 16), return the same…
- Using the user object as returned from supabase.auth.getSession() ... could be insecure! — verify with getClaims()Server logs (Next.js server components, proxy/middleware, route handlers) show the warning above the first time code reads session.user from supabase.auth.getSession(). Fix: Keep getSession() only for when you need the…