Simon Riggs wrote:
> There was another hang earlier today. One session just went idle in
> transaction on server right in the middle of a long transaction. 1500
> statements in about a second on the session, then nothing, while holding
> locks. People are adamant it is not the application; much checking has
> been done.
It's worth noting that this does not sound like the socket deadlock case.
In the socket deadlock case, the backend will be stuck in PARSE or
something similar, blocked trying to write to the JDBC client.
-O