db.prepare("PRAGMA table_info(?)").bind(table)
db.prepare("PRAGMA table_info(?)").bind(table)
A
D
ERROR] {"D1_RESET_DO":true} or ✘ [ERROR] Durable Object's isolate exceeded its memory limit and was reset. when trying to import a sql dump. has anyone managed to get this work without this obscure error?
J
JDDJD
KLBut on production the 5 records are displaying instead of the 21 records.What exactly do you mean by this? You said that the D1 Dashboard correctly shows the 21 records, so what is "production" in this sentence that still shows 5 records?
DLhow are we supposed to do long running maintenance operations in d1?What do you want to do exactly? What's "maintenance operations" here? A D1 database processes 1 request at a time and since SQLite queries are usually a few milliseconds you can execute many per second, But, if you are doing something that takes more than a few seconds/minutes, then it won't behave nicely for several reasons.
LDDL
RDDJDJJDJJL
bind(), not how many rows you can operate on.
D
D
R
D1_ERROR: Network connection lost errors? 
D
AL
ZLZ
LZLZZLZBy the end of 2024, D1 will support automatic read replication for scalability and low-latency access around the world. If this managed model appeals to you, use D1.
J
P
UNION ALL SELECT terms. According to SQLite documentation, the number of terms in the query is limited by the value SQLITE_MAX_COMPOUND_SELECT which defaults to 500. But in D1 this is set to 5 and any query with more than 5 terms (like for inserting multiple values at once) fail with too many terms in compound SELECT. P
AD1_ERROR: Network connection lost. errors being thrown since friday. Any idea if this is on d1 or my side?AERROR] {"D1_RESET_DO":true}✘ [ERROR] Durable Object's isolate exceeded its memory limit and was reset.npx wrangler d1 execute mydb --file scripts/sql/db.sql --remote
⛅️ wrangler 3.95.0
-------------------
:heavy_check_mark: :warning: This process may take some time, during which your D1 database will be unavailable to serve queries.
Ok to proceed? … yes
:cyclone: Executing on remote database mydb ([redacted]):
:cyclone: To execute on your local development database, remove the --remote flag from your wrangler command.
Note: if the execution fails to complete, your DB will return to its original state and you can safely retry.
:cyclone: File already uploaded. Processing.
:cyclone: Starting import...
:cyclone: Processed 36213 queries.
:cyclone: Processed 52452 queries.
:cyclone: Processed 69008 queries.
:cyclone: Processed 85617 queries.
:cyclone: Processed 101990 queries.
:cyclone: Processed 118607 queries.
:cyclone: Processed 135103 queries.
:cyclone: Processed 151403 queries.
:cyclone: Processed 168062 queries.
:cyclone: Processed 184991 queries.
:cyclone: Processed 201756 queries.
:cyclone: Processed 218587 queries.
:cyclone: Processed 235727 queries.
:cyclone: Processed 252693 queries.
:cyclone: Processed 269614 queries.
:cyclone: Processed 288195 queries.
:cyclone: Processed 305191 queries.
✘ [ERROR] Durable Object's isolate exceeded its memory limit and was reset.DELETE FROM table_name
WHERE id IN (
SELECT id
FROM table_name
WHERE condition
LIMIT 10
);bind()D1_ERROR: Network connection lostUNION ALL SELECTSQLITE_MAX_COMPOUND_SELECTtoo many terms in compound SELECTD1_ERROR: Network connection lost.