Got something similar, happened 3 times in the last 6 hours among ~=1000 SQL inserts: `D1_ERROR: Err

Got something similar, happened 3 times in the last 6 hours among ~=1000 SQL inserts:

D1_ERROR: Error: Internal error in D1 storage caused object to be reset.

D1_ERROR: Error: Internal error in D1 storage caused object to be reset.

D1_ERROR: Error: Internal error in D1 storage caused object to be reset.

D1_ERROR: Error: Internal error in D1 storage caused object to be reset.

itsmatteomanf•8/1/23, 9:57 PM

My volume is higher than that, and those were all subsequent writes.

ZZebra oh and response says I'm not authorized, hm, gonna try log out and back in

divby0•8/2/23, 6:11 AM

can confirm I have the exact same error code and message (and the same result of not being able to view rows inside dashboard)

Iitsmatteomanf I saw 61 instances of this error in the span of a few seconds, seems fine now......

itsmatteomanf•8/2/23, 8:34 AM

Got a few more hits in another Worker ~1h and ~2h later than that time.
So:

Aug 1, 2023 23:26:15 CEST — Aug 1, 2023 23:26:19 CEST
Aug 2, 2023 00:15:42 CEST
Aug 2, 2023 01:04:36 CEST

nick•8/2/23, 12:32 PM

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

nick•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...

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

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

nick•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

nick•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!

Got something similar, happened 3 times in the last 6 hours among ~=1000 SQL inserts: `D1_ERROR: Err

Similar Threads

Similar Threads

Similar Threads