D1 in workers constant query errors & timeouts
starting around 8 hours ago today, I started receiving a bunch of these two errors and queries started timing out or taking far longer than usual. Does anyone know a way to fix?
7 Replies
Going to the database console and entering select 1; hangs and part of the page (table size, tables) doesn’t load. The total size of all tables is 3.72 Mb
what's your account id + db id?
and how much traffic is being sent to the db?
account id -
bd22ac056a23329365c8a57927490701
db id - 2bd61136-7eb6-4b5d-82ce-f3405294398d
traffic wise from Nov 1 -4
read: 107m
written: 1.8ki don't really see volume changing but i see latency and errors just jumping right up
yeah :/
let me get this escalated to the team, i can't see anything that would indicate you did anything to cause this
ty 🙏
I disabled the db call that was making a majority of those read requests and I haven't had any more issues.
The call was:
where the
events
table consisted of 0-2 items normally, right now it has 2 items:
(copied from the dashboard, sorry about formatting)
I ended up replacing d1 with kv since it suited our needs better (high read volume, low writes), haven't had any issues yet 🙂