Bug #4628 | Can't connect to database | ||
---|---|---|---|
Submitted: | 19 Jul 2004 16:34 | Modified: | 22 Oct 2004 14:27 |
Reporter: | frederik oucum | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | Connector / J | Severity: | S1 (Critical) |
Version: | OS: | Linux (Linux Redhat 9) | |
Assigned to: | Matthew Lord | CPU Architecture: | Any |
[19 Jul 2004 16:34]
frederik oucum
[30 Jul 2004 2:33]
Matthew Lord
Dear User, Thank you for your bug report! I have been using various connector/j versions on Red Hat 9 connection to various versions of MySQL and I haven't experienced this problem. Would it be possible for you to provide the version of mysql you are trying to connect to as well as providing the source file that is causing the problem for you? If the file is too large to attach to the bug report you can use the anonymous account on ftp.mysql.com/pub/mysql/upload and just let me know the filename. Best Regards
[15 Sep 2004 15:57]
Ales Justin
I have the same problem. Running MySql server 4.0.20 and MySql Connector 3.0.18. What is to do here? Thanx, Ales ------------------------------- org.quartz.SchedulerConfigException: Failure occured during job recovery. [See n ested exception: org.quartz.JobPersistenceException: Failed to obtain DB connect ion from data source 'myDS': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause: Communication link failure: java.io.EOF Exception, underlying cause: null ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1388) at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1407) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:621) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1771) at com.mysql.jdbc.Connection.<init>(Connection.java:440) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :400) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv erConnectionFactory.java:82) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:300) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas icDataSource.java:838) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:821) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:518) at org.quartz.utils.PoolingConnectionProvider.getConnection(PoolingConne ctionProvider.java:180) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManage r.java:119) at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSu pport.java:526) at org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(J obStoreTX.java:113) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSuppo rt.java:479) at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:74 ) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.j ava:772) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory. java:904) at org.quartz.impl.StdSchedulerFactory.getDefaultScheduler(StdSchedulerF actory.java:920) at com.generalynx.smsmailman.client.Initializer.schedulerInit(Initialize r.java:73) at com.generalynx.smsmailman.client.Initializer.init(Initializer.java:47 ) at com.generalynx.smsmailman.client.DaoSupport.<init>(DaoSupport.java:26 ) at com.generalynx.smsmailman.client.Sender.<init>(Sender.java:56) at com.generalynx.webcontrol.logic.broadcast.Sender.sendSMS(Sender.java: 146) at com.generalynx.webcontrol.logic.data.dbase.ControlUnit.read(ControlUn it.java:69) at com.generalynx.webcontrol.web.controller.MainAction.executeAction(Mai nAction.java:66) at com.generalynx.webcontrol.web.controller.AbstractAction.execute(Abstr at com.generalynx.webcontrol.web.controller.AbstractAction.execute(Abstr actAction.java:29) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:148 2) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at com.generalynx.common.filters.SetCharacterEncodingFilter.doFilter(Set CharacterEncodingFilter.java:170) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline .java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline .java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2343) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline .java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche rValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline .java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline .java:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline .java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline .java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcesso r.java:1012) at org.apache.ca va:1122) at java.lang.Thread.run(Thread.java:534) ** END NESTED EXCEPTION ** [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot creat e PoolableConnectionFactory, cause: Communication link failure: java.io.EOFExcep tion, underlying cause: null ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1388) at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1407) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:621) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1771) at com.mysql.jdbc.Connection.<init>(Connection.java:440) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :400) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv erConnectionFactory.java:82) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:300) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas icDataSource.java:838) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:821) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource .java:518) at org.quartz.utils.PoolingConnectionProvider.getConnection(PoolingConne ctionProvider.java:180) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManage r.java:119) at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSu pport.java:526) at org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(J obStoreTX.java:113) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSuppo rt.java:479) at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:74 at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:74 ) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.j ava:772) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory. java:904) at org.quartz.impl.StdSchedulerFactory.getDefaultScheduler(StdSchedulerF actory.java:920) at com.generalynx.smsmailman.client.Initializer.schedulerInit(Initialize r.java:73) at com.generalynx.smsmailman.client.Initializer.init(Initializer.java:47 ) at com.generalynx.smsmailman.client.DaoSupport.<init>(DaoSupport.java:26 ) at com.generalynx.smsmailman.client.Sender.<init>(Sender.java:56) at com.generalynx.webcontrol.logic.broadcast.Sender.sendSMS(Sender.java: 146) at com.generalynx.webcontrol.logic.data.dbase.ControlUnit.read(ControlUn it.java:69) at com.generalynx.webcontrol.web.controller.MainAction.executeAction(Mai nAction.java:66) at com.generalynx.webcontrol.web.controller.AbstractAction.execute(Abstr actAction.java:29) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:148 2) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at com.generalynx.common.filters.SetCharacterEncodingFilter.doFilter(Set CharacterEncodingFilter.java:170) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelin
[15 Sep 2004 15:59]
Ales Justin
Sorry - not 3.0.18, but: mysql-connector-java-3.0.14-production-bin.jar Ales
[22 Oct 2004 13:56]
Vinod Kumar
For some reason I am getting the same problem, my situation is I am using the connection to log the unix cpu data to a database every 15 minutes. I have a servlet which loads as soon as the the JVM starts and there is a TimeTask which is schedule to run every 15 minutes. I didn't have problem until recently i started seeing this error. Get connection Exception: Communication link failure: java.net.SocketException, underlying cause: Connection reset ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Connection reset STACKTRACE: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at java.io.BufferedInputStream.fill(BufferedInputStream.java:183) at java.io.BufferedInputStream.read1(BufferedInputStream.java:222) at java.io.BufferedInputStream.read(BufferedInputStream.java:277) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1391) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:954) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1782) at com.mysql.jdbc.Connection.<init>(Connection.java:450) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:193) at com.xxxxxcompany.pccm.dao.CPUConnection.getConnection(CPUConnection.java:29) at com.xxxxxcompany.pccm.dao.CPUDataDAO.insertCPUData(CPUDataDAO.java:30) at com.xxxxxcompany.pccm.util.Commands.executeMemory(Commands.java:149) at com.xxxxxcompany.pccm.util.Commands.runCommands(Commands.java:43) at com.xxxxxcompany.pccm.util.Commands.run(Commands.java:167) at java.util.TimerThread.mainLoop(Timer.java:432) at java.util.TimerThread.run(Timer.java:382) ** END NESTED EXCEPTION ** java.lang.NullPointerException at com.xxxxxcompany.pccm.dao.CPUDataDAO.insertCPUData(CPUDataDAO.java:45) at com.xxxxxcompany.pccm.util.Commands.executeMemory(Commands.java:149) at com.xxxxxcompany.pccm.util.Commands.runCommands(Commands.java:43) at com.xxxxxcompany.pccm.util.Commands.run(Commands.java:167) at java.util.TimerThread.mainLoop(Timer.java:432) at java.util.TimerThread.run(Timer.java:382)
[22 Oct 2004 14:27]
Mark Matthews
Not that it's related to the connection reset exception (which means something along the line either severed your connection, or re-started the server or machine it was running on), however if you ever have the following in a stacktrace from Connector/J, you should upgrade, as you're using an old version that doesn't have a workaround for a 'feature' in BufferedInputStreams (which many call a bug): > at java.io.BufferedInputStream.fill(BufferedInputStream.java:183) > at java.io.BufferedInputStream.read1(BufferedInputStream.java:222) > at java.io.BufferedInputStream.read(BufferedInputStream.java:277) > at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1391)
[4 Jan 2005 16:37]
Malik Gammar
I have the same problem with the latest MySQL5 and the latest Connector/J : mysql-connector-java-3.2.0-alpha. I am using this with Weblogic8.1.3 and Eclipse3.1. The stack trace exeption is similar to those reported without the null : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1895) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2342) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2838) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:773) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3612) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1204) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699) at com.mysql.jdbc.Connection.<init>(Connection.java:408) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:270) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.gammer.malik.model.LoginBean.validateUser(LoginBean.java:65) at com.gammer.malik.controller.LoginAction.execute(LoginAction.java:40) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6452) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178) ** END NESTED EXCEPTION ** at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2554) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2838) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:773) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3612) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1204) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699) at com.mysql.jdbc.Connection.<init>(Connection.java:408) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:270) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.gammer.malik.model.LoginBean.validateUser(LoginBean.java:65) at com.gammer.malik.controller.LoginAction.execute(LoginAction.java:40) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6452) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178) The code fragment is quite similar, the comments are some try i let for the purpose because they lead to the same exception : Class.forName("com.mysql.jdbc.Driver").newInstance(); String urlDB = "jdbc:mysql://localhost/corpo"; String userNameDB = "mgammar"; String passwordDB = "mgammar"; conn = DriverManager.getConnection(urlDB, userNameDB,passwordDB); //conn = DriverManager.getConnection("jdbc:mysql://localhost/corpo", "mgammar", "mgammar"); //conn = DriverManager.getConnection("jdbc:mysql://localhost/corpo?user=mgammar&password=mgammar"); //conn = DriverManager.getConnection("jdbc:mysql://localhost/corpo", "root", ""); //conn = DriverManager.getConnection("jdbc:mysql://localhost/corpo?user=root"); Thank you.
[4 Jan 2005 17:33]
Mark Matthews
Malik, Looks like your server is crashing/restarting when you try and connect...What does the .err log file that is created by the MySQL server say?
[4 Jan 2005 21:49]
Malik Gammar
Mark, The output doesn't show any thing for today. The Eclipse console is showing the message. Here is below the hole content of the.err file of MySQL : InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 041227 14:01:58 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 041227 14:01:58 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 041227 14:01:58 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 041227 14:02:04 InnoDB: Started; log sequence number 0 0 C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.2-alpha-nt' socket: '' port: 3306 Source distribution 041227 17:09:45 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 041227 17:09:46 InnoDB: Starting shutdown... 041227 17:09:49 InnoDB: Shutdown completed; log sequence number 0 56406 041227 17:09:49 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete 041227 17:09:56 InnoDB: Started; log sequence number 0 56406 C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.2-alpha-nt' socket: '' port: 3306 Source distribution 041227 17:43:06 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 041227 17:43:06 InnoDB: Starting shutdown... 041227 17:43:09 InnoDB: Shutdown completed; log sequence number 0 56406 041227 17:43:10 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete 041227 17:42:50 InnoDB: Started; log sequence number 0 56406 C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.2-alpha-nt' socket: '' port: 3306 Source distribution
[20 Mar 2005 11:25]
mao lao
I am having the problem similar to this. OS:redhat-10 mysql:3.23.58 jConnector:mysql-connector-java-3.1.6 net.sf.hibernate.exception.GenericJDBCException: could not load: [db.Company#ff80808102b633e10102bf6258fc259e] at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30) at net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1332) at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:418) at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2130) at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:2000) at net.sf.hibernate.impl.SessionImpl.load(SessionImpl.java:1929) at net.archean.ltmis.db.base._BaseRootDAO.load(_BaseRootDAO.java:614) at net.archean.ltmis.db.base._BaseRootDAO.load(_BaseRootDAO.java:597) at net.archean.ltmis.db.base.BaseCompanyDAO.load(BaseCompanyDAO.java:35) at net.archean.sooq.InfoEditManager.publishToSooq(InfoEditManager.java:688) at org.apache.jsp.publishcompany_jsp._jspService(publishcompany_jsp.java:211) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1845) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2292) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Connection.execSQL(Connection.java:2226) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1812) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1657) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:88) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911) at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931) at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59) at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51) at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:415) at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2130) at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:2000) at net.sf.hibernate.impl.SessionImpl.load(SessionImpl.java:1929) at net.archean.ltmis.db.base._BaseRootDAO.load(_BaseRootDAO.java:614) at net.archean.ltmis.db.base._BaseRootDAO.load(_BaseRootDAO.java:597) at net.archean.ltmis.db.base.BaseCompanyDAO.load(BaseCompanyDAO.java:35) at net.archean.sooq.InfoEditManager.publishToSooq(InfoEditManager.java:688) at org.apache.jsp.publishcompany_jsp._jspService(publishcompany_jsp.java:211) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
[13 Jul 2006 17:34]
Marc Baumgartner
I have this Exception as well with a mysql 4.0.15 database. In which version is the error fixed? Or isn't the bug fixed allready? Is there any workaround? Thanks, Marc Caused by: java.sql.SQLException: Communication link failure: java.io.EOFException, underlying cause: null ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1395) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1539) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1930) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) at com.mysql.jdbc.Connection.execSQL(Connection.java:2281) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at dsh.dao.PageConnector.loadPage(PageConnector.java:19) at treetech.cms.Enviroment.loadPage(Enviroment.java:264) at dsh.servlet.IndexServlet.doGet(IndexServlet.java:140) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:263) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:562) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) ** END NESTED EXCEPTION ** at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1714) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1930) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) at com.mysql.jdbc.Connection.execSQL(Connection.java:2281) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) ... 45 more
[6 Feb 2010 14:26]
vatoer ckplus
if i set url="jdbc:mysql://127.0.0.1:3306/MyNewDatabase?autoReconnect=true" error DataSource invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.) if i set url="jdbc:mysql://127.0.0.1:3306/MyNewDatabase error org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure Last packet sent to the server was 0 ms ago what's wrong ?? any ideas?