Title
t

Tyler Storm

02/04/2021, 7:37 PM
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
m

Martïn

02/04/2021, 9:32 PM
@Tyler Storm Did you try setting
pool_timeout=0
in your connection URL to see if it fixes your issue?
t

Tyler Storm

02/04/2021, 9:39 PM
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
r

Ryan

02/05/2021, 6:33 AM
@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 🙂