eazyBI Source Data import 스케쥴이 실행되지 않는 문제

환경

• Jira 8.4.2 DC
• Mysql 5.7X

예상원인

1. eazyBI DataBase를 다른 Jira Instance에서 공유해서 사용하고 있을 가능성
2. import 스케쥴 날짜 설정이 잘못된 가능성

확인방법

1. database에서 프로세스 조회
   실행 후 Host 컬럼 확인하여 정상적인 Jira Instance에서 접속중인지 확인

   mysql> show processlist;

2. eazyBI 고급 기능에서 스크립트 실행
   1. Open eazyBI Advanced settings page.

   2. Add the following options:

      [troubleshooting]
      eval_code = true

   3. Click on the button "Update advanced settings".
   4. Open eazyBI Troubleshooting page.
   5. Find the field "Evaluate code".

   6. Copy and paste into it the following code:

      results = []
      results << SystemEvent.search_results(q: 'start_regular_imports.source_application', per_page: 10)
      results << "-----------------"
      results << SystemEvent.search_results(q: 'start_import.source_application', per_page: 10)
      results << "-----------------"
      results << RegularJob.all.to_a
      results

   7. Click on the button "Evaluate".
   8. Copy results that will be displayed below the button.
   9. Remove added lines from advanced settings

조치방법

1. eazyBI DB 권한설정을 통하여 특정 IP에서만 접근 가능하도록 변경

2. 스크립트 실행결과에 고정된 날짜가 노출되면 제거하는 스크립트 실행

   실행결과

   [[], "-----------------", [], "-----------------", [#<RegularJob id: 1, job_name: "SourceApplication.start_regular_imports", lock: nil, locked_at: "2050-04-22 05:58:00", lock_released_at: "2050-04-22 05:58:00", created_at: "2019-10-27 14:58:24", updated_at: "2019-10-27 14:58:24">, #<RegularJob id: 2, job_name: "DashboardEmailSubscription.start_regular_emails", lock: nil, locked_at: "2050-04-22 05:58:00", lock_released_at: "2050-04-22 05:58:00", created_at: "2019-10-27 14:58:24", updated_at: "2019-10-27 14:58:24">, #<RegularJob id: 3, job_name: "RegularJob.cancel_orphan_jobs", lock: nil, locked_at: "2050-04-22 05:58:00", lock_released_at: "2050-04-22 05:58:00", created_at: "2019-10-27 14:58:24", updated_at: "2019-10-27 14:58:24">]]

   아래 내용 수행 시 import 스케쥴이 다시 실행됨

   1. Open eazyBI Advanced settings page.
   2. Add the following options:
   [troubleshooting]
   eval_code = true
   3. Click on the button "Update advanced settings".
   4. Open eazyBI Troubleshooting page.
   5. Find the field "Evaluate code".
   6. Copy and paste into it the following code:
   RegularJob.all.map do |rj|
     [rj.id, rj.update_attributes(locked_at: nil, lock_released_at: nil)]
   end
   7. Click on the button "Evaluate".
   8. Copy results that will be displayed below the button.
   9. Remove added lines from advanced settings.
   10. Wait for ten minutes and then check does the regular imports are renewed