It all seems fine, the error is pretty vague.

M

Mongy•2/28/24, 3:53 PM

yes i see the bearer when logging

Kkian It all seems fine, the error is pretty vague.

M

Mongy•2/28/24, 3:54 PM

Yeah that's why I've come here to see if anyone has experienced something similar. It is offly vague

Original message was deleted

M

Mongy•2/28/24, 4:11 PM

the uuid matches to what im putting in the url

Original message was deleted

M

Mongy•2/28/24, 4:19 PM

Still receiving the same message

M

Mongy•2/28/24, 4:22 PM

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

M

Mongy•2/28/24, 4:23 PM

just simplified the insert statement

M

Mongy•2/28/24, 4:24 PM

already did when i realized lol

M

Mongy•2/28/24, 4:25 PM

but the api token has both read and write permissions for d1 instance

M

Mongy•2/28/24, 4:25 PM

they are actual strings

M

Mongy•2/28/24, 4:25 PM

i just renamed them

M

Mongy•2/28/24, 4:26 PM

i ran the same sql directly through the d1 dashboard

M

Mongy•2/28/24, 4:26 PM

and populated just fine

M

Mongy•2/28/24, 4:26 PM

same one im using in this script, not the one i posted here

M

Mongy•2/28/24, 4:27 PM

its an id problem but its not specifying what id its trying to decode

K

kianOP•2/28/24, 4:30 PM

Your DB ID is wrong

K

kianOP•2/28/24, 4:30 PM

It isn't formatted properly

K

kianOP•2/28/24, 4:30 PM

Yeah

K

kianOP•2/28/24, 4:30 PM

It's 7-4-4-4-12 when it should be 8-4-4-4-12

K

kianOP•2/28/24, 4:31 PM

Probably the first letter got cut off when copying

M

Mongy•2/28/24, 4:36 PM

That did the job

M

Mongy•2/28/24, 4:37 PM

I appreciate it

K

kianOP•2/28/24, 4:38 PM

@Max (@rozenmd) I'm not sure if the error is thrown by the API gateway before it gets to D1's REST API, but it'd be cool if the "failed to decode id" error could be more detailed even if it just calls out which ID it's upset with - d1-database

M

Max (@rozenmd)•2/28/24, 4:39 PM

ah yeah nah that's the rust uuid parser

M

Max (@rozenmd)•2/28/24, 4:39 PM

we'll be fixing this

S

Sébastien Morel•2/28/24, 7:48 PM

hello here I know we are still in beta with D1 but I just want to see if that makes sense. Without D1 I have 40ms latency on my worker, as soon as I do a query (simple select on an ID that has an index) it goes to 400ms... like 10x... am I doing something wrong ?

A

Aaryan•2/28/24, 8:03 PM

Guys my d1

f19f4e90-2514-4f2f-9d09-13ece5212673

f19f4e90-2514-4f2f-9d09-13ece5212673

f19f4e90-2514-4f2f-9d09-13ece5212673

f19f4e90-2514-4f2f-9d09-13ece5212673 is down. I really need it back for my presentation at uni tomorrow. Is there a time frame? or should I make another?

Original message was deleted

S

Sébastien Morel•2/28/24, 8:04 PM

that's something I don't know how to check, where is the DB ?

S

Sébastien Morel•2/28/24, 8:05 PM

here is an example of meta @nora

