Topic
  • No replies
blainemeyer@us.ibm.com
1 Post

Pinned topic J2CA0046E error when server is stopped

‏2013-09-27T14:33:54Z |

We recently updated our version of Liberty Profile to :

   WebSphere Application Server Version 8.5.5.0 Liberty Profile - (8.5.5.0-20130608-1425)

and are seeing the following exception in the console.log file when we issue a "./server stop Unity" , Unity is our application, to stop the server:

[ERROR   ] J2CA0046E: Method reserve caught an exception during creation of the ManagedConnection for resource jdbc/derbyClient, throwing ResourceAllocationException. Original exception: Failed preTestConnection. Pool requests blocked until the test connection thread is successful.
[err] java.sql.SQLException: Failed preTestConnection. Pool requests blocked for jdbc/derbyClient until the test connection thread is successful.
[err]     at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1333)
[err]     at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:368)
[err]     at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:440)
[err]     at com.ibm.tivoli.unity.DAOLayer.DBPooledConnectionFactory.getPooledConnection(DBPooledConnectionFactory.java:74)
[err]     at com.ibm.tivoli.unity.handlers.AbstractHandler.getConnection(AbstractHandler.java:449)
[err]     at com.ibm.tivoli.unity.handlers.StatisticsTrackerHandler.statisticExists(StatisticsTrackerHandler.java:284)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerManager.statisticExists(StatisticsTrackerManager.java:884)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerConsumer.doWork(StatisticsTrackerConsumer.java:136)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerConsumer.processQueue(StatisticsTrackerConsumer.java:94)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerConsumer.run(StatisticsTrackerConsumer.java:71)
[err] Caused by:
[err] javax.resource.spi.ResourceAllocationException: Failed preTestConnection. Pool requests blocked for jdbc/derbyClient until the test connection thread is successful.
[err]     at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2620)
[err]     at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2325)
[err]     at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1285)
[err]     at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:852)
[err]     at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:354)
[err]     ... 8 more
[ERROR   ] J2CA0046E: Method reserve caught an exception during creation of the ManagedConnection for resource jdbc/derbyClient, throwing ResourceAllocationException. Original exception: Failed preTestConnection. Pool requests blocked until the test connection thread is successful.
[err] java.sql.SQLException: Failed preTestConnection. Pool requests blocked for jdbc/derbyClient until the test connection thread is successful.
[err]     at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1333)
[err]     at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:368)
[err]     at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:440)
[err]     at com.ibm.tivoli.unity.DAOLayer.DBPooledConnectionFactory.getPooledConnection(DBPooledConnectionFactory.java:74)
[err]     at com.ibm.tivoli.unity.handlers.AbstractHandler.getConnection(AbstractHandler.java:449)
[err]     at com.ibm.tivoli.unity.handlers.StatisticsTrackerHandler.getDAO(StatisticsTrackerHandler.java:65)
[err]     at com.ibm.tivoli.unity.handlers.StatisticsTrackerHandler.statisticExists(StatisticsTrackerHandler.java:288)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerManager.statisticExists(StatisticsTrackerManager.java:884)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerConsumer.doWork(StatisticsTrackerConsumer.java:136)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerConsumer.processQueue(StatisticsTrackerConsumer.java:94)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerConsumer.run(StatisticsTrackerConsumer.java:71)
[err] Caused by:
[err] javax.resource.spi.ResourceAllocationException: Failed preTestConnection. Pool requests blocked for jdbc/derbyClient until the test connection thread is successful.
[err]     at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2620)
[err]     at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2325)
[err]     at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1285)
[err]     at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:852)
[err]     at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:354)
[err]     ... 9 more
[err] Exception in thread "Thread-59"
[err] java.lang.NullPointerException
[err]     at com.ibm.tivoli.unity.DAOLayer.AbstractDAO.<init>(AbstractDAO.java:53)
[err]     at com.ibm.tivoli.unity.DAOLayer.StatisticsTrackerDAO.<init>(StatisticsTrackerDAO.java:57)
[err]     at com.ibm.tivoli.unity.handlers.StatisticsTrackerHandler.getDAO(StatisticsTrackerHandler.java:65)
[err]     at com.ibm.tivoli.unity.handlers.StatisticsTrackerHandler.statisticExists(StatisticsTrackerHandler.java:288)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerManager.statisticExists(StatisticsTrackerManager.java:884)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerConsumer.doWork(StatisticsTrackerConsumer.java:136)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerConsumer.processQueue(StatisticsTrackerConsumer.java:94)
[err]     at com.ibm.tivoli.unity.statistics.StatisticsTrackerConsumer.run(StatisticsTrackerConsumer.java:71)

we are using a very basic Derby database data source whic his configured in server.xml like this :

   <!--  Begin Derby data source configuration. -->
    <dataSource id="derbyClient" jndiName="jdbc/derbyClient" >
      <jdbcDriver libraryRef="DerbyLib"/>
      <properties.derby.client databaseName="/home/blaine/IBM/LogAnalyticsWorkgroup/database/UnityDB"  
                             serverName="unity1.tivlab.raleigh.ibm.com" portNumber="1627"/>
    </dataSource>

    <library id="DerbyLib">
      <fileset dir="/home/blaine/IBM/LogAnalyticsWorkgroup/database/db-derby-10.8.2.3-bin/lib"/>
    </library>
    <!--  End Derby data source configuration. -->