<font size=2 face="sans-serif">Hi All,</font>
<br>
<br><font size=2 face="sans-serif">To many times i am getting Data source
rejected establishment of connection, message from server: "Too
many connections" error and my server become unresponsive. Please
somebody tell me how to overcome this problem. my opencms log says:</font>
<br>
<br><font size=2 face="sans-serif">21 Oct 2015 11:08:47,797 ERROR [e.CmsDetailPageResourceHandler:
148] Resource not found for URI: "/sites/default/events/"</font>
<br><font size=2 face="sans-serif">org.opencms.db.CmsDbSqlException: Error
reading id for url name "events".</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:109)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:334)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.CmsDbContext.report(CmsDbContext.java:286)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.CmsSecurityManager.readIdForUrlName(CmsSecurityManager.java:4389)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.file.CmsObject.readIdForUrlName(CmsObject.java:2533)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.ade.detailpage.CmsDetailPageResourceHandler.initResource(CmsDetailPageResourceHandler.java:122)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.main.OpenCmsCore.initResource(OpenCmsCore.java:1561)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.main.OpenCms.initResource(OpenCms.java:708)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.i18n.CmsDefaultLocaleHandler.getI18nInfo(CmsDefaultLocaleHandler.java:101)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.i18n.CmsLocaleManager.getI18nInfo(CmsLocaleManager.java:873)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:2406)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.main.OpenCmsCore.updateContext(OpenCmsCore.java:1927)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.main.A_CmsAuthorizationHandler.registerSession(A_CmsAuthorizationHandler.java:92)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.security.CmsDefaultAuthorizationHandler.initCmsObject(CmsDefaultAuthorizationHandler.java:96)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.security.CmsDefaultAuthorizationHandler.initCmsObject(CmsDefaultAuthorizationHandler.java:112)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:2531)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1700)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)</font>
<br><font size=2 face="sans-serif"> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)</font>
<br><font size=2 face="sans-serif"> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</font>
<br><font size=2 face="sans-serif"> at
com.pmidc.opencms.LoadSalt.doFilter(LoadSalt.java:58)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</font>
<br><font size=2 face="sans-serif"> at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)</font>
<br><font size=2 face="sans-serif"> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)</font>
<br><font size=2 face="sans-serif"> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)</font>
<br><font size=2 face="sans-serif"> at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)</font>
<br><font size=2 face="sans-serif"> at
java.lang.Thread.run(Thread.java:701)</font>
<br><font size=2 face="sans-serif">Caused by: org.opencms.db.CmsDbSqlException:
An SQL error occurred when executing the following query: . </font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.generic.CmsVfsDriver.wrapException(CmsVfsDriver.java:4634)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.generic.CmsVfsDriver.readUrlNameMappingEntries(CmsVfsDriver.java:2712)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.CmsDriverManager.readIdForUrlName(CmsDriverManager.java:6873)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.CmsSecurityManager.readIdForUrlName(CmsSecurityManager.java:4386)</font>
<br><font size=2 face="sans-serif"> ...
31 more</font>
<br><font size=2 face="sans-serif">Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Data source rejected establishment of connection, message from server:
"Too many connections"</font>
<br><font size=2 face="sans-serif"> at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</font>
<br><font size=2 face="sans-serif"> at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)</font>
<br><font size=2 face="sans-serif"> at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</font>
<br><font size=2 face="sans-serif"> at
java.lang.reflect.Constructor.newInstance(Constructor.java:534)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.Util.getInstance(Util.java:386)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1112)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)</font>
<br><font size=2 face="sans-serif"> at
sun.reflect.GeneratedConstructorAccessor158.newInstance(Unknown Source)</font>
<br><font size=2 face="sans-serif"> at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</font>
<br><font size=2 face="sans-serif"> at
java.lang.reflect.Constructor.newInstance(Constructor.java:534)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)</font>
<br><font size=2 face="sans-serif"> at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)</font>
<br><font size=2 face="sans-serif"> at
java.sql.DriverManager.getConnection(DriverManager.java:615)</font>
<br><font size=2 face="sans-serif"> at
java.sql.DriverManager.getConnection(DriverManager.java:195)</font>
<br><font size=2 face="sans-serif"> at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)</font>
<br><font size=2 face="sans-serif"> at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)</font>
<br><font size=2 face="sans-serif"> at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)</font>
<br><font size=2 face="sans-serif"> at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:180)</font>
<br><font size=2 face="sans-serif"> at
java.sql.DriverManager.getConnection(DriverManager.java:615)</font>
<br><font size=2 face="sans-serif"> at
java.sql.DriverManager.getConnection(DriverManager.java:213)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:96)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:224)</font>
<br><font size=2 face="sans-serif"> at
org.opencms.db.generic.CmsVfsDriver.readUrlNameMappingEntries(CmsVfsDriver.java:2701)</font>
<br><font size=2 face="sans-serif"> ...
33 more</font>
<br>
<br>
<br><font size=2 face="sans-serif">With Regards</font>
<br><font size=2 face="sans-serif">Manoj Kumar Sharma</font>