Can we check where our d1 database is created? - Cloudflare Developers

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

SteffTek

S

SteffTekOP•7/5/24, 5:19 AM

ive used terraform to instantiate it and we cannot give a location hint there

SteffTek

S

SteffTekOP•7/5/24, 5:23 AM

and the "message wait time" settings say 0-60, but you cannot actually set it to 0

engi.dev

Eengi.dev Hello everyone I am using free account. I have deployed my next.js project on cl...

harshil1712

H

harshil1712•7/5/24, 9:19 AM

Hey, answered on your thread

SteffTek

SSteffTek Can we check where our d1 database is created?

harshil1712

H

harshil1712•7/5/24, 9:22 AM

You can use the wrangler d1 infowrangler d1 info command. https://developers.cloudflare.com/workers/wrangler/commands/#info

Cloudflare Docs

Commands - Wrangler · Cloudflare Workers docs

Create, develop, and deploy your Cloudflare Workers with Wrangler commands.

harshil1712

Hharshil1712 You can use the `wrangler d1 info` command. https://developers.cloudflare.com/wo...

SteffTek

S

SteffTekOP•7/5/24, 9:26 AM

thanks, looks like my databases are running in WNAM... great for european users /s

cosbgn

C

cosbgn•7/5/24, 11:31 AM

hey I'm getting a lot of too many SQL variables at offsettoo many SQL variables at offset seems d1 supports only 10 parameters, so even simple inserts like this will fail:

const sqlite = new Database("db.sqlite");

const db = drizzle<typeof schema>(sqlite, { schema });

const books = new Array(35).fill({}).map((b, i) => ({
  id: i.toString(),
  title: "The Great Gatsby",
  description: "A book about a rich guy",
}));

await db.insert(schema.books).values(books);

const sqlite = new Database("db.sqlite");

const db = drizzle<typeof schema>(sqlite, { schema });

const books = new Array(35).fill({}).map((b, i) => ({
  id: i.toString(),
  title: "The Great Gatsby",
  description: "A book about a rich guy",
}));

await db.insert(schema.books).values(books);

Is there any workaround?

cosbgn

C

cosbgn•7/5/24, 11:32 AM

seems crazy I can't just insert 30 rows

cosbgn

C

cosbgn•7/5/24, 11:32 AM

do I need to do one by one?

oof2win2

O

oof2win2•7/5/24, 1:26 PM

so if you have over 10 columns you cant insert a row?

Vikash

V

Vikash•7/6/24, 4:07 AM

What is offsetoffset in errors ?

I have just 100 lines in my insert file and it errors with message syntax error at offset 245syntax error at offset 245 On what line I should look for the error to correct it.

Unsmart

U

Unsmart•7/6/24, 4:14 AM

character 245

Unsmart

UUnsmart character 245

Vikash

V

Vikash•7/6/24, 4:17 AM

Got it, thanks.

Vikash

V

Vikash•7/6/24, 10:10 AM

New error:

{"D1_RESET_DO":true}

{"D1_RESET_DO":true}

Any idea what is this?

Old Man Maker

O

Old Man Maker•7/6/24, 2:16 PM

it is seriously rediculous that we can name a table with a - dash in it within the CF dashboard, but doing a PRAGMA table_info fails. I think I mentioned this several months ago.

Chinoman10

C

Chinoman10•7/6/24, 11:54 PM

Error: D1_TYPE_ERROR: Type 'object' not supported for value '123string,134,123string,0,0.17,comercial@Error: D1_TYPE_ERROR: Type 'object' not supported for value '123string,134,123string,0,0.17,comercial@ (...)

Any ideas? I already tried searching around and reading all the docs back and forth.

Chinoman10

C

Chinoman10•7/7/24, 12:07 AM

... found it :facepalm:

Chinoman10

C

Chinoman10•7/7/24, 12:08 AM

turns out building wrappers for nice abstraction is only good if you test it our extensively...

Chinoman10

C

Chinoman10•7/7/24, 12:08 AM

I was missing the spread operator on the params that I was passing.

Chinoman10

C

Chinoman10•7/7/24, 12:41 AM

dog1283

D

dog1283•7/7/24, 6:58 PM

Hi All, I am facing an issue using D1 locally. The issue is my worker cannot see any of the DB objects I have created.

First, I setup my DB with some DDL:

wrangler d1 execute appdb-dev --local --file=./1.sqlwrangler d1 execute appdb-dev --local --file=./1.sql

Then I can query the DB:

wrangler d1 execute appdb-dev --local --command="SELECT * FROM User" wrangler d1 execute appdb-dev --local --command="SELECT * FROM User" // works

However, when I try to access my local d1 instance in the worker, it can't find any tables. It is obviously looking at some other local instance, but I can't find any way to list the local instances, or don't know the commands to understand whether I am looking at the right one.

Any ideas? Wrangler.toml below:

name = "app-services"
compatibility_date = "2023-12-01"
route = "api.myapp.app/*"
compatibility_flags = ["nodejs_compat"]

