postgresqlのデッドロック時のログ
こんなログが吐かれますよと
ERROR: deadlock detected DETAIL: Process 27840 waits for ShareLock on transaction 232876765; blocked by process 27808. Process 27808 waits for ShareLock on transaction 232876479; blocked by process 27840. postgres 4643 0.0 0.3 62376 3304 ? S Dec14 3:05 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data postgres 4645 0.0 0.0 11964 692 ? S Dec14 0:00 \_ postgres: logger process postgres 13374 0.0 5.5 62564 49976 ? S Dec14 0:00 \_ postgres: writer process postgres 13375 0.0 0.1 12964 1616 ? S Dec14 0:25 \_ postgres: stats buffer process postgres 13376 0.0 0.0 12112 776 ? S Dec14 0:17 | \_ postgres: stats collector process postgres 27808 0.0 0.4 63056 3620 ? S 13:04 0:00 \_ postgres: user db [local] idle in transaction postgres 13375 0.0 0.1 12964 1616 ? S Dec14 0:25 \_ postgres: stats buffer process postgres 13376 0.0 0.0 12112 776 ? S Dec14 0:17 | \_ postgres: stats collector process postgres 27808 0.0 0.4 63056 3620 ? S 13:04 0:00 \_ postgres: user db [local] idle in transaction postgres 28982 0.0 0.3 63056 3556 ? S 13:08 0:00 \_ postgres: user db [local] UPDATE waiting