Invalid `prisma.user.findMany()` invocation:


  Can't reach database server at `MY_DB_URL`:`MY_DB_PORT`

Please make sure your database server is running at `MY_DB_URL`:`MY_DB_PORT`.
    at PrismaClientFetcher.request (/Users/tyler/prismaproject/node_modules/@prisma/client/runtime/index.js:78463:15)
    at processTicksAndRejections (internal/process/task_queues.js:94:5)

Whenever looking up a large quantity of records I get an error saying unable to reach database server. The same query works with less records but seems to be timing out. Found more info on github incase anyone searches the slack here is the link https://github.com/prisma/prisma/issues/4280

@Tyler Storm Did you try setting

pool_timeout=0

in your connection URL to see if it fixes your issue?

Yeah, I tried everything in the thread and eventually decided to just get the count of records and run multiple fetchMany calls with skips and takes

@Tyler Storm 👋 This seems like a bug, so it would be great if you could create one here so that we can investigate this behaviour 🙂