We recently added/created several issues to the one of project of JIRA. Quite a few of those records cannot be accessed. I was able to print out an excel log of the issues but those issues are not accessible.
but when i click on any one of issues displayed message "The issue you are trying to view does not exist" .
Could you tell me if those issues does not exist or saved to data base , so from where these issues displaying for view either from temporary memory or some dummy table etc. Our end customer wants to know reason from where those issues displayed before applied re-index.
Unfortunately we are using HSQL database for production . please provide your valuable root cause to understand the issue.
I guess you ignored the warnings about using HSQL for production. You need to run sql commands to know for sure, but the database is corrupted.
HSQL is stored in (nearly) plain text, so you could take a copy of the database.script file and have a look through that for your lost data.
However, you need to work on the assumption that you've lost everything. As Norman says, you should NOT have used it for production, and frankly, I'd forget looking for your damaged/lost data for now, your top priority at the moment is to move it on to a supported database before you lose anything else.
No. The index is Lucene.
HSQLDB is the data store which holds all your issue data (except attachments). You can lose the Lucene index and rebuild it from the data store. You lose the data store, you lose everything.
You really need to move from HSQLDB to PostGreSQL, MySQL, Oracle or MS-SQL. Now.
I don't think that's of much use here, this system needs to be moved onto a supported database as soon as possible, then the lost data looked into.
Speculating about other databases isn't really relevant (although it is a good general question - I'd like to see others supported, and I've had it working fine on others as well)
The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs