Cloudflare Developers•3y ago

Did the d1 database fail? My website was directly impacted badly!

nickOP•8/2/23, 12:34 PM

My worker is bound to my database, but all of them can't work now, it was fine yesterday

Nnick Did the d1 database fail? My website was directly impacted badly!

Cyb3r-Jak3•8/2/23, 1:00 PM

Are you seeing any errors in your logs?

Nnick Did the d1 database fail? My website was directly impacted badly!

Matt Silverlock•8/2/23, 1:03 PM

We’re not seeing any widespread failures. Can you share:

What errors you’re seeing?
Confirm you didn’t run out of storage?
your account & database IDs?

ZZiga Zajc Latency graph is weird. If most responses happens under 1ms than at least 1 deci...

Matt Silverlock•8/2/23, 2:11 PM

Something we'll fix.

LLicoricevntrs Hello, do you know why I'm getting this error?

Matt Silverlock•8/2/23, 7:34 PM

https://developers.cloudflare.com/d1/changelog/#new-default-storage-subsystem

Farhian•8/2/23, 9:02 PM

Hi guys, any known outage with the D1 web portal (and maybe not only)? When trying to see the content of any of the tables, the content is empty. I can see how many rows there are but none are being returned. I noticed the POST /database/<guid>/query returns a 500: code
:
7500
message
:
"ERROR 9015: SQL engine error: query error: Error code 23: Authorization denied (not authorized)"

Farhian•8/2/23, 9:07 PM

I should add then I do have Admin permissions and this worked before.

FFarhian Hi guys, any known outage with the D1 web portal (and maybe not only)? When tryi...

Matt Silverlock•8/2/23, 9:12 PM

There's been a couple of reports (scroll up). We're looking into it — we haven't made any changes to how we auth users in D1. Can you confirm that logging out / in again does not resolve it? And what is your accountId?

FFarhian Hi guys, any known outage with the D1 web portal (and maybe not only)? When tryi...

Matt Silverlock•8/2/23, 9:14 PM

Can you also confirm that you can otherwise query D1 via

wrangler

wrangler

Farhian•8/2/23, 9:26 PM

This is the only query that fails.

Farhian•8/2/23, 9:26 PM

let me relog

Farhian•8/2/23, 9:27 PM

Same issue after logout->login

Farhian•8/2/23, 9:29 PM

I can see that the actual DB query does work and returns data - just that the webpage does not display it (presumably due to the other query failing)

Farhian•8/2/23, 9:30 PM

Farhian•8/2/23, 9:32 PM

Farhian•8/2/23, 10:02 PM

Any toughts?

LLogan Grasby If it's helpful - also experiencing this issue. Tried logging out and back in an...

Matt Silverlock•8/2/23, 10:50 PM

Ah, I see the problem. When we changed to show generated columns, we use a pragma we haven’t allow-listed ourselves. Ugh. @geelen

MMatt Silverlock There's been a couple of reports (scroll up). We're looking into it — we haven't...

nickOP•8/3/23, 1:18 AM

This is today's mistake, yesterday's mistake was different

nickOP•8/3/23, 2:07 AM

What exactly happened to D1? I have completely collapsed! My website cannot return to normal now!

Unsmart•8/3/23, 2:09 AM

D1 is alpha so issues are to be expected I wouldnt suggest you be using D1 if whatever you are using it for going down would be an issue

Unsmart•8/3/23, 2:11 AM

I would ensure that you are not overwriting your bindings somewhere in your code though as thats what it almost seems like it happening in some way potentially

since it says it cant read fetch on the binding because its undefined

nickOP•8/3/23, 2:18 AM

I used Wrangler to rebind the database, and in the online editor, the code underwent transcoding. Then, I copied the entire previous code and the database was functioning properly! I can connect and read normally, but when I clicked on deploy, an error occurred again and I have crashed

Farhian•8/3/23, 2:30 AM

Here is some more info: I have just created a new database (manually) and that one works fine. I can manually add and view the records. The problem is still there for my existing databases.

Farhian•8/3/23, 4:13 AM

Sounds good, thank you!

Ggeelen yeah sorry D1 is _only_ supported through wrangler at the moment, not through th...

nickOP•8/3/23, 6:42 AM

Thanks, so what should I do, recreate the database, and then rebind it? Can it support online editing?

Ggeelen if you deploy it through Wrangler again it should work

nickOP•8/3/23, 10:04 AM

Thank you, it is indeed possible. I have rebuilt the database and worker, but I am still unable to edit the code online. Once edited and deployed, there will be errors. Additionally, all Chinese characters in my code have been transcoded through the online editor. I am still more accustomed to online editing. When can I restore support for online editing?

Did the d1 database fail? My website was directly impacted badly!

Similar Threads

Similar Threads

Similar Threads