HSQLDB Error on startup

For some reason on starting Team City via the web browser I get the an error.

  • Team City was working when I installed last week.
  • I have reinstalled
  • I have recreated the database
  • Using version 6


Can someone let me know what is this probelm please?

Error

jetbrains.buildServer.serverSide.db.UnexpectedDBException: SQL error when doing: Connecting to HSQLDB
SQL exception: error in script file line: 171 out of memory
   at org.hsqldb.jdbc.Util.sqlException(Util.java:63)
   at org.hsqldb.jdbc.jdbcConnection.<init>(jdbcConnection.java:2430)
   at org.hsqldb.jdbcDriver.getConnection(jdbcDriver.java:183)
   at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:161)
   at jetbrains.buildServer.serverSide.db.jdbcLoader.JdbcDataSource.getConnection(JdbcDataSource.java:47)
   at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.connect(TeamCityDatabaseManager.java:215)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.setupAndConnectToDB(TeamCityDispatcherServlet.java:188)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:423)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerSafe(TeamCityDispatcherServlet.java:263)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$400(TeamCityDispatcherServlet.java:183)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$5.run(TeamCityDispatcherServlet.java:2)
   at java.lang.Thread.run(Unknown Source)
caused by: java.sql.SQLException: error in script file line: 171 out of memory
   at org.hsqldb.jdbc.Util.sqlException(Util.java:63)
   at org.hsqldb.jdbc.jdbcConnection.<init>(jdbcConnection.java:2430)
   at org.hsqldb.jdbcDriver.getConnection(jdbcDriver.java:183)
   at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:161)
   at jetbrains.buildServer.serverSide.db.jdbcLoader.JdbcDataSource.getConnection(JdbcDataSource.java:47)
   at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.connect(TeamCityDatabaseManager.java:215)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.setupAndConnectToDB(TeamCityDispatcherServlet.java:188)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:423)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerSafe(TeamCityDispatcherServlet.java:263)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$400(TeamCityDispatcherServlet.java:183)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$5.run(TeamCityDispatcherServlet.java:2)
   at java.lang.Thread.run(Unknown Source)


Message was edited by: David Wong

1 comment
Comment actions Permalink

Hi David

Usually root cause of this error is a corruption of HSQLDB database.
You'll have to restore it from backup, or completely and re-create TeamCity data directory.
But we recommend to switch to external database to prevent such issues in future.

Michael

0

Please sign in to leave a comment.