Hi guys, any known outage with the D1 web portal (and maybe not only)? When trying to see the conten

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

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

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

This is the only query that fails.

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

let me relog

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

Same issue after logout->login

FarhianOP•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)

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

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

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

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

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

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

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

nick•8/3/23, 10:06 AM

Actually, it's best to be able to bind directly like KV, without using the command line. I like Worker because it can be edited online and deployed quickly. To be honest, I really don't like the command line method. Can D1 databases be directly bound through the dashboard in the future

Ggeelen Found the error: it was only affecting DBs with the older, slower backend. All D...

FarhianOP•8/3/23, 12:00 PM

Thank you! It works now

Rabid•8/3/23, 1:20 PM

Anyone using D1 for a CRUD app with any kind of real load? Looking at migrating my tinder-like dating app from RDS/AWS to D1/Workers

nick•8/3/23, 1:30 PM

The code downloaded from another computer again, why does the part that binds D1 become like this? Then it will report an error when deploying? ? ? ? ?

RRabid Anyone using D1 for a CRUD app with any kind of real load? Looking at migrating...

Cyb3r-Jak3•8/3/23, 1:34 PM

I’d avoid doing that. D1 is still alpha so not good for production

CCyb3r-Jak3 I’d avoid doing that. D1 is still alpha so not good for production

Rabid•8/3/23, 1:43 PM

Well my app isn't "production" ready either, just more of a public preview (test) right now for early adopters

nejc•8/3/23, 2:12 PM

Hi all, I am getting a fetch problem that was mentioned above as well. Code is generated with wrangler and the interesting thing is that INSERT works (with .run()), but when I do SELECT (with .all()) I get fetch error

nejc•8/3/23, 2:12 PM

TypeError: Cannot read properties of undefined (reading 'fetch')\n    at No._send (worker.js:34:466)\n    at Za.all (worker.js:34:1936)\n    at pu (worker.js:33:63946)\n    at async Object.fetch (worker.js:33:63296)

TypeError: Cannot read properties of undefined (reading 'fetch')\n    at No._send (worker.js:34:466)\n    at Za.all (worker.js:34:1936)\n    at pu (worker.js:33:63946)\n    at async Object.fetch (worker.js:33:63296)

nejc•8/3/23, 2:13 PM

this was all working correctly until last couple of days

TypeError: Cannot read properties of undefined (reading 'fetch')\n at No._send (worker.js:34:466)\n at Za.all (worker.js:34:1936)\n at pu (worker.js:33:63946)\n at async Object.fetch (worker.js:33:63296)

Hi guys, any known outage with the D1 web portal (and maybe not only)? When trying to see the conten

Similar Threads

Similar Threads

Similar Threads