AnsweredAssumed Answered

Database Connection Issues

Question asked by CMCN1982 on Aug 12, 2015
Latest reply on Sep 9, 2015 by CMCN1982

Hi all,

 

during the last few days we have noticed a strange issue in that the application appears to lose it's connection to the database. But then it re-establishes connection after a time.

 

examples of the errors are as follows:

 

FATAL 2015-08-12 01:24:30,727 [http-bio-8080-exec-7798] union.persistence (clarity:unknown:none:union.notFound) Failed to determine analytic function support

java.lang.RuntimeException: Unexpected invocation exception: [CA Clarity][SQLServer JDBC Driver]Object has been closed.

 

FATAL 2015-08-12 01:24:30,726 [http-bio-8080-exec-7798] union.persistence (clarity:unknown:none:union.notFound)

java.sql.SQLNonTransientConnectionException: [CA Clarity][SQLServer JDBC Driver]Connection reset by peer: socket write error

 

FATAL 2015-08-12 01:24:30,728 [http-bio-8080-exec-7798] union.persistence (clarity:unknown:none:union.notFound) Failed to retrieve database version

java.lang.RuntimeException: Unexpected invocation exception: [CA Clarity][SQLServer JDBC Driver]Object has been closed.

 

[http-bio-8080-exec-7512] union.persistence (clarity:none:none:none)

java.sql.SQLNonTransientConnectionException: [CA Clarity][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.

 

 

 

In the past I have seen these types of errors when the db or app servers briefly lose network connectivity. But I have checked in with our network and VMware guys and they assure me that no work was taking place at the times we see the errors. It has been happening for the last 3 days now at roughly the same time (between 01:30 and 03:30)

 

Is there anything other than potential hardware/VMware issues that could explain above errors?

Outcomes