`npx prisma migrate dev --name v1` fails with "There are 2 other sessions using the database."

Cloud Integrations Prisma
1

Hi team,

I have following setup

.env

DATABASE_URL="postgres://yuyokk:XXXXXX@ep-frosty-voice-34243734-pooler.us-east-1.aws.neon.tech/prisma-poc?pgbouncer=true"

Whenever I run npx prisma migrate dev --name v1 it fails with following error

Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database "prisma-poc", schema "public" at "ep-frosty-voice-34243734-pooler.us-east-1.aws.neon.tech"

Error: db error: ERROR: database "prisma_migrate_shadow_db_0d9a0f9f-e1e0-48d0-9cc1-d0e52c78d3fc" is being accessed by other users
DETAIL: There are 2 other sessions using the database.
   0: schema_core::state::DevDiagnostic
             at schema-engine/core/src/state.rs:270

Not sure what I do wrong here. Any help is appreciated.
Thank you

2

hi yuyokk. Did you fix this error? I have the same now and stuck with it

3

Hey @Jan_K, are you still running into this issue?

4

Check out Using prisma migate to update prod db schema · vercel · Discussion #4023 · GitHub.