Database lock
luccabassoli
PROOP

10 days ago

My database showing lock

Solved$10 Bounty

0 Replies

luccabassoli
PROOP

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)
luccabassoli
PROOP

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.

medim
MODERATOR

10 days ago

advsory locks are made on the application level afaik

medim
MODERATOR

10 days ago

I wonder if prisma activated a lock but I've also never seen this

medim
MODERATOR

10 days ago

Is this locally? On your machine?

luccabassoli
PROOP

10 days ago

on railway

medim
MODERATOR

10 days ago

Check your service db credentials because Prisma has some explicit errors when tables are locked

medim
MODERATOR

10 days ago

You can try manually removing the locks by using a DB Client like DBeaver, Beeekeeper…

medim
MODERATOR

10 days ago

Make sure to have backups in place before doing so.

luccabassoli
PROOP

10 days ago

I solved the problems; it was something in the prism causing a lock.

Status changed to Solved medim • 10 days ago

Loading...