Postgres Pro
Downloads
Home   >   mailing lists

Abort() doesn't abort backends which are in WAITING state - Mailing list pgsql-jdbc

From Sudalai
Subject Abort() doesn't abort backends which are in WAITING state
Date
Msg-id 1511190321680-0.post@n3.nabble.com
Whole thread Raw
Responses Re: Abort() doesn't abort backends which are in WAITING state  (rob stone <floriparob@gmail.com>)
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: Stephen Frost
Date:
Subject: Migration to PGLister - After
Next
From: rob stone
Date:
Subject: Re: Abort() doesn't abort backends which are in WAITING state