Hi, I need help with my DB. I tried to use the time travel feature to restore some data and now I ca

Hi, I need help with my DB. I tried to use the time travel feature to restore some data and now I can't access the DB at all. The status on the dashboard just says:

Failed to reach database. Please try again later.

Failed to reach database. Please try again later.

Failed to reach database. Please try again later.

Failed to reach database. Please try again later. and when trying to access the url, it says the DB has just been successfully created. Any tips?

SSej Hi, I need help with my DB. I tried to use the time travel feature to restore so...

Max (@rozenmd)•2/22/24, 9:39 AM

What's the databaseId?

SejOP•2/22/24, 9:40 AM

Can I safely put it here?

SSej Can I safely put it here?

Max (@rozenmd)•2/22/24, 9:40 AM

Yes, it's not a secret

SejOP•2/22/24, 9:40 AM

Its 1b99b448-40c1-4ba5-8808-2949e2e52779

SSej Its 1b99b448-40c1-4ba5-8808-2949e2e52779

Max (@rozenmd)•2/22/24, 9:46 AM

Looks like that database is indeed stuck - I've forwarded this to our internal team to take a look, though they're on US-time so might be a few hours before they can help

MMax (@rozenmd)Looks like that database is indeed stuck - I've forwarded this to our internal t...

SejOP•2/22/24, 9:47 AM

Alright, thanks for the help!

RRicardas Not the nicest output here 🙂 but looks like this, i've omitted id and name ├──...

Max (@rozenmd)•2/22/24, 10:26 AM

I'll need the id to be able to look anything up about your database

RRicardas Hey is anyone else experiencing those errors: D1_ERROR: Cannot resolve D1 due to...

Max (@rozenmd)•2/22/24, 11:41 AM

and when you say high write rate, how many requests per second are we talking? >400?

Kosicki•2/22/24, 12:05 PM

Hey @Max (@rozenmd) any dates planned to release D1 on South America?

KKosicki Hey @Max (@rozenmd) any dates planned to release D1 on South America?

Max (@rozenmd)•2/22/24, 12:07 PM

Cloudflare doesn't give ETAs, but it'll come once DOs launch there

Kosicki•2/22/24, 12:07 PM

Could you give a spoiler in terms of "this year", "in five years"? something like that?

Max (@rozenmd)•2/22/24, 12:10 PM

I have no idea

Tony Leung•2/22/24, 1:59 PM

hi guys, it seems like D1 does not use any of my indexes

TTony Leung hi guys, it seems like D1 does not use any of my indexes

Max (@rozenmd)•2/22/24, 1:59 PM

are you using a view by any chance?

Tony Leung•2/22/24, 2:00 PM

well no, i don't use that feature

Tony Leung•2/22/24, 2:01 PM

I've created an index like

CREATE INDEX project_tiktok_link_is_empty_idx ON project (tiktok_link IS NULL OR tiktok_link == '');

CREATE INDEX project_tiktok_link_is_empty_idx ON project (tiktok_link IS NULL OR tiktok_link == '');

Tony Leung•2/22/24, 2:01 PM

and my query is like:

SELECT * FROM project WHERE id = '01HQ81GRDX539N2EJSW1ECGRMY' AND (tiktok_link IS NULL OR tiktok_link = '')

SELECT * FROM project WHERE id = '01HQ81GRDX539N2EJSW1ECGRMY' AND (tiktok_link IS NULL OR tiktok_link = '')

Tony Leung•2/22/24, 2:01 PM

but when i tried to

EXPLAIN QUERY PLAN

EXPLAIN QUERY PLAN

Tony Leung•2/22/24, 2:02 PM

the result is this:

Tony Leung•2/22/24, 2:02 PM

it only uses primary key index

Max (@rozenmd)•2/22/24, 2:02 PM

sqlite uses the best index where possible

Tony Leung•2/22/24, 2:02 PM

i tried

CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link IS NULL OR tiktok_link == '', id);

CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link IS NULL OR tiktok_link == '', id);

Tony Leung•2/22/24, 2:03 PM

and

CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link, id);

CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link, id);

Tony Leung•2/22/24, 2:03 PM

but none of them work

Tony Leung•2/22/24, 2:03 PM

i'm aware that index is left-most so i also changed my condition order but none of them work

Tony Leung•2/22/24, 2:04 PM

this table is large and this query is burning the

rows read

rows read

MMax (@rozenmd)sqlite uses the best index where possible

Tony Leung•2/22/24, 2:05 PM

well no more than one index will be used?

SSej Hi, I need help with my DB. I tried to use the time travel feature to restore so...

Max (@rozenmd)•2/22/24, 2:29 PM

can you try accessing the DB again?

F0rce•2/22/24, 3:45 PM

I noticed the following error / was able to reproduce it https://github.com/cloudflare/workers-sdk/issues/3160#issuecomment-1943795347 - has this been deployed yet (because the error is still open)

FF0rce I noticed the following error / was able to reproduce it <https://github.com/clo...

Max (@rozenmd)•2/22/24, 3:53 PM

It was released, where were you able to reproduce it?

MMax (@rozenmd)It was released, where were you able to reproduce it?

F0rce•2/22/24, 3:53 PM

D1 and using Drizzle.

F0rce•2/22/24, 3:53 PM

so it could be an drizzle error / they didnt update their part yet

Max (@rozenmd)•2/22/24, 3:53 PM

D1 as in through a Worker, or via wrangler d1 execute?

F0rce•2/22/24, 3:53 PM

through a worker

Max (@rozenmd)•2/22/24, 3:54 PM

using

.raw()

.raw()

F0rce•2/22/24, 3:54 PM

I dont know what drizzle uses at the end, 1 sec let me check

Max (@rozenmd)•2/22/24, 3:54 PM

Oh, yeah they'd need to update on their end

F0rce•2/22/24, 3:55 PM

probably they are not using

.raw()

.raw()

Max (@rozenmd)•2/22/24, 3:55 PM

To include an array of column names in the results when using raw(), use
raw({columnNames: true})
raw({columnNames: true})
.

F0rce•2/22/24, 3:55 PM

ahhhh let me bump the issue on their end again, sorry for the false alarm

F0rce•2/22/24, 3:55 PM

thanks for the fast answer

Max (@rozenmd)•2/22/24, 4:00 PM

Actually let me double check with the workerd team internally

FF0rce ahhhh let me bump the issue on their end again, sorry for the false alarm

Max (@rozenmd)•2/22/24, 4:12 PM

It's on us actually, it's live in main but not released in the workerd package + workers-types

F0rce•2/22/24, 4:13 PM

wait, so the fix has not been released yet ?

F0rce•2/22/24, 4:13 PM

and thats probably why the issue is still open ?

Max (@rozenmd)•2/22/24, 4:13 PM

if you use raw directly, you're interacting with the live runtime, which has the fix

Hi, I need help with my DB. I tried to use the time travel feature to restore some data and now I ca

Similar Threads

Similar Threads

Similar Threads