skip to main content
Troubleshooting : Troubleshooting connection pooling : Pool Manager Trace file example
  

Try DataDirect Drivers Now

Pool Manager Trace file example

The following example shows a DataDirect Connection Pool Manager trace file. Notes provide explanations for the referenced text to help you understand the content of your own Pool Manager trace files.
jdbc/AutoRESTNCMarkBPool: *** ConnectionPool Created1
(jdbc/AutoRESTNCMarkBPool2,
com.ddtek.jdbcx.autorest.AutoRESTDataSource@1835282, 5, 5, 10, https://example.com/countries/)3
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 0.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.

jdbc/AutoRESTNCMarkBPool: Enforced minimum!4
NrFreeConnections was: 0
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 5.

jdbc/AutoRESTNCMarkBPool: Reused free connection.5
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 4.

jdbc/AutoRESTNCMarkBPool: Reused free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 3.

jdbc/AutoRESTNCMarkBPool: Reused free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 2.

jdbc/AutoRESTNCMarkBPool: Reused free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 1.

jdbc/AutoRESTNCMarkBPool: Reused free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.

jdbc/AutoRESTNCMarkBPool: Created new connection.6
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 6.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.

jdbc/AutoRESTNCMarkBPool: Created new connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 7.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.

jdbc/AutoRESTNCMarkBPool: Created new connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 8.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.

jdbc/AutoRESTNCMarkBPool: Created new connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 9.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.

jdbc/AutoRESTNCMarkBPool: Created new connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 10.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.

jdbc/AutoRESTNCMarkBPool: Created new connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.7
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 1.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 2.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 3.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 4.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 5.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 6.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 7.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 8.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 9.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 10.

jdbc/AutoRESTNCMarkBPool: Connection was closed and added to the cache.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 11.

jdbc/AutoRESTNCMarkBPool: Enforced minimum!8
NrFreeConnections was: 11
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 11.
jdbc/AutoRESTNCMarkBPool: Number free connections = 11.

jdbc/AutoRESTNCMarkBPool: Enforced maximum!9
NrFreeConnections was: 11
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 10.
jdbc/AutoRESTNCMarkBPool: Number free connections = 10.

jdbc/AutoRESTNCMarkBPool: Enforced minimum!
NrFreeConnections was: 10
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 10.
jdbc/AutoRESTNCMarkBPool: Number free connections = 10.

jdbc/AutoRESTNCMarkBPool: Enforced maximum!
NrFreeConnections was: 10
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 10.
jdbc/AutoRESTNCMarkBPool: Number free connections = 10.

jdbc/AutoRESTNCMarkBPool: Enforced minimum!
NrFreeConnections was: 10
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 10.
jdbc/AutoRESTNCMarkBPool: Number free connections = 10.

jdbc/AutoRESTNCMarkBPool: Enforced maximum!
NrFreeConnections was: 10
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 10.
jdbc/AutoRESTNCMarkBPool: Number free connections = 10.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.10
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 9.
jdbc/AutoRESTNCMarkBPool: Number free connections = 9.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 8.
jdbc/AutoRESTNCMarkBPool: Number free connections = 8.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 7.
jdbc/AutoRESTNCMarkBPool: Number free connections = 7.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 6.
jdbc/AutoRESTNCMarkBPool: Number free connections = 6.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 5.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 4.
jdbc/AutoRESTNCMarkBPool: Number free connections = 4.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 3.
jdbc/AutoRESTNCMarkBPool: Number free connections = 3.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 2.
jdbc/AutoRESTNCMarkBPool: Number free connections = 2.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 1.
jdbc/AutoRESTNCMarkBPool: Number free connections = 1.

jdbc/AutoRESTNCMarkBPool: Dumped free connection.
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 0.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.

jdbc/AutoRESTNCMarkBPool: Enforced minimum!11
NrFreeConnections was: 0
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 5.

jdbc/AutoRESTNCMarkBPool: Enforced maximum!
NrFreeConnections was: 5
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 5.

jdbc/AutoRESTNCMarkBPool: Closing a pool of the group
jdbc/AutoRESTNCMarkBPool12
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 5.
jdbc/AutoRESTNCMarkBPool: Number free connections = 5.

jdbc/AutoRESTNCMarkBPool: Pool closed13
jdbc/AutoRESTNCMarkBPool: Number pooled connections = 0.
jdbc/AutoRESTNCMarkBPool: Number free connections = 0.
1 The Pool Manager creates a connection pool.

2 The JNDI name used to look up the connection pool

3 The DataSource class associated with the connection pool followed by the initial pool size, the minimum pool size, the maximum pool size, and the user name.

4 The Pool Manager checks the pool size. Because the minimum pool size is five connections, the Pool Manager creates new connections to satisfy the minimum pool size.

5 The driver requests a connection from the connection pool. The driver retrieves an available connection.

6 The driver requests a connection from the connection pool. Because a connection is unavailable, the Pool Manager creates a new connection for the request.

7 A connection is closed by the application and returned to the connection pool.

8 The Pool Manager checks the pool size. Because the number of connections in the connection pool is greater than the minimum pool size, five connections, no action is taken by the Pool Manager.

9 The Pool Manager checks the pool size. Because the number of connections in the connection pool is greater than the maximum pool size, 10 connections, a connection is closed and discarded from the pool.

10 The Pool Manager detects that a connection was idle in the connection pool longer than the maximum idle timeout. The idle connection is closed and discarded from the pool.

11 The Pool Manager detects that the number of connections dropped below the limit set by the minimum pool size, five connections. The Pool Manager creates new connections to satisfy the minimum pool size.

12 The Pool Manager closes one of the connection pools in the pool group. A pool group is a collection of pools created from the same PooledConnectionDataSource call. Different pools are created when different user IDs are used to retrieve connections from the pool. A pool group is created for each user ID that requests a connection. In our example, because only one user ID was used, only one pool group is closed.

13 The Pool Manager closed all the pools in the pool group. The connection pool is closed.