Too many connections

Hi





I am running Jchem 1.7.4, tomcat 5.0.18 with a MySQL server (3.23.54). I am occasionally getting an error when running structure searches and I'm wondering whether it means that the MySQL server can't cope with the number of connections or if I need to upgrade the license for JChem to allow more searches / minute. The tomcat error message that gets spat out is below. Any ideas?





Fri Sep 03 14:20:59 BST 2004 - Search time: 381ms, screening: 361ms


java.sql.SQLException: Communication failure during handshake. Message from server: "Too many connections"


at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:650)


at com.mysql.jdbc.Connection.createNewIO(Connection.java:1511)


at com.mysql.jdbc.Connection.<init>(Connection.java:485)


at com.mysql.jdbc.Driver.connect(Driver.java:341)


at java.sql.DriverManager.getConnection(DriverManager.java:512)


at java.sql.DriverManager.getConnection(DriverManager.java:171)


at chemaxon.util.ConnectionHandler.setConnected(ConnectionHandler.java:189)


at chemaxon.util.ConnectionHandler.connect(ConnectionHandler.java:229)


at org.apache.jsp.searching_jsp._jspService(searching_jsp.java:255)


at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)


at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)


at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)


at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)


at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)


at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)


at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)


at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)


at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)


at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)


at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)


at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)


at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)


at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)


at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)


at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)


at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)


at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)


at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)


at java.lang.Thread.run(Thread.java:534)

Check to make sure you're closing your MySQL connections. See


http://dev.mysql.com/doc/mysql/en/Too_many_connections.html

Thanks daveroe for the quick answer.





Heelism, please let me know if this tip helps.

I have same problem on Apache 2 SMF and mysql 5.0. Sometimes it says when try forum that is too many connection. But when I log in to mySql server from phpmyadmin mysql works and accept connection but smf forum do not works. How to increase connection to smf forum?

That is little strange but it is.

hi andrewz,

Here is the ChemAxon's support forum, we can support just issues which are related the ChmAxon products. Moreover this forum may contain answers for general informatik problems which appeared related a ChemAxon product.

Regards, Edvard