Since yesterday, I have been encountering the error "D1_ERROR: Network connection lost." in a Worker

Since yesterday, I have been encountering the error "D1_ERROR: Network connection lost." in a Worker that is performing a SELECT query on D1.
When I try to open the corresponding D1 dashboard in a web browser, it keeps loading indefinitely and does not display anything.
Is there any solution to this issue?

Sorry if it sounds weird, I'm using a translation tool.

LLarry In the meantime, you might want to take a look at Durable Objects (DOs) with the...

Dean•2/23/25, 11:45 AM

This is good advice, but it’s not exactly the same as D1, for example time travel backups doesn’t exist for durable objects (afaik) and no API support

Ttt Since yesterday, I have been encountering the error "D1_ERROR: Network connectio...

James•2/23/25, 2:46 PM

Is this still happening? If so, let us know your Database ID and we can escalate this to be looked at.

James•2/23/25, 3:24 PM

Your account ID would also be helpful @tt for the team, thanks

JJames Your account ID would also be helpful @tt for the team, thanks

ttOP•2/23/25, 3:29 PM

@James
Thanks for reading.
Sent by DM

James•2/23/25, 3:30 PM

Thanks, I've escalated to the team. Hopefully they'll be able to resolve it soon.

IIsaac McFadyen This won't work unless you do the `await`. You can't see the value of a Promise ...

Hamir Mahal•2/23/25, 9:30 PM

I'm looking into this now.

Hamir Mahal•2/23/25, 9:30 PM

async fetch(request, env, ctx)

async fetch(request, env, ctx)

Hamir Mahal•2/23/25, 9:30 PM

How do I get accurate typing for envenv and

ctx

ctx

Hamir Mahal•2/23/25, 9:44 PM

Thanks for the suggestion.

Hamir Mahal•2/23/25, 9:45 PM

From where should I import ExportedHandlerExportedHandler and EnvEnv?

Silvan•2/23/25, 11:34 PM

Special type of question. I use the new worker assets with a framework. i have access to my bindings on my pages but now i want to connect drizzle
usually you have a db.ts where you export your drizzle client. but here i dont have access to my platform env.

i see some people do const db = drizzle(env.DB);const db = drizzle(env.DB); everywhere they need the db. is that the way to go? or is it still possible to somehow export 1 drizzle client globally?

SSilvan Special type of question. I use the new worker assets with a framework. i have a...

Hello, I’m Allie!•2/23/25, 11:38 PM

Yeah, that’s the way. There is sort of a way to do globals, but it shouldn’t give you much of a benefit since Drizzle itself is stateless

HHello, I’m Allie!Yeah, that’s the way. There is *sort of* a way to do globals, but it shouldn’t g...

Silvan•2/23/25, 11:40 PM

okay good to know thanks!

Silvan•2/24/25, 12:18 AM

Actually managed to migrate an entire app fairly quick. everything working with some hacks.
Even tho i gotta rewrite my transactions :/

https://github.com/cloudflare/workers-sdk/issues/2733

im in love with the cloudflare services but d1 seems to be the biggest headache for a lot of people

GitHub

🚀 Feature Request: D1 Transaction support · Issue #2733 · cloudflar...

Describe the solution Has the procedures feature mentioned in this article been shipped? This feature does not seem to be available in the current version sdk, either locally or remotely. Is there ...

beelzabub•2/24/25, 5:35 AM

Does D1 support positional parameter binding like ?1 ?2 instead of ? ?

beelzabub•2/24/25, 6:39 AM

Yes, but await DB.prepare('SELECT col FROM table WHERE col1 = ?2 AND col2 = ?1 AND col3 = ?1').bind(1, 2).run()await DB.prepare('SELECT col FROM table WHERE col1 = ?2 AND col2 = ?1 AND col3 = ?1').bind(1, 2).run()

imrebuild•2/24/25, 8:11 PM

