Cloudflare Developers•2y ago

So this query latency is very low.

Isaac McFadyenOP•2/17/24, 2:20 PM

That indicates that the issue definitely isn't with the D1 database itself. Therefore there are two options.

IIsaac McFadyen So this query latency is very low.

Ɽ

ⱤØ₥₳₦•2/17/24, 2:20 PM

look at network tab

Isaac McFadyenOP•2/17/24, 2:21 PM

1. There is high network congestion from Worker -> D1
2. There is high network congestion from You -> Worker.

ⱤⱤØ₥₳₦look at network tab

Isaac McFadyenOP•2/17/24, 2:21 PM

Yes, but that time is including the time from You -> Worker -> D1.

Isaac McFadyenOP•2/17/24, 2:21 PM

The

duration

duration

is the actual time D1 took to execute your query, which is very low so indicates the problem isn't with D1 itself.

Ɽ

ⱤØ₥₳₦•2/17/24, 2:22 PM

I get it

Ɽ

ⱤØ₥₳₦•2/17/24, 2:24 PM

yes

Ɽ

ⱤØ₥₳₦•2/17/24, 2:25 PM

that is insane

Ɽ

ⱤØ₥₳₦•2/17/24, 2:25 PM

I was thinking that too

Ɽ

ⱤØ₥₳₦•2/17/24, 2:25 PM

Isaac McFadyenOP•2/17/24, 2:26 PM

Hmm, that is quite odd.

Isaac McFadyenOP•2/17/24, 2:26 PM

Are you making any other requests in the Worker? Perhaps hitting an external API via

fetch

fetch

or similar?

Isaac McFadyenOP•2/17/24, 2:26 PM

Also that SSL Handshake time is quite high... indicates there might be congestion between you and Cloudflare.

IIsaac McFadyen Are you making any other requests in the Worker? Perhaps hitting an external API...

Ɽ

ⱤØ₥₳₦•2/17/24, 2:27 PM

nope, just d1 thing

Isaac McFadyenOP•2/17/24, 2:27 PM

Even if the Worker is placed in London your connection will still be made to your nearest datacenter...

Isaac McFadyenOP•2/17/24, 2:27 PM

Can you go to https://cloudflare.com/cdn-cgi/trace and tell us the

colo=

colo=

field?

Ɽ

ⱤØ₥₳₦•2/17/24, 2:27 PM

const tpvchk = await env.DB.prepare("SELECT * FROM posts WHERE post_id = ?").bind(post_id).all();
return new Response(JSON.stringify([tpvchk]));

worker has only 2 line of code

IIsaac McFadyen Can you go to https://cloudflare.com/cdn-cgi/trace and tell us the `colo=` field...

Ɽ

ⱤØ₥₳₦•2/17/24, 2:28 PM

colo=AMD

Isaac McFadyenOP•2/17/24, 2:30 PM

Interesting. So that's in India but it doesn't host Durable Objects (which D1 uses). However, the SIN colo does. So I'd expect D1 to be spawned in SIN, unless D1 is disabled in that colo for some reason.

Isaac McFadyenOP•2/17/24, 2:30 PM

Can you try disabling Smart Placement?

Ɽ

ⱤØ₥₳₦•2/17/24, 2:30 PM

D1 is in singapore

Isaac McFadyenOP•2/17/24, 2:30 PM

That might line up with what you are seeing then.

Isaac McFadyenOP•2/17/24, 2:31 PM

If D1 is in SIN then that's 300ms away from AMD

Isaac McFadyenOP•2/17/24, 2:31 PM

https://where.durableobjects.live/colo/AMD/

Ɽ

ⱤØ₥₳₦•2/17/24, 2:32 PM

But still that doesn't explain why it is smart placed in london

IIsaac McFadyen Can you try disabling Smart Placement?

Ɽ

ⱤØ₥₳₦•2/17/24, 2:38 PM

I disabled smart placement, what's even intriguing is that in USA & EU i'm getting 150ms max, that is super strange

ⱤⱤØ₥₳₦I disabled smart placement, what's even intriguing is that in USA & EU i'm getti...

Isaac McFadyenOP•2/17/24, 2:38 PM

