Announcement Announcement Module
Collapse
No announcement yet.
Protocol violation causing OutOfMemoryError: Java heap space Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Protocol violation causing OutOfMemoryError: Java heap space

    Hi,

    I have a web application that is calling a transactional method that itself calls multiple stored procedures.
    All is working well, however I am getting the following exception thrown in the logs every few weeks.
    Exception <Could not roll back JDBC transaction; nested exception is java.sql.SQLException: Protocol violation>
    After this exception is thrown, the following error occurs soon afterwards and brings down the application:
    java.lang.OutOfMemoryError: Java heap space

    I have provided a fuller stacktrace below.
    I have searched the internet and learned that the rollback violation can occur when you have multiple layers of transactional methods and the deeper one throws an exception.
    This isn't the case for our app however. We don't have nested transactional methods.
    Does anybody have any idea what could be causing this.
    Any help would really be appreciated.

    Thanks.


    2014-03-23 01:48:56 INFO anonymousUser - ProcedureClass:122 - ProcedureClass.executeProc Finish
    2014-03-23 01:48:56 ERROR anonymousUser - TransactionInterceptor:496 - Application exception overridden by rollback exception
    java.lang.OutOfMemoryError: Java heap space
    2014-03-23 01:48:56 ERROR anonymousUser - TransactionInterceptor:496 - Application exception overridden by rollback exception
    java.lang.OutOfMemoryError: Java heap space
    2014-03-23 01:48:56 ERROR anonymousUser - TransactionInterceptor:496 - Application exception overridden by rollback exception
    java.lang.OutOfMemoryError: Java heap space
    2014-03-23 01:48:56 ERROR anonymousUser - ExceptionController:29 - package.PublicClass.handleException: Exception <Could not roll back JDBC transaction; nested exception is java.sql.SQLException: Protocol violation: [1]>
    2014-03-23 01:48:56 ERROR anonymousUser - ExceptionController:29 - package.PublicClass.handleException: Exception <Could not roll back JDBC transaction; nested exception is java.sql.SQLException: Protocol violation: [1]>
    2014-03-23 01:48:56 ERROR anonymousUser - ExceptionController:29 - package.PublicClass.handleException: Exception <Could not roll back JDBC transaction; nested exception is java.sql.SQLException: Protocol violation: [1]>

    ..
    ..
    ..

    2014-03-23 23:48:14 ERROR anonymousUser - ExceptionController:29 - package.PublicClass.handleException: Exception <Could not roll back JDBC transaction; nested exception is java.sql.SQLException: Protocol violation>
    2014-03-23 23:48:14 INFO anonymousUser - ProcedureClass:122 - ProcedureClass.executeProc Finish
    2014-03-23 23:48:14 ERROR anonymousUser - TransactionInterceptor:496 - Application exception overridden by rollback exception
    org.springframework.jdbc.UncategorizedSQLException : CallableStatementCallback; uncategorized SQLException for SQL [{? = call FUNCTION_NAME(?)}]; SQL state [99999]; error code [17401]; Protocol violation: [32]; nested exception is java.sql.SQLException: Protocol violation: [32]
    at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:83)
    at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:1036)
    at org.springframework.jdbc.core.JdbcTemplate.call(Jd bcTemplate.java:1070)
    at org.springframework.jdbc.object.StoredProcedure.ex ecute(StoredProcedure.java:144)
    at package.Class.ourMethod(OurClass.java:118)
    at package.Class.ourMethod(OurClass.java:137)
    at sun.reflect.GeneratedMethodAccessor82.invoke(Unkno wn Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
Working...
X