Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

HSQL DB - problem

What does it mean:
You are using HSQL DB, which is an in-memory database and susceptible to corruption when abnormally terminated. DO NOT USE THIS IN A PRODUCTION SYSTEM. Instead we recommend using an external database, for a list of supported databases please see our documentation.

2 answers

1 accepted

1 vote
Answer accepted

Hi Pawel,

The quicker way would be to export your instance to XML and set up a new production JIRA connected to a proper database, like PostgreSQL, MySQL, Oracle or MSSQL and finally reimport your XML again.

Everything is very detailed on this KB.

Best regards,

Felipe Alencastro

It means do not use HSQLDB for production systems.

JIRA ships with a built-in HSQLDB (HyperSQL DataBase) database. While this database is suitable for evaluation purposes, it is susceptible to data loss during system crashes. Hence, for production environments we strongly recommend that you configure JIRA to use an external database.

The list of supported databases means Atlassian tests out their products and supports those databases. It does not mean all databases should be used for production. In fact, Atlassian makes it very clear, HSQLDB should not be used.

What happens if you use an unsupported database, you could have support deny you fixing your problem unless you can show the problem exists on a supported database.

One thing it doesn't explicitly mention - HSQL in Jira can sometimes fail catastrophically and without warning. That can be ok in a test system, as they can be "throwaway" and are usually rebuilt from standard test data or copies, but it's not acceptable in production. Seriously, use another database, as it advises.

How and where can I change database?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

ThinkTilt is joining the Atlassian Family!

This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...

976 views 31 33
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you