I just noticed that SELECT file_id FROM file WHERE ref_id = '123'SELECT file_id FROM file WHERE ref_id = '123' shows "rows_read": 2"rows_read": 2. Does it mean that reading index is also counted as well as reading the data?

Iimrebuild I just noticed that `SELECT file_id FROM file WHERE ref_id = '123'` shows `"rows...

Isaac McFadyen•2/24/25, 8:17 PM

Correct.

beelzabub•2/24/25, 8:26 PM

@Isaac McFadyen any idea why none of npx wrangler d1 migrations --helpnpx wrangler d1 migrations --help / npx wrangler d1 migrations apply --helpnpx wrangler d1 migrations apply --help lists persist-topersist-to as a valid option?

Bbeelzabub @Isaac McFadyen any idea why none of `npx wrangler d1 migrations --help` / `npx ...

Isaac McFadyen•2/24/25, 8:35 PM

From the source it looks like a valid option so I'm guessing it might have just been forgotten in the --help--help output?

Isaac McFadyen•2/24/25, 8:35 PM

Not quite sure, I haven't used migrations much, sorry.

Skycrafter•2/25/25, 3:13 PM

Hello, I have a website project where I'm trying to use a D1 db. However, I'm getting big latencies, so I was thinking of using the Sessions API. However, I'm afraid of data inconsistency (for reads) from one user to the next. Can help me understand how should a session be initiated on a worker to ensure that all future queries have up-to-date data? Like, should navigating between pages create a new session to have up-to-date info? That feels as bad as using no replication. Any insights on if I missed something? Thanks a lot

James•2/25/25, 3:15 PM

The sessions API doesn’t exist yet - but soon. I’m sure a lot more info will be shared when it’s released and generally available, with best practices, recommendations, etc.

Skycrafter•2/25/25, 3:15 PM

okay thank you

MMax (@rozenmd)It'll be possible to limit replication within an area (like the EU for GDPR)

mohamnag•2/26/25, 6:06 AM

Is this already available? I’m not sure if anyone can use D1 for a serious project in EU until we have this

Mmohamnag Is this already available? I’m not sure if anyone can use D1 for a serious proje...

lambrospetrou•2/26/25, 6:47 AM

Replication is not released yet, and will be optional anyway for some time. You can decide to keep your primary database instance in EEUR or WEUR.

Llambrospetrou Replication is not released yet, and will be optional anyway for some time. You ...

mohamnag•2/26/25, 6:54 AM

is keeping data in EU done using location hint? Because docs say that one is not binding and might even be ignored.

Also is there any way to prevent this replication? Like when does that happen? If for anyone outside of an specific region no DB access happens, does that mean no replication is happening either?

o7•2/26/25, 6:56 AM

EU GDPR jurisdiction support is something I'm also interested in

Mmohamnag is keeping data in EU done using location hint? Because docs say that one is not...

lambrospetrou•2/26/25, 6:59 AM

Also is there any way to prevent this replication? Like when does that happen? If for anyone outside of an specific region no DB access happens, does that mean no replication is happening either?

There is no replication at the moment. Once it's out, we will have some control for jurisdictions once those are added for D1.

You can also check where your database is located after creation to confirm its location.

Llambrospetrou > Also is there any way to prevent this replication? Like when does that happen?...

mohamnag•2/26/25, 8:54 AM

would you mind pointing me where the location of a DB can be seen? not finding anything on dashboard

Mmohamnag would you mind pointing me where the location of a DB can be seen? not finding a...

mohamnag•2/26/25, 8:57 AM

found it using wrangler

Mmohamnag found it using wrangler 😉

lambrospetrou•2/26/25, 10:00 AM

Wrangler can give it to you yes, your query responses also contain that information in the

meta

meta

object, and the dashboard will show it soon as well.

Llambrospetrou Wrangler can give it to you yes, your query responses also contain that informat...

mohamnag•2/26/25, 11:14 AM

Thanks again. For now need to provide the hint and chk location afterwards. Would be nice if in future that hint is more binding too.

Mmohamnag is keeping data in EU done using location hint? Because docs say that one is not...

Hello, I’m Allie!•2/26/25, 2:07 PM

If you are referring to DOs, they do support Jurisdictions, which means it isn’t a hint, but a guarantee that they run in a given region

cosbgn•2/26/25, 3:01 PM

Does D1 provides some proper error codes?
so far I'm doing:

if (e.message.startsWith(`D1_ERROR: UNIQUE constraint failed:`)){
  throw createError({statusCode:400, statusMessage:`Your name needs to be unique`})
}

if (e.message.startsWith(`D1_ERROR: UNIQUE constraint failed:`)){
  throw createError({statusCode:400, statusMessage:`Your name needs to be unique`})
}

but seems super hacky

HHello, I’m Allie!If you are referring to DOs, they do support Jurisdictions, which means it isn’t...

mohamnag•2/26/25, 3:16 PM

what is DO? durable object? we were talking about D1 not sure if there is relation

Roger•2/26/25, 3:21 PM

Hello, is there any plan to create an official driver to manage D1 databases via third-party database managers like DBeaver?

PV76•2/26/25, 3:22 PM

Hi All. I'm working with the D1 Database by using the Prisma, Wrangler in the NextJS App Router Fullstack. I have a problem when I need to get the env to bind it into the Prisma D1 Adapter. Does anyone have experience with that? Could you help me with this? Thanks all

Mmohamnag what is DO? durable object? we were talking about D1 not sure if there is relati...

Hello, I’m Allie!•2/26/25, 4:50 PM

Yes, it is Durable Objects. D1 Databases are Durable Objects with some utils to make it easy to query externally

Hello, I’m Allie!•2/26/25, 4:50 PM

Durable Objects do support Jurisdictions, which force the location. Not sure whether D1 will have the same(don’t think it exists yet)

Caleb•2/26/25, 7:12 PM

Im sure someone has asked this before but I couldn't find anything about it. The D1 free tier says there are 25 billion rows read per month included. Does this only count the rows that the query returns? Or does it count rows that were checked and not returned as well?

CCaleb Im sure someone has asked this before but I couldn't find anything about it. The...

lambrospetrou•2/26/25, 7:14 PM

Or does it count rows that were checked and not returned as well?

All rows read are counted. From indices, non-indices, views, etc.

Caleb•2/26/25, 7:15 PM

CCaleb Im sure someone has asked this before but I couldn't find anything about it. The...

1984 Ford Laser•2/27/25, 4:41 AM

D1 Free tier is 5million row reads per day, not 25bil per month. 25bil is included in the $5 Workers Paid plan

dan—1106•2/27/25, 6:42 PM

I know that during a D1 export the database is unavailable for other requests (https://developers.cloudflare.com/d1/best-practices/import-export-data/#known-limitations).

A couple of questions on this:

What's a reasonable maximum time for an export to take? If a database hits the 10gb limit, how long would exporting it take?
Will this limitation go away when read only replicas become available?

YYS•2/27/25, 9:14 PM

Where can I request to update the error message for D1 response errors?

Ddan—1106 I know that during a D1 export the database is unavailable for other requests (h...

lambrospetrou•2/27/25, 9:19 PM

This really depends on each database. How many millions of rows, how big each row is, etc.
Probably reads could still flow through with the replicas, but the primary will still be blocked. We have some work streams to improve the import/export APIs over the next few months.

Llambrospetrou 1. This really depends on each database. How many millions of rows, how big each...

1984 Ford Laser•2/27/25, 10:53 PM

Replicas that don't exist publicly yet right?

Llambrospetrou 1. This really depends on each database. How many millions of rows, how big each...

dan—1106•2/27/25, 11:00 PM

On 1, makes sense. Can you give any guidance on the possible ranges of times the db might be blocked? Seconds, 10 minutes, 30 minutes?

Since yesterday, I have been encountering the error "D1_ERROR: Network connection lost." in a Worker

Similar Threads

Similar Threads

Similar Threads