Re-Indexing Issue: issues missing from search and Agile board

Question

Re-indexed JIRA this morning due to workflow updates for new projects.  However, the re-indexing caused issues to be missing from planned versions or to not be searched for from the issue navigator or the quick search.  However, the issues is still present in JIRA.

What give?

Rachel

Thiago Ribeiro · Answer

Rachel,

You have mentioned that Workflow changes were done, so I would suggest you to check your Board Column mappings to see if all statuses are properly mapped and also to have a look on this KB article:

Issues are not appearing in GreenHopper Rapid Boards

I hope it helps you!

Tiago Comasseto · Answer

Hi Rachel,

Just sharing with our community the resolution to this index issue. It was related to MySQL timestamp conversion. I've created a KB article explaining the cause and including the steps to solve this problem:

https://confluence.atlassian.com/display/JIRAKB/Re-index+fail+due+to+timestamp+conversion+issue

Cheers

vkharisma · Answer

Hi Rachel, does the problem still persist on your side? Are you able to search the issue now? Just addition to what Sachin said above, you can clear the cache by doing as per following steps:

* Stop JIRA.
* Remove the following directory and all its subdirectories:

$JIRA_HOME/caches/indexes

This will be rebuilt when JIRA is next reindexed.

* Start JIRA.
* Perform a re-index of JIRA through the Administration section.

If the problem still persist, I'd suggest you to contact https://support.atlassian.com and provide the log file for further investigation. Once the problem is resolved, kindly spend time to update this post.

Cheers, Vicky.