Hi guys. I've been using prisma for my projects and this time I have a weird issue:
I keep getting:
Can't reach database server at
123.j.db.ondigitalocean.com:25060
Please make sure your database server is running at 123.j.db.ondigitalocean.com:25060.
It drops pretty regularly - once/2-3 min and crashes all my systems. Digital ocean provides me with 250 connections and I've checked their metrics on connections - no issues. Im nearly certain its a prisma problem. Ty14 Replies
You decided to hold for human wisdom. We'll chime in soon! Meanwhile,
#ask-ai is there if you need a quick second opinion.Hey 👋
Does this happen randomly? Like a few database queries work and then some do not?
hi there
yeah so exactly that
the queries are random as well
Is this happening on latest version of prisma?
yes
correct
digital ocean provides me with over 250 connections, I cant tell if prisma is out of connections or the time to obtain one is too long
but the server is not reachable
the server is always up though
Are you using any connection pooler?
nop
just regular prisma
Can you try with a different DB provider temporarily and check if you get the same error?
If it happens again, then we can confirm that the issue is related to prisma
Yes
I tried with raw sql
No issues
Hi @Nurul (Prisma)
Anything u can say
Hi, I meant using a different database provider other than DigitalOcean and check if the issue persists?
hmmm
i could try but ive checked already, they allow 250 connections, prisma allows 33
not so easy to move my data
I can understand. Ideally if we could have a minimal reproduction for this issue then we should be able to debug.
how many parallel connections can go through prisma
i have maybe 15-20 processes that query the db with a new instance of prisma / 3s maybe
The number of parallel connections that can go through Prisma depends on the connection pool size configuration.
https://www.prisma.io/docs/orm/prisma-client/setup-and-configuration/databases-connections/connection-pool#setting-the-connection-pool-size
Connection pool | Prisma Documentation
Prisma ORM's query engine creates a connection pool to store and manage database connections.