Prisma•3mo ago

TypeError: Cannot read properties of undefined (reading 'exec')

"Hi, does anyone know why I'm getting a TypeError: Cannot read properties of undefined (reading 'exec') when using Prisma with @prisma/adapter-neon and Next.js? The error seems to originate in library.js and could be related to the environment or connection configuration. I'm attaching a screenshot with the stack trace and debug info. Thanks in advance!"

13 Replies

RaphaelEtim•3mo ago

Hi @simo Can you please show how you are instantiating and using Prisma Client in your code?

simoOP•3mo ago

// prisma/schema.prisma


generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["driverAdapters"]
  binaryTargets   = ["native"]
}

datasource db {
  provider  = "postgresql"
  url       = env("DATABASE_URL")
  directUrl = env("DIRECT_URL")
}

//client.ts

import ws from "ws"
import { Pool, neonConfig } from "@neondatabase/serverless"
import { PrismaNeon } from "@prisma/adapter-neon"
import { PrismaClient } from "@prisma/client"

const prismaClientSingleton = () => {
  neonConfig.webSocketConstructor = ws
  neonConfig.poolQueryViaFetch = true
  const pool = new Pool({ connectionString: `${process.env.DATABASE_URL}` })
  const adapter = new PrismaNeon(pool)
  const db = new PrismaClient({ adapter })

  return db
}

declare const globalThis: {
  prismaGlobal: ReturnType<typeof prismaClientSingleton>
} & typeof global
const db = globalThis.prismaGlobal ?? prismaClientSingleton()
export default db
if (process.env.NODE_ENV !== "production") globalThis.prismaGlobal = db

// prisma/schema.prisma


generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["driverAdapters"]
  binaryTargets   = ["native"]
}

datasource db {
  provider  = "postgresql"
  url       = env("DATABASE_URL")
  directUrl = env("DIRECT_URL")
}

//client.ts

import ws from "ws"
import { Pool, neonConfig } from "@neondatabase/serverless"
import { PrismaNeon } from "@prisma/adapter-neon"
import { PrismaClient } from "@prisma/client"

const prismaClientSingleton = () => {
  neonConfig.webSocketConstructor = ws
  neonConfig.poolQueryViaFetch = true
  const pool = new Pool({ connectionString: `${process.env.DATABASE_URL}` })
  const adapter = new PrismaNeon(pool)
  const db = new PrismaClient({ adapter })

  return db
}

declare const globalThis: {
  prismaGlobal: ReturnType<typeof prismaClientSingleton>
} & typeof global
const db = globalThis.prismaGlobal ?? prismaClientSingleton()
export default db
if (process.env.NODE_ENV !== "production") globalThis.prismaGlobal = db

RaphaelEtim•3mo ago

In your client.ts file, I think this is the declaration you need

import { Pool } from "@neondatabase/serverless";
import { PrismaNeon } from "@prisma/adapter-neon";
import { PrismaClient } from "@prisma/client";

export function createPrismaClient() {
  const pool = new Pool({ connectionString: process.env.DATABASE_URL });
  const adapter = new PrismaNeon(pool);
  const prisma = new PrismaClient({ adapter: adapter });

  return prisma;
}

import { Pool } from "@neondatabase/serverless";
import { PrismaNeon } from "@prisma/adapter-neon";
import { PrismaClient } from "@prisma/client";

export function createPrismaClient() {
  const pool = new Pool({ connectionString: process.env.DATABASE_URL });
  const adapter = new PrismaNeon(pool);
  const prisma = new PrismaClient({ adapter: adapter });

  return prisma;
}

You can now import it like this

import { createPrismaClient } from "./client";

import { createPrismaClient } from "./client";

simoOP•3mo ago

Thank you very much for your help. I have made the suggested changes and I still have the same error. I suspect that it may be something wrong with the version of openSSL I have installed on my Windows OS. Or maybe I have openSSL configured wrong What version of openssl do you recommend?

RaphaelEtim•3mo ago

Can you please confirm if this will be deployed to the edge?

simoOP•3mo ago

No, it is not deployed to edge Sorry, I don't have access to the code right now, but when I can, I'll attach all the possible parts of the code.

RaphaelEtim•3mo ago

In that case, you can simply make do the code below in your client.ts filewith

import { PrismaClient } from '@prisma/client'

const globalForPrisma = global as unknown as { prisma: PrismaClient }

export const prisma = globalForPrisma.prisma || new PrismaClient()

if (process.env.NODE_ENV !== 'production') globalForPrisma.prisma = prisma

export default prisma

import { PrismaClient } from '@prisma/client'

const globalForPrisma = global as unknown as { prisma: PrismaClient }

export const prisma = globalForPrisma.prisma || new PrismaClient()

if (process.env.NODE_ENV !== 'production') globalForPrisma.prisma = prisma

export default prisma

simoOP•3mo ago

I still have the same error

RaphaelEtim•3mo ago

Is it possible to share the repo so i can take a look

simoOP•3mo ago

I have cleared the npm cache and reinstalled node.js

RaphaelEtim•3mo ago

After clearing the npm cache and reinstalling node, does the error persist? if yes, is it possible to share a reproducible repo with me

simoOP•3mo ago

Yes, the error persists. I'll share a repo with you this afternoon. Thanks

RaphaelEtim•3mo ago

Looking forward to it. Thanks

Gaming

Programming

TypeError: Cannot read properties of undefined (reading 'exec')