Are you using the new backend? Executed as-is for me. ```sh ~/repos/d1 (main) ✔ ➜ wrangler d1 execu

Ooxygencraft I'm trying to setup the schema on my D1 database but when I run the wrangler com...

M

➜  wrangler d1 execute db-wnam --command "PRAGMA table_xinfo(scores)"

🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on db-wnam (6f2478dc-789b-4f31-95ff-d6001dc617d2):
🚣 Executed 1 commands in 0.225492000579834ms
┌─────┬───────────────┬─────────┬─────────┬────────────┬────┬────────┐
│ cid │ name          │ type    │ notnull │ dflt_value │ pk │ hidden │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 0   │ scoreId       │ INTEGER │ 0       │            │ 1  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 1   │ leaderboardId │ INTEGER │ 0       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 2   │ userId        │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 3   │ value         │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 4   │ gameVersion   │ TEXT    │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 5   │ timestamp     │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 6   │ hasReplay     │ INTEGER │ 0       │ 0          │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 7   │ verified      │ INTEGER │ 0       │ 0          │ 0  │ 0      │
└─────┴───────────────┴─────────┴─────────┴────────────┴────┴────────┘

➜  wrangler d1 execute db-wnam --command "PRAGMA table_xinfo(scores)"

🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on db-wnam (6f2478dc-789b-4f31-95ff-d6001dc617d2):
🚣 Executed 1 commands in 0.225492000579834ms
┌─────┬───────────────┬─────────┬─────────┬────────────┬────┬────────┐
│ cid │ name          │ type    │ notnull │ dflt_value │ pk │ hidden │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 0   │ scoreId       │ INTEGER │ 0       │            │ 1  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 1   │ leaderboardId │ INTEGER │ 0       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 2   │ userId        │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 3   │ value         │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 4   │ gameVersion   │ TEXT    │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 5   │ timestamp     │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 6   │ hasReplay     │ INTEGER │ 0       │ 0          │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 7   │ verified      │ INTEGER │ 0       │ 0          │ 0  │ 0      │
└─────┴───────────────┴─────────┴─────────┴────────────┴────┴────────┘

➜  wrangler d1 execute db-wnam --command "PRAGMA table_xinfo(scores)"

🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on db-wnam (6f2478dc-789b-4f31-95ff-d6001dc617d2):
🚣 Executed 1 commands in 0.225492000579834ms
┌─────┬───────────────┬─────────┬─────────┬────────────┬────┬────────┐
│ cid │ name          │ type    │ notnull │ dflt_value │ pk │ hidden │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 0   │ scoreId       │ INTEGER │ 0       │            │ 1  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 1   │ leaderboardId │ INTEGER │ 0       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 2   │ userId        │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 3   │ value         │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 4   │ gameVersion   │ TEXT    │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 5   │ timestamp     │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 6   │ hasReplay     │ INTEGER │ 0       │ 0          │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 7   │ verified      │ INTEGER │ 0       │ 0          │ 0  │ 0      │
└─────┴───────────────┴─────────┴─────────┴────────────┴────┴────────┘

➜  wrangler d1 execute db-wnam --command "PRAGMA table_xinfo(scores)"

🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on db-wnam (6f2478dc-789b-4f31-95ff-d6001dc617d2):
🚣 Executed 1 commands in 0.225492000579834ms
┌─────┬───────────────┬─────────┬─────────┬────────────┬────┬────────┐
│ cid │ name          │ type    │ notnull │ dflt_value │ pk │ hidden │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 0   │ scoreId       │ INTEGER │ 0       │            │ 1  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 1   │ leaderboardId │ INTEGER │ 0       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 2   │ userId        │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 3   │ value         │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 4   │ gameVersion   │ TEXT    │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 5   │ timestamp     │ INTEGER │ 1       │            │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 6   │ hasReplay     │ INTEGER │ 0       │ 0          │ 0  │ 0      │
├─────┼───────────────┼─────────┼─────────┼────────────┼────┼────────┤
│ 7   │ verified      │ INTEGER │ 0       │ 0          │ 0  │ 0      │
└─────┴───────────────┴─────────┴─────────┴────────────┴────┴────────┘

ZZebra Hello! I have a stupid question but how do I view my table entries in D1 ? I c...

D

divby0•8/1/23, 8:27 PM

Seeing the same for all tables on my project, worked fine before. I guess this is a temporary thing

Ddivby0 Seeing the same for all tables on my project, worked fine before. I guess this i...

M

Matt SilverlockOP•8/1/23, 8:32 PM

Specifically after 9? Or just in general.

MMatt Silverlock Specifically after 9? Or just in general.

D

divby0•8/1/23, 8:34 PM

Definitely independant of the number cause it didn't change

D

divby0•8/1/23, 8:35 PM

Some tables have 1 row, some have 4, some 11, none of them are showing up, but the console tab is still working fine so in case this is temporary it's totally okay for me at least

Ddivby0 Some tables have 1 row, some have 4, some 11, none of them are showing up, but t...

M

Matt SilverlockOP•8/1/23, 8:37 PM

I suspect a bug (we didn’t push any code today, but the dashboard team may have). Let me take a look shortly.

MMatt Silverlock I suspect a bug (we didn’t push any code today, but the dashboard team may have)...

D

divby0•8/1/23, 8:37 PM

no rush - I appreciate it

M

Matt SilverlockOP•8/1/23, 8:41 PM

I can't immediately repro: one of my DBs seems fine?

M

Matt SilverlockOP•8/1/23, 8:41 PM

M

Matt SilverlockOP•8/1/23, 8:41 PM

ZZebra And sorry for spamming with images here, just thought it might help with bug fix...

M

Matt SilverlockOP•8/1/23, 8:56 PM

No, that's helpful. But also weird — there's no paid tier at all (yet). Zero changes there.

ZZebra And sorry for spamming with images here, just thought it might help with bug fix...

M

Matt SilverlockOP•8/1/23, 8:56 PM

cc @geelen when he's in shortly

A

AFSANEH ABBAS•8/1/23, 9:18 PM

Why Web
https://api.sandbox-transgerwise-tech
Can not work with email

U

Unsmart•8/1/23, 9:21 PM

Not sure what you mean

I

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

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

D1_ERROR: Error: Internal error while starting up D1 storage caused object to be reset.
D1_ERROR: Error: Internal error while starting up D1 storage caused object to be reset.
D1_ERROR: Error: Internal error while starting up D1 storage caused object to be reset.
D1_ERROR: Error: Internal error while starting up D1 storage caused object to be reset.

I

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

New backend, Database ID:

546787dd-35d5-4822-9b50-36fa0a4310c2

546787dd-35d5-4822-9b50-36fa0a4310c2

546787dd-35d5-4822-9b50-36fa0a4310c2

546787dd-35d5-4822-9b50-36fa0a4310c2.

T

TigersWay•8/1/23, 9:55 PM

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.

I

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

D

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

I

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

N

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

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

N

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!

C

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!

M

Matt SilverlockOP•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...

M

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

Something we'll fix.

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

M

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

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

F

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)"

F

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

M

Matt SilverlockOP•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...

M

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

Can you also confirm that you can otherwise query D1 via

wrangler

wrangler

?

F

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

This is the only query that fails.

F

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

let me relog

F

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

Same issue after logout->login

F

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)

F

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

F

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

F

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

Any toughts?

Are you using the new backend? Executed as-is for me. ```sh ~/repos/d1 (main) ✔ ➜ wrangler d1 execu

Similar Threads

Similar Threads

Similar Threads