Setup Error: jetbrains.buildServer.serverSide.db.HSQL.HsqlInternalError: SQL error when doing: Connecting to HSQL error

Hello I installed the latest version of TeamCity the installer said everything was sucessfull then I went to http//localhost:80 and I got the following exception.  I am new to the community so any assistance will be appreciated.


jetbrains.buildServer.serverSide.db.HSQL.HsqlInternalError: SQL error when doing: Connecting to HSQL error in script file line: 196 S1000 General error java.lang.NullPointerException in statement [SET TABLE AGENT INDEX'4 4 4 4 4 0']
SQL exception: error in script file line: 196 S1000 General error java.lang.NullPointerException in statement [SET TABLE AGENT INDEX'4 4 4 4 4 0']
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:49)
at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.connect(TeamCityDatabaseManager.java:222)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.setupAndConnectToDB(TeamCityDispatcherServlet.java:30)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.tryToUseDB(TeamCityDispatcherServlet.java:207)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.performOneAttempt(TeamCityDispatcherServlet.java:585)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.performSequentialAttempts(TeamCityDispatcherServlet.java:354)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$100(TeamCityDispatcherServlet.java:91)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$3.run(TeamCityDispatcherServlet.java:2)
at java.lang.Thread.run(Unknown Source)
caused by: java.sql.SQLException: error in script file line: 196 S1000 General error java.lang.NullPointerException in statement [SET TABLE AGENT INDEX'4 4 4 4 4 0']
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:49)
at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.connect(TeamCityDatabaseManager.java:222)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.setupAndConnectToDB(TeamCityDispatcherServlet.java:30)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.tryToUseDB(TeamCityDispatcherServlet.java:207)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.performOneAttempt(TeamCityDispatcherServlet.java:585)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.performSequentialAttempts(TeamCityDispatcherServlet.java:354)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$100(TeamCityDispatcherServlet.java:91)
at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$3.run(TeamCityDispatcherServlet.java:2)
at java.lang.Thread.run(Unknown Source)

1 comment
Comment actions Permalink

Hello,

It is a problem related to the embedded HSQL database. The possible reason is that TC service has no full access to the TeamCity Data Directory (see http://confluence.jetbrains.net/display/TCD7/TeamCity+Data+Directory to details).

During the TC on windows installation, the installer didn't create a database but just installs the software. When TeamCity starts the first time, it attempts to create a database. So as we can see the database creation process has failed.

In this case, I would ensure that TC service has full access to the Data Directory, delete all content from the Data Directory (of course if TC is just installed and contains no data yet) and try to start TC again.

If it didn't help, please provide me with the teamcit-server.log file - I'll attempt to investigate the problem.

Leonid

0

Please sign in to leave a comment.