Too many connections

User 065d7a2e40

03-09-2004 15:12:47

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)

User b7aa615db3

04-09-2004 14:58:10

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


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

ChemAxon 9c0afc9aaf

06-09-2004 14:06:31

Thanks daveroe for the quick answer.





Heelism, please let me know if this tip helps.

User 5be17fd83a

19-09-2010 22:27:32

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.



ChemAxon e274e1bada

21-09-2010 15:49:43

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