[prev in list] [next in list] [prev in thread] [next in thread]
List: openjms-developer
Subject: [openjms-developer] [ openjms-Bugs-970675 ] java.sql.SQLException: Communication link failure: java.
From: "SourceForge.net" <noreply () sourceforge ! net>
Date: 2004-06-30 2:23:28
Message-ID: E1BfUky-0000UO-00 () sc8-sf-web4 ! sourceforge ! net
[Download RAW message or body]
Bugs item #970675, was opened at 2004-06-11 06:01
Message generated for change (Comment added) made by tanderson
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=970675&group_id=54559
Category: persistence
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: FrESh (frezh)
Assigned to: Jim Alateras (jalateras)
Summary: java.sql.SQLException: Communication link failure: java.io.E
Initial Comment:
I was doing some performance testings, by having
several threads posting persistent messages to a topic,
and OpenJMS crashed with the appended exception, and
the messages pending to process were lost.
Then, without reseting OpenJMS nor My consumer thread,
I sent more messages from some other publishing threads
and worked, and so on, some tests were successfull and
others were not.
I some one could tell me why, or the piece of code that
should be worked out, I'm willing to cooperate !
It migth be the db driver's problem, I'm using MySQL
with the org.gjt.mm.mysql.Driver driver, I'm not sure
if it is the latest version, but I think it is. this is
a fragment of my config file:
<RdbmsDatabaseConfiguration
driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost:3306/openjms"
user="openjms"
password="openjms"
maxActive="10"
maxIdle="5"
evictionInterval="3600"
testQuery="select current_date" />
</DatabaseConfiguration>
And here the exception trace:
14:38:05.952 ERROR [RMI TCP Connection(446)-127.0.0.1]
- Failed to make message persistent
org.exolab.jms.persistence.PersistenceException:
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:1388)
at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1532)
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1923)
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1900)
at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:950)
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(DriverConnectionFactory.java:82)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at
org.exolab.jms.persistence.DBCPConnectionManager.getConnection(DBCPConnectionManager.java:119)
at
org.exolab.jms.persistence.RDBMSAdapter.getConnection(RDBMSAdapter.java:709)
at
org.exolab.jms.persistence.DatabaseService.getConnection(DatabaseService.java:142)
at
org.exolab.jms.messagemgr.MessageMgr.addPersistentMessage(MessageMgr.java:366)
at
org.exolab.jms.messagemgr.MessageMgr.add(MessageMgr.java:281)
at
org.exolab.jms.server.JmsServerSession.sendMessage(JmsServerSession.java:350)
at
org.exolab.jms.server.rmi.RmiJmsServerSession.sendMessage(RmiJmsServerSession.java:174)
at
sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at
sun.rmi.transport.Transport$1.run(Transport.java:148)
at
java.security.AccessController.doPrivileged(Native Method)
at
sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1707)
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1923)
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1900)
at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:950)
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(DriverConnectionFactory.java:82)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at
org.exolab.jms.persistence.DBCPConnectionManager.getConnection(DBCPConnectionManager.java:119)
at
org.exolab.jms.persistence.RDBMSAdapter.getConnection(RDBMSAdapter.java:709)
at
org.exolab.jms.persistence.DatabaseService.getConnection(DatabaseService.java:142)
at
org.exolab.jms.messagemgr.MessageMgr.addPersistentMessage(MessageMgr.java:366)
at
org.exolab.jms.messagemgr.MessageMgr.add(MessageMgr.java:281)
at
org.exolab.jms.server.JmsServerSession.sendMessage(JmsServerSession.java:350)
at
org.exolab.jms.server.rmi.RmiJmsServerSession.sendMessage(RmiJmsServerSession.java:174)
at
sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at
sun.rmi.transport.Transport$1.run(Transport.java:148)
at
java.security.AccessController.doPrivileged(Native Method)
at
sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
14:38:05.955 ERROR [RMI TCP Connection(446)-127.0.0.1]
- Failed to process message
javax.jms.JMSException: Failed to make message
persistent:
org.exolab.jms.persistence.PersistenceException: Failed
to get pooled connection
at
org.exolab.jms.messagemgr.MessageMgr.addPersistentMessage(MessageMgr.java:397)
at
org.exolab.jms.messagemgr.MessageMgr.add(MessageMgr.java:281)
at
org.exolab.jms.server.JmsServerSession.sendMessage(JmsServerSession.java:350)
at
org.exolab.jms.server.rmi.RmiJmsServerSession.sendMessage(RmiJmsServerSession.java:174)
at
sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at
sun.rmi.transport.Transport$1.run(Transport.java:148)
at
java.security.AccessController.doPrivileged(Native Method)
at
sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
Thank a lot to All !
----------------------------------------------------------------------
>Comment By: Tim Anderson (tanderson)
Date: 2004-06-30 12:23
Message:
Logged In: YES
user_id=557161
The stack trace indicates that the connection to the MySQL
server has been lost. Check your MySQL server logs to help
locate the cause.
Also:
. the latest production MySQL JDBC drivers is 3.0.14:
http://dev.mysql.com/downloads/connector/j/3.0.html
. the org.gjt.mm.mysql.Driver class has been deprecated,
replaced by com.mysql.jdbc.Driver
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=970675&group_id=54559
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
openjms-developer mailing list
openjms-developer@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openjms-developer
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic