CODEWITHSUNDEEP
databasepostgresqldatabase-deadlocks
vjcalling
vjcalling

Reputation: 45

update transaction stuck from last few days in postgres

update transaction is stuck from last few days in postgres 9.2. Select on pg_locks shows one ShareLock granted is false. I have not added any explicit locks around my script. Any idea how to fix this?

Upvotes: 0

Views: 1080

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 248075

The transaction must be waiting on a lock that is held by another open transaction that is either active or idle in transaction.

Terminate that transaction and the hanging transaction will be able to proceed.

Upvotes: 1

Related Questions