search

Hendrixer / fullstack-music

fullstack-music.vercel.app
159 stars 103 forks source link

Error: P1000: Authentication failed against database server #8

Open ThierryHeinz opened 2 years ago

ThierryHeinz commented 2 years ago

Hi,

I have an issue regarding the use of Heroku postgresql database. I received an email from Heroku speifying that the database needed maintenance.

It seems the credentials on Heroku are rotating ?

When I update my .env files, it does not work and authentication fails. Is anyone knowing about this ? How to set-up this in order to keep it working ?

Thanks in advance

Pmejna commented 2 years ago

Hi Thierry - I have experienced the same issue - I needed to create the two additional instances. The credentials of the old ones didn't work. This happened again later on with the new ones and I needed to switch back again to the other ones. Later on had no issues. So hope this stay that way.

Skulek commented 2 years ago

I've got a similar problem on a dev server with a number of Prisma instances and after some period of time, it crashes.

I've found a solution here: https://www.prisma.io/docs/support/help-articles/nextjs-prisma-client-dev-practices and after that, I don't have any problems.