"result": {
"success": true,
"meta": {
"served_by": "v3-prod",
"duration": 0.1743,
"changes": 0,
"last_row_id": 0,
"changed_db": false,
"size_after": 25100288,
"rows_read": 1804,
"rows_written": 0
},
"results": [
{
"COUNT(*)": 1804
}
]

"result": {
"success": true,
"meta": {
"served_by": "v3-prod",
"duration": 0.1743,
"changes": 0,
"last_row_id": 0,
"changed_db": false,
"size_after": 25100288,
"rows_read": 1804,
"rows_written": 0
},
"results": [
{
"COUNT(*)": 1804
}
]

"result": {
"success": true,
"meta": {
"served_by": "v3-prod",
"duration": 0.1743,
"changes": 0,
"last_row_id": 0,
"changed_db": false,
"size_after": 25100288,
"rows_read": 1804,
"rows_written": 0
},
"results": [
{
"COUNT(*)": 1804
}
]

"result": {
"success": true,
"meta": {
"served_by": "v3-prod",
"duration": 0.1743,
"changes": 0,
"last_row_id": 0,
"changed_db": false,
"size_after": 25100288,
"rows_read": 1804,
"rows_written": 0
},
"results": [
{
"COUNT(*)": 1804
}
]

S

Sébastien Morel•2/28/24, 8:05 PM

383ms to get it

S

Sébastien Morel•2/28/24, 8:09 PM

wrangler d1 info

S

Sébastien Morel•2/28/24, 8:09 PM

got it so same region with my worker checking the header CF-Placement

S

Sébastien Morel•2/28/24, 8:11 PM

also for SELECT query is it not supposed to be distributed?

AAaryan Guys my d1 `f19f4e90-2514-4f2f-9d09-13ece5212673` is down. I really need it back...

A

Aaryan•2/28/24, 8:22 PM

seems to be back

S

Sébastien Morel•2/28/24, 8:29 PM

I am debugging a bit more and it seems to be the

_QUEUE?.send(payload)

_QUEUE?.send(payload)

_QUEUE?.send(payload)

_QUEUE?.send(payload) done right after the query that changes the game based on user location. Do queues have locations too?

W

wesbos•2/28/24, 8:31 PM

Hello - trying upload a DB. I followed the docs of dumping it

sqlite3 mydb.sqlite .dump > db.sql

sqlite3 mydb.sqlite .dump > db.sql

sqlite3 mydb.sqlite .dump > db.sql

sqlite3 mydb.sqlite .dump > db.sql and then import with

wrangler d1 execute podcast-stats-prod --file=db.sql

wrangler d1 execute podcast-stats-prod --file=db.sql

wrangler d1 execute podcast-stats-prod --file=db.sql

wrangler d1 execute podcast-stats-prod --file=db.sql but I get

not authorized [code: 7500]

not authorized [code: 7500]

not authorized [code: 7500]

not authorized [code: 7500] error.

Seems to be related to this? https://github.com/cloudflare/workers-sdk/issues/3892 Any ideas how to work around it? Its a 10,000 line long file so Im notsure where to look

GitHub

🐛 BUG: d1 execution with comment including semicolon causes SQL cod...

Which Cloudflare product(s) does this pertain to? D1 What version(s) of the tool(s) are you using? 3.6.0 What version of Node are you using? 20.5.1 What operating system are you using? Mac Describe...

Wwesbos Hello - trying upload a DB. I followed the docs of dumping it `sqlite3 mydb.sqli...

M

Max (@rozenmd)•2/28/24, 8:33 PM

Hey Wes,

not authorized

not authorized

not authorized

not authorized gets thrown by the runtime when an sql command we haven't allow-listed gets used - look for things like

pragma

pragma

pragma

pragma statements

W

wesbos•2/28/24, 8:34 PM

Ah,

PRAGMA foreign_keys=OFF;

PRAGMA foreign_keys=OFF;

PRAGMA foreign_keys=OFF;

PRAGMA foreign_keys=OFF; is the first line

W

wesbos•2/28/24, 8:34 PM

ill remove it

W

wesbos•2/28/24, 8:35 PM

Hmm no dice - still errors

W

wesbos•2/28/24, 8:36 PM

could it be this at the start too?

BEGIN TRANSACTION;
CREATE TABLE _cf_KV (
      key TEXT PRIMARY KEY,
      value BLOB
    ) WITHOUT ROWID;

BEGIN TRANSACTION;
CREATE TABLE _cf_KV (
      key TEXT PRIMARY KEY,
      value BLOB
    ) WITHOUT ROWID;

BEGIN TRANSACTION;
CREATE TABLE _cf_KV (
      key TEXT PRIMARY KEY,
      value BLOB
    ) WITHOUT ROWID;

BEGIN TRANSACTION;
CREATE TABLE _cf_KV (
      key TEXT PRIMARY KEY,
      value BLOB
    ) WITHOUT ROWID;

Wwesbos could it be this at the start too? ```sql BEGIN TRANSACTION; CREATE TABLE _cf_K...

M

Max (@rozenmd)•2/28/24, 8:37 PM

Ah yep - remove the

BEGIN TRANSACTION;

BEGIN TRANSACTION;

BEGIN TRANSACTION;

BEGIN TRANSACTION; and the end of it, we're already running in a transaction for you (i'll also update the docs to mention that)

W

wesbos•2/28/24, 8:38 PM

Maybe im doing this wrong - I have a local wrangler D1 DB, I ran that dump command on the sqlite DB directly, but is there a wrangler command to push my local DB up to production? Or a command to export

M

Max (@rozenmd)•2/28/24, 8:39 PM

That is a good point though - wonder if we can't make wrangler take the local db and do that for you

W

wesbos•2/28/24, 8:45 PM

took the transaction stuff out and still hitting it. Will dig and se if there are any other lines

Original message was deleted

W

wesbos•2/28/24, 9:03 PM

No - should I have?

M

Max (@rozenmd)•2/28/24, 9:05 PM

and

COMMIT;

COMMIT;

COMMIT;

COMMIT;

M

Max (@rozenmd)•2/28/24, 9:06 PM

we'll add a note to replace these here in the meanwhile https://developers.cloudflare.com/d1/build-databases/import-data/#convert-sqlite-database-files

W

wesbos•2/28/24, 9:21 PM

it worked! Thank you

It all seems fine, the error is pretty vague.

Similar Threads