Problem

Under Administration Setting > System > SYSTEM SUPPORT > Scheduler details we see an error in some of the schedulers, after clicking Show more we observe an error like "com.atlassian.jira.issue.subscription.DefaultSubscriptionManager:XXXX"

Diagnosis

Diagnostic Steps

• Run the below query on the database to know the owner and name of the filter subscription. Once we have that we can fo to the subscription and verify if the filter has an issue or not. 

  select * from filtersubscription where ID=XXXX;

   Replace XXXX with the SUBSCRIPTION_ID we see in the error like in this case 10071

  
  

• If the above query gives a blank output then to double check please run the below query to check all the subscription id's in the DB and verify all the id's shown in the error are not present in JIRA. 

  select * from filtersubscription;

   If it is not present in the database then we can follow the steps in Resolution. 

Cause

We face this error when the subscription ID is not present in JIRA database but JIRA is still try read it. Due to this, it shows an error in the Scheduler Administration section. 

Resolution

We have to remove the Scheduler entry (for the invalid subscription) from JIRA Database. 

• To verify the entry

select * from clusteredjob where JOB_ID like '%XXXX%';

 For each error replace XXXX with the entry we see in the error "com.atlassian.jira.issue.subscription.DefaultSubscriptionManager:10071" .

• To delete the entries

DELETE from clusteredjob where JOB_ID like '%XXXX%' and ID = ZZZZ;

 Replace ZZZZ with the ID we get from the first query.

NOTE

• Please always take backups of JIRA DB using the native tool before proceeding with any changes.