How do you remove a filter that does not exist?

[Stephan van der Linde]

Good day

So we have a very weird issue with Jira server.

Every morning, a subscription for a filter gets received via email. However when I view it, Jira responds that the filter does not exist. The name of said filter is "Atlassian High Priority" and the filter ID is 17219.

We deleted all filters with that name in Jira, yet the filter subscription still gets sent through every morning. I also did a check in the Jira DB if I can find the filter with ID 17219 and it is not there.

Has anyone ever had similar issue with these "ghost filters"? Any advice would be greatly appreciated, as I am not sure where to start on how to remove it.

[Payne]

Perhaps the filter does exist, but you don't have permission to view it, so it appears not to exist?

When you say you looked in the DB, do you mean directly? e.g. ran a query like

select * from jiradb.searchrequest where ID=17219

If it's not there, then you may consider removing records from the filtersubscription table. I never advocate making direct database updates, but in this case, I tend to think that there would not be any side effects, and it may be the only way to remedy the situation. You could check for subscription records with

select * from jiradb.filtersubscription where FILTER_I_D = 17219

to confirm their existence and then delete them. 

[Stephan van der Linde]

Hi,

Thanks for the reply and sorry for the late response. After querying the filter ID from the filtersubscription table, results came up empty.

Thanks for the suggestion.

Stephan

[Fazila Ashraf]

@Stephan van der Linde , not sure whether this will help but can you try to run Integrity checker (https://confluence.atlassian.com/adminjiraserver/using-the-database-integrity-checker-938847667.html) for the below checks?

[Stephan van der Linde]

Hi @Fazila Ashraf 

Thanks for the reply, ran it and all checks passed: