Error in Scheduler Administration "com.atlassian.jira.issue.subscription.DefaultSubscriptionManager:XXXX"
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
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 go to the subscription and verify if the filter has an issue or not.
1select * 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.
1select * 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.
Solution
Resolution
We have to remove the Scheduler entry (for the invalid subscription) from JIRA Database.
To verify the entry
1
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
1
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.
Was this helpful?