Terracotta Discussion Forums

Hello together,

I have a installation of a J2EE Software an problems with quartz and the CMT Datasource. We have updated quartz from 1.4 to 1.7.3.
My system environment is as follow:
- JBoss 4.2.3 GA
- mySql 5.0.67
- mysql-Driver 5.0.5 GA
- Quartz-Version: 1.7.3 (Updated from Quartz 1.4)
- Hibernateversion 2.0

My JBoss Datasource looks as follow:
Code:

<?xml version="1.0" encoding="UTF-8"?>
 <datasources>
    <local-tx-datasource>
 
       <!-- The jndi name of the DataSource, it is prefixed with java:/ -->
       <jndi-name>jdbc/mySQL_Datasource</jndi-name>
       
       <!-- The connection url to db -->
       <connection-url>jdbc:mysql://url:port/db?autoReconnect=true</connection-url>
 
       <driver-class>com.mysql.jdbc.Driver</driver-class>
 
       <!-- The login and password -->
       <user-name>username</user-name>
       <password>password</password>
       <min-pool-size>5</min-pool-size>
       <max-pool-size>20</max-pool-size>
    </local-tx-datasource>
 
    <no-tx-datasource>
       <!-- The jndi name of the DataSource, it is prefixed with java:/ -->
       <jndi-name>jdbc/mySQL_datasource_nonTx</jndi-name>
       <connection-url>jdbc:mysql://url:port/db_name?autoReconnect=true</connection-url>
 
       <!-- The driver class -->
       <driver-class>com.mysql.jdbc.Driver</driver-class>
 
       <!-- The login and password -->
       <user-name>username</user-name>
       <password>password</password>
       <min-pool-size>5</min-pool-size>
       <max-pool-size>20</max-pool-size>
    </no-tx-datasource>
 </datasources>

And i have following exception in my log.files
Code:

ERROR [org.quartz.impl.jdbcjobstore.JobStoreCMT] MisfireHandler: Error handling misfires: null
 java.lang.reflect.UndeclaredThrowableException
 	at $Proxy56.rollback(Unknown Source)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3583)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3133)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3869)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3889)
 Caused by: java.lang.reflect.InvocationTargetException
 	at sun.reflect.GeneratedMethodAccessor220.invoke(Unknown Source)
 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 	at java.lang.reflect.Method.invoke(Method.java:597)
 	at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:71)
 	... 5 more
 Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 
 
 ** BEGIN NESTED EXCEPTION ** 
 
 java.net.SocketException
 MESSAGE: Broken pipe
 
 STACKTRACE:
 
 java.net.SocketException: Broken pipe
 	at java.net.SocketOutputStream.socketWrite0(Native Method)
 	at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
 	at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
 	at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
 	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
 	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2708)
 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1604)
 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
 	at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
 	at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5371)
 	at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:529)
 	at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:826)
 	at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:499)
 	at sun.reflect.GeneratedMethodAccessor220.invoke(Unknown Source)
 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 	at java.lang.reflect.Method.invoke(Method.java:597)
 	at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:71)
 	at $Proxy56.rollback(Unknown Source)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3583)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3133)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3869)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3889)
 
 
 ** END NESTED EXCEPTION **
 
 
 
 Last packet sent to the server was 0 ms ago.
 	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2723)
 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1604)
 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
 	at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
 	at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5371)
 	at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:529)
 	at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:826)
 	at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:499)
 	... 9 more

I hope this Information are sufficient for describing the Error and anyone can answer my Questions:
- How can we reproduces this error? (This error is from a production System
- How can we fix them ?