Expected parent IDs to be set when ordering by parent

[romanwbruce]

Hi Prisma Team! My Prisma Client just crashed. This is the report:

Versions

Name	Version
Node	v20.12.0
OS	rhel-openssl-3.0.x
Prisma Client	5.11.0
Query Engine	efd2449663b3d73d637ea1fd226bafbcf45b3102
Database	mysql

Logs

prisma:tryLoadEnv Environment variables not found at null
prisma:tryLoadEnv Environment variables not found at undefined
prisma:tryLoadEnv No Environment variables loaded
prisma:client checkPlatformCaching:postinstall false
prisma:client checkPlatformCaching:ciName Vercel
prisma:tryLoadEnv Environment variables not found at null
prisma:tryLoadEnv Environment variables not found at undefined
prisma:tryLoadEnv No Environment variables loaded
prisma:client dirname /var/task/node_modules/.pnpm/@prisma+client@5.11.0_prisma@5.11.0/node_modules/.prisma/client
prisma:client relativePath ../../../../../../apps/dashboard/prisma
prisma:client cwd /var/task/node_modules/.pnpm/@prisma+client@5.11.0_prisma@5.11.0/node_modules/.prisma/client
prisma:client clientVersion 5.11.0
prisma:client:libraryEngine internalSetup
prisma:client:libraryEngine sending request, this.libraryStarted: false
prisma:get-platform Found distro info:
{
  "targetDistro": "rhel",
  "familyDistro": "rhel",
  "originalDistro": "amzn"
}
prisma:get-platform Trying platform-specific paths for "rhel"
prisma:get-platform Found libssl.so file using platform-specific paths: libssl.so.3
prisma:get-platform The parsed libssl version is: 3.0.x
prisma:client:engines:resolveEnginePath enginePath /var/task/node_modules/.pnpm/@prisma+client@5.11.0_prisma@5.11.0/node_modules/.prisma/client/libquery_engine-rhel-openssl-3.0.x.so.node
prisma:client:libraryEngine library starting
prisma:client:libraryEngine library started
prisma:client:libraryEngine sending request, this.libraryStarted: true
prisma:client checkPlatformCaching:postinstall false
prisma:client checkPlatformCaching:ciName Vercel
prisma:tryLoadEnv Environment variables not found at null
prisma:tryLoadEnv Environment variables not found at undefined
prisma:tryLoadEnv No Environment variables loaded
prisma:client dirname /var/task/node_modules/.pnpm/@prisma+client@5.11.0_prisma@5.11.0/node_modules/.prisma/client
prisma:client relativePath ../../../../../../apps/dashboard/prisma
prisma:client cwd /var/task/node_modules/.pnpm/@prisma+client@5.11.0_prisma@5.11.0/node_modules/.prisma/client
prisma:client clientVersion 5.11.0
prisma:client:libraryEngine internalSetup
prisma:client:engines:resolveEnginePath enginePath /var/task/node_modules/.pnpm/@prisma+client@5.11.0_prisma@5.11.0/node_modules/.prisma/client/libquery_engine-rhel-openssl-3.0.x.so.node
prisma:client:libraryEngine sending request, this.libraryStarted: true
prisma:client:libraryEngine sending request, this.libraryStarted: true

Client Snippet

    slides = await prisma.slide.findMany({
        where: {
            id: (q != "" ? {
                in: ids
            } : {
            }),
            company: company != "" ? {
                contains: company
            } : {},
            sector: sector != "" ? {
                contains: sector
            } : {},
            year: year != "" ? {
                contains: year
            } : {},
        },
        include: {
            pitch: {
                select: {
                    id: true,
                    name: true,
                    views: true,
                    company: true,
                    created_at: true,
                    sector: true
                }
            }
        },
        take: 100
    });

Schema

model Slide {
  id       String           @id @default(uuid())
  pitch_id String?
  index    Int
  url      String
  text     String?          @db.LongText
  forum_id String?
  block_id String?
  forum    ForumDiscussion? @relation(fields: [forum_id], references: [id])
  block    Block?           @relation(fields: [block_id], references: [id])
  pitch    Pitch?           @relation(fields: [pitch_id], references: [id])
  items    CollectionItem[]

  industry String? @default("")
  sector   String? @default("")
  company  String? @default("")
  year     String? @default("")

  @@index([pitch_id])
  @@index([forum_id])
  @@index([sector])
  @@index([company])
  @@index([industry])
  @@index([block_id])
  @@fulltext([text])
}

Prisma Engine Query

{"X":true}}}}}

[SevInf]

Hi @romanwbruce .

Could you provide the complete schema? IT is missing pitch model present in your query. Also, it would be really helpful if you can provide a sample of the data from the tables.

Thank you!

[jkomyno]

Hi @romanwbruce, could you please reply to @SevInf's comment above?
That information would be very important for us to evaluate, investigate - and possibly solve - this issue. Thanks!

[Jolg42]

With the lack of information and our inability to reproduce this issue, we're now closing it. Feel free to comment if you have any updates about it.

Thank you 🙏