[#RHQ-1101] need to test upgrade to make sure there is nothing in quartz tables we need to delete

RHQ Project

RHQ-1100

need to test upgrade to make sure there is nothing in quartz tables we need to delete

Created: 11/Nov/08 02:29 PM Updated: 08/Dec/08 07:29 AM

Component/s:

Core Server

Affects Version/s:

None

Fix Version/s:

1.2

Time Tracking:

Not Specified

Resolution Date:	11/Nov/08 03:29 PM
VCS Revision:	1,963

Description

« Hide

Since we are now getting rid of the baseline job, it means it will no longer be scheduled in Quartz.

We need to test to make sure that after we upgrade from an old version, we no longer have the baseline job still scheduled in the quartz tables.

This baseline job was non-volatile, so I think it will show up in the RHQ_QRTZ tables. I think we may need to add something to our db-upgrade script to remove the baseline job.

All

Comments

Work Log

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

John Mazzitelli - 11/Nov/08 03:14 PM

delete from rhq_qrtz_triggers where trigger_name = 'org.rhq.enterprise.server.scheduler.jobs.AutoBaselineCalculationJob'

delete from rhq_qrtz_simple_triggers where trigger_name = 'org.rhq.enterprise.server.scheduler.jobs.AutoBaselineCalculationJob'

delete from rhq_qrtz_job_details where job_name = 'org.rhq.enterprise.server.scheduler.jobs.AutoBaselineCalculationJob'

[ Permlink | « Hide ]

John Mazzitelli - 11/Nov/08 03:21 PM

we do need to do this. this error happens if we do not clean the quartz tables:

16:17:23,609 ERROR [JobStoreCMT] MisfireHandler: Error handling misfires: Couldn
't store trigger: No ClassLoaders found for: org.rhq.enterprise.server.scheduler
.jobs.AutoBaselineCalculationJob
org.quartz.JobPersistenceException: Couldn't store trigger: No ClassLoaders foun
d for: org.rhq.enterprise.server.scheduler.jobs.AutoBaselineCalculationJob [See
nested exception: org.quartz.JobPersistenceException: Couldn't store trigger: No
ClassLoaders found for: org.rhq.enterprise.server.scheduler.jobs.AutoBaselineCa
lculationJob [See nested exception: java.lang.ClassNotFoundException: No ClassLo
aders found for: org.rhq.enterprise.server.scheduler.jobs.AutoBaselineCalculatio
nJob]]
        at org.quartz.impl.jdbcjobstore.JobStoreCMT.doRecoverMisfires(JobStoreCM
T.java:1343)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(Jo
bStoreSupport.java:2449)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobSt
oreSupport.java:2468)

[ Permlink | « Hide ]

John Mazzitelli - 11/Nov/08 03:29 PM

db-upgrade.xml now purges the old auto-baseline calc job