Folks - I need some help here please. Everything local on my machine has stopped working. I just cre

Folks - I need some help here please. Everything local on my machine has stopped working.
I just created a new worker project (v3.10.1) - a toml binding of a test database with a test_table and a single int PK column
Inserting into it with execute or prepare batching is failing with the same errors I am getting with every other cloudflare project.
These appear to work when deployed, just not on my local machine.

The error code is explicit here - does anyone know what it means at all?
This is the db binding dump object:

Object {                                                                                                                                                                                                                     
  message: D1_ERROR: Failed to parse body as JSON, got: error code: 1042,                                                                                                                                                    
  cause: Failed to parse body as JSON, got: error code: 1042                                                                                                                                                                 
}

Object {                                                                                                                                                                                                                     
  message: D1_ERROR: Failed to parse body as JSON, got: error code: 1042,                                                                                                                                                    
  cause: Failed to parse body as JSON, got: error code: 1042                                                                                                                                                                 
}

Object {                                                                                                                                                                                                                     
  message: D1_ERROR: Failed to parse body as JSON, got: error code: 1042,                                                                                                                                                    
  cause: Failed to parse body as JSON, got: error code: 1042                                                                                                                                                                 
}

Object {                                                                                                                                                                                                                     
  message: D1_ERROR: Failed to parse body as JSON, got: error code: 1042,                                                                                                                                                    
  cause: Failed to parse body as JSON, got: error code: 1042                                                                                                                                                                 
}

I have restarted my machine, I have uninstalled and removed all versions of wrangler from my appdata roaming profile as well as from the local project. Installed everything back - this is the same error guys.

Is there anywhere else I could try and remove or clean up - any cache or any other wrangler commands to test and verify stuff?

Old Man MakerOP•10/5/23, 8:39 AM

BTW - It is a simple command like this that is failing:

return await db.exec("INSERT INTO test_table (val1) VALUES (1)");

return await db.exec("INSERT INTO test_table (val1) VALUES (1)");

kian•10/5/23, 8:51 AM

That’s just how JS works

kian•10/5/23, 8:51 AM

You’re destructuring so it must be an actual property name

kian•10/5/23, 8:51 AM

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Destructuring_assignment

Destructuring assignment - JavaScript | MDN

The destructuring assignment syntax is a JavaScript expression that makes it possible to unpack values from arrays, or properties from objects, into distinct variables.

OOld Man Maker Folks - I need some help here please. Everything local on my machine has stopped...

Max (@rozenmd)•10/5/23, 9:55 AM

I'm unable to reproduce this with a simple worker:

export interface Env {
  DB: D1Database;
}

export default {
  async fetch(
    request: Request,
    env: Env,
    ctx: ExecutionContext
  ): Promise<Response> {
    const res = await env.DB.exec("INSERT INTO test_table (val1) VALUES (1)");
    console.log("res: ", res);
    return new Response("Hello World!");
  },
};

export interface Env {
  DB: D1Database;
}

export default {
  async fetch(
    request: Request,
    env: Env,
    ctx: ExecutionContext
  ): Promise<Response> {
    const res = await env.DB.exec("INSERT INTO test_table (val1) VALUES (1)");
    console.log("res: ", res);
    return new Response("Hello World!");
  },
};

where I've run CREATE TABLE IF NOT EXISTS "test_table" ("val1" INTEGER);CREATE TABLE IF NOT EXISTS "test_table" ("val1" INTEGER); beforehand. Could you provide a repo with a minimal reproduction?

MMax (@rozenmd)I'm unable to reproduce this with a simple worker: ``` export interface Env { ...

Old Man MakerOP•10/5/23, 9:57 AM

Certainly - thanks for taking a look. @Jerome has a pretty big break down from me as well over the last 24 hours.
I'll get a simple repo together and DM the details if that works

Max (@rozenmd)•10/5/23, 9:59 AM

oops nvm, discord ui being weird

Matthijs•10/5/23, 12:19 PM

