Hi, I, personnaly, search archives using : http://marc.theaimsgroup.com/?l=tomcat-user&r=1&w=2
Hope this helps, Cédric ----- Original Message ----- From: "Kapil Sharma" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Monday, March 17, 2003 5:33 PM Subject: RE: tomcat tuning > > Hi, > Please look at my tomcat confirmation below. I am having problems with > database connection now. I am getting the following errors in catalina.out > file: > java.sql.SQLException: Error while trying to retrieve text for error > ORA-12154 > > I am also unable to login to site. I get the above error. Any solutions? > > > Thanks > kapil > -----Original Message----- > From: Kapil Sharma [mailto:[EMAIL PROTECTED] > Sent: 16 March 2003 20:10 > To: Tomcat Users List > Subject: RE: tomcat tuning > > > Thanks for reply. This answers one of the problem. Another problem is db > connections. I am monitoring db connections and they are just increasing > even if there is no load on the server. The problem is tomcat is not > clearing idle connections or timing out the db connections. > I still cannot understand how tomcat work directory fill up with 6GB of > space in 24 hours. > > kapil > > -----Original Message----- > From: Filip Hanik [mailto:[EMAIL PROTECTED] > Sent: 16 March 2003 19:43 > To: Tomcat Users List > Subject: RE: tomcat tuning > > > the error is that you have a limited number of file descriptor. > so it doesn't look like your db pool is causing the problem, but your OS > configuration. > Increase the number of file descriptors for your system > > Filip > > -----Original Message----- > From: Kapil Sharma [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 16, 2003 11:04 AM > To: [EMAIL PROTECTED] > Subject: tomcat tuning > > > Hi Guys, > I am facing a performance issue with tomcat 4.1.12 on Solaris. Following is > my setup > > apache 1.3.27 > tomcat 4.1.12 > ajp 13 > > Following is my server.xml context for database and tomcat-apache connector > > <ResourceParams name="jdbc/foo"> > <parameter> > <name>url</name> > <value>jdbc:oracle:oci8:@foo</value> > </parameter> > <parameter> > <name>validationQuery</name> > <value>select 1 from dual</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>0</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>255</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>oracle.jdbc.driver.OracleDriver</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>30000</value> > </parameter> > <parameter> > <name>removeAbandoned</name> > <value>true</value> > </parameter> > <parameter> > <name>username</name> > <value>test</value> > </parameter> > <parameter> > <name>password</name> > <value>test</value> > </parameter> > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>removeAbandonedTimeout</name> > <value>300</value> > </parameter> > </ResourceParams> > > <Connector className="org.apache.coyote.tomcat4.CoyoteConnector" > acceptCount="20" > bufferSize="2048" > connectionTimeout="20000" > debug="4" > enableLookups="false" > maxProcessors="255" > minProcessors="21" > port="8009" > > protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" > proxyPort="0" > redirectPort="8443" > scheme="http" > secure="false" > tcpNoDelay="true" > useURIValidationHack="false"> > <Factory > className="org.apache.catalina.net.DefaultServerSocketFactory"/> > > </Connector> > > Following are the problems. > > I changed some parameters in the server.xml file to match the number of > apache connections. I was also having heavy load on tomcat so I had to > increase the database connections. Now the problem is tomcat is not closing > the database connections and database pool is filling up. Tomcat filled up > the system partition to 100% and threw the following errors for some reason: > > exception: java.net.SocketException: Too many open files > java.net.SocketException: Too many open files > at java.net.PlainSocketImpl.socketAccept(Native Method) > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353) > at java.net.ServerSocket.implAccept(ServerSocket.java:439) > at java.net.ServerSocket.accept(ServerSocket.java:410) > at > org.apache.tomcat.util.net.DefaultServerSocketFactory.acceptSocket(DefaultSe > rverSocketFactory.java:107) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.acceptSocket(PoolTcpEndpoint.java > :335) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:483) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav > a:533) > at java.lang.Thread.run(Thread.java:536) > > > Can anyone help me with this problem and refer me to some good docs for > tomcat setup and performance issues for production heavy loaded servers? > > Thanks > kapil > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]