4 Replies Latest reply on Jan 4, 2013 7:32 PM by Stephen Coy

    Jboss connection pool has high TotalBlockingTime

    Eric Neilsen Newbie

      I have a lot of blocked threads all on this stacktrace:

       

      Stack Trace:

      org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getConnectionProperties(BaseWrapperManagedConnectionFactory.java:1005)
      org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:490)
      org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:282)
      org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)
      org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)
      org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)
      org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
      org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
      org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)

       

      Not all of the connections are handed out, yet I see a lot of wait time trying to get a connection to the db.

      statistics.pool.ActiveCount60
      statistics.pool.AvailableCount46
      statistics.pool.AverageBlockingTime33731
      statistics.pool.AverageCreationTime756
      statistics.pool.CreatedCount79
      statistics.pool.DestroyedCount19
      statistics.pool.MaxCreationTime2310
      statistics.pool.MaxUsedCount60
      statistics.pool.MaxWaitTime1976
      statistics.pool.TimedOut19
      statistics.pool.TotalBlockingTime2664779
      statistics.pool.TotalCreationTime59753

       

      standalone.xml

       

      <datasources>

                      <datasource jta="false" jndi-name="java:jboss/datasource/oracle" pool-name="oracle" enabled="true" use-ccm="false">

                          <connection-url>jdbc:oracle:thin:@//produt-scan.ora.ut.us.attask.com/cl2load</connection-url>

                          <driver-class>oracle.jdbc.OracleDriver</driver-class>

                          <driver>oracle</driver>

                          <pool>

                              <min-pool-size>20</min-pool-size>

                              <max-pool-size>60</max-pool-size>

                              <prefill>true</prefill>

                          </pool>

                          <security>

                              <security-domain>encryptedoracle-ds</security-domain>

                          </security>

                          <validation>

                              <validate-on-match>false</validate-on-match>

                              <background-validation>false</background-validation>

                          </validation>

                          <statement>

                              <prepared-statement-cache-size>10</prepared-statement-cache-size>

                              <share-prepared-statements>true</share-prepared-statements>

                          </statement>

                      </datasource>