Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)   Search   Recent Topics     Member Listing    Back to home page  Register /  Login  [Expert]

Messages posted by: smochi   Profile for smochi -> Messages posted by smochi [1] Author Message Quartz -> Deadlock problem on Oracle when using many clustered servers -> Go to message 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 Profile for smochi -> Messages posted by smochi [1] Go to:  Select a forum BigMemory Ehcache General Quartz BigMemory + Hadoop Terracotta for Web Sessions Terracotta Platform Terracotta Licensing Terracotta 中文社区 Terracotta for Spring

Powered by JForum 2.1.7 © JForum Team