Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-59938

Improve the schedule job status and history cache in DC

XMLWordPrintable

    • 1
    • 7
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Currently, with the DC implementation, the scheduled job status and history were not cached which results in the following query has been executed on every each scheduled job execution against the database:
      (example in oracle)

      select * from ( select schedulerr0_.id as id1_51_, schedulerr0_.job_id as job_id2_51_, 
       schedulerr0_.start_time as start_time3_51_, schedulerr0_.duration as duration4_51_, 
       schedulerr0_.outcome as outcome5_51_, schedulerr0_.message as message6_51_ 
       from scheduler_run_details schedulerr0_ where schedulerr0_.job_id=:1 order by schedulerr0_.start_time desc ) 
       where rownum <= :2 
      

      This is causing unnecessary database resource consumption, and in case the scheduled job cleanup job failed to execute for some reason, it might cause heavy performance issues.

      It will be great to check what could be a better way to handle this data that supposed to be cached.

              Unassigned Unassigned
              yilinmo Yilin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: