Hi! Is possible to run D1 migrations in the Pages deploy script? Something like: `npm run build && n

Hi! Is possible to run D1 migrations in the Pages deploy script? Something like:

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name
I would like that migrations are executed at the same time as pushing the code...

JJure Hi! Is possible to run D1 migrations in the Pages deploy script? Something like:...

Matt Silverlock•9/19/23, 12:16 PM

Yes: remove the locallocal flag but otherwise follow this - https://developers.cloudflare.com/d1/learning/local-development/#develop-locally-with-pages

Local development · Cloudflare D1 docs

D1 has fully-featured support for local development, running the same version of D1 as Cloudflare runs globally. Local development uses Wrangler, the …

JureOP•9/19/23, 12:28 PM

I tried with this deploy scipt:

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name

and got error:

Failed: Error while executing user command. Exited with error code: 1
Failed: build command exited with code: 1
Failed: error occurred while running build command

Failed: Error while executing user command. Exited with error code: 1
Failed: build command exited with code: 1
Failed: error occurred while running build command

Is this a big mentioned here?
https://github.com/cloudflare/workers-sdk/issues/3598

GitHub

🐛 BUG: D1 migration doesn't work on Github Actions · Issue #3598 · ...

Which Cloudflare product(s) does this pertain to? D1 What version of Wrangler are you using? 3.1.2 What operating system are you using? Linux Describe the Bug When I try to apply a d1 database migr...

CCole Xemi It loaded a couple times successfully then is now failing

Matt Silverlock•9/19/23, 1:15 PM

Yes - we fixed it at 10:20PM ET and it looks to have last responded at ~3AM ET based on our data.

Farhian•9/19/23, 1:54 PM

Hi guys, we are having problems with one of our D1 databases - we can't seem to be able to reach it using either the web portal or from a worker.

Farhian•9/19/23, 1:54 PM

All the other databases are ok - only one seems to be acting up.

FFarhian All the other databases are ok - only one seems to be acting up.

James•9/19/23, 2:01 PM

What error are you seeing? Internal error: failed to get DB size and num_tablesInternal error: failed to get DB size and num_tables?

Farhian•9/19/23, 2:03 PM

"Failed to reach database. Please try again later."

James•9/19/23, 2:04 PM

@elithrar Seems like this error is growing - ~4 reports now I think

Farhian•9/19/23, 2:05 PM

(and I know that we 'should' not be using D1 for Prod - but we are :))

FFarhian Hi guys, we are having problems with one of our D1 databases - we can't seem to ...

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

Please share the databaseId.

Farhian•9/19/23, 2:20 PM

sec

Farhian•9/19/23, 2:21 PM

@elithrar I've sent you the DB id in private

FFarhian @elithrar I've sent you the DB id in private

Matt Silverlock•9/19/23, 2:22 PM

Thanks. DB IDs can be public — no one can do anything with your DB ID.

Farhian•9/19/23, 2:22 PM

oh ok

Matt Silverlock•9/19/23, 2:22 PM

(I have it now, but for future)

Farhian•9/19/23, 2:23 PM

sounds good, thanks!

Farhian•9/19/23, 2:38 PM

@colexemi yes, the error from the networking tab is: "errors": [
{
"code": 7500,
"message": "Internal error: failed to get DB size and num_tables"
}
],

Matt Silverlock•9/19/23, 3:25 PM

@farhian @colexemi @Jeff -

we're looking to roll out a patch this afternoon that should address this (we believe all of your DBs are affected by this edge case).

Farhian•9/19/23, 3:25 PM

Thank you @elithrar !

dave•9/19/23, 3:27 PM

what happens if I delete a D1 database that is currently bound to two Workers?

dave•9/19/23, 3:27 PM

for context, I'm deleting a database that's in alpha, to recreate it as beta

Farhian•9/19/23, 3:30 PM

I think that the process should be (not an expert - just my thoughts)

Create the beta DB and migrate the data from the alpha
Update your worker's toml file in order to update the bindings to point the new DB
re-deploy your workers using the new bindings
delete the alpha DB

dave•9/19/23, 3:38 PM

oh, that's smarter

dave•9/19/23, 3:38 PM

I was gonna delete first lol

Farhian•9/19/23, 3:38 PM

Cyb3r-Jak3•9/19/23, 3:38 PM

I don’t think it will let you delete a binding in use

dave•9/19/23, 3:42 PM

hmm, can I have a duplicate name database though?

Farhian•9/19/23, 3:45 PM

I do not think so... what I did (which is probably NOT a good practice) was to do a backup first (you need it anyway for the migration), delete it (it did allow me to delete even if I had a worker using it) - like you I wanted to use the same name, went through the beta migration, updated the toml binding and used the new ID and then redployed the worker. In my case, it was OK to have an outage

Farhian•9/19/23, 3:52 PM

or the same one