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

From: Sudalai <sudalait2(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Abort() doesn't abort backends which are in WAITING state
Date: 2017-11-20 15:05:21
Message-ID: 1511190321680-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Achilleas Mantzios 2017-11-20 15:30:53 Re: [ADMIN] Migration to pglister - Before
Previous Message Stephen Frost 2017-11-20 14:55:52 Migration to PGLister - After