scheduler stops in middle-way of cron trigger

[Pitchaimani]

Hi All,


I am using Pentaho 1.7 along with Quartz Scheduer. I am able to schedule a job using “startJob” action from JobSchedulerComponent. Scheduled Action is stopped some way in middle after changing the value of QRTZ_TRIGGERS.TRIGGER_STATE from WAITING to ACQUIRED.


Please help me to identify why ??


Your help is highly appriciated at this juncture.



Thanks,
Pitchaimani



My Quartz.properties config:


org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount = 10
org.quartz.threadPool.threadPriority = 5
org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread = true


oorg.quartz.scheduler.instanceName = PentahoQuartzScheduler
org.quartz.scheduler.instanceId = 1
org.quartz.scheduler.rmi.export = false
org.quartz.scheduler.rmi.proxy = false
org.quartz.scheduler.wrapJobExecutionInUserTransaction = false


org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore.misfireThreshold = 60000
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
org.quartz.jobStore.useProperties = true
org.quartz.jobStore.dataSource = PentahoQuartz
org.quartz.jobStore.tablePrefix = QRTZ_
org.quartz.jobStore.isClustered = false


org.quartz.dataSource.PentahoQuartz.jndiURL=java:comp/env/jdbc/Quartz


MySQL Log:


14 Prepare [45] UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = ? WHERE (TRIGGER_STATE = ? OR TRIGGER_STATE = ?) AND NEXT_FIRE_TIME < ?
14 Execute [45] UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = 'MISFIRED' WHERE (TRIGGER_STATE = 'WAITING' OR TRIGGER_STATE = 'WAITING') AND NEXT_FIRE_TIME < 1225980527376
14 Prepare [46] SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = ? AND NEXT_FIRE_TIME >= 0
14 Execute [46] SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = 'WAITING' AND NEXT_FIRE_TIME >= 0
14 Prepare [47] SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = ? AND NEXT_FIRE_TIME = ?
14 Execute [47] SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = 'WAITING' AND NEXT_FIRE_TIME = 1225980600000
14 Prepare [48] UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = ? WHERE TRIGGER_NAME = ? AND TRIGGER_GROUP = ? AND TRIGGER_STATE = ?
14 Execute [48] UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = 'ACQUIRED' WHERE TRIGGER_NAME = 'VolumeReportEMailTrigger' AND TRIGGER_GROUP = 'DEFAULT' AND TRIGGER_STATE = 'WAITING'
14 Prepare [49] SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = ? AND TRIGGER_GROUP = ?
14 Execute [49] SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = 'VolumeReportEMailTrigger' AND TRIGGER_GROUP = 'DEFAULT'
14 Prepare [50] SELECT * FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = ? AND TRIGGER_GROUP = ?
14 Execute [50] SELECT * FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = 'VolumeReportEMailTrigger' AND TRIGGER_GROUP = 'DEFAULT'
14 Prepare [51] SELECT TRIGGER_LISTENER FROM QRTZ_TRIGGER_LISTENERS WHERE TRIGGER_NAME = ? AND TRIGGER_GROUP = ?
14 Execute [51] SELECT TRIGGER_LISTENER FROM QRTZ_TRIGGER_LISTENERS WHERE TRIGGER_NAME = 'VolumeReportEMailTrigger' AND TRIGGER_GROUP = 'DEFAULT'
14 Prepare [52] INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
081106 19:40:03 19 Connect root@localhost on mydb
19 Query SET NAMES latin1
19 Query SET character_set_results = NULL
19 Query SHOW VARIABLES
19 Query SHOW COLLATION
19 Query SET autocommit=1
19 Query SET sql_mode='STRICT_TRANS_TABLES'
19 Query SET autocommit=1
19 Query SET autocommit=0