Cloudflare Developers•9mo ago

Is that in the D1 overview page?

Llambrospetrou Is that in the D1 overview page?

Kavatch•4/25/25, 12:17 PM

Yes correct

DDiego Hey all, just a quick question. I was able to create and populate a FTS5 virtual...

lambrospetrouOP•4/25/25, 3:30 PM

Every D1 response contains a

meta

meta

object that has this information about rows read and written and query duration itself.

lambrospetrouOP•4/25/25, 3:57 PM

Hey folks, the main fix for the increased

internal error

internal error

errors due to D1 read replication is now fully rolled out in production.

Feel free to re-enable replication again, and give us feedback.

Same guideline applies, D1 Read replication is in BETA. Do not enable directly in production without testing in a staging/test environment for a few days to ensure it works fine for your workload.

Read https://developers.cloudflare.com/d1/best-practices/read-replication/ for how to use.

Aajgeiss0702 thank you. Will there be any kind of notification when these fixes are rolled ou...

Milan•4/25/25, 4:03 PM

See Lambros' latest message.

ac•4/25/25, 7:10 PM

How can I copy a D1 database to another D1 database? I've tried using

wrangler d1 export

wrangler d1 export

to create a .sql file and then

wrangler d1 execute

wrangler d1 execute

with that file, but that fails every time due to foreign key constraints.

I know how to do it locally by just running sqlite3 on the sql file and replacing the file, but for remote changes it's confusing why the d1 exports generate invalid SQL for the

execute

execute

command. Any tips?

ac•4/25/25, 7:12 PM

Before anyone mentions it, yeah the export includes

PRAGMA defer_foreign_keys=TRUE;

PRAGMA defer_foreign_keys=TRUE;

at the top

ac•4/25/25, 7:24 PM

Looks like it works if I change that to

PRAGMA foreign_keys = off;

PRAGMA foreign_keys = off;

and turn off FKs completely for the duration of the file (then on again at the end)

ac•4/25/25, 8:04 PM

Ok, separate question: is there any way to programmatically know what local sqlite files match to which DB bindings for a worker? I have multiple that all persist to the same directory and the sqlite file names are all hashed and don't seem related to the database ID or anything

gruntlord6•4/25/25, 9:21 PM

why not just have a worker batch the contents?

seflanka•4/25/25, 10:27 PM

Is there any ETA on when Cloudflare SQL D1 clusters will be available in Brazil? When can we expect Cloudflare SQL D1 infrastructure to be available in Brazil?

Chaika•4/25/25, 10:48 PM

?crossposting -> workers-and-pages-discussions

SuperHelpflare•4/25/25, 10:48 PM

Please do not post your question in multiple channels/post it multiple times per the rules at #

welcome-and-rules. It creates confusion for people trying to help you and doesn't get your issue or question solved any faster.

Llambrospetrou Hey folks, the main fix for the increased `internal error` errors due to D1 read...

Zack•4/26/25, 12:25 AM

I've just rolled up our production load over the last hour to 100% and so far, zero errors!

Zack•4/26/25, 12:26 AM

Initially had some increased latency but now presumably the database has "warmed up" and we are back to the same latency as on our pre-replica setup!

Zack•4/26/25, 12:27 AM

Going to keep an eye on it, but will probably leave it running for the next 12 hours and check how it looks in the morning from our monitoring

parisholley•4/26/25, 1:53 PM

would enabling read replicas allow us to do an export of the database without blocking requests?

Pparisholley would enabling read replicas allow us to do an export of the database without bl...

lambrospetrouOP•4/26/25, 2:46 PM

Not yet. We will be working on that soon.

Zack•4/26/25, 7:37 PM

Some more feedback: I reverted back to our original setup after a few hours, though we saw no errors, latencies did increase more than I would have liked. Note that these graph quantiles aren't accurate for their quantile due to the way the metrics are currently aggregated, but the difference between the before and after is accurate and does show a significant shift in our latencies

Zack•4/26/25, 7:37 PM

