Confluence : Troubleshooting the Embedded Database (hSQL DB)
This page last changed on Jul 06, 2006 by ivan@atlassian.com.
java.sql.SQLException: User not found: SAAlso see http://hsqldb.sourceforge.net/doc/guide/ch01.html#N101C2 . HSQLDB periodically must update its files to represent changes made in the database. In doing so, it must delete the current confluencedb.data file on the filesystem (beneath conf.home/database) and replace it with a new one. If an administrator issues a shutdown on Confluence in this period, data can be lost, and is typically noticed by the error message, when starting Confluence up again, of 'User not found: SA' . Users encountering this problem should seek to restore backups, contained in the backup directory beneath confluence.home. If daily backups have been turned off, and no other copy of data remains, the data is lost.
Hibernate loggingIt can be useful to enable detailed Hibernate logging when debugging problems with HSQL.
|
![]() |
Document generated by Confluence on Mar 22, 2007 20:58 |