commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Radhika Zawar (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DBCP-353) When DB Restarts(Bounce) the number ESTABLISHED DB connections exceeds its maximum configured limit.
Date Fri, 11 Feb 2011 09:25:02 GMT

    [ https://issues.apache.org/jira/browse/DBCP-353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12993408#comment-12993408
] 

Radhika Zawar commented on DBCP-353:
------------------------------------

dbcp version - commons-dbcp-1.2.2
pool version - commons-pool-1.3

We are counting connections using command

netstat -an | grep <host>.1521 | grep ESTABLISHED | wc -l

--------------

Following are the actual steps that were performed
1. Run the load

 bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
     100
2 . Shutdown DB
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
       3
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
       0
3. start DB

bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
      77
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
      77
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
      83
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
     112
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
     133
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
     154
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
     191
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
     128
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
     128
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
     129
bash-3.00# netstat -an | grep 1521 | grep  ESTABLISHED | wc -l
     128


 


> When DB Restarts(Bounce) the number ESTABLISHED DB connections exceeds its maximum configured
limit.
> ----------------------------------------------------------------------------------------------------
>
>                 Key: DBCP-353
>                 URL: https://issues.apache.org/jira/browse/DBCP-353
>             Project: Commons Dbcp
>          Issue Type: Bug
>            Reporter: Radhika Zawar
>
> We have set Max connections configuration to 100. There was heavy load on application.
When we restarted DB in between, number of connections exceeds from 100 to 200,250...

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message