Jaiswal,
This issue is of connection between your host and postgresql server, you
are trying to connect and has nothing to do with Tomcat per say.
To debug the issue, you will have to answer few more question:
Is your postgresql server responsive?
Have you ever been able to get a valid
Is your postgresql server responsive?
Yes, there is no error logged in db server and server is very much
responsive.
Have you ever been able to get a valid connection during the lifetime of
the application?
Yes
Was it working for sometime, and then you suddenly start getting this
issue...?
Yes.
On Sat, Nov 22, 2014 at 4:03 PM, Dhaval Jaiswal dhaval.jais...@via.com
wrote:
Is your postgresql server responsive?
Yes, there is no error logged in db server and server is very much
responsive.
Have you ever been able to get a valid connection during the lifetime of
the application?
Yes
Following thread stuck and increased the load.
java.net.SocketInputStream.read(SocketInputStream.java:129)
org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:145)
Jaiswal, what your exact question is?
Obviously in your application, you need a DB connection and if this is
thread which is stuck, stack trace tells that tomcat dbcp, is trying to get
you a connection, but stuck while reading the result of validate query
which it had run before returning you a
yes. the thread is stucked and started increasing load of the server.
My configuration is as below. Query is fetching one row only.
Resource name=jdbc auth=Container type=javax.sql.DataSource
driverClassName=org.postgresql.Driver url=jdbc:postgresql
maxActive=100