Kanban board does not have data in it after DB restore

[Olga Mill]

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-]

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]

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

[Craig Nodwell]

Hi @Olga Mill welcome to the community.  You can connect to the database using any database management tool, once connected you can execute sql to query for information in the tables.

[Olga Mill]

Thank you ! We are trying that right now

[Olga Mill]

Any way to run SQL query from JIRA to see if the DB has data that we need ?