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.
Nothing in logs. Please share your thoughts
Regards
Chander Inguva
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
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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. :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Matheus.I will execute that during weekend and let you know.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'll be awaiting! :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Matheus. I applied this on Dev and it worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.