Re: [GENERAL] What could keep a connection / query alive?

2011-03-29 Thread Jerry Sievers
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,

Re: [GENERAL] What could keep a connection / query alive?

2011-03-29 Thread Derrick Rice
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

Re: [GENERAL] What could keep a connection / query alive?

2011-03-29 Thread Derrick Rice
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