Hyperdrive is a transaction mode pooler, so those 25 go a lot further than you might imagine. Also

Hyperdrive is a transaction mode pooler, so those 25 go a lot further than you might imagine. Also the default limit is 60 after last month, with plans to make it adjustable down the road a bit.

Not saying you should reconsider, but just stating for posterity

kchro3•3/4/25, 8:11 PM

Hi, I am seeing a ton of logs like this:
Error: write CONNECTION_CLOSED <...>.hyperdrive.local:5432

can someone explain what this does

kchro3•3/4/25, 8:16 PM

we had as high as 20 errors per second and a couple hundred failures over a 10 min period

kchro3•3/4/25, 8:21 PM

brandonpsmith•3/5/25, 5:46 AM

i am using neon. i use neon branches for local development. when i set my neon branch connection string in .dev.vars (WRANGLER_HYPERDRIVE_LOCAL_CONNECTIONSTRING<BINDING>=neon branch connection string) and run wrangler dev. it recognizes my environment variable

Found a non-empty WRANGLER_HYPERDRIVE_LOCAL_CONNECTION_STRING variable for binding. Hyperdrive will connect to this database during local development.

Found a non-empty WRANGLER_HYPERDRIVE_LOCAL_CONNECTION_STRING variable for binding. Hyperdrive will connect to this database during local development.

now when i get the connection string from the binding (BINDING.connectionString), it returns a hyperdrive.localhyperdrive.local host instead of my neon connection string.

what am i doing wrong?

kchro3•3/5/25, 2:15 PM

has there been an uptick in the number of these Error: write CONNECTION_CLOSED <...>.hyperdrive.local:5432Error: write CONNECTION_CLOSED <...>.hyperdrive.local:5432 errors?

I've been getting tons of these starting yesterday, and even though I've added retry logic, it's still concerning & a waste of CPU time

AJROP•3/5/25, 2:18 PM

There was an accelerated release yesterday that may have severed some connections. We'll need to investigate that, there shouldn't have been the level of disruption you're describing.

Are you still observing elevated error rates? I'm not seeing any such in our broader monitoring.

kchro3•3/5/25, 2:23 PM

yup, here's our 24hr view

kchro3•3/5/25, 2:24 PM

we haven't made any significant code changes before we started seeing errors, except to add retries

AJROP•3/5/25, 2:24 PM

I think you were working with Adrian? Let me touch base with him

kchro3•3/5/25, 2:24 PM

yes, thank you

kchro3•3/5/25, 8:56 PM

still seeing this error... please let me know if there are things that I can try as mitigations or if there are any updates

for now, i'm trying to see what'll happen if i disable hyperdrive caching since i have a separate cache in front of my postgres client

AJROP•3/5/25, 9:27 PM

We're investigating internally. We will share updates as we have them.

iano•3/5/25, 10:04 PM

We are also seeing increased CONNECTION CLOSED errors, although also are dealing with increased traffic so hard to tell if its the same % or not

AJROP•3/5/25, 10:05 PM

same ID as in our thread?

Iiano We are also seeing increased CONNECTION CLOSED errors, although also are dealing...

AJROP•3/5/25, 10:36 PM

Went looking. I do see a bump in disconnects for you, but it's not related to what kchro3 is dealing with.

Franco Romano Losada•3/6/25, 3:55 AM

Hey everyone, I'm testing hyperdrive. These are my results:
/api/test/ ---> 200ms first hit, 3-7ms subsequent calls. Great!
/api/test/:id ---> 200-600ms always.

I see in the Hyperdrive analytics that I have a lot of "Uncacheable" requests. I guess this is the dynamic endpoint.

I'm trying to understand why or how it works? Is there a workaround? Does hyperdrive always relay on caching? I'm wondering for the stale data too.

Thanks!

FFranco Romano Losada Hey everyone, I'm testing hyperdrive. These are my results: /api/test/ ---> 200m...

Sam•3/6/25, 9:30 AM

Only static SELECT queries qualify for caching.

SSam Only static SELECT queries qualify for caching.

Franco Romano Losada•3/6/25, 9:57 AM

Thanks. Do you think the 200ms latency is due to me being in Brasil and the DB in Germany?

FFranco Romano Losada Thanks. Do you think the 200ms latency is due to me being in Brasil and the DB i...

Sam•3/6/25, 10:18 AM

Yes for sure.

SSam Yes for sure.

Franco Romano Losada•3/6/25, 12:48 PM

Thanks. Just tested it with a VPN and yes

Sam•3/6/25, 12:49 PM

I think smart placement would be something usefull to look at. Saves time in roundtrips in your code

Franco Romano Losada•3/6/25, 12:50 PM

I was going to ask you that. I have it in smart placement, but it seems like the worker is processed close to the end-user (in this case, me)

