JdbcSchedulerHistoryPlugin & H2 DB connection problem
Closed this issue · 8 comments
GoogleCodeExporter commented
What steps will reproduce the problem?
1. configure myschedule-2.4.2, h2-1.3.166, quartz.properties generically.
2. create/start scheduler
3. monitor job history
What is the expected output? What do you see instead?
expecting triggerFired/triggerComplete for JobHistoryRemovalJob, receiving
triggerFired/triggerMisfired/ScheduleError instead.
Please use labels and text to provide additional information.
quartz.properties is as follows:
org.quartz.scheduler.skipUpdateCheck = true
org.quartz.scheduler.instanceName = QuartzScheduler
org.quartz.scheduler.jobFactory.class = org.quartz.simpl.SimpleJobFactory
org.quartz.scheduler.instanceId = NON_CLUSTERED
org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore.driverDelegateClass =
org.quartz.impl.jdbcjobstore.StdJDBCDelegate
org.quartz.jobStore.dataSource = quartzDataSource
org.quartz.jobStore.tablePrefix = QRTZ_
org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount = 5
# JobStore: JDBC jobStoreTX
org.quartz.dataSource.quartzDataSource.driver = org.h2.Driver
org.quartz.dataSource.quartzDataSource.URL = jdbc:h2:~/test
org.quartz.dataSource.quartzDataSource.user = sa
org.quartz.dataSource.quartzDataSource.password =
org.quartz.dataSource.quartzDataSource.maxConnections = 9
# Jdbc Scheduler History Plugin
org.quartz.plugin.MyJobHistoryPlugin.class =
myschedule.quartz.extra.JdbcSchedulerHistoryPlugin
org.quartz.plugin.MyJobHistoryPlugin.insertSql = INSERT INTO
qrtz_scheduler_history VALUES(?,?,?,?,?,?,?,?,?,?,?)
org.quartz.plugin.MyJobHistoryPlugin.querySql = SELECT * FROM
qrtz_scheduler_history ORDER BY event_time DESC
org.quartz.plugin.MyJobHistoryPlugin.deleteSql = DELETE qrtz_scheduler_history
WHERE event_time < ?
org.quartz.plugin.MyJobHistoryPlugin.deleteIntervalInSecs = 604800
org.quartz.plugin.MyJobHistoryPlugin.dataSourceName = quartzDataSource
org.quartz.plugin.MyJobHistoryPlugin.schedulerContextKey =
JdbcSchedulerHistoryPlugin.Instance
tomcat 7 logs the attached:
Thanks for the great tool, btw!
John
Original issue reported on code.google.com by uove...@gmail.com
on 31 May 2012 at 7:49
Attachments:
GoogleCodeExporter commented
Hi John, thanks for reporting this bug. Yes I see a obvious mistake of not
setting the SQL param when deleting old histories. I will try to put out a fix
soon.
Original comment by saltnlight5
on 1 Jun 2012 at 2:31
- Changed state: Accepted
GoogleCodeExporter commented
John, can you plz give the latest myschedule-quartz-extra-2.4.3-SNAPSHOT.2.jar
a try?
Original comment by saltnlight5
on 1 Jun 2012 at 3:46
GoogleCodeExporter commented
Hi Zemian,
Good news - immediate problem is solved - thanks!
Do you have any thoughts/ideas why this job might continue to throw
triggerMisfired events?
I've attached some job/trigger details.
Good progress - thanks for your help!
John
Original comment by uove...@gmail.com
on 1 Jun 2012 at 5:29
Attachments:
GoogleCodeExporter commented
This issue was closed by revision fef0c9103db8.
Original comment by saltnlight5
on 1 Jun 2012 at 11:22
- Changed state: Fixed
GoogleCodeExporter commented
John,
Are you saying the "JobHistoryRemovalJob" itself is misfiring? The repeat
interval you set is large enough, so it shouldn't be. Can you print the logger
output text when this job is misfired? Can you verify the
"JobHistoryRemovalJob" and it's trigger is indead properly scheduled?
Original comment by saltnlight5
on 1 Jun 2012 at 5:02
- Changed state: Started
GoogleCodeExporter commented
Ah, I think I see the problem. I have set the start datetime of this
JobHistoryRemovalJob in the past instead of future date. I need to negate this.
I will give you another snapshot.3 to try.
Original comment by saltnlight5
on 1 Jun 2012 at 5:38
GoogleCodeExporter commented
Hi Zemian,
This looks great - thanks for the wonderful help!
Please close out this issue - a super job!
John
Original comment by uove...@gmail.com
on 2 Jun 2012 at 6:11
GoogleCodeExporter commented
No problem. Glad it works out for you. I will make these into a release soon.
Thanks for verifying.
Original comment by saltnlight5
on 2 Jun 2012 at 3:35
- Changed state: Fixed
- Added labels: Release-2.4.3