My Oracle Support Banner

Unable to Open Connections with Connection Pool Too Small (Doc ID 2161232.1)

Last updated on SEPTEMBER 01, 2018

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

Symptoms

On : 5.5 version, Error Messages

Unable to open connection to MySQL even though only one third of connections are used compared to max_connetcions.

 

ERROR
-----------------------

Here is the error from application (jboss eap) after mysql connection reached 558, it show error:
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/prospera
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:421)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:510)
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143)
... 53 more
Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (10000 [ms])
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:427)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:453)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:425)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:354)
... 56 more


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get full utilization of all the connections

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.