Why would Jira run config setup on an established system? Can't find any Projects or Stories.

[Orlando Garcia]

After over 6 months of using JIRA , this weekend, it seems something has gone wrong on our JIRA system. When we pull up Jira Dashboard, it prompts to run Config Setup over again.

We already have over 300 stories and 4 projects already established. It seems that there is data loss. I find Storie Folders inside "C:\Program Files\Atlassian\Application Data\JIRA\data\attachments\" but not the actual stories.

Database in: C:\Program Files\Atlassian\Application Data\JIRA\database is only 2.42mb

Where else can I look for story info or restore my data?

[Nic Brough -Adaptavist- · Accepted solution]

Jira starts trying to do the setup again when it cannot find the basic core data in the database.

I suspect your database has failed, so it looks to be empty.  The reason I suspect that is that you've said you have a database on the file system, which implies you are using the embedded h2 database which is not suitable for long term use or production, as it does fail without warning.

Can you confirm that you were using the internal database?  You have not set up a supported database (PostGres, MySQL, Oracle or MS-SQL)?

[Orlando Garcia]

I believe postgres. Where can I see original install info?

[Orlando Garcia]

dbconfig.xml states h2.

Is there anywhere else in the server where the stories may reside or is all lost?

[Nic Brough -Adaptavist-]

I'm afraid if an h2 database fails, it's usually terminal or catastrophic, and most or all of it has gone.  You might be able to read and repair it, but it is unlikely.

If you have been taking backups of the local jira-home directory, then you may be able to replace files in the database directory from that.

The other option is hopefully you have not turned off the default internal backups.  If that is true, then take a look under data/exports - there should be some .zip files with dates in them. 

Take some nice safe copies of recent ones of these, re-install a clean Jira and then import the data from the latest one of them.  (In fact, those are the files you could also use to migrate to a supported database!)

[Orlando Garcia]

Thank you so much! You have saved the day!! Appreciate the quick responses!!

Cheers!

Orlando