tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George Sexton" <geor...@mhsoftware.com>
Subject RE: Maximum Number of processes Exceeded
Date Fri, 18 Sep 2009 14:48:27 GMT
Most likely, you're leaking connection handles or result sets.

A common error is storing them on the session. When the session times out
they are not necessarily garbage collected. 

George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
 
> -----Original Message-----
> From: Sharath Babu S S S [mailto:Sharath.Babu@solix.com]
> Sent: Thursday, September 17, 2009 8:22 PM
> To: Tomcat Users List
> Subject: Maximum Number of processes Exceeded
> 
> 
> Hi,
> 
>    We are using Tomcat Server and oracle database. After running for a
> while we are getting this error in the log files.
>     Its taking both inactive and active processess. how to remove the
> inactive processess so that we dont have this error.
> 
> Debug: makeConnection(Database)
> 
> java.sql.SQLException: ORA-00020: maximum number of processes (300)
> exceeded
> 
> 
> 
>         at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:1
> 12)
> 
>         at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> 
>         at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
> 
>         at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
> 
>         at
> oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthentic
> ate.java:294)
> 
>         at
> oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
> 
>         at
> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:43
> 9)
> 
>         at
> oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
> 
>         at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.
> java:35)
> 
>         at
> oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
> 
>         at
> org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(Dr
> iverConnectionFactory.java:38)
> 
>         at
> org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Poolab
> leConnectionFactory.java:294)
> 
>         at
> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(Generic
> ObjectPool.java:974)
> 
>         at
> org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedO
> bjectPool.java:84)
> 
>         at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingData
> Source.java:96)
> 
>         at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSour
> ce.java:880)
> 
>         at
> utils.ConnectionBroker.makeConnection(ConnectionBroker.java:256)
> 
>         at
> utils.ConnectionBroker.makeConnection(ConnectionBroker.java:76)
> 
>         at beans.PurgeProcess_T.run(PurgeProcess_T.java:166)
> 
> 
> 
> 
> 
> 
> With Regards............
> Sharat Babu Shravanam
> 
> 
> 
> --------------------------------------------------------------------
> Byte and Switch Names Solix Technologies
> One of the Top 10 Startups to Watch
> 
> Read More at http://www.solix.com/top10startups
> ---------------------------------------------------------------------
> 
> 
> 
> 
> 
> 
> 
> **************** CAUTION - Disclaimer *****************
> 
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this
> e-mail or its contents to any other person and any such actions are
> unlawful. This e-mail may contain viruses. Solix has taken every
> reasonable precaution to minimize this risk, but is not liable for any
> damage you may sustain as a result of any virus in this e-mail. You
> should carry out your own virus checks before opening the e-mail or
> attachment. Solix reserves the right to monitor and review the content
> of all messages sent to or from this e-mail address. Messages sent to
> or
> from this e-mail address may be stored on the Solix e-mail system.
> 
> 
> ****End of Disclaimer **********************************
> 
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message