Cloudflare Developers•3y ago

Any update on the database access problem? Thanks!

FFarhian Any update on the database access problem? Thanks!

Matt Silverlock•9/19/23, 9:47 PM

This is rolling out now. Your DB was last on the east coast and we're about 35% done there.

FarhianOP•9/19/23, 9:48 PM

ooo

FarhianOP•9/19/23, 9:48 PM

thanks!

KKev FWIW my production D1 is back up 🙂

Matt Silverlock•9/19/23, 9:59 PM

Yep, I see that just now: "2023-09-19T21:51:02.570Z""2023-09-19T21:51:02.570Z" for last touched

KKev I might have celebrated a bit too early

Matt Silverlock•9/19/23, 10:00 PM

Yeah - still ~35% rolled out. Luck of the draw.

FarhianOP•9/19/23, 10:03 PM

I hope mine will be fixed before @.k.e.v. 's

FarhianOP•9/19/23, 10:31 PM

Mine is now working

FarhianOP•9/19/23, 10:32 PM

(much slower than usual but working

)

FarhianOP•9/19/23, 10:34 PM

I spoke to soon. I can see the DB, but when I try to query a row: {
"result": [],
"success": false,
"errors": [
{
"code": 7500,
"message": "internal error"
}
],
"messages": []
}

FarhianOP•9/19/23, 10:36 PM

It worked after a few refreshes - maybe it is due to the fix process still being rolled out

Cyb3r-Jak3•9/19/23, 10:36 PM

I would wait until there is an update saying your databases should be good before testing them.

FarhianOP•9/19/23, 10:36 PM

sounds good

FarhianOP•9/19/23, 10:37 PM

benthecarman•9/19/23, 11:18 PM

Is there a way to download your database?

FarhianOP•9/19/23, 11:19 PM

You can backup if you are still using the old alpha DB version
https://developers.cloudflare.com/d1/learning/backups/#:~:text=D1%20automatically%20backs%20up%20your,the%20backup%20will%20be%20queued.

Backups (Legacy) · Cloudflare D1 docs

D1 has built-in support for creating and restoring backups of your databases, including support for scheduled automatic backups and manual backup …

Cyb3r-Jak3•9/19/23, 11:20 PM

^ on the new backend someone make a package to handle it https://github.com/nora-soderlund/cloudflare-d1-backups

FarhianOP•9/19/23, 11:20 PM

ah cool

CCyb3r-Jak3 ^ on the new backend someone make a package to handle it https://github.com/nora...

benthecarman•9/19/23, 11:35 PM

my worker is written in rust, is there no way to do it then?

FarhianOP•9/19/23, 11:58 PM

any news on the fix rollout? thanks

FarhianOP•9/19/23, 11:59 PM

btw, I am able to access the database from the portal, but the worker using it can't

Bbenthecarman my worker is written in rust, is there no way to do it then?

Cyb3r-Jak3•9/20/23, 12:08 AM

You can rewrite the JavaScript package to rust or run it in a different worker

FarhianOP•9/20/23, 1:04 AM

getting errors trying to retrieve the table info: {
"result": null,
"success": false,
"errors": [
{
"code": 7500,
"message": "Internal error: failed to get table info"
}
],
"messages": []
} and {
"result": [],
"success": false,
"errors": [
{
"code": 7500,
"message": "internal error"
}
],
"messages": []
}. This time from the Cloudflare portal

FFarhian getting errors trying to retrieve the table info: { "result": null, "succes...

Matt Silverlock•9/20/23, 1:18 AM

This is still rolling out, but should be near complete in an hour or so.

FarhianOP•9/20/23, 1:19 AM

ok sounds good. It is weird because parts of it sometimes seems to work and other do not. Also those who work (e.g. query the data) are very intermittent

FarhianOP•9/20/23, 3:10 AM

The database looks ok, thank you!

tobias-•9/20/23, 8:36 AM

I just started migrating from KV to D1. I can create & access the database fine in the web ui, but I cannot access it via e.g. wrangler d1 listwrangler d1 list (getting the authentication error 10000 that somebody already reported on github). Is there a workaround for it?

雷

雷巴•9/20/23, 8:37 AM

When will it be beta?

雷

雷巴•9/20/23, 8:41 AM

If I use it now during the alpha testing, will my data be wiped?

random_media1•9/20/23, 9:00 AM

I am also looking for workaround on wrangler for auth error on wrangler. Is there any workaround for this? As @tobias- mentioned issue.

conneo•9/20/23, 9:06 AM

Hi, in the communication earlier this year it seemed to be a matter of weeks for getting big news about D1. We all hoped it would be entering Beta stage. Is there any prediction when that will happen? Do we need to think in weeks or months?
We are still preparing some tools for production use to get benefits when beta is there. Also we need then more databases and storage per database to be able to scale up.

Any insight is highly appreciated. If we speak about months, then I need to find a different SQLite hosting for the time in between. Thanks a lot

雷雷巴 If I use it now during the alpha testing, will my data be wiped?

Hello, I’m Allie!•9/20/23, 9:07 AM

Not intentionally, though there is always a chance that something breaks

雷雷巴 If I use it now during the alpha testing, will my data be wiped?

Matt Silverlock•9/20/23, 10:12 AM

No data will be wiped from alpha to beta/GA

tobias-•9/20/23, 10:40 AM

I'm trying to implement a simple optimistic lock, but I can't find any method where I get the number of affected lines for an update, while still allowing binding of values. The D1Database has exec(): D1ExecResultexec(): D1ExecResult (which does include count), but if I want to perform something similar on D1PreparedStatementD1PreparedStatement, I'm lost. What am I missing?

Ttobias-I'm trying to implement a simple optimistic lock, but I can't find any method wh...

Matt Silverlock•9/20/23, 11:01 AM

It’s not implemented. Open an issue on GitHub?

MMatt Silverlock It’s not implemented. Open an issue on GitHub?

tobias-•9/20/23, 11:02 AM

Haha, I'm still struggling with the concept of "open alpha" apparently

I thought everything was more or less done and now it was just bug-squashing, tooling and possibly backend stuff. I'll make a feature request. Thanks

Ttobias-Haha, I'm still struggling with the concept of "open alpha" apparently 🙂 I thou...

Matt Silverlock•9/20/23, 11:11 AM

I would never say features are “complete”, even at GA. There’s a near infinite list of things to build.

JJeff hey Matt what was the issue of the DB's failing?

Matt Silverlock•9/20/23, 12:32 PM

We’re still debugging. It’s deep in our storage layer which is why it only affected so few. There’s nothing unique about any of the DBs here or access patterns.

KKev yeah now my issues seem intermittent, feeling anecdotally like the issue is on "...

Matt Silverlock•9/20/23, 2:06 PM

You are still seeing it not respond? Remind me the DB ID?

Any update on the database access problem? Thanks!

Similar Threads

Similar Threads

Similar Threads