Investigate Prisma issues due to client being generated in the api workspace

[dac09]

Prisma throws errors when trying to access models, in the seed scripts, exec scripts or services.

Invalid `db.post.create()` invocation in
/Users/dac09/Experiments-28feb-1049/scripts/seed.ts:24:41

  21
  22 Promise.all(
  23   posts.map(async (post) => {
→ 24     const newPost = await db.post.create(
  The table `main.Post` does not exist in the current database 

Diagnosis

Looks like in yarn 1 workspaces, sometimes prisma will create the .prisma folder at one or more of the nested workspaces. Deleting the generated folder fixes the problem

So the migrations and generation produces the client in the root node_modules/.prisma but when running the api side code, it picks a different prisma client, causing this error

In our case:

├── node_modules
│   ├── .prisma # 👈 this is good!
├── web
│   ├── node_modules
├── api
│   ├── node_modules
│   │   ├── .prisma  # 😨 whai?

Node version: v16.13.1
Yarn version: 1.23.0-20220130.1630 (set using yarn version classic)

Tasks

• Create reproduction repo for Prisma team
  Prisma 3.9.x+ multiple clients being generated, and in the wrong Yarn 1 workspace prisma/prisma#12083
• Make sure we run prisma commands in the correct cwd (fixi(prisma): Set default cwd for runCommand task to base #4604)
• Diagnose which version of Prisma the issue was introduced in
  Last known working version (in Redwood world) - Prisma 3.8.1 (Redwood v0.42.1)

[jvanbaarsen]

I can confirm this is also happening with yarn 3. I just created a brand new redwoodJS app, and ran into this problem as well.

[lyonusi]

I'm doing the tutorial and ran into this problem at Getting Dynamic after yarn rw prisma migrate dev. Temporarily fixed by rm -rf api/node_modules/.prisma. Node 16.14, yarn 1.22, prisma 3.10. Spent half my day trying to figure out what is going on...

[thedavidprice]

@lyonusi Gah, that's so frustrating. So sorry. This is a particularly annoying bug... 😖

Update

Prisma is moving forward with a fix. The tests on a pre-release version are looking good here #4850

Need to wait for a Prisma patch or minor release, then we'll get this merged into a Redwood release. Soon!

[thedavidprice]

Closed by

• fix(deps): update prisma monorepo to v3.11.1 #4914

I'll patch RC and release rc.final.2