Sam•3/6/25, 12:51 PM

You'll need more requests to have it kick in then

Franco Romano Losada•3/6/25, 12:52 PM

Interesting. So when you have a lot of requests it will process the request close to the db?

Sam•3/6/25, 12:55 PM

Yes it needs to analyse your requests: https://developers.cloudflare.com/workers/configuration/smart-placement/#understand-how-smart-placement-works

Sam•3/6/25, 12:56 PM

Ah wait nvm, it does not apply to Hyperdrive. Sorry

Franco Romano Losada•3/6/25, 12:57 PM

Damn. Would be nice if we could set a base region and maybe some replicas if needed

AJROP•3/6/25, 1:41 PM

It actually does apply to Hyperdrive

AJROP•3/6/25, 1:41 PM

Part of the benefit of the recent pool placement work is that it'll play way nicer with smart placement

SSam Only static SELECT queries qualify for caching.

AJROP•3/6/25, 1:42 PM

Actually we can cache extended protocol queries too, but each different ID in this case will be a cache miss the first time you see it

AJROP•3/6/25, 1:43 PM

If you re run with the same ID and are seeing misses I'd be curious to poke a bit more. Probably there's something odd with your connection settings that is causing issues for caching. First guess would be a prepare: false setting

Franco Romano Losada•3/6/25, 2:25 PM

Okay, cool! I will check it later if this is an issue with my settings or code

AJROP•3/6/25, 2:26 PM

Feel free to DM me with specific queries and connections settings and such. Happy to dig a bit, this is a complicated part and it's always useful to me to see how exactly folks are using it

Franco Romano Losada•3/6/25, 3:11 PM

Thanks, I appreciate it

Jeff•3/6/25, 4:34 PM

Hello, seeing a lot of Connection terminated unexpectedlyConnection terminated unexpectedly errors suddenly, how can I debug?

JJeff Hello, seeing a lot of `Connection terminated unexpectedly` errors suddenly, how...

AJROP•3/6/25, 4:37 PM

please post or DM your hyperdrive ID.

thomasgauvin•3/7/25, 4:34 PM

We made it official with an announcement

: https://developers.cloudflare.com/changelog/2025-03-04-hyperdrive-pooling-near-database-and-ip-range-egress/

TLDR:

Query latency is reduced by 90% (!) by pooling databases connections closer to your database (as mentioned by @AJR earlier this week)
Hyperdrive uses Cloudflare IP addresses to connect to your database so you can configure access control lists on your database firewall (as mentioned by @xortive earlier this week)
Workers Smart Placement is more effective with Hyperdrive to ensure minimal network latency for db queries

@Hyperdrive ^

Cloudflare Docs

Hyperdrive reduces query latency by up to 90% and now supports IP a...

Tthomasgauvin We made it official with an announcement 📢: https://developers.cloudflare.com/...

Rapid•3/7/25, 4:43 PM

The link in the changelog is https://developers.cloudflare.com/hyperdrive/platform/changelog/(https://www.cloudflare.com/ips/https://developers.cloudflare.com/hyperdrive/platform/changelog/(https://www.cloudflare.com/ips/

Rapid•3/7/25, 4:43 PM

https://developers.cloudflare.com/hyperdrive/platform/changelog/#2025-03-07

Rapid•3/7/25, 4:43 PM

Just a malfunctioned link

dan•3/7/25, 6:00 PM

kinda interesting, it seems like my hyperdrive performance has gotten significantly worse in last 24 hours

dan•3/7/25, 6:00 PM

dan•3/7/25, 6:00 PM

connection latency in last 6 hours is 100ms

dan•3/7/25, 6:00 PM

vs 34ms over last week

AJROP•3/7/25, 6:34 PM

Mind sending me the ID? We haven't released any changes in the last 24 hours, I'd be curious to see where you're at.

Tthomasgauvin We made it official with an announcement 📢: https://developers.cloudflare.com/...

dave•3/8/25, 12:30 AM

IMO the firewall news so great I wish it was an email! I was very happy to see that news in my RSS feed.

mega•3/8/25, 10:48 AM

has anyone used for pushing data onto a kafka queue?

mega•3/8/25, 10:49 AM

or anything similar (redpanda, celery, some other db etc.)?

Mmega has anyone used for pushing data onto a kafka queue?

dave•3/8/25, 4:07 PM

imo I found traditional queues to be more complicated than needed. I personally recommend just using PostgreSQL and polling a table with a Cron Worker.

mega•3/8/25, 4:21 PM

I agree, but I want to keep some high volume financial data in a backup server (apart from D1), and was wondering if I can push that onto a kafka which later can be processed by something else (aws rds probably).

Hyperdrive is a transaction mode pooler, so those 25 go a lot further than you might imagine. Also

Similar Threads

Similar Threads

Similar Threads