[opencms-dev] Data source rejected establishment of connection, message from server: "Too many connections"

Mon Oct 26 12:34:21 CET 2015

Hi All,

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:

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

With Regards
Manoj Kumar Sharma
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20151026/7028d81e/attachment.htm>