Wrong Issue Count displayed on a version

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

 

2 answers

1 accepted

1 vote

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. smile

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

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>);

 

 

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. :)

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

I'll be awaiting! :)

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

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

138 views 0 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you