Prisma update and delete with extendedWhereUnique work with MongoDB shared but not serverless tier

[akevinge]

Node: v16.20.0
Prisma: v4.11, v4.12, v4.13 (issue occurs with all of these versions)
OS/Runtimes: MacOS, Manjaro, Vercel serverless runtime (issue occurs with all of these OS/Runtimes)
Database: MongoDB Atlas, serverless tier, v6.3

Schema file

Original: https://github.com/UTDNebula/planner/blob/develop/prisma/schema.prisma
Truncated:

generator client {
  provider = "prisma-client-js"
  previewFeatures = ["extendedWhereUnique"]
}

datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

model Plan {
  id              String              @id @default(auto()) @map("_id") @db.ObjectId
  name            String
  createdAt       DateTime            @default(now()) @map("created_at")
  updatedAt       DateTime            @default(now()) @map("updated_at")
  semesters       Semester[]
  transferCredits String[]
  User            User?               @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId          String?             @db.ObjectId
  startSemester   SemesterCode
  endSemester     SemesterCode
}


model Course {
  id         String    @id @default(auto()) @map("_id") @db.ObjectId
  code       String
  color      String    @default("")
  semester   Semester? @relation(fields: [semesterId], references: [id], onDelete: Cascade)
  semesterId String?   @db.ObjectId
  locked     Boolean   @default(false)
  prereqOverriden Boolean @default(false)
  
  @@unique([semesterId, code])
}

model Semester {
  id      String       @id @default(auto()) @map("_id") @db.ObjectId
  code    SemesterCode
  courses Course[]
  plan    Plan?        @relation(fields: [planId], references: [id], onDelete: Cascade)
  planId  String?      @db.ObjectId
  color   String       @default("")
  locked  Boolean      @default(false)
}

type SemesterCode {
  semester SemesterType
  year     Int
}

enum SemesterType {
  f
  s
  u
}

// Necessary for Next auth
model Account {
  id                String  @id @default(auto()) @map("_id") @db.ObjectId
  userId            String  @db.ObjectId
  type              String
  provider          String
  providerAccountId String
  refresh_token     String? // @db.Text
  access_token      String? // @db.Text
  expires_at        Int?
  token_type        String?
  scope             String?
  id_token          String? // @db.Text
  session_state     String?
  user              User    @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@unique([provider, providerAccountId])
}

model Session {
  id           String   @id @default(auto()) @map("_id") @db.ObjectId
  sessionToken String   @unique
  userId       String   @db.ObjectId
  expires      DateTime
  user         User     @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model User {
  id                      String    @id @default(auto()) @map("_id") @db.ObjectId
  email                   String?   @unique
  emailVerified           DateTime?
  onboardingComplete      Boolean   @default(false)
  seenHomeOnboardingModal Boolean   @default(false)
  seenPlanOnboardingModal Boolean   @default(false)
  credit                  Credit[]
  accounts                Account[]
  sessions                Session[]
  plans                   Plan[]
}

Reproduction

The following query

await prisma.course.update({
    where: {
      semester: { plan: { userId: "a-user-id" } },
      semesterId_code: {
        semesterId: oldSemesterId,
        code: courseName,
      },
    },
    data: {
      semesterId: newSemesterId,
    },
  });

Fails with this error:

prisma:error
Invalid `prisma.semester.update()` invocation:


An operation failed because it depends on one or more records that were required but not found. No 'Semester' record (needed to inline the relation on 'Course' record) was found for a nested create on one-to-many relation 'CourseToSemester'.
PrismaClientKnownRequestError:
Invalid `prisma.semester.update()` invocation:


An operation failed because it depends on one or more records that were required but not found. No 'Semester' record (needed to inline the relation on 'Course' record) was found for a nested create on one-to-many relation 'CourseToSemester'.

The error ONLY occurs when:

• MongoDB's serverless tier (MongoDB v6.3) is used
• More than 1 user account is created

It works perfectly fine on MongoDB's shared tier (MongoDB 6.0.5)

Related: #15837

[jkomyno]

Hi, could you please share all the required info in our bug report issue template?
I.e., your Prisma version, Prisma schema, Node.js version, OS.

Thank you.

[akevinge]

Hi, could you please share all the required info in our bug report issue template? I.e., your Prisma version, Prisma schema, Node.js version, OS.

Thank you.

Hi Jkomyno. Updated!

[Weakky]

Hey @akevinge,

I think you've provided the wrong failing query as I'm not able to reproduce your issue. The share query snippet updates the course, but the error suggests that it's happening on prisma.semester.update().

Could you perhaps share that query?

Thank you!

[janpio]

Ping @akevinge

[jkomyno]

Hey @akevinge, I'm closing this issue for inactivity and because we couldn't reproduce it. Feel free to comment here again with the actual failing query and answers to the questions we've asked so we can address this problem. Thanks!