wood burning stoves*
The moose likes BEA/Weblogic and the fly likes Connection pool bringing the managed server down. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Connection pool bringing the managed server down." Watch "Connection pool bringing the managed server down." New topic
Author

Connection pool bringing the managed server down.

Praveen RajKumar
Greenhorn

Joined: Aug 23, 2012
Posts: 6
Hi,

We are using WL8 to deploy our applications.Soon we are going to migrating to 10.x.
Here my problem is we have a connection pool in wl8 server whose allowed connections limit is 40.
Whenever it reaches the count of 40 it is bringing the managed server down.
So to eradicate this issue we are daily monitoring the connections count and restarting managed server as and when it reaches 30.

So,to minimize our efforts we thought to write a script which will calculate the connection count on hourly basis,and restart the managed server when the connection count reached to 30.

What will be the best option for this problem.

thanks
Praveen
sudipto shekhar
Ranch Hand

Joined: Apr 02, 2008
Posts: 813

Praveen RajKumar wrote:Hi,

Whenever it reaches the count of 40 it is bringing the managed server down.



Hi Praveen,

Can you tell me what do you mean by bringing the managed server down? Who is bringing the server down?

What do you see in the server and diagnostic logs? Is there is any exception related to connection pool, memory that you see before shutdown is initiated?

What kind of shutdown is this, graceful or forced? Server logs at the time of shutdown is required to triage further !


Regards, Sud.
SCJP 5 ScjpFAQ JLS
Joseph Antoine Raja
Ranch Hand

Joined: Feb 01, 2010
Posts: 32
since you have mentioned that the migration has happened to WL 10.x . I am guessing that the issue is currently with WL10.x domain.

In normal case when the db pool reaches the max limit (in your case 40) it use to throw [Resource unavailable] exception when the connection request arrived . and then the db pool will be put into Overloaded state

but I'm not sure why it kills the wl server .

please check the server logs while the server is going down . to find the root cause for the shutdown . Wl server usualy says something like this in the logs

<shutdown requsted by <user> > / <JVM called shutdown hook>

the first one is normal shutdown issued by any user . the second one is a JVM overload issue (OOM/Stuck Thread...)

if possible trigger a thread dump during the issue .
Praveen RajKumar
Greenhorn

Joined: Aug 23, 2012
Posts: 6
Hi,

Thanks for your responses.
We are yet to migrate this server to 10.x.

Surely i will go through the logs to identify the issue.

Here my intention is to get the connection pool active connections count through a script which will elaborate my coding skills.

We have another option to increase the connection pool max limit but we are trying to write a script rather identify the issue.
Infact,In this environment we have 1 admin and 6 managed server out of which we monitor only admin and one managed server which we are talking now.

thanks
Praveen
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection pool bringing the managed server down.
 
Similar Threads
Connection Pool issue in Weblogic 8.1 SP5
Transaction time out problem on WAS 5.1.1
DB Connection Pool refresh
Connection Pool Problem in weblogic 9.2 MP3
Best way to track down connection leak