This page last changed on Jul 06, 2006 by ivan@atlassian.com.

java.sql.SQLException: User not found: SA

Also 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.

HSQLDB should not be used as a production database. It is included for evaluation purposes only.

Hibernate logging

It can be useful to enable detailed Hibernate logging when debugging problems with HSQL.

Restore system from backup appears to relate to this topic.

Posted by sheltbw at Sep 28, 2005 14:42
Document generated by Confluence on Mar 22, 2007 20:58