I just started using it, just 5 rows db (tutorial sql) still takes 500 ms this is nuts, almost 100 t

Yyeehow Is there an outage with the D1 API right now? The databases work when queried, b...

T

Tzewat•2/9/24, 7:42 AM

I am facing the same problem. I wonder if this affects some users or the whole service?

TTzewat I am facing the same problem. I wonder if this affects some users or the whole ...

Y

yeehow•2/9/24, 7:44 AM

Maybe a regional issue? I'm located in Western North America

D

Denver James Duran•2/9/24, 7:45 AM

Hi team, there seems to be a problem with D1.. also wrangler logs is not working...

Yyeehow Maybe a regional issue? I'm located in Western North America

R

rekkies•2/9/24, 7:46 AM

Experiencing the same in Europe too

Yyeehow Maybe a regional issue? I'm located in Western North America

T

Tzewat•2/9/24, 7:48 AM

I am in Italy. D1 could not be accessed about 3 hours ago according to the log.

Yyeehow Maybe a regional issue? I'm located in Western North America

D

Denver James Duran•2/9/24, 7:49 AM

I am in the Philippines

H

Hello, I’m Allie!•2/9/24, 7:57 AM

Just raised the issue, y'all

L

LeftSpace•2/9/24, 7:57 AM

same here (solved somehow)

L

LeftSpace•2/9/24, 7:57 AM

:NotLikeThis:

A

ale•2/9/24, 8:24 AM

hi, hi

Thank you for reporting these potential issues (and @HardlyWorkin' for raising it). I may reach out to many of you to gather more info

M

Matthijs•2/9/24, 8:27 AM

Hi, we are seeing the same for all of our D1 databases.

M

Matthijs•2/9/24, 8:27 AM

Located in Europe (AMS)

M

Matthijs•2/9/24, 8:30 AM

@ale
Here's what the API is returning:

{
  "result": null,
  "success": false,
  "errors": [
    {
      "code": 7501,
      "message": "Internal error: D1 API returned: (400 Bad Request) {\"success\":false,\"errors\":[\"Code: invalid_enum_value ~ Path: action ~ Message: Invalid enum value. Expected 'query' | 'execute' | '_tracing', received 'metadata'\"]}"
    }
  ],
  "messages": []
}

{
  "result": null,
  "success": false,
  "errors": [
    {
      "code": 7501,
      "message": "Internal error: D1 API returned: (400 Bad Request) {\"success\":false,\"errors\":[\"Code: invalid_enum_value ~ Path: action ~ Message: Invalid enum value. Expected 'query' | 'execute' | '_tracing', received 'metadata'\"]}"
    }
  ],
  "messages": []
}

{
  "result": null,
  "success": false,
  "errors": [
    {
      "code": 7501,
      "message": "Internal error: D1 API returned: (400 Bad Request) {\"success\":false,\"errors\":[\"Code: invalid_enum_value ~ Path: action ~ Message: Invalid enum value. Expected 'query' | 'execute' | '_tracing', received 'metadata'\"]}"
    }
  ],
  "messages": []
}

{
  "result": null,
  "success": false,
  "errors": [
    {
      "code": 7501,
      "message": "Internal error: D1 API returned: (400 Bad Request) {\"success\":false,\"errors\":[\"Code: invalid_enum_value ~ Path: action ~ Message: Invalid enum value. Expected 'query' | 'execute' | '_tracing', received 'metadata'\"]}"
    }
  ],
  "messages": []
}

A

ale•2/9/24, 8:31 AM

thank you @Matthijs

M

Matthijs•2/9/24, 8:32 AM

welcome, please let us know once you have an eta on a fix if possible

Aale hi, hi 👋 Thank you for reporting these potential issues (and @HardlyWorkin' ...

D

Denver James Duran•2/9/24, 8:39 AM

The log stream also is not working

S

Softbear•2/9/24, 8:42 AM

in the dashboard I can't access my databases

SSoftbear in the dashboard I can't access my databases

S

Softbear•2/9/24, 8:42 AM

May need to update the status page ...

A

ale•2/9/24, 8:49 AM

status page update is on its way

A

ale•2/9/24, 8:51 AM

https://www.cloudflarestatus.com/incidents/083d43qlrdzm

D1 users may be experiencing a higher error rate and API latency

S

Softbear•2/9/24, 8:57 AM

seems resolved for me

TTzewat I am facing the same problem. I wonder if this affects some users or the whole ...

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:04 AM

Same here in India

M

Matthijs•2/9/24, 9:06 AM

fixed for me. thanks for the quick response @geelen and @ale

ⱤⱤØ₥₳₦I just started using it, just 5 rows db (tutorial sql) still takes 500 ms this i...

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:06 AM

Jeez so I think this D1 ongoing issue caused this

T

Tzewat•2/9/24, 9:07 AM

d1 works now, thx for the team!

ⱤⱤØ₥₳₦Same here in India

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:11 AM

Fixed

ⱤⱤØ₥₳₦I just started using it, just 5 rows db (tutorial sql) still takes 500 ms this i...

M

Max (@rozenmd)•2/9/24, 9:13 AM

what does https://where.durableobjects.live/ show for you?

Where Durable Objects Live

Tracking where Durable Objects are created, wherever you are in the world.

MMax (@rozenmd)what does https://where.durableobjects.live/ show for you?

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:16 AM

MMax (@rozenmd)what does https://where.durableobjects.live/ show for you?

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:16 AM

AMD, Ahmedabad, India

AAdi Question, I see with the latest workerd release on github the bugfix for row wri...

M

Max (@rozenmd)•2/9/24, 9:16 AM

workerd releases tend to go live within a week or so

ⱤⱤØ₥₳₦AMD, Ahmedabad, India

M

Max (@rozenmd)•2/9/24, 9:18 AM

so your nearest db is unfortunately 200ms away - the queries themselves are fast (if you run

npx wrangler d1 insights <dbname>

npx wrangler d1 insights <dbname>

npx wrangler d1 insights <dbname>

npx wrangler d1 insights <dbname> you can see query timing data)

MMax (@rozenmd)so your nearest db is unfortunately 200ms away - the queries themselves are fast...

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:18 AM

It is actually city i live in

MMax (@rozenmd)so your nearest db is unfortunately 200ms away - the queries themselves are fast...

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:25 AM

Lol, insanely fast, but not with worker

ⱤⱤØ₥₳₦Lol, insanely fast, but not with worker

M

Max (@rozenmd)•2/9/24, 9:26 AM

like I said, your nearest DB is 200ms away

MMax (@rozenmd)like I said, your nearest DB is 200ms away

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:28 AM

How? DB is less than 10 km far

ⱤⱤØ₥₳₦How? DB is less than 10 km far

M

Max (@rozenmd)•2/9/24, 9:29 AM

a worker in AMD created a durable object in Singapore

M

Max (@rozenmd)•2/9/24, 9:29 AM

your worker is less than 10km away, but the DB is in SG

MMax (@rozenmd)your worker is less than 10km away, but the DB is in SG

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:30 AM

ohh damn, I got it now

M

Max (@rozenmd)•2/9/24, 9:30 AM

if you add caching to your Worker so it doesn't have to wait for the request from singapore to come back each time, it'll be insanely fast, see: https://developers.cloudflare.com/workers/examples/cache-api/

MMax (@rozenmd)if you add caching to your Worker so it doesn't have to wait for the request fro...

Ɽ

ⱤØ₥₳₦OP•2/9/24, 9:43 AM

If in the worker there are multiple blocks of code using DB again and again then what will happen?

Each block of code using DB will add Amd to Sin round trip latency to the response time?

ⱤⱤØ₥₳₦If in the worker there are multiple blocks of code using DB again and again then...

M

Max (@rozenmd)•2/9/24, 9:45 AM

If you enable Smart Placement in the dashboard for your Worker, the Worker will move itself to Sin, so only the first hop is slow, and the round-trips will be fast

AAdi Question, I see with the latest workerd release on github the bugfix for row wri...

M

Max (@rozenmd)•2/9/24, 12:21 PM

forgot to mention - once this fix is live, it'll only be applied to new queries, so

wrangler d1 insights

wrangler d1 insights

for historical data (like 31 days) will be inaccurate for a bit

A

Arturo•2/9/24, 12:22 PM

I'm trying to understand this metric, on the selected chart I have "Rows Metrics" selected, as you can see there was some spikes very weird on selected dates, I don't think what I'm doing requires that many rows read, like the max I probably have is like 50K rows, is this an indication of a compromised db? How can I dig deeper?

AArturo I'm trying to understand this metric, on the selected chart I have "Rows Metrics...

M

Max (@rozenmd)•2/9/24, 12:23 PM

run

npx wrangler@latest d1 insights <dbname> --sortBy reads --timePeriod 7d

npx wrangler@latest d1 insights <dbname> --sortBy reads --timePeriod 7d

, will tell you the queries doing this

M

Max (@rozenmd)•2/9/24, 12:25 PM

looking at your tables list counts as a read on every row in every table, so it could be as simple as that (we plan to address this)

A

Arturo•2/9/24, 12:27 PM

the query looks good, the top one is something I'm doing but it looks just too odd

A

Arturo•2/9/24, 12:28 PM

is that counting towards my quota or it's just the queries / write?

A

Arturo•2/9/24, 12:29 PM

I got this metrics from the wrangler:

 "avgRowsRead": 92284,
    "totalRowsRead": 7659605,
    "avgRowsWritten": 0,
    "totalRowsWritten": 0,
    "avgDurationMs": 26.3779313253012,
    "totalDurationMs": 2189.3682999999996,
    "numberOfTimesRun": 83

 "avgRowsRead": 92284,
    "totalRowsRead": 7659605,
    "avgRowsWritten": 0,
    "totalRowsWritten": 0,
    "avgDurationMs": 26.3779313253012,
    "totalDurationMs": 2189.3682999999996,
    "numberOfTimesRun": 83

 "avgRowsRead": 92284,
    "totalRowsRead": 7659605,
    "avgRowsWritten": 0,
    "totalRowsWritten": 0,
    "avgDurationMs": 26.3779313253012,
    "totalDurationMs": 2189.3682999999996,
    "numberOfTimesRun": 83

 "avgRowsRead": 92284,
    "totalRowsRead": 7659605,
    "avgRowsWritten": 0,
    "totalRowsWritten": 0,
    "avgDurationMs": 26.3779313253012,
    "totalDurationMs": 2189.3682999999996,
    "numberOfTimesRun": 83

For the top read spike

I just started using it, just 5 rows db (tutorial sql) still takes 500 ms this is nuts, almost 100 t

Similar Threads

Similar Threads

Similar Threads