That would make sense if D1 is in Singapore.

Isaac McFadyenOP•2/17/24, 2:38 PM

D1 doesn't move.

IIsaac McFadyen That would make sense if D1 is in Singapore.

Ɽ

ⱤØ₥₳₦•2/17/24, 2:41 PM

nope, the average latency between most US cities and singapore is 210-250ms (raw latency doesn't include server response time and bla bla), so it still doesn't make sense why is USA i'm getting 150ms

Ɽ

ⱤØ₥₳₦•2/17/24, 2:42 PM

and not where i want 150ms (way closer to sin)

ⱤⱤØ₥₳₦nope, the average latency between most US cities and singapore is 210-250ms (raw...

Isaac McFadyenOP•2/17/24, 2:42 PM

Yes, but is that via Cloudflare's private backbone?

Nicolas4677•2/17/24, 3:34 PM

Looking for some help here, anything would be appreciated.

So, I'm trying to self-host some services without opening any ports in my router. I've been trying to do this through cloudflare's tunnels but no luck yet. I keep encountering this error when I enter my website through my subdomain (see image 1).

The tunnel's hostname setup is the following (see image 2). The reason why I've chosen localhost:8080 is because that's where my service is running at the moment, although I don't know if that's correct. When I open localhost:8080 I'm actually able to see my YouTrack service running.

simplenotezy•2/17/24, 4:26 PM

I am asked to help an owner of an old Battlefield Bad Company 2 server who's a victim on ongoing and recurring DDoS attacks. I recommend him using Cloudflare, but I am not sure how this could be setup. Could anybody point me in the right direction?

soos•2/17/24, 5:04 PM

general-helpWebsocket HLS stream can't be received

would streaming like this be against cloudflare TOS? its just LHLS tunnel for a security camera that wouldn't be on 24/7

Ssimplenotezy I am asked to help an owner of an old Battlefield Bad Company 2 server who's a v...

Jaren•2/17/24, 5:06 PM

cloudflare is probably not going to be your solution to this. you can do this with spectrum on the enterprise plan, but it would be a lot of money

Original message was deleted

soos•2/17/24, 5:07 PM

what could I use as an alternative so that I don't have to port open

Original message was deleted

soos•2/17/24, 5:35 PM

Thank you so much that worked

Andy•2/17/24, 10:10 PM

redirect rules are free forever right?

Andy•2/17/24, 10:10 PM

no matter how many requests get it?

Walshy•2/17/24, 10:10 PM

yep

Erisa•2/18/24, 12:22 AM

Not to my knowledge but you could totally build one on Workers

EErisa cloudflared in docker won't run on the same network as your localhost, 127.0.0.1...

E1337 NOTORඞOUS The PRESTඞGඞOUS•2/18/24, 12:35 AM

it's not working now

E1337 NOTORඞOUS The PRESTඞGඞOUS•2/18/24, 12:35 AM

it keeps giving me 502

E1337 NOTORඞOUS The PRESTඞGඞOUS•2/18/24, 12:35 AM

i tried reinstalling cloudflared but that didn't work

E1337 NOTORඞOUS The PRESTඞGඞOUS•2/18/24, 12:35 AM

i didn't change anything

E1337 NOTORඞOUS The PRESTඞGඞOUS•2/18/24, 12:36 AM

 ERR Request failed error="Unable to reach the origin service. The service may be down or it may not be responding to traffic from cloudflared: dial tcp 172.17.0.5:80

 ERR Request failed error="Unable to reach the origin service. The service may be down or it may not be responding to traffic from cloudflared: dial tcp 172.17.0.5:80

Erisa•2/18/24, 12:36 AM

The error is self explanatory, double check that the service is listening on that IP and port

Erisa•2/18/24, 12:36 AM

Not much i can suggest other than since I have no access to your environment, it's a local configuration issue

E1337 NOTORඞOUS The PRESTඞGඞOUS•2/18/24, 12:36 AM

docker can change IPs over time?

Erisa•2/18/24, 12:37 AM

If you recreate the container then sure

So this query latency is very low.

Similar Threads

Similar Threads

Similar Threads