[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register /  [Login] Login 
[Expert]
Deadlock problem on Oracle when using many clustered servers  XML
Forum Index -> Quartz
Author Message
[Post New]12/23/2009 15:42:52
    Subject: Deadlock problem on Oracle when using many clustered servers
[Up]
smochi

neo

Joined: 12/23/2009 15:41:37
Messages: 1
Offline
Hello,

we are using Quartz 1.6.5 to schedule batch jobs (printing of reports, end-of-day jobs). The web server we’re using is WebLogic 10.0.3 and the database is Oracle 10.2.0.
We have a clustered configuration with two physical servers each one having three logical servers (this means 6 quartz instances running); in this configuration we experience regularly a deadlock where all quartz instances are hung in “SELECT * FROM QRTZ_LOCKS WHERE LOCK_NAME = :1 FOR UPDATE”. The strange thing is that if we reduce the number of number of quartz instances to 2 the system works correctly.
Can anybody help us? I’m attaching the quartz properties file at the end of the mail.

Thanks in advance,
Simona

org.quartz.scheduler.instanceName = SpringSched
org.quartz.scheduler.instanceId = AUTO
org.quartz.scheduler.rmi.export = false
org.quartz.scheduler.rmi.proxy = false
org.quartz.scheduler.wrapJobExecutionInUserTransaction = false

org.quartz.scheduler.threadsInheritContextClassLoaderOfInitializer = true
org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount = 25
org.quartz.threadPool.threadPriority = 5


org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreCMT
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.oracle.weblogic.WebLogicOracleDelegate
org.quartz.jobStore.misfireThreshold = 60000
org.quartz.jobStore.dataSource = SpringDS
#org.quartz.jobStore.nonManagedTXDataSource = SpringDS
org.quartz.jobStore.nonManagedTXDataSource = SpringDSnoCMT

org.quartz.jobStore.txIsolationLevelReadCommitted = true

org.quartz.jobStore.lockHandler.transactionManagerJNDIName=javax.transaction.TransactionManager

org.quartz.jobStore.isClustered = true
org.quartz.jobStore.clusterCheckinInterval = 20000

#data sources
# 1 managed
org.quartz.dataSource.SpringDS.jndiURL = jdbc/SpringDataSource

# 2 non managed
org.quartz.dataSource.SpringDSnoCMT.driver = oracle.jdbc.driver.OracleDriver
org.quartz.dataSource.SpringDSnoCMT.URL = jdbc:oracle:thin:@colorado.test.it:1522HR
org.quartz.dataSource.SpringDSnoCMT.user = U_TEST_ESER
org.quartz.dataSource.SpringDSnoCMT.password = test
org.quartz.dataSource.SpringDSnoCMT.maxConnections = 25
[Post New]01/07/2010 20:52:05
    Subject: Re:Deadlock problem on Oracle when using many clustered servers
[Up]
jhouse

seraphim
[Avatar]
Joined: 11/06/2009 15:29:56
Messages: 1703
Offline

This topic (same poster) has been discussed on the user's mailing list:

https://quartz.dev.java.net/servlets/ReadMsg?list=users&msgNo=10587
 
Forum Index -> Quartz
Go to:   
Powered by JForum 2.1.7 © JForum Team