search

quartz-scheduler / quartz

Code for Quartz Scheduler
http://www.quartz-scheduler.org
Apache License 2.0
6.29k stars 1.94k forks source link

many threads blocked at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore #485

Closed umesh2611 closed 3 years ago

umesh2611 commented 5 years ago

Hi ,

We are usng quartz 2.2.1.

Sometime ( frequently ) , the Quartz threads are blocked at ( stack trace attached )

at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96) at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3780) at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93) at org.quartz.impl.jdbcjobstore.JobStoreSupport.removeTrigger(JobStoreSupport.java:1423) at org.quartz.core.QuartzScheduler.unscheduleJob(QuartzScheduler.java:1090) at org.quartz.impl.StdScheduler.unscheduleJob(StdScheduler.java:311) at com.mycomosi.ea.application.alarmsubscription.collection.connector.AlarmCollectionScheduleService.deleteJob(AlarmCollectionScheduleService.java:120)

Quartz Properties : org.quartz.scheduler.instanceName=fm-bridge org.quartz.scheduler.instanceId=AUTO org.quartz.threadPool.class=org.quartz.simpl.SimpleThreadPool org.quartz.threadPool.threadCount=64 org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread=true org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreTX org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.oracle.OracleDelegate org.quartz.jobStore.dataSource=tasksDataStore org.quartz.jobStore.tablePrefix=QRTZ_ org.quartz.jobStore.isClustered=true org.quartz.jobStore.clusterCheckinInterval=20000 org.quartz.dataSource.tasksDataStore.driver=oracle.jdbc.driver.OracleDriver org.quartz.dataSource.tasksDataStore.URL=jdbc:oracle:thin:@${scheduler.db.name}:${scheduler.db.port}/${scheduler.db.sid} org.quartz.dataSource.tasksDataStore.user=${scheduler.db.user} org.quartz.dataSource.tasksDataStore.password=${scheduler.db.user} org.quartz.dataSource.tasksDataStore.maxConnections=20 org.quartz.datasource.tasksDataStore.validationQuery=select table_name from user_tables

Any help is higly appreciated.

stale[bot] commented 3 years ago

Is this still relevant? If so, what is blocking it? Is there anything you can do to help move it forward?

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.