Re: [GENERAL] PG9.1.2 -- 3 day old orphaned/non-responsive query -- pg_(cancel)(terminate)_backend has no effect

2012-01-14 Thread Josh Kupershmidt
On Fri, Jan 13, 2012 at 12:02 PM, Reid Thompson wrote: > The select query has been apparently orphaned by it's originating > terminal or script or application.  pg_/cancel/terminate/_backend both > return t, but the query does not cancel/terminate.   sigterm via the OS > has no effect either. Yo

[GENERAL] PG9.1.2 -- 3 day old orphaned/non-responsive query -- pg_(cancel)(terminate)_backend has no effect

2012-01-13 Thread Reid Thompson
Looking for some quidance or suggestions. PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit $ uname -a Linux db1.hw.ateb.com 2.6.32-131.21.1.el6.x86_64 #1 SMP Tue Nov 22 19:48:09 GMT 2011 x86_64 x86_64 x86_64 GNU/Linux datid| d