CODEWITHSUNDEEP
javatimerquartz-scheduler
Adder
Adder

Reputation: 5868

Quartz triggers are in the past

I have 750 Quartz Jobs with 1 trigger each.

Dumping the trigger data show a next fire time with a time in the past. The dump is from 15:55 Berlin/Europe timezone.

Is the nextfire time wrong or is Quartz overloaded with too many jobs?

Quartz Jobs

Name= INSTANT_KPI_DEF_ID_1000708 Group=DEFAULT NextFireTime=Thu Feb 09 15:15:30 CET 2017 Priority=5 Paused=NOT PAUSED Triggers #=1

Name= INSTANT_KPI_DEF_ID_1000829 Group=DEFAULT NextFireTime=Thu Feb 09 15:15:30 CET 2017 Priority=5 Paused=NOT PAUSED Triggers #=1

Name= INSTANT_KPI_DEF_ID_1000707 Group=DEFAULT NextFireTime=Thu Feb 09 15:15:30 CET 2017 Priority=5 Paused=NOT PAUSED Triggers #=1

Name= INSTANT_KPI_DEF_ID_1000828 Group=DEFAULT NextFireTime=Thu Feb 09 15:15:30 CET 2017 Priority=5 Paused=NOT PAUSED Triggers #=1

Name= INSTANT_KPI_DEF_ID_1000706 Group=DEFAULT NextFireTime=Thu Feb 09 15:15:30 CET 2017 Priority=5 Paused=NOT PAUSED Triggers #=1

Name= INSTANT_KPI_DEF_ID_1000827 Group=DEFAULT NextFireTime=Thu Feb 09 15:15:30 CET 2017 Priority=5 Paused=NOT PAUSED Triggers #=1

Name= INSTANT_KPI_DEF_ID_1000705 Group=DEFAULT NextFireTime=Thu Feb 09 15:15:30 CET 2017 Priority=5 Paused=NOT PAUSED Triggers #=1

Name= INSTANT_KPI_DEF_ID_1000826 Group=DEFAULT NextFireTime=Thu Feb 09 15:15:30 CET 2017 Priority=5 Paused=NOT PAUSED Triggers #=1

Upvotes: 1

Views: 950

Answers (2)

Srinivas
Srinivas

Reputation: 400

You can control the number of connections to the database by specifying

org.quartz.dataSource.myDS.maxConnections = 5

Refer here for sample config JDBC-JobStore Configuration

Upvotes: 0

Adder
Adder

Reputation: 5868

I found that quartz is by default configured to have only 10 running jobs. I changed that to 200, now the next wall I've hit is that oracle doesn't like that many connections being made simultaneously.

SchedulerFactoryBean quartzScheduler = new SchedulerFactoryBean();
quartzScheduler.setSchedulerName("rm-quartz-scheduler");

Properties props = new Properties();

// Thread pooling
props.put("org.quartz.threadPool.class", org.quartz.simpl.SimpleThreadPool.class.getName());
props.put("org.quartz.threadPool.threadCount", "200");
props.put("org.quartz.threadPool.threadPriority", "5");

quartzScheduler.setQuartzProperties(props);

Upvotes: 1

Related Questions