Pool connection timeout even after server restart
Deepa Durdi, December 06, 2023 - 7:03 am UTC
Hello,
In continuation with my previous question, the pool connection timeout is still occuring.
I beg you to please look on to this issue.
Library: 19.19.0
Connection string details:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=on)(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=****)(PORT=***))(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT=***)))(CONNECT_DATA=(SERVICE_NAME=))); user id=USER_ID=**;password=**;persist security info=true;enlist=true",
Stack trace:
{"OracleLogicalTransaction":{}, "Errors":[{"DataSource":"", "Message":"Pooled connection request timed out", "Number":-1012, "ParseErrorOffset":-1, "Procedure":"", "Source":"Oracle Data Provider for .NET, Managed Driver", "ArrayBindIndex":-1}], "DataSource":"", "Message":"Pooled connection request timed out", "Procedure":"", "Source":"Oracle Data Provider for .NET, Managed Driver", "Number":-1012, "IsRecoverable":false, "ErrorCode":-2147467259, "Data":{}, "TargetSite":"PR Get(OracleInternal.ConnectionPool.ConnectionString, Boolean, Oracle.ManagedDataAccess.Client.OracleConnection, System.String, Boolean)", "StackTrace":" at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)\r\n at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)\r\n at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)\r\n at Oracle.ManagedDataAccess.Client.OracleConnection.Open()\r\n at TSISData.DbConnection.OpenConnection()",
December 07, 2023 - 6:31 am UTC
If you head into Windows performance monitor, the ODP.NET driver should record statistics such as
NumberOfActiveConnectionPools
NumberOfActiveConnections
NumberOfFreeConnections
NumberOfInactiveConnectionPools
NumberOfNonPooledConnections
NumberOfPooledConnections
NumberOfReclaimedConnections
NumberOfStasisConnections
Compare those with how you have configured the min/max pool size for your connection pool