DataSource got Suspended as Complete Number of Defined Datasource Connections Were Not Created Resource. Resource Pool "DataSourceName" suspending due to number of resource creation or test failures exceeding threshold of 2 (Doc ID 2243316.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.

Symptoms


Datasource is targeted at a cluster and it is successfully created for first node being started, but it gets suspended when creating the connection pool in second node of the cluster.

Below exception can be seen in the failing server's standard out log just after a number of connections are created.


...
<Jan 20, 2017 1:30:05 PM EST> <Info> <Common> <BEA-000626> <Free resources in pool "DataSourceName" will be tested every "60" seconds.>
<Jan 20, 2017 1:30:10 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:11 PM EST> <Info> <JDBC> <BEA-001516> <Data source connection pool "DataSourceName" connected to Database: "Oracle", Version: "Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options".>
<Jan 20, 2017 1:30:11 PM EST> <Info> <JDBC> <BEA-001517> <Data source connection pool "DataSourceName" using Driver: "Oracle JDBC driver", Version: "11.2.0.3.0".>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:12 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:13 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:13 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:13 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:13 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:13 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:13 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:13 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:13 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:13 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
...
<Jan 20, 2017 1:30:17 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:17 PM EST> <Info> <JDBC> <BEA-001072> <Connection for XA pool "DataSourceName" created.>
<Jan 20, 2017 1:30:17 PM EST> <Info> <JDBC> <BEA-001132> <Initialized statement cache of size "10" for connection in pool "DataSourceName".>
<Jan 20, 2017 1:30:19 PM EST> <Info> <Common> <BEA-000633> <Resource Pool "DataSourceName" suspending due to number of resource creation or test failures exceeding threshold of 2>
<Jan 20, 2017 1:31:03 PM EST> <Info> <JDBC> <BEA-001508> <Destroying data source connection pool DataSourceName.>
<Jan 20, 2017 1:31:03 PM EST> <Info> <JDBC> <BEA-001155> <The following exception has occurred:

weblogic.common.ResourceException: Unknown Data Source DataSourceName
at weblogic.jdbc.common.internal.ConnectionPoolManager.shutdownConnectionPool(ConnectionPoolManager.java:622)
at weblogic.jdbc.common.internal.ConnectionPoolManager.shutdownAndDestroyPool(ConnectionPoolManager.java:594)
at weblogic.jdbc.common.internal.ConnectionPoolManager.shutdownAndDestroyPool(ConnectionPoolManager.java:520)
at weblogic.jdbc.module.JDBCModule.prepare(JDBCModule.java:320)
at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:517)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:159)
at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:45)
at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:648)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:191)
at weblogic.application.internal.SingleModuleDeployment.prepare(SingleModuleDeployment.java:44)
at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:60)
at weblogic.deploy.internal.targetserver.SystemResourceDeployment.prepare(SystemResourceDeployment.java:55)
at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:39)
at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:191)
at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:21)
at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)
at weblogic.management.deploy.internal.ConfiguredDeployments.prepare(ConfiguredDeployments.java:165)
at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:122)
at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:180)
at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:96)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
>

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms