issue in watchedIssues() returning incorrect results

[Esther Strom]

I'm looking for a way to find all the issues I'm watching in a certain project so I can unwatch them. I used "issue in watchedIssues()" JQL as provided in one of the answers here, and got a result of 1999 issues. (Note that I also tried "watcher = currentUser()" as suggested in another answer on the same post, and got the same results.)

I opened one of the issues returned and manually removed myself from the watchers list (i.e. when I look at the issue, it now shows Start Watching This Issue.) But when I go back and refresh the filter results, that issue is still there. I'm trying to use this filter to use the bulk actions to stop watching.

I tried running the unwatch action on the visible issues, but again, even though the action indicated that it completed successfully, I'm still seeing all 1999 issues in the filter. We're on 7.1.10; is this a bug or am I missing something?

[Fazila Ashraf]

@Esther Strom, I recently saw the same issue in my jira. It turned out to be the bug described in https://jira.atlassian.com/browse/JRASERVER-35622 

The workaround to update the db tables solved my issue. Could you check whether it is the same for you?

[Esther Strom]

It's possible that might be the problem, although there was no import involved. Unfortunately I'm the only one affected by this at this point (I'm the system admin), so mucking around in the database isn't allowed. If I start to hear about other users have this issue, then I'll look into it.

[Jobin Kuruvilla [Adaptavist]]

It might be that your search indexes are broken. Are you seeing any error in the logs? Can you do a full reindexing and see if it helps?

[Esther Strom]

No errors, but I'll try reindexing.

[Esther Strom]

I reindexed, and am still seeing all of the issues. It seems that watchedIssues() doesn't work properly.