Derrick Rice derrick.r...@gmail.com writes:
I'm investigating (using 8.2) an instance of a database client
connection remaining open in a single query well past statement
timeout settings.? I understand that severed TCP connections can cause
the backend to hang until the connection is closed,
On Tue, Mar 29, 2011 at 3:17 AM, Jerry Sievers gsiever...@comcast.netwrote:
What can cause this?? Why would these tcp and statement timeout settings
not terminate the backend?
Try trussing the backend process. You may find it in a network IO wait
trying to send data to a client that is
On Tue, Mar 29, 2011 at 2:54 PM, Derrick Rice derrick.r...@gmail.comwrote:
Try trussing the backend process. You may find it in a network IO wait
trying to send data to a client that is hung or over a socket that was
timed out by a firewall or network equipment.
Such a condition will cause