Kanban board does not have data in it after DB restore

Question

Hello,

We are working on Jira data recovery

1, We took DB from our prod, rolled back in time, and put that db into our test server. Our test server has the same SW version number as our prod

2. we see a correct Kanban Board, but the board shows not data in it.

Should we re-index Jira (but full re-index takes more than a day) ? Also is there a way to force Jira NOT to use index but search the DB 'live 'without index?

Any other suggestions?  The DB should have data in it, but all we see is a shell (like the Board name, that is it)

Nic Brough -Adaptavist- · Answer

Hi Olga,

Your guess at the index being the problem is correct - you will need to run a full re-index to make it work.

Searches all work from the index, and the boards all work from a search.  There's no code in Jira to run any search against the raw database (it would be unusably slow, so there's no reason or way to do it)

There is one way to bypass the need to re-index in this case, but it only works if you took Jira down during the database backup, and took a copy of the production index files at the same time.  Effectively, you copy the working index from production.  You say you've rolled the db back though, so that is not an option.

Olga Mill · Answer

How much Jira software relies on the indexing files to retrieve the data? Does Jira use index files or look into the DB itself ?

Olga Mill · Answer

Thank you ! We are trying that right now