Error Retrieving Issues under the 'Component' Category in the 'Browse Project' Menu
There are few components shown under the project and each component will show the total number of open issues. However, when clicking on the particular component which has certain number of open issues, nothing appears in the issue navigator. The following error will be displayed in the logs:
2008-06-04 15:07:26,499 TP-Processor3 ERROR [jira.issue.statistics.ComponentStatisticsMapper] Indexes may be corrupt - unable to retrieve component with id '10061'.
There is an invalid component associated with the issues.
Alwaysyour data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
- Retrieve the invalid component id from the
atlassian-jira.log(10061 in the above example).
Run the following SQL statement to remove the invalid component id:
delete from nodeassociation where source_node_entity = 'Issue' AND sink_node_entity = 'Component' and sink_node_id='<invalid component id from jira logs>';
- Re-index JIRA
Track JRA-15750 for a permanent resolution to this issue.