PrismaClientInitializationError
iamzainn opened this issue · 4 comments
iamzainn commented
Bug description
I am recentlly working on next js 14 project. For backent i choose prisma orm with supabase as a database.
Now i follow each and every step of prisma.
on Server off (npm run dev )
All steps working fine prisma generate / prisma migrate . each and everything working fine.
But on Server on in my web app where i user prisma its throw an error that
Prisma Client is not initialized and since my server is on npx prisma generate also show an Error :
EPERM: operation not permitted, unlink 'C:\Users\zainn\Desktop\redit\reddit\node_modules\.prisma\client\query_engine-windows.dll.node .
I uses this code for generating prisma client . in my next js as i know its best practises
import { PrismaClient } from "@prisma/client";
const prismaClientSingleton = () => {
return new PrismaClient();
};
declare global {
var prismaGlobal: undefined | ReturnType<typeof prismaClientSingleton>;
}
const prisma = globalThis.prismaGlobal ?? prismaClientSingleton();
export default prisma;
if (process.env.NODE_ENV !== "production") globalThis.prismaGlobal = prisma;
Then i fetch prisma from here to use it but its throw error how to resolve this issue guide me.....
MAIN ERROR THAT IS SHOWING :
⨯ PrismaClientInitializationError:
Invalid `prisma.user.findUnique()` invocation:
Can't reach database server at `aws-0-ap-south-1.pooler.supabase.com:6543`
Please make sure your database server is running at `aws-0-ap-south-1.pooler.supabase.com:6543`.
at In.handleRequestError (C:\Users\zainn\Desktop\redit\reddit\node_modules\@prisma\client\runtime\library.js:122:7177)
at In.handleAndLogRequestError (C:\Users\zainn\Desktop\redit\reddit\node_modules\@prisma\client\runtime\library.js:122:6211)
at In.request (C:\Users\zainn\Desktop\redit\reddit\node_modules\@prisma\client\runtime\library.js:122:5919)
at async l (C:\Users\zainn\Desktop\redit\reddit\node_modules\@prisma\client\runtime\library.js:127:11167)
at async GET (webpack-internal:///(rsc)/./src/app/api/auth/creation/route.ts:24:18)
at async C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:53446
at async e_.execute (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:44747)
at async e_.handle (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:54700)
at async doRender (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\base-server.js:1377:42)
at async cacheEntry.responseCache.get.routeKind (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\base-server.js:1599:28)
at async DevServer.renderToResponseWithComponentsImpl (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\base-server.js:1507:28)
at async DevServer.renderPageComponent (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\base-server.js:1924:24)
at async DevServer.renderToResponseImpl (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\base-server.js:1962:32)
at async DevServer.pipeImpl (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\base-server.js:920:25)
at async NextNodeServer.handleCatchallRenderRequest (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\next-server.js:272:17)
at async DevServer.handleRequestImpl (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\base-server.js:816:17)
at async C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\dev\next-dev-server.js:339:20
at async Span.traceAsyncFn (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\trace\trace.js:154:20)
at async DevServer.handleRequest (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\dev\next-dev-server.js:336:24)
at async invokeRender (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\lib\router-server.js:174:21)
at async handleRequest (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\lib\router-server.js:353:24)
at async requestHandlerImpl (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\lib\router-server.js:377:13)
at async Server.requestListener (C:\Users\zainn\Desktop\redit\reddit\node_modules\next\dist\server\lib\start-server.js:141:13) {
clientVersion: '5.14.0',
errorCode: undefined
}
How to reproduce
Expected behavior
No response
Prisma information
// Add your schema.prisma
// Add your code using Prisma Client
Environment & setup
- OS:
- Database:
- Node.js version:
Prisma Version
5.14.0
iamzainn commented
prisma version : 5.14.0