Prisma: Error querying the database: db error: FATAL: too many connections

user_155196 0
Viewed 2330

I am using Prisma as ORM in my nextjs app. I am initiating the Prisma client in a lib file and importing the same where ever i need the instance. But still am getting the following error.

Error querying the database: db error: FATAL: too many connections for role "qcjoaamjgbnxjx"

prisma-client:

import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();
export default prisma;
prisma next.js
2 Answers

You could try instantiating PrismaClient as shown here so that a new connection isn't created on every reload.

user_88743510

I got the same error in my local computer. but my error was due to I have opened too many panels in pgAdmin. my database is Postgres. after removing all panels. my issue is solved

user_149826810
Related