HSQL DB - problem

sledzinski
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 8, 2014

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
FelipeA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 9, 2014

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

0 votes
Norman Abramovitz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 8, 2014

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.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 8, 2014

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.

sledzinski
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 9, 2014
How and where can I change database?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events