I am using PG 8.1.4, and my server was stop service, and when I checked the log, I found that some process had locked pg_listener in ExclusiveLock, it blocked all of the following processes which use NOTIFY/LISTEN. Can anyone tell me why pg_listener is locked forever?
Before that there are two deadlock detected Jan 9 08:10:40 SUC01 postgres[19767]: [2-1] ERROR: deadlock detected Jan 9 08:10:40 SUC01 postgres[19767]: [2-2] DETAIL: Jan 9 08:12:32 SUC01 postgres[19767]: [3-1] ERROR: deadlock detected Jan 9 08:12:32 SUC01 postgres[19767]: [3-2] DETAIL: Jan 9 08:12:32 SUC01 postgres[19767]: [3-3] STATEMENT: UNLISTEN LABD11