[vars]
LOG_LEVEL="debug"
TEST_MODE="TRUE"
kv_namespaces = [
    { binding = "MYAPP_TOKENS", preview_id = "###", id = "###" },
]

[[d1_databases]]
binding = "DB"
database_name = "appdb-dev"
database_id = "###"
preview_database_id = "appdb-dev"

[env.dev]
route = "dev-api.myapp.app/*"

name = "app-services"
compatibility_date = "2023-12-01"
route = "api.myapp.app/*"
compatibility_flags = ["nodejs_compat"]

[vars]
LOG_LEVEL="debug"
TEST_MODE="TRUE"
kv_namespaces = [
    { binding = "MYAPP_TOKENS", preview_id = "###", id = "###" },
]

[[d1_databases]]
binding = "DB"
database_name = "appdb-dev"
database_id = "###"
preview_database_id = "appdb-dev"

[env.dev]
route = "dev-api.myapp.app/*"

Vikash

VVikash New error: `{"D1_RESET_DO":true}` Any idea what is this?

slagathor

S

slagathor•7/8/24, 3:41 AM

I'm running into this as well. Have you been able to resolve it?

slagathor

Sslagathor I'm running into this as well. Have you been able to resolve it?

Vikash

V

Vikash•7/8/24, 3:57 AM

No, the import on D1 is super buggy. I was unable to import a small DB of 1gb as well.

Vikash

VVikash No, the import on D1 is super buggy. I was unable to import a small DB of 1gb as...

slagathor

S

slagathor•7/8/24, 5:08 AM

Hmm...interesting. This is the first time I've ran into this issue

slagathor

S

slagathor•7/8/24, 5:08 AM

wonder if an update was pushed

Old Man Maker

OOld Man Maker it is seriously rediculous that we can name a table with a - dash in it within t...

Max (@rozenmd)

M

Max (@rozenmd)•7/8/24, 11:15 AM

?

SteffTek

SSteffTek thanks, looks like my databases are running in WNAM... great for european users ...

Max (@rozenmd)

M

Max (@rozenmd)•7/8/24, 11:34 AM

Looks like I overlooked adding the location hint into our OpenAPI spec, which means it isn't available for terraform. Will fix.

Max (@rozenmd)

MMax (@rozenmd)Looks like I overlooked adding the location hint into our OpenAPI spec, which me...

SteffTek

S

SteffTekOP•7/8/24, 11:35 AM

that would be great <3

Original message was deleted

luna

L

luna•7/8/24, 11:39 AM

i just hit something similar. i cant delete my tables at all in the dashboard

i get the following error when attempting to delete the table. FOREIGN KEY constraint failed (Code: 7500)FOREIGN KEY constraint failed (Code: 7500)

luna

Lluna i just hit something similar. i cant delete my tables at all in the dashboard 😅...

Max (@rozenmd)

M

Max (@rozenmd)•7/8/24, 11:46 AM

Are you able to provide a sample schema that reproduces the issue? last time we tried, we couldn't repro it d1-database

Max (@rozenmd)

MMax (@rozenmd)Are you able to provide a sample schema that reproduces the issue? last time we ...

luna

L

luna•7/8/24, 11:50 AM

yes and i worked out the issue. i’ll upload a code example in a bit.

Max (@rozenmd)

MMax (@rozenmd)Are you able to provide a sample schema that reproduces the issue? last time we ...

luna

L

luna•7/8/24, 1:33 PM

CREATE TABLE
    user (
        id TEXT NOT NULL PRIMARY KEY,
        username TEXT NOT NULL,
        email TEXT NOT NULL,
        password_hash TEXT NOT NULL,
        created_at INTEGER NOT NULL,
        updated_at INTEGER NOT NULL
    );

CREATE TABLE
    session (
        id TEXT NOT NULL PRIMARY KEY,
        expires_at INTEGER NOT NULL,
        user_id TEXT NOT NULL,
        FOREIGN KEY (user_id) REFERENCES user (id)
    );

CREATE TABLE
    user (
        id TEXT NOT NULL PRIMARY KEY,
        username TEXT NOT NULL,
        email TEXT NOT NULL,
        password_hash TEXT NOT NULL,
        created_at INTEGER NOT NULL,
        updated_at INTEGER NOT NULL
    );

CREATE TABLE
    session (
        id TEXT NOT NULL PRIMARY KEY,
        expires_at INTEGER NOT NULL,
        user_id TEXT NOT NULL,
        FOREIGN KEY (user_id) REFERENCES user (id)
    );

i used the above schema and created users + sessions in my app. i then tried deleting both tables which wouldnt work. i had to delete the sessions table first and then the users.
would be nice if the error at least said which table caused the issue.

luna

Lluna ```sql CREATE TABLE user ( id TEXT NOT NULL PRIMARY KEY, use...

SteffTek

S

SteffTekOP•7/8/24, 1:39 PM

sounds like regular sqlite

SteffTek

S

SteffTekOP•7/8/24, 1:40 PM

if you are using raw sql and not an ORM (like a mad man) you can start a transaction and set the foreign key pragma to OFF, then delete your stuff, and then turn the pragma back on

SteffTek

SSteffTek if you are using raw sql and not an ORM (like a mad man) you can start a transac...

luna

L

luna•7/8/24, 1:49 PM

you cant do that with the dashboard and again "would be nice if the error at least said which table caused the issue."

SteffTek

S

SteffTekOP•7/8/24, 1:49 PM

Technically you can

luna

L

luna•7/8/24, 1:49 PM

okay but im saying this is an issue. that response doesnt really help me.

SteffTek

S

SteffTekOP•7/8/24, 1:50 PM

Yeah like I said it's an sqlite problem not cloudflare

luna

L

luna•7/8/24, 1:50 PM

okay..

SteffTek

SSteffTek Yeah like I said it's an sqlite problem not cloudflare

luna

L

luna•7/8/24, 1:51 PM

a bit of advice. this isnt helpful at all.

SteffTek

S

SteffTekOP•7/8/24, 1:55 PM

Yeah I'm not support staff so tbh I don't really care if you find my advice helpful. I just tried to tell you cloudflare cannot really do much here

luna

L

luna•7/8/24, 1:55 PM

incorrect. they can fix the error

next time just dont comment if you have nothing to add.

SteffTek

S

SteffTekOP•7/8/24, 2:01 PM

:lul:

Finn 🔜 39C3

FFinn 🔜 39C3 no i have to give stefftek a point here, you are referencing a user in a session...

luna

L

luna•7/8/24, 2:09 PM

no it is not. this is a bug in the ui. the ui should be surfacing the full error which includes the table name.

im not posting here asking for help. i was asked by someone that works at cloudflare to reply. i really wish people would stop trying to but into things.

Finn 🔜 39C3

FFinn 🔜 39C3 (as far as i understand the problem at hand)

luna

L

luna•7/8/24, 2:10 PM

no one asked you to. d1-database

SteffTek

S

SteffTekOP•7/8/24, 2:11 PM

It isn't even an error , it's by design you can't delete a referenced table entry

SteffTek

S

SteffTekOP•7/8/24, 2:11 PM

Lol

luna

L

luna•7/8/24, 2:13 PM

... i didnt ask for help.

name = "app-services"
compatibility_date = "2023-12-01"
route = "api.myapp.app/*"
compatibility_flags = ["nodejs_compat"]

[vars]
LOG_LEVEL="debug"
TEST_MODE="TRUE"
kv_namespaces = [
    { binding = "MYAPP_TOKENS", preview_id = "###", id = "###" },
]

[[d1_databases]]
binding = "DB"
database_name = "appdb-dev"
database_id = "###"
preview_database_id = "appdb-dev"

[env.dev]
route = "dev-api.myapp.app/*"

name = "app-services"
compatibility_date = "2023-12-01"
route = "api.myapp.app/*"
compatibility_flags = ["nodejs_compat"]

[vars]
LOG_LEVEL="debug"
TEST_MODE="TRUE"
kv_namespaces = [
    { binding = "MYAPP_TOKENS", preview_id = "###", id = "###" },
]

[[d1_databases]]
binding = "DB"
database_name = "appdb-dev"
database_id = "###"
preview_database_id = "appdb-dev"

[env.dev]
route = "dev-api.myapp.app/*"

const sqlite = new Database("db.sqlite");

const db = drizzle<typeof schema>(sqlite, { schema });

const books = new Array(35).fill({}).map((b, i) => ({
  id: i.toString(),
  title: "The Great Gatsby",
  description: "A book about a rich guy",
}));

await db.insert(schema.books).values(books);

const sqlite = new Database("db.sqlite");

const db = drizzle<typeof schema>(sqlite, { schema });

const books = new Array(35).fill({}).map((b, i) => ({
  id: i.toString(),
  title: "The Great Gatsby",
  description: "A book about a rich guy",
}));

await db.insert(schema.books).values(books);

CREATE TABLE
    user (
        id TEXT NOT NULL PRIMARY KEY,
        username TEXT NOT NULL,
        email TEXT NOT NULL,
        password_hash TEXT NOT NULL,
        created_at INTEGER NOT NULL,
        updated_at INTEGER NOT NULL
    );

CREATE TABLE
    session (
        id TEXT NOT NULL PRIMARY KEY,
        expires_at INTEGER NOT NULL,
        user_id TEXT NOT NULL,
        FOREIGN KEY (user_id) REFERENCES user (id)
    );

CREATE TABLE
    user (
        id TEXT NOT NULL PRIMARY KEY,
        username TEXT NOT NULL,
        email TEXT NOT NULL,
        password_hash TEXT NOT NULL,
        created_at INTEGER NOT NULL,
        updated_at INTEGER NOT NULL
    );

CREATE TABLE
    session (
        id TEXT NOT NULL PRIMARY KEY,
        expires_at INTEGER NOT NULL,
        user_id TEXT NOT NULL,
        FOREIGN KEY (user_id) REFERENCES user (id)
    );