"out of memory" error with internal (HSQLDB) database

Symptoms

• "error in script file line: ... out of memory"
• "java.sql.SQLException: out of memory",

Solution

• try increasing server memory. If this does not help, most probably this means that you have encountered internal database corruption. You can try to deal with this corruption using the notes based on the HSQLDB documentation.

Possible workarounds

A way to attempt a manual database restore:

• stop the TeamCity server
• backup the <TeamCity Data Directory>/system/buildserver.data file
• remove the <TeamCity Data Directory>/system/buildserver.data file and replace it with a zero-size file of the same name.
• start the TeamCity server

Additional notes

If the database does not recover automatically, the chance that it can be fixed manually is minimal.

The internal (HSQL) database is not stable enough for production use, and we highly recommend using an external database for TeamCity non-evaluation usage. If you encountered database corruption, you can restore the last good backup or drop builds history and users, but preserve the settings, see Migrating to an External Database#Switching to Another Database.