hey, quick question, is the outage mentioned here: https://www.cloudflarestatus.com/
also affacting D1? Because when running locally with worker attached to remote all queries to D1 return Failed to parse body as JSON, got: error code: 1042Failed to parse body as JSON, got: error code: 1042

Cloudflare Status

Welcome to Cloudflare's home for real-time and historical data on system performance.

MMatthijs hey, quick question, is the outage mentioned here: https://www.cloudflarestatus....

Matt Silverlock•10/5/23, 12:22 PM

Yes, if you are using —remote—remote mode in wrangler

Matthijs•10/5/23, 12:22 PM

Yup, that's what i'm doing

Matthijs•10/5/23, 12:22 PM

okay, thanks for confirming

MMatthijs hey, quick question, is the outage mentioned here: https://www.cloudflarestatus....

Matt Silverlock•10/5/23, 12:22 PM

(Scroll up about 15 minutes too)

Matthijs•10/5/23, 12:23 PM

i guess discord ui is acting up, last message was from just over 2 hours ago

Matthijs•10/5/23, 12:23 PM

thanks anyway

mian.m.arslan•10/5/23, 1:19 PM

Hi everyone
I have created a worker with the help of wrangler cli and bind with D1
Using Hono
And i am trying to send request with payload (i send data in request -> body) from client side
Can anyone tell me how can i get that payload in my route?

mian.m.arslan•10/5/23, 1:20 PM

Any solution?

MMatt Silverlock No, _that_ is something we don’t yet support. Working on it. If you can bind any...

GuillaumeLakano•10/5/23, 1:50 PM

Hi!
You said you're working on a kind of dynamic bindings with a system of group/tag databases for security.
Could you please confirm this will be available for the GA version of D1 ( Q1 2024 ) ?

Max (@rozenmd)•10/5/23, 3:29 PM

In case anyone else runs into it: https://www.cloudflarestatus.com/incidents/qjkzwwjjqxzn

Issues with Wrangler remote-mode dev

captain•10/5/23, 4:08 PM

a very basic question...I understand the previous method now considered legacy of how to create a backup and then download a backup. What is the replaced method that is supposed to be performed now? I am looking to add a new column (stored) for user settings. And my plan was to download the current users table, deleted it, then add the new column and insert all the data. (this is a practice area so only 10 users)

captain•10/5/23, 4:15 PM

I see a section on how to import data in the documenation, I see the legacy tab on how to download data (which will not work with beta only alpha) and i see the time travel backups area documentation tab that says how to see different bookmarks and restore bookmarked time travel...but not seeing how to download the data or table set up...ideas?

captain•10/5/23, 4:19 PM

https://developers.cloudflare.com/workers/wrangler/commands/#backup-download

Commands - Wrangler · Cloudflare Workers docs

Wrangler offers a number of commands to manage your Cloudflare Workers.

captain•10/5/23, 4:20 PM

this also seems to be out of date

captain•10/5/23, 4:22 PM

@Matt you around?

Dahoom•10/5/23, 4:22 PM

dont @ the devs, they have a lot going on as is

Ccaptain https://developers.cloudflare.com/workers/wrangler/commands/#backup-download

Dahoom•10/5/23, 4:23 PM

theres no current official solution i dont think but for now you can use this https://github.com/nora-soderlund/cloudflare-d1-backups

GitHub

GitHub - nora-soderlund/cloudflare-d1-backups: A package to dump a ...

A package to dump a copy of your experimental D1 database through a worker. - GitHub - nora-soderlund/cloudflare-d1-backups: A package to dump a copy of your experimental D1 database through a worker.

Dahoom•10/5/23, 4:25 PM

I've been using it for a while and honestly i prefer this method since I can basically mould it into exactly what I would want from a backup system

Dahoom•10/5/23, 4:25 PM

this is an ad sponsored by @nora

DDahoom theres no current official solution i dont think but for now you can use this ht...

captain•10/5/23, 4:28 PM

