The embedded database health check has failed in your system

[MelviN]

"The embedded database health check has failed in your system" what is the problem?

[Kurt Klinner · Accepted solution]

@MelviN 

Hi Melvin

any chance you are using the embedded db with a production license key?https://confluence.atlassian.com/support/instance-health-790796828.html

The H2 database is not intended for use for productive purposes

Cheers

Kurt

[Nic Brough -Adaptavist-]

We would strongly recommend that the very next project you do is to migrate from the h2 database to one of the proper databases on the "supported platform" page for your version of Confluence.

H2 databases don't scale well, and are only suitable for systems that you don't mind losing (dev/test/play) - the database can fail catastrophically with no notice and you can lose everything irrecoverably.

[MelviN]

What database do you recommend?

[Nic Brough -Adaptavist-]

Given a completely free choice, PostGreSQL first (because that's what Atlassian use and develop against primarily), MySQL second, Oracle third, and Microsoft-SQL last.

It is not a huge gap between them, and my list is based purely on the experiences of which ones have given me the least and most grief in the past.   The software works with, and is supported on, all four.

So, my real life recommendation is actually "whichever one your organisation has the best support for already".