II
M
M
X
newUser.id and account.id from the first two queries to use in the third one. Since the queries are in an array, I can't assign these values to a constant. Is there a way to achieve this within a single batch, or do I need to split it into two?
A
wrangler 3.111.0
MD1 DB storage operation exceeded timeout which caused object to be reset and D1 DB is overloaded. Too many requests queued.MM
J
SJ
O
1
āā
T
NN
AAA
meta.duration in the response object might be useful to look at, as it shows the time that ONLY the query took. If it is signifigant, consider re-evaluating the query you are running, and/or make sure you are using indexesN
L
storage operation exceeded timeout which caused object to be reset is an error specific to slow user queries. What query were you trying to run? How often do you run this, and how often do you get this error?
LMDB is overloaded errors on 2025-02-28 around 14:26-14:33GMT, and storage operation exceeded timeout errors around 2025-03-01 14:33 GMT. I don't know exactly which queries were associated with the errors, but the Query Latency metrics show the P95 latency can't have been higher than 8-10ms. My most frequently run queries have a P95 latency of 0-3ms.
ćLćL
storage operation exceeded timeout errors at that exact timestamp (2025-03-01 14:33 GMT) on your database, nothing else before or after, so it might have been something transient or maybe a query slowdown momentarily if the machine had any issue.insert if not exists) or selects, then retrying them is always suggested.M
AMA
J
W
TD1_ERROR: internal error; reference = 3v37q0sukf03r4emb40aq73q , account_id: 75d8d68ecf8f9e8155f1ccc7dad82e00JJ
BB
H
A1
B
.wrangler directory with each state independant from each other. Thanks
JA1
cf: colo headernewUser.idaccount.idD1 DB storage operation exceeded timeout which caused object to be resetD1 DB is overloaded. Too many requests queued.meta.durationstorage operation exceeded timeout which caused object to be resetDB is overloadedstorage operation exceeded timeoutstorage operation exceeded timeout2025-03-01 14:33 GMTinsert if not existsD1_ERROR: internal error; reference = 3v37q0sukf03r4emb40aq73q75d8d68ecf8f9e8155f1ccc7dad82e00/root
/app1
wrangler.jsonc -> "d1_databases": [{ "binding": "DB", "database_name": "a-shared-name", "database_id": "1234..." }]
/app2
wrangler.jsonc -> "d1_databases": [{ "binding": "DB", "database_name": "a-shared-name", "database_id": "1234..." }].wranglercf: colo