Hello, prisma's migration function does not work in Fly Postgres. I think it is occupied by users who manage the cluster, but I don't know how to suspend it.

, ,
1

I executed the command:

fly proxy 5432 -a pg

prisma migrate dev --name init

Exception thrown

Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "localhost:5432"

Error: ERROR: database "prisma_migrate_shadow_db_13cc2be0-8659-4d75-a1f5-9997855cc574" is being accessed by other users
DETAIL: There is 1 other session using the database.
2

Hi… You can use pg_stat_activity to see more about who’s present:

https://community.fly.io/t/rename-postgres-database-after-importing-from-heroku/17840/4

Is the migration attempting to rename or drop prisma_migrate_shadow_* at this point?

1 Like
3

Added dev, nodejs

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.