Unable to build initial database using pnpm migrations migrate

[Erudition]

I'm trying to run this locally, and when I get to the installation step to run migrations (which is supposed to create the database from scratch if there is none), I get errors implying some tables where expected to have already existed. For example:

pnpm migrations migrate reset

> [email protected] migrations /home/adroit/Software/webstudio
> pnpm --filter=@webstudio-is/prisma-client generate && pnpm --filter=./packages/prisma-client migrations --dev --cwd ../../apps/builder "migrate" "reset"


> @webstudio-is/[email protected] generate /home/adroit/Software/webstudio/packages/prisma-client
> PRISMA_BINARY_TARGET=${PRISMA_BINARY_TARGET:-'["native"]'} prisma generate

Prisma schema loaded from prisma/schema.prisma

✔ Generated Prisma Client (v5.12.1) to ./src/__generated__ in 150ms

...prisma fluff removed

> @webstudio-is/[email protected] migrations /home/adroit/Software/webstudio/packages/prisma-client
> ./migrations-cli/cli.ts "--dev" "--cwd" "../../apps/builder" "migrate" "reset"

There are failed migrations:
  - 20220912142938_assets-meta-data

PrismaClientKnownRequestError: 
Invalid `prisma.asset.findMany()` invocation in
/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220912142938_assets-meta-data/migration.ts:17:49

  14 
  15 return client.$transaction(
  16   async (prisma) => {
→ 17     const previousAssets = await prisma.asset.findMany(
The table `public.Asset` does not exist in the current database.
    at In.handleRequestError (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220912142938_assets-meta-data/client/runtime/library.js:122:6854)
    at In.handleAndLogRequestError (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220912142938_assets-meta-data/client/runtime/library.js:122:6188)
    at In.request (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220912142938_assets-meta-data/client/runtime/library.js:122:5896)
    at async l (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220912142938_assets-meta-data/client/runtime/library.js:127:11167)
    at async client.$transaction.timeout (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220912142938_assets-meta-data/migration.ts:17:30)
    at async Proxy._transactionWithCallback (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220912142938_assets-meta-data/client/runtime/library.js:127:9534)
    at async Object.up (/home/adroit/Software/webstudio/packages/prisma-client/migrations-cli/umzug.ts:48:13)
    at async <anonymous> (/home/adroit/Software/webstudio/node_modules/.pnpm/[email protected]/node_modules/umzug/src/umzug.ts:257:6)
    at async Umzug.runCommand (/home/adroit/Software/webstudio/node_modules/.pnpm/[email protected]/node_modules/umzug/src/umzug.ts:208:11)
    at async up (/home/adroit/Software/webstudio/packages/prisma-client/migrations-cli/commands.ts:236:5)


Please mark them as resolved or reset the database before you can proceed.

/home/adroit/Software/webstudio/packages/prisma-client:
 ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL  @webstudio-is/[email protected] migrations: `./migrations-cli/cli.ts "--dev" "--cwd" "../../apps/builder" "migrate" "reset"`
Exit status 1
 ELIFECYCLE  Command failed with exit code 1.

This prevents me from proceeding, there are many more migrations left (and many more have the issue, as I've realized by manually marking the migrations as "applied").

pnpm migrations migrate reset doesn't seem to do anything different from just migrate.

[Erudition]

I removed all docker containers and volumes for a fresh start to try again, here is the first migration that crashes:

Starting 20220601192603_start
20220601192603_start done in 0.534s
Starting 20220608130924_
20220608130924_ done in 0.523s
Starting 20220608130959_adduser
20220608130959_adduser done in 0.525s
Starting 20220608131719_add_user
20220608131719_add_user done in 0.524s
Starting 20220611090740_
20220611090740_ done in 0.508s
Starting 20220611091346_add_email
20220611091346_add_email done in 0.497s
Starting 20220616143541_add_projects
20220616143541_add_projects done in 0.5s
Starting 20220616143902_userid_not_mandatory
20220616143902_userid_not_mandatory done in 0.501s
Starting 20220619163536_userid_mandatory
20220619163536_userid_mandatory done in 0.502s
Starting 20220624214305_teams
20220624214305_teams done in 0.493s
Starting 20220624215036_remove_userid
20220624215036_remove_userid done in 0.497s
Starting 20220624235138_users_have_projects
20220624235138_users_have_projects done in 0.515s
Starting 20220714112221_add_assets
20220714112221_add_assets done in 0.501s
Starting 20220714114102_remove_size
20220714114102_remove_size done in 0.499s
Starting 20220715192633_add_alt
20220715192633_add_alt done in 0.5s
Starting 20220716191150_add_more_info_to_asset
20220716191150_add_more_info_to_asset done in 0.507s
Starting 20220716192051_make_metadata_not_mandatory
20220716192051_make_metadata_not_mandatory done in 0.538s
Starting 20220717152939_make_width_and_height_float
20220717152939_make_width_and_height_float done in 0.506s
Starting 20220717193140_make_width_and_height_decimal
20220717193140_make_width_and_height_decimal done in 0.508s
Starting 20220722131820_remove_path
20220722131820_remove_path done in 0.49s
Starting 20220722132445_add_location
20220722132445_add_location done in 0.493s
Starting 20220905153337_noop

PrismaClientKnownRequestError: 
Invalid `prisma.user.count()` invocation in
/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220905153337_noop/migration.ts:6:42

  3 export default () => {
  4   const client = new PrismaClient();
  5   return client.$transaction(async (prisma) => {
→ 6     const usersCount = await prisma.user.count(
The table `public.User` does not exist in the current database.
    at In.handleRequestError (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220905153337_noop/client/runtime/library.js:122:6854)
    at In.handleAndLogRequestError (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220905153337_noop/client/runtime/library.js:122:6188)
    at In.request (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220905153337_noop/client/runtime/library.js:122:5896)
    at async l (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220905153337_noop/client/runtime/library.js:127:11167)
    at async <anonymous> (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220905153337_noop/migration.ts:6:24)
    at async Proxy._transactionWithCallback (/home/adroit/Software/webstudio/packages/prisma-client/prisma/migrations/20220905153337_noop/client/runtime/library.js:127:9534)
    at async Object.up (/home/adroit/Software/webstudio/packages/prisma-client/migrations-cli/umzug.ts:48:13)
    at async <anonymous> (/home/adroit/Software/webstudio/node_modules/.pnpm/[email protected]/node_modules/umzug/src/umzug.ts:257:6)
    at async Umzug.runCommand (/home/adroit/Software/webstudio/node_modules/.pnpm/[email protected]/node_modules/umzug/src/umzug.ts:208:11)
    at async up (/home/adroit/Software/webstudio/packages/prisma-client/migrations-cli/commands.ts:236:5)

/home/adroit/Software/webstudio/packages/prisma-client:
 ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL  @webstudio-is/[email protected] migrations: `./migrations-cli/cli.ts "--dev" "--cwd" "../../apps/builder" "migrate"`
Exit status 1
 ELIFECYCLE  Command failed with exit code 1.

[TrySound]

Try to execute just pnpm migrations migrate. I'm not sure where did you get "reset" part.