[Logo] Terracotta Discussion Forums
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
[Expert]
Failed to override connection auto commit/transaction isolation.  XML
Forum Index -> Quartz
Author Message
Rossiell

neo

Joined: 11/16/2011 23:54:16
Messages: 7
Offline

Hello,

I have such problem:

Between ending and starting each tasks. I have error:

org.quartz.impl.jdbcjobstore.JobStoreTX Failed to override connection auto commit/transaction isolation.
java.sql.SQLException: I/O Error: Connection reset by peer: socket write error
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
at net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:895)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.setAutoCommit(ConnectionJDBC2.java:2026)
at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.setAutoCommit(AttributeRestoringConnectionInvocationHandler.java:91)
at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:65)
at $Proxy9.setAutoCommit(Unknown Source)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:711)
at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3737)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2720)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)
Caused by: java.net.SocketException: Connection reset by peer: socket write error
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.DataOutputStream.write(DataOutputStream.java:90)
at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:656)
at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:560)
at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:508)
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1036)
... 12 more
2012-06-26 10:43:00,079 WARN [ClusteredScheduler_QuartzSchedulerThread ] org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler Failed restore connection's original auto commit setting.
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.setAutoCommit(ConnectionJDBC2.java:1990)
at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.restoreOriginalAtributes(AttributeRestoringConnectionInvocationHandler.java:134)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3538)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3761)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2720)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)
2012-06-26 10:43:00,079 ERROR [ClusteredScheduler_QuartzSchedulerThread ] org.quartz.impl.jdbcjobstore.JobStoreTX Failed to close Connection
java.sql.SQLException: Already closed.
at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:3563)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3539)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3761)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2720)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)
2012-06-26 10:43:00,079 ERROR [ClusteredScheduler_QuartzSchedulerThread ] org.quartz.core.QuartzSchedulerThread quartzSchedulerThreadLoop: RuntimeException null
java.lang.reflect.UndeclaredThrowableException
at $Proxy9.rollback(Unknown Source)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3588)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3754)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2720)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
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: java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1889)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)

Can you give me advice how to solve this issue?
light5

ophanim
[Avatar]
Joined: 01/14/2011 20:32:56
Messages: 554
Offline

Can you share your quartz.properties ?

Zemian Deng
---------------
Looking for a web UI to manage Quartz?
Try http://code.google.com/p/myschedule
[WWW]
Rossiell

neo

Joined: 11/16/2011 23:54:16
Messages: 7
Offline


#============================================================================
# Configure Main Scheduler Properties
#============================================================================

org.quartz.scheduler/instanceName = ClusteredScheduler
org.quartz.scheduler/instanceId = AUTO
org.quartz.scheduler/threadsInheritContextClassLoaderOfInitializer=true
#============================================================================
# Configure ThreadPool
#============================================================================

org.quartz.threadPool/class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool/threadCount = 25
org.quartz.threadPool/threadPriority = 5

#============================================================================
# Configure JobStore
#============================================================================

org.quartz.jobStore/misfireThreshold = 60000

org.quartz.jobStore/class = org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore/driverDelegateClass =org.quartz.impl.jdbcjobstore.MSSQLDelegate
org.quartz.jobStore/useProperties = true
org.quartz.jobStore/dataSource=BatchDS
org.quartz.jobStore/tablePrefix = QRTZ_
org.quartz.jobStore/isClustered=true
org.quartz.jobStore/clusterCheckinInterval = 20000
org.quartz.jobStore/selectWithLockSQL=SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?
org.quartz.jobStore.lockHandler/class=org.quartz.impl.jdbcjobstore.UpdateLockRowSemaphore
org.quartz.jobStore/acquireTriggersWithinLock=true

#============================================================================
# Configure Datasources
#============================================================================

org.quartz.dataSource.BatchDS/driver=MUST_OVERRIDE
org.quartz.dataSource.BatchDS/maxConnections=5
org.quartz.dataSource.BatchDS/URL=MUST_OVERRIDE
org.quartz.dataSource.BatchDS/user=MUST_OVERRIDE
org.quartz.dataSource.BatchDS/password=MUST_OVERRIDE
light5

ophanim
[Avatar]
Joined: 01/14/2011 20:32:56
Messages: 554
Offline

For quartz clustering to work, you need two datasource defined. See the ref doc for details.

Also, why you have "/" instead of "." on the configuration key? Ensure you use the correct key.

Zemian Deng
---------------
Looking for a web UI to manage Quartz?
Try http://code.google.com/p/myschedule
[WWW]
Rossiell

neo

Joined: 11/16/2011 23:54:16
Messages: 7
Offline

My question was asked a long time ago, but it is still urgent.
I try to find in documentation " you need two datasource defined", but I failed.

I've found out that it's true for JDBC-JobStoreCMT, but for JDBC-JobStoreTX there is no information. It would be great if you send links to such information.
 
Forum Index -> Quartz
Go to:   
Powered by JForum 2.1.7 © JForum Team