From: | rob stone <floriparob(at)gmail(dot)com> |
---|---|
To: | Sudalai <sudalait2(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Abort() doesn't abort backends which are in WAITING state |
Date: | 2017-11-20 18:11:51 |
Message-ID: | 1511201511.5126.8.camel@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jorge Solórzano | 2017-11-20 21:42:21 | Re: Abort() doesn't abort backends which are in WAITING state |
Previous Message | Stephen Frost | 2017-11-20 15:34:02 | Re: [ADMIN] Migration to pglister - Before |