Uploaded image for project: 'Medici'
  1. Medici
  2. MMDB-343

webapp stops responding temporarily when MySQL has too many connections

XMLWordPrintableJSON

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocking Blocking
    • 0.4
    • None
    • Web application
    • None

      ERROR [http-8080-1] (UnionContext.java:119) - child unifier failed
      org.tupeloproject.kernel.OperatorException: pool failed to produce connection
      at org.tupeloproject.sql.BaseSqlContext.getConnection(BaseSqlContext.java:292)
      at org.tupeloproject.sql.SqlContext.unify(SqlContext.java:281)
      at org.tupeloproject.sql.SqlContext.doPerform(SqlContext.java:367)
      at sun.reflect.GeneratedMethodAccessor490.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.tupeloproject.kernel.Kernel.invokeMethodOnOperator(Kernel.java:151)
      at org.tupeloproject.kernel.Kernel.perform(Kernel.java:189)
      at org.tupeloproject.kernel.Context.perform(Context.java:51)
      at org.tupeloproject.kernel.UnionContext.doPerform(UnionContext.java:111)
      at sun.reflect.GeneratedMethodAccessor493.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.tupeloproject.kernel.Kernel.invokeMethodOnOperator(Kernel.java:151)
      at org.tupeloproject.kernel.Kernel.perform(Kernel.java:189)
      at org.tupeloproject.kernel.Context.perform(Context.java:51)
      at edu.illinois.ncsa.mmdb.web.server.dispatch.GetCollectionsHandler.execute(GetCollectionsHandler.java:70)
      at edu.illinois.ncsa.mmdb.web.server.dispatch.GetCollectionsHandler.execute(GetCollectionsHandler.java:40)
      at net.customware.gwt.dispatch.server.DefaultDispatch.doExecute(DefaultDispatch.java:78)
      at net.customware.gwt.dispatch.server.DefaultDispatch.execute(DefaultDispatch.java:68)
      at net.customware.gwt.dispatch.server.service.DispatchServiceServlet.execute(DispatchServiceServlet.java:24)
      at sun.reflect.GeneratedMethodAccessor505.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:562)
      at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:188)
      at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:224)
      at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at edu.illinois.ncsa.mmdb.web.server.MyDispatchServiceServlet.service(MyDispatchServiceServlet.java:34)
      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 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:128)
      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:293)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
      at java.lang.Thread.run(Thread.java:636)
      Caused by: org.tupeloproject.util.PoolException: Too many connections
      at org.tupeloproject.sql.BaseSqlContext$1.create(BaseSqlContext.java:212)
      at org.tupeloproject.sql.BaseSqlContext$1.create(BaseSqlContext.java:215)
      at org.tupeloproject.util.Pool.checkOut(Pool.java:42)
      at org.tupeloproject.sql.BaseSqlContext.getConnection(BaseSqlContext.java:282)
      ... 42 more
      Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
      at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
      at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
      at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
      at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
      at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
      at java.sql.DriverManager.getConnection(DriverManager.java:620)
      at java.sql.DriverManager.getConnection(DriverManager.java:169)
      at org.tupeloproject.sql.BaseSqlContext$1.create(BaseSqlContext.java:209)
      ... 45 more

              futrelle Joe Futrelle (Inactive)
              futrelle Joe Futrelle (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: