Hi Konstantin,
Thanks for prompt reply. Server.xml contains following resource.
<Resource name="jdbc/xxxxxxxxServer"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
testOnBorrow="true"
testOnReturn="false"
validationQuery="SELECT 1 FROM DUAL"
validationInterval="30000"
timeBetweenEvictionRunsMillis="30000"
maxActive="500"
minIdle="10"
maxWait="20000"
initialSize="10"
removeAbandonedTimeout="200"
removeAbandoned="true"
logAbandoned="true"
logValidationErrors="true"
minEvictableIdleTimeMillis="30000"
abandonWhenPercentageFull="0"
jmxEnabled="true"
accessToUnderlyingConnectionAllowed="true"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;
org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;
org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer"
username="xxxxxxxxxx"
password="xxxxxxxxxx"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//172.16.xx.xx:1526/xxdb"/>
We are having Apache web server (2.2) which sends request to tomcat and when
tomcat communicates with database it creates close_wait.
Best Regards,
Prashant Kaujalgi
-----Original Message-----
From: Konstantin Kolinko [mailto:knst.koli...@gmail.com]
Sent: Thursday, January 07, 2016 12:15 PM
To: Tomcat Users List
Subject: Re: close_wait in Tomcat 7.0.63
2016-01-07 9:36 GMT+03:00 Prashant Kaujalgi <prashant.kauja...@e-nxt.com>:
> Dear Team,
>
>
>
> First of all, I want to apologies if there is a well known fix to my
> problem.
>
>
>
> Environment:
>
> OS: Windows server 2008
>
> Tomcat application server: Apache Tomcat 7.0.63
>
> Web server : Apache 2.2
>
> JRE build : jdk1.6.0_23
>
> Connection pooling: Tomcat jdbc connection pooling (Tomcat-jdbc.jar)
>
>
>
> We are having web based application hosted on Tomcat 7. We are facing
> close_wait issue between tomcat and database
>
> server. After certain time period close_wait count increases and
> reaches threshold (maxActive="500") after which tomcat was unable to
> create new thread and we have to restart the service.
>
>
>
> Our observation is that Oracle closes the connection and Tomcat is not
> able to close the same connection and hence resulting in close_wait
>
>
>
> Below is the sample netstat when CLOSE_WAIT was there. Application
> server is
> 192.168.15.109 with 219 database server listing on 1527 port.
>
>
>
> TCP 192.168.xx.xx:51588 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51621 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51622 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51623 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51632 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51647 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51648 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51658 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51659 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51691 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51699 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51705 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51706 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51722 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51724 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51725 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51744 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51805 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
> TCP 192.168.xx.xx:51807 172.16.xx.xx:1527 CLOSE_WAIT 3812
>
What is your actual configuration?
Also,
https://bz.apache.org/bugzilla/show_bug.cgi?id=58610#c2
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
Disclaimer & Privilege Notice: This e-Mail may contain proprietary, privileged
and confidential information and is sent for the intended recipient(s) only.
If, by an addressing or transmission error, this mail has been misdirected to
you, you are requested to notify us immediately by return email message and
delete this mail and its attachments. You are also hereby notified that any
use, any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication of this e-mail message, contents
or its attachment(s) other than by its intended recipient(s) is strictly
prohibited. Any opinions expressed in this email are those of the individual
and may not necessarily represent those of e-Nxt Financials Ltd. Before opening
attachment(s), please scan for viruses.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
