i'm getting `Error: D1_ERROR: D1 is

i'm getting Error: D1_ERROR: D1 is overloaded. Too many requests queued. for the last while. its a tiny little d1 database with no traffic
3 Replies
stridex
stridex2mo ago
database id aa76b36d-692e-423b-9718-aabfafb4588a
Max (@rozenmd)
Max (@rozenmd)2mo ago
can see it erroring quite a bit - what kind of query is it running?
stridex
stridex2mo ago
It was running just a basic select across a few columns. Nothing had changed when it started happening. It’s an app for myself basically. SELECT DISTINCT releases.name, releases.group, releases.category, releases.size, releases.files, releases.resolution, releases.source, releases.updatedAt, releases.imdb_id FROM releases LEFT JOIN movies ON movies.imdb_id = releases.imdb_id WHERE ( movies.imdb_rating_votes > ? AND releases.resolution = ? AND releases.name not like ? ) ORDER BY releases.updated_at DESC LIMIT ? i think i found a place i was missing an index