DD
HH
L
Map so the .get() doesn't exist on objects. You can just do response.results.
AAA
ML
A
bind function in the wrong way?AAAPRAGMA table_info(?); but it threw another error:"PRAGMA table_info(\""+table+"\")". It worked good.
D
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
JDDJDKLBut 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()
D
D
RD1_ERROR: Network connection lost
D
AL
DELETE FROM table_name
WHERE id IN (
SELECT id
FROM table_name
WHERE condition
LIMIT 10
);Map.get()response.resultsWrong number of parameter bindings for SQL query.bindPRAGMA table_info(?);near "?": syntax error at offset 18: SQLITE_ERROR"PRAGMA table_info(\""+table+"\")"db.prepare("PRAGMA table_info(?)").bind(table)ERROR] {"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.var table='PLiFNg5fXiX33oJoBNfuq2yO7exoc_9qJW';
var queries=[env.db.prepare("PRAGMA table_info(\"?\")").bind(table)]
const batchResult = await env.db.batch(queries)