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
Please sign in to leave a comment.
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