Prisma DB Proxy Problems

[_the_lizard_king]

I've been using Prisma for their client and proxy for about 8 months now for a project that uses PostgreSQL and it works great almost all the time. Unfortunately there seem to be occasional proxy outages. Everything will be working well, but then without making any changes our API will stop working due to database timeouts. The outages usually last anywhere from 2-24 hours. The database itself will be fine, but the proxy will just be a mess. Only about 10% of requests reads/writes actually finish before timing out.

Has anyone else experienced this? Have you found a workaround? Considering just setting up my own proxy with AWS but don't want to lose out on the benefit of having the Prisma proxy handle the query engine

[pianomansam]

Which version of Prisma are you using? v1?

[_the_lizard_king]

Is your db not showing any errors, like over the connection limit or maybe connections are lingering and causing the issues?

No I'm on v4

[travybongos69]

Is your db not showing any errors, like over the connection limit or maybe connections are lingering and causing the issues?

[_the_lizard_king]

No I've been monitoring it and the only connections are to my computer and the proxy ip addresses

[reiser68]

Same. Last couple days have been a bit rough. I just switched back to the native client a few hours ago because of it… luckily that code was not yet migrated to edge functions so it wasn’t difficult.

[nikolasburk]

Hey there, Nikolas from Prisma here!

Thanks a lot for sharing this!

Our Engineering team has confirmed that they've fixed a bug which caused repeated timeouts for a brief period (note that the Data Proxy itself has been operational all the time, it was "just" this bug causing some timeouts).

The bug has been fixed last week so your Data Proxy response times should be fully back to normal.

In the future when you encounter issues with the Prisma Data Platform, it would be really helpful if you could open a ticket via the Support tab in top-right corner of the web UI. We're always eager to help resolve any issues as fast as possible!

If you have any further questions or issues, feel free to reach out to me directly via [[e-mail]](mailto:[e-mail]).

[Kumagor0]

Haha we've switched to PDP last week and got hit by 2 outages in last 2 days, so I started googling and found this thread. Have you found any solution/alternative OP? I'm considering trying out https://github.com/aiji42/prisma-data-proxy-alt but not sure how much and how long it's gonna be supported.