Re: Abort() doesn't abort backends which are in WAITING state

On Mon, 2017-11-20 at 08:05 -0700, Sudalai wrote:
> Dear geeks,
> 
> When we try to abort backend process which are in "WAITING STATE" via
> java.sql.Connection.abort(), socket in application server was closed,
> but
> backend process doesn't get aborted. 
> Backends get aborted only after it resources for which it waited.
> 
> Is there anyway we can abort those backend immediately?
> 
> We are using database version : 9.5.1, 9.4.0.  Driver version :
> 42.1.4 JDBC
> 42.
> 
> Thanks in advance. 
> 
> -
> Sudalai
> 
> 
> 
> -----
> sudalai
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-jdbc-f2168246
> .html
> 



Hi Sudalai,

I'm not a "geek" -- just giving my two cents worth.

java.sql.Connection.abort(Executor executor) may throw a SQLException
or a SecurityException.
Are either of these exceptions being thrown?

Are you closing the connection prior to trying the abort?

HTH,
Robert