On Sat, Nov 22, 2014 at 4:03 PM, Dhaval Jaiswal
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
>
> Was it work
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.
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 connection
yes. the thread is stucked and started increasing load of the server.
My configuration is as below. Query is fetching one row only.
On Sat, Nov 22, 2014 at 1:29 AM, Ameer Mawia wrote:
> Jaiswal, what your exact question is?
>
> Obviously in your application, you need a DB connec
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 va
Following thread stuck and increased the load.
java.net.SocketInputStream.read(SocketInputStream.java:129)
org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:145)
org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:1
Below thread stucked and increased the load.
java.net.SocketInputStream.read(SocketInputStream.java:129)
org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:145)
org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:114
