I've a EAR deployed on WAS 22.214.171.124. The application is build using Spring 3.1 and JPA 2.0 and the JPA provider is Hibernate. This application was working without any issues until we upgraded WAS from 126.96.36.199 to 188.8.131.52. After upgrade I started getting an exception as below:
1/19/12 12:55:50:732 EST] 00000073 PoolManager W Exceeded the number of allowable managed connection on thread 00000073. 1 managed connections are already being used on this thread. Managed connection being used on this thread MCWrapper id 1810181 Managed connection WSRdbManagedConnectionImpl@3bf73bf7 State:STATE_TRAN_WRAPPER_INUSE Thread Id: 00000073 Thread Name: WebContainer : 6 Handle count 0
Start time inuse Thu Jan 19 12:55:49 EST 2012 Time inuse 1 (seconds)
Last allocation time Thu Jan 19 12:55:50 EST 2012 getConnection stack trace information:
A) Is it possible to configure the WAS to increase the allowed size to more than 1.
B) Is this a fix add to 184.108.40.206 to warn about potential connection leak
C) If the application is designed such that web layer (controller) makes database calls (read only) in addition to database calls (Read/Write) at the service layer in such a scenario we would assume we would have more than one connection inolved per thread. Is there a database property to supress this check which is causing the above exception
Pinned topic Configure Allowable Managed Database Connections for a thread
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-05T08:11:33Z at 2012-06-05T08:11:33Z by dhinckle
JamesStephens 120000P3A21 Post
Re: Configure Allowable Managed Database Connections for a thread2012-01-20T16:52:58ZThis is the accepted answer. This is the accepted answer.Yes, custom pool property maxNumberOfMCsAllowableInThread can be set to a higher value. Go to Data sources > your Datasource or connection factory > Connection pools > Custom properties. Create the new custom pool property setting it to the value you wish.
The warning being generated is for detecting unexpected managed connection usage on a thread during the development of an application or in production environments which are using more managed connections then expected.
Since this is expected behavior for your application to use more then one managed connection per thread, you should only see this warning if trace is enabled or maxNumberOfMCsAllowableInThread is set.
If this warning is occurring unexpectedly, please create a PMR and we will provide a fix to remove this warning. Until a fix can be provided, a temporary work around to the warning is to set maxNumberOfMCsAllowableInThread to a high value like 10.
JaySoko 0100000R9C1 Post
Re: Configure Allowable Managed Database Connections for a thread2012-01-24T23:07:07ZThis is the accepted answer. This is the accepted answer.FYI, I just enabled SIB for one of my clusters and I'm receiving the same error message. The application is an off-the-shelf product from a large company, and their consultant did not experience these errors in previous deployments on WAS 220.127.116.11 or 18.104.22.168. I only mention this because I, too, am running WAS ND 22.214.171.124. I'll enter a PMR to double check I haven't made mistakes elsewhere in my configuration which may be causing this error.
vincent75 27000574FS1 Post
Re: Configure Allowable Managed Database Connections for a thread2012-03-27T09:19:30ZThis is the accepted answer. This is the accepted answer.Same issue here, we use the default workmanager, I configured the custom property but did not took it into account, that one have no reference anywhere on the web.
Any news with your PMR ?
dhinckle 270000NQ6F1 Post
Re: Configure Allowable Managed Database Connections for a thread2012-06-05T08:11:33ZThis is the accepted answer. This is the accepted answer.
- JamesStephens 120000P3A2