0 Replies
10 days ago
53295 active advisory 2025-11-26 18:55:53.041143+00 SELECT pg_advisory_lock(72707369)
53301 active 2025-11-26 18:57:42.217225+00 "SELECT pid, state, wait_event, query_start, query
FROM pg_stat_activity
WHERE query LIKE '%pg_advisory_lock%';"
53249 active advisory 2025-11-26 18:45:16.019049+00 SELECT pg_advisory_lock(72707369)
53290 active advisory 2025-11-26 18:54:55.839654+00 SELECT pg_advisory_lock(72707369)
53256 active advisory 2025-11-26 18:46:31.386732+00 SELECT pg_advisory_lock(72707369)
53238 active advisory 2025-11-26 18:43:22.702289+00 SELECT pg_advisory_lock(72707369)10 days ago
My database is blocking, and I can't run Prisma migrations. How can I fix this? I've never had this problem before.
10 days ago

10 days ago
advsory locks are made on the application level afaik
10 days ago
I wonder if prisma activated a lock but I've also never seen this
10 days ago
10 days ago
Is this locally? On your machine?
10 days ago
on railway
10 days ago

10 days ago
Check your service db credentials because Prisma has some explicit errors when tables are locked
10 days ago
You can try manually removing the locks by using a DB Client like DBeaver, Beeekeeper…
10 days ago
Make sure to have backups in place before doing so.
10 days ago
I solved the problems; it was something in the prism causing a lock.
Status changed to Solved medim • 10 days ago