Skip to content

Instantly share code, notes, and snippets.

@Sailias

Sailias/deadlock

Created July 6, 2012 14:42
Show Gist options
  • Save Sailias/3060565 to your computer and use it in GitHub Desktop.
Save Sailias/3060565 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
deadlock
PG::Error: ERROR: deadlock detected
DETAIL: Process 3929 waits for RowExclusiveLock on relation 18025 of database 17637; blocked by process 3955.
Process 3955 waits for ShareLock on transaction 43569483; blocked by process 3929.
HINT: See server log for query details.
CONTEXT: SQL statement "UPDATE ship SET prospecting=(prospecting+quantity) WHERE id=reference_id"
PL/pgSQL function "upgrade" line 103 at SQL statement
: SELECT UPGRADE(5619, 'PROSPECTING', 100) FROM "my_ships" WHERE "my_ships"."id" = 5619 LIMIT 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment