Wrong Issue Count displayed on a version

[Chander Inguva]

Hi All,

           I see that there is a wrong count of issues displayed on a project version in version panel view though clicking the version displays issues.

• Performed Re-Indexing - It did not help
  
  

Nothing in logs. Please share your thoughts

Regards

Chander Inguva

[Matheus Fernandes · Accepted solution]

I have seen similar problems when there were invalid associations in the nodeassociation table, pointing issues to (in that case components) that didn't exist, but I imagine the same could happen for versions.

I'd suggest reaching out to our support on support.atlassian.com though.

Reference: https://confluence.atlassian.com/x/8YCVCQ

[Chander Inguva]

Hi Matheus,

                    Just found the database has some missed links.

select count(*) from nodeassociation where sink_node_id not in (select id from projectversion) and association_type = 'IssueFixVersion';

and 

select count(*) from nodeassociation where sink_node_id not in (select id from projectversion) and association_type = 'IssueVersion';

Expected: They should return 0 rows

But, its displaying records when executed.

Workaround:

delete from nodeassociation where sink_node_id not in (select id from projectversion) and association_type = 'IssueFixVersion';

and

delete from nodeassociation where sink_node_id not in (select id from projectversion) and association_type = 'IssueVersion';

Also i ran these queries to identify which projects have been affected

select COUNT(*) as distinct_issues_in_project, PROJECT from jiraissue 
 where ID IN (select distinct(SOURCE_NODE_ID) from nodeassociation 
where sink_node_id not in (select id from projectversion) and association_type = 'IssueFixVersion') group by PROJECT;

and

select ID, pname from project where ID in (<Project ID's from above query>);

[Matheus Fernandes]

You will need to re-index JIRA after deleting the missing links if that's the case. Let us know if that fixes the issue. :)

[Chander Inguva]

Hey Matheus.I will execute that during weekend and let you know.

[Matheus Fernandes]

I'll be awaiting! :)

[Chander Inguva]

Hey Matheus. I applied this on Dev and it worked.