Welcome to the official Cloudflare Developers server. Here you can ask for help and stay updated with the latest news
83,498Members
View on DiscordResources
Similar Threads
Was this page helpful?
ZZ
AZ
withSession yet, might just be coincidence, but I just deployed the worker with that change, and now the replicated D1 database is working just fine
MZZMZ
L
withSession()) all requests are sent to the primary explicitly. Under the hood the D1 binding has already been using the Sessions API for non replicated databases for months now, and it sends first-primary when you don't use withSession() yourself.ZwithSession('first-unconstrained') which is working as I would expect, and not experiencing those same errorsAD1_ERROR: Network connection lost. error. Sometimes after a few seconds, sometimes within a secondA
LNetwork connection lost. are transient errors reaching the location/datacenter of your database.A
AZAZLLAfirst-unconstrained) just doing withSession()ZZZLAAZwithSession('first-unconstrained') in dev, I decided to try and push that to prod. Now the database is entirely unresponsive and hasn't managed to serve a successful request for the last 10 minutes. Continually getting network connection lost errorsAZAZZA
CSessions API works with databases that do not have read replication enabled, so it is safe to run code with Sessions API even after disabling read replication.https://developers.cloudflare.com/d1/best-practices/read-replication/#benefits-of-read-replication
AAAAwithSession() though, i'm not trying to use bookmarks on DBs that dont have replication enabled, so i cant confirm if that works or not. I imagine it would though
Wwrangler.jsonc. I can successfully run the migrations if I do wrangler d1 migrations apply <database>, but when I then do wrangler pages dev --d1 MY_DB=mydb to run my app locally, drizzle complains about a missing table, seemingly my migrations haven't been run after all..sqlite files in .wrangler/state/v3/d1/miniflare-D1DatabaseObject migrations apply command operate on a different local database than wrangler pages dev? Just trying to figure out the best way to set this up, and feel like I'm using wrangler incorrectly hereLLD1DatabaseSession has the same prepare/batch() methods as the top level D1 Binding your code doing D1 queries should just accept D1DatabaseSession. And therefore you can pass in your code either the top level binding or the session create by withSession().ZZ
ZZLLNon-replicated D1 feels like either, the instances (DOs) live for longer before being shutdown or are just faster at starting up?No. Replicas start up in the same way as any other database, and non-replicated databases do not live longer.
ZwithSessionwithSession()withSession()withSession()withSession()withSession()first-primarywithSession('first-unconstrained')withSession('first-unconstrained')D1_ERROR: Network connection lost.Network connection lost.first-unconstrainedwrangler.jsoncwrangler d1 migrations apply <database>wrangler pages dev --d1 MY_DB=mydb.sqlite.wrangler/state/v3/d1/miniflare-D1DatabaseObjectmigrations applywrangler pages devD1DatabaseSessionD1DatabaseSessionprepare/batch()