i can see an issue in the front end application, but i cannot find the same issue in the DB.

Question

not sure what is happening.

but i can search for an issue in the search page, and it displays in the list.

however, if i click on the link for the issue, i get a screen suggesting that i dont have access to it.

what is odd, is that when i do a DB search on the JIraIssue table, i cannot find that issue in there...

so i am a bit confused on why the initial search can find that issue???

what can i do to solve this issue?

Nic Brough -Adaptavist- · Answer

Same here!

There is a long boring essay possible about how it works, but it is not too hard to summarise.

You said, "Search results come from the Lucene index", which covers most of the essay really well.

The bit I wanted to add was a note about when Jira does read the database.  It does it for

* Issue view (not as part of a search/report/gadget/board/queue, just the plain "look at the whole of an issue")
* Re-indexing
* Most permission checks
* Admin screens

It's a "source of truth" thing.

There are a few other bits, mostly because it's quicker and easier to ask the database for data directly rather than write a huge amount of code for a really simple abstraction that is rarely if ever, used.

The other thing was "try just a project re-index", or even just edit an issue that you think should be appearing in the search - editing an issue triggers a rebuild of all the index data for it, so if it is an index problem, that should fix it.  (Amend a system field to be 100% sure it triggers re-indexing.  I usually add or remove some punctuation from the summary or description; "Mr Flibble rocks." to "Mr Flibble rocks!" will re-index the whole issue)

Jared Kells_0on071 · Answer

😀 for sure, keen to hear back now!

Nic Brough -Adaptavist- · Answer

If re-indexing works here, then you need to take a long hard look at what you have set up that is corrupting your index.