thanks, and yikes...at a minimum probably should be added all the documentation links I referenced that there is no replacement solution to download a back up for beta from either command line or dashboard...i can't be the first person that circled around and around this for an hour

Dahoom•10/5/23, 4:29 PM

yeah trust me they are making a lot of changes to the docs recently and sometimes the miss some legacy aspects

Original message was deleted

Dahoom•10/5/23, 4:29 PM

exactly what i was about to say

DDahoom exactly what i was about to say

captain•10/5/23, 4:40 PM

https://github.com/cloudflare/cloudflare-docs/pull/11108

GitHub

Update commands.md to reflect the ability to "Download existing dat...

…to your local machine" not functioning with a beta database
Currently there is not an option to "Download existing data to your local machine" for a beta database. The documentation...

Ccaptain https://github.com/cloudflare/cloudflare-docs/pull/11108

Dahoom•10/5/23, 4:43 PM

I dont work at cloudflare, there's dev's working at Cloudflare specifically on the docs that will approve your pull request :)

dave•10/5/23, 5:18 PM

Error: D1_ERROR: D1 storage operation exceeded timeout which caused object to be reset.

dave•10/5/23, 5:18 PM

oh no

dave•10/5/23, 6:24 PM

I forget, do D1 requests count towards the overall Worker subrequest limit?

Original message was deleted

dave•10/5/23, 6:25 PM

Did you find an answer for this?

Ddave I forget, do D1 requests count towards the overall Worker subrequest limit?

Matt Silverlock•10/5/23, 6:27 PM

Yes

MMatt Silverlock Yes

dave•10/5/23, 6:30 PM

thanks! And .batch().batch() only counts as one subrequest I assume, regardless of the number of statements? https://developers.cloudflare.com/d1/platform/client-api/#dbbatch

Unsmart•10/5/23, 6:59 PM

The "new" backend which has been the default and only really supported option for quite some time now limits depths of queries to 20. You basically need to create queries that do not go over that limit.

There was a github issue about it you can see here if you want to add your example and request for this limit to be upped in the future: https://github.com/cloudflare/workers-sdk/issues/4094

Unsmart•10/5/23, 7:15 PM

I have no clue I do not use SQL databases and have no knowledge of query depths or anything

SSPS | Shootmail `Expression tree is too large (maximum depth 20)` I deleted my old dB that was c...

Jason Hostetter•10/6/23, 1:46 AM

I hit this same error a while back, and after a lot of digging I could not for the life of me figure out how expression depth was calculated, whether my query had a depth of 21 or 121, or any useful information about how to decrease depth. I ended up splitting the query into two separate queries instead of using a common table expression (an ordinary CTE, not a recursive one even), and the error went away. Cloudflare devs at the time sounded open to increasing the max depth (default sqlite is set at like 1000 or something), but again I couldn't say what number I would need! So all that to say...

Jason Hostetter•10/6/23, 1:51 AM

Just saw the comment from @Unsmart | Tech debt and the github issue after writing all that lol. Really wish the sqlite error also reported the query expression depth.

Hữu Phong•10/6/23, 4:13 AM

Is there anyway to use D1 with TablePlus?

Cretezy•10/6/23, 4:53 AM

It should be noted in the documentation for the client API (https://developers.cloudflare.com/d1/platform/client-api) how successsuccess is handled.
It's returned from

run

run

/batchbatch, but firstfirst/allall don't have it

D1 client API · Cloudflare D1 docs

As part of our Client API, both static and prepared statements are supported. Best practice is to use prepared statements which are precompiled …

Cretezy•10/6/23, 4:54 AM

Also seems like success: truesuccess: true is forced in the typings, so presumably it's not even useful?

Cretezy•10/6/23, 6:03 AM

Also, are batchbatch ran sequencially? Would it work if I read a row in the 1st batched statement, but delete the same row in the 2nd statement?

Folks - I need some help here please. Everything local on my machine has stopped working. I just cre

Similar Threads

Similar Threads

Similar Threads