However we experienced zero errors whatsoever, so that is a significant improvement from before!

Zack•4/26/25, 7:38 PM

I think I asked this question before, but I don't think it was answered. For the replicas, when they startup, do they have to go back to the origin DC for all of the data they need, or just for any recent checkpoints they are missing? I ask this because I think the reason we are getting these latency spikes is for regions where it was currently nighttime and the requests were low

Zack•4/26/25, 7:39 PM

I think for APAC for example, the latency can spike substantially if the replica is currently shutdown as it needs to fetch the data from the source in WEUR

Zack•4/26/25, 7:40 PM

However, if this data was cached near the replica location so it only had to go back "home" for new checkpoints, then I would expect this to not have much impact, especially for our database as it is entirely static, we never insert new rows

ZZack Some more feedback: I reverted back to our original setup after a few hours, tho...

lambrospetrouOP•4/27/25, 8:02 AM

but the difference between the before and after is accurate and does show a significant shift in our latencies

Where is the difference in this graph? Can you post that instead of the percentiles that you say are wrong? What is the magnitude of the difference you see, 1s, 5s, 500ms?

ZZack I think I asked this question before, but I don't think it was answered. For the...

lambrospetrouOP•4/27/25, 8:06 AM

The snapshot to boot a replica initially is fetched from the primary's region as far as I remember, but will double check and confirm. Then, once the replica is caught up, updates flow from the primary to all replicas in parallel while they are written to the primary. This should still only add a few hundred ms delay vs if it was in the replica's region, not multiple seconds, unless networking is really bad in those regions (APAC is quite noisy).

Either way, this case is already something we are working on improving/fixing soon, so that you don't need to wait for replicas to boot and they are used only once they are booted. So, these spikes should be eliminated.

Llambrospetrou > but the difference between the before and after is accurate and does show a si...

Zack•4/27/25, 8:15 AM

I can try to get some proper numbers on that, I did break it down by Colo and see some significant spikes. I do have metrics specifically for the D1 call so I can look at pulling those out and getting something useful for you guys probably tomorrow

Zack•4/27/25, 8:18 AM

If it's going back to the primary to pull the entire database I can see that being part of the reason for this. Pulling 2.5GB from WEUR to APAC or OC will surely take more than a few hundred ms. I feel like caching the checkpoints in each region would help significantly there, especially if you immediately boot the database and then sync the changes after. Clients that specify they don't care about any checkpoint could theoretically get the same performance as the primary, if it's cached

Zack•4/27/25, 8:18 AM

I'm sure there's significant complications to doing something like that though that I can't see from the outside

ZZack If it's going back to the primary to pull the entire database I can see that bei...

lambrospetrouOP•4/27/25, 8:22 AM

Pulling 2.5GB from WEUR to APAC or OC will surely take more than a few hundred ms.

Yeah, but in theory only the TTFB will be the significant difference, again with many caveats here.

Hopefully we will get the non-blocking replica boot soon, so this won't be a problem even without caching the snapshots in all regions.

Zack•4/27/25, 8:23 AM

Yea that would be a significant improvement

Llambrospetrou > Pulling 2.5GB from WEUR to APAC or OC will surely take more than a few hundred...

Zack•4/28/25, 1:47 PM

Hey, so coming back with some more (correct) metrics now.
Firstly, these are significantly improved because we made a change to always query D1, regardless of if the response is cached in the CDN, this seems to keep D1 significantly warmer, and our response times are much better in general than before we added this.
Now, onto the data. As I said before, errors are basically gone now, however we still get latency spikes. I've drilled into this pulling some data split by region, this is specifically metrics around the D1 call from the worker.
As you can see (in this 95th percentile graph), OC is our worst offender here, it occasionally has significant spikes in latency, sometimes going over a minute.
It is currently nighttime there, so we don't have many requests going through for OC, however a minute is still significant.
As we said, the upcoming changes around bypassing the replica when it's booting up would help this for sure, but a minute still seems pretty excessive

Zack•4/28/25, 1:47 PM

Lmk if you want me to pull any other metrics for you

Zack•4/28/25, 1:48 PM

A logarithmic version of the graph so you can see things are generally working normally other from those few OC spikes, one WNAM and one APAC spike

ZZack Hey, so coming back with some more (correct) metrics now. Firstly, these are sig...

lambrospetrouOP•4/28/25, 2:45 PM

Thanks a lot for the numbers! Yeah, the minute latency is almost always due to very slow network/retries/failures.
We will prioritize the non-blocking replica cold starts which will eliminate all this noise.

Zack•4/28/25, 2:48 PM

Yea makes sense, hopefully you can solve those slow starts too at some point, it feels like caching all that data locally within the DC would help there surely, as you don't have to pull up to 10GB across multiple oceans

Zack•4/28/25, 2:48 PM

For now, keeping the database warm by calling on every request is working for us, we can deal with these occasional slow starts for now

Zack•4/28/25, 2:49 PM

So we'll be mainlining replicas for now

ZZack So we'll be mainlining replicas for now 🙂

lambrospetrouOP•4/28/25, 2:59 PM

Keep us posted if you encounter anything else unexpected.

YYS•4/28/25, 8:23 PM

Are there plans to enable querying D1 from a database client like SQL developer?

YYYS Are there plans to enable querying D1 from a database client like SQL developer?

Cyb3r-Jak3•4/28/25, 8:32 PM

?d1-remote-connections

SuperHelpflare•4/28/25, 8:32 PM

Accessing D1 from outside workers:

D1 is based on SQLite, which does not natively support remote connections and isn't MySQL/PostgreSQL wire compatible, nor does D1 itself offer that functionality. As such, your options are:

1 -> The Cloudflare API Query Endpoint (https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database), with the upside of needing less setup, all requests have to go back to Cloudflare's core, so request latency is far from optimal from some locations. You would also be subject to the API Rate limit of 1200 requests per 5 minutes.

2 -> Create a worker to proxy requests to your D1 Database. Either tightly bound to your application/schema or loose and just accepting any query. This would allow your worker to execute potentially closer to your D1 Database and avoid the api rate limit.

YYYS Are there plans to enable querying D1 from a database client like SQL developer?

Brayden•4/28/25, 11:10 PM

You can access your D1 from the open source Outerbase project which is a database client.

Madi•4/29/25, 6:03 AM

Hello,
Is there any workaround for D1's lack of geospatial indexing?

MMadi Hello, Is there any workaround for D1's lack of geospatial indexing?

Max (@rozenmd)•4/29/25, 8:30 AM

Hyperdrive + Postgres

Llambrospetrou Keep us posted if you encounter anything else unexpected.

Zack•4/29/25, 10:37 AM

Nothing more currently outside of the delays, which surprisingly are occuring more in WNAM atm. I was wondering if there is there is a better or worse region to be the primary region for your replica instance? Right now ours is in WEUR, but would ENAM or WNAM be better for instance, or maybe EEUR?

ZZack Nothing more currently outside of the delays, which surprisingly are occuring mo...

lambrospetrouOP•4/29/25, 11:16 AM

That really depends on your traffic patterns. There isn't a golden rule. All regions in the US and Europe are usually reliable and pretty good.

Zack•4/29/25, 11:17 AM

We get traffic from all over, mostly US and EU, but I was mostly wondering about the replicas spinning up in OC and APAC, is there a better primary location for that

sh4•4/29/25, 5:37 PM

Hi folks, apologies if this is already explained somewhere.. I noticed that via API I can create new D1 databases, but I cannot find information on how to direct a query on a per-worker-request basis towards a specific D1 Database. Imagine I have a multi-tenant SaaS with a new customer come in. Using the API I can create a new D1 database with just their data; But then imagine that user for that org wants to manipulate data in their database. I already know which requests should map to which database ID, but I have no idea how to construct/use a client for that database ID because it's not an environment binding.

Is that in the D1 overview page?

Similar Threads

Similar Threads

Similar Threads