Confluence with HSQLDB Throws a "User not found" Exception


アトラシアン コミュニティをご利用ください。



The following message appears when restarting Confluence, on a site using the evaluation HSQLDB database:

java.sql.SQLException: User not found: SA


HSQLDB periodically updates its files to represent changes made in the database. In doing so, it deletes the MY_CONFLUENCE_HOME\database\ file on the file system and replaces it with a new one.

If you shut down Confluence while the database is deleting and replacing the file, data can be lost. Typically, you will see the above error message when restarting Confluence.


Restore the backups contained in the MY_CONFLUENCE_HOME\backups directory.

If daily backups have been turned off, and no other copy of the data remains, the data is lost.

For more information see

More about Confluence and HSQLDB

The Confluence installation includes an embedded HSQLDB database, supplied for the purpose of evaluating Confluence.

If you are using the embedded database, the database files are stored in the \database directory under your Confluence Home and other important directories.

注意: 組み込みの HSQLDB データベースは本番環境用の Confluence サイトには適していません。

Production sites should use an external database. See our guide to database configuration. When using the default HSQLDB database, you run the risk of irrecoverable data loss because HSQLDB is not transaction safe.

  • Corruption is occasionally encountered after sudden power loss. It can usually be corrected using the data recovery procedure documented in our knowledge base.
  • HSQLDB は Confluence の評価用であり、データ消失リスクを回避するには外部データベースを使用することが唯一の方法です。このことは、Confluence の評価を終えて本番環境に移行する際には極めて重要な点です。外部データベースは、動作速度やスケーラビリティの面でも有利です。

To find out if you are still using the embedded database, go to  > General Configuration > Atlassian Support Tools > Health Check

Last modified on Mar 30, 2016


Powered by Confluence and Scroll Viewport.