On April 27, 2024, our Sign-in and Create Account options will be unavailable from 9am-12pm ET. During this maintenance window, developer account access and free trial registration will be unavailable.

Drastic grow of Quartz Trigger tables

Migrateduser
Migrateduser New
in Enterprise Process Service (EPS) #1

Hi there,

Recently we noticed that the Quartz trigger tabels starting to grow fast. In past the number of rows in these tabels remained fairly stable. All the triggers seem to be of the timeRestrictiongroup trigger group. Every day the trigger tables (QRTZ_TRIGGERS, QRTZ_JOB_DETAIL, QRTZ_SIMPLE_TRIGGERS) are growing by 60.000 rows. An hourly log of monitoring on QRTZ_TRIGGERS reveals the following:

ACTION_NAME RETURNCODE COUNT(*)
UPDATE 0 18528
DELETE 0 104
INSERT 0 3752

Several processes have steps with a time restriction, sometimes on the step and sometimes on the connection. Normally after a trigger fires it will be deleted from the table but this does not seems to be happening. Upon investigation of the fire time and the workitems we noticed that almost half of the total (600.000 to date) are in the past and the majorty of triggers are concerned with workitems that have status 9 (NOT ACCEPTED).

Is there any cause for this suddenly eratic behaviour?

How can we stop it?

Can we clean up de QUARTZ database by removing the triggers with a fire time in the past and concerning NOT ACCEPTED workitems?

Best regards,

Marc

EPS version 10.2.1 / Database Oracle 11g

Flag · Like

Categories