Hey we are using Prisma 2 we deploy on Vercel and are trying Prisma #orm-help

Hey we are using Prisma 2, we deploy on Vercel and...

fondfolio

09/12/2020, 11:33 PM

Hey we are using Prisma 2, we deploy on Vercel and are trying to get Preview deploys to work on our app. We're close, but are hitting a

PrismaClientUnknownRequestError

on any Prisma operation for

create

(

update

and

delete

work). We’re on Heroku Postgres and use a staging database for these Preview deploys. We aren't sure what part of the stack is producing this error. Could it be something with the how the domain is randomly generated for these deploys and not our main domain? Everything works as expected locally. Longer error in thread

fondfolio

09/12/2020, 11:33 PM

Copy code

PrismaClientUnknownRequestError: Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: Db, cause: Some(DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState("42501"), message: "permission denied for table User", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("aclchk.c"), line: Some(3489), routine: Some("aclcheck_error") }) }) })
    at PrismaClientFetcher.request (/var/task/node_modules/@prisma/client/runtime/index.js:1:228459)
    at processTicksAndRejections (internal/process/task_queues.js:97:5)

janpio

09/12/2020, 11:43 PM

The error message indicates that the credentials you are using can not access the table

User

janpio

09/12/2020, 11:44 PM

Can you use the same credentials locally to connect to the domain and create data in that table?

fondfolio

09/13/2020, 5:35 PM

Thanks @janpio after a bit more digging we realized that our staging Db was full so wasn't allowing new entities to be created

janpio

09/14/2020, 11:01 AM

Interesting that this reflected in this error message - not really that obvious.

➕ 1

3 Views

Open in Slack

Previous Next