Massive performance problems with JBoss EAP 6.3.3 and Oracle DB 11.2.0.4.0 EE 64-bit.

Solution Verified - Updated -

Issue

  • Massisver Performance Problem with JBoss EAP 6.3.3 und Oracle DB 11.2.0.4.0 EE 64-bit. JBoss EAP 6.3.3 und Oracle DB 11.2.0.4.0 EE 64-bit are on the same server.
  • When a batch job which is implemented in the application runs the CPU usage of java rises to 100% for up to 15-20 minutes. During this time the server almost freezes and the clients, using for instance Internet Explorer do not get any pages displayed. As soon as the batch work is finished everything runs normal again.
  • Here is an excerpt from server.log by JBoss:
 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] () IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection

Caused by: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] () javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/TestDS

 org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection

 INFO  [stdout] () Caused by: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress

NFO  [org.hibernate.engine.internal.StatisticalLoggingSessionEventListener] Session Metrics {
    2256175 nanoseconds spent acquiring 1 JDBC connections;
    0 nanoseconds spent releasing 0 JDBC connections;
    1898115 nanoseconds spent preparing 86 JDBC statements;
    21678752 nanoseconds spent executing 86 JDBC statements;
    0 nanoseconds spent executing 0 JDBC batches;
    0 nanoseconds spent performing 0 L2C puts;
    0 nanoseconds spent performing 0 L2C hits;
    0 nanoseconds spent performing 0 L2C misses;
    0 nanoseconds spent executing 0 flushes (flushing a total of 0 entities and 0 collections);
    6831 nanoseconds spent executing 2 partial-flushes (flushing a total of 0 entities and 0 collections)
}
 INFO  [org.hibernate.engine.internal.StatisticalLoggingSessionEventListener] Session Metrics {
    98411 nanoseconds spent acquiring 1 JDBC connections;
    0 nanoseconds spent releasing 0 JDBC connections;
    0 nanoseconds spent preparing 0 JDBC statements;
    0 nanoseconds spent executing 0 JDBC statements;
    0 nanoseconds spent executing 0 JDBC batches;
    0 nanoseconds spent performing 0 L2C puts;
    0 nanoseconds spent performing 0 L2C hits;
    0 nanoseconds spent performing 0 L2C misses;
    0 nanoseconds spent executing 0 flushes (flushing a total of 0 entities and 0 collections);
    0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)

09:40:50,036 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ) javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/TestDS
 Step 'TaskDequeueStep.Step': org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 6.3.3

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.