Unable to start TeamCity
Hi i have inherited a teamcity server that i am unable to start. The server is configured for HSQLDB, but would like to migrate it to MSSQL Server.
I am getting the following entries in the TeamCity-Server.log file:
[2016-12-21 16:32:54,234] INFO - jetbrains.buildServer.STARTUP -
[2016-12-21 16:32:54,234] INFO - jetbrains.buildServer.STARTUP - ===========================================================
[2016-12-21 16:32:54,234] INFO - jetbrains.buildServer.STARTUP - Starting TeamCity server
[2016-12-21 16:32:54,655] INFO - jetbrains.buildServer.STARTUP - TeamCity version: 9.1.7 (build 37573), data format version 727
[2016-12-21 16:32:54,670] INFO - jetbrains.buildServer.STARTUP - OS: Windows Server 2008 R2, User: TEAMCITY$, JRE: 1.8.0_66, Java HotSpot(TM) Server VM (32 bit) (25.66-b17, mixed mode), Java(TM) SE Runtime Environment (1.8.0_66-b17), Oracle Corporation
[2016-12-21 16:32:54,670] INFO - jetbrains.buildServer.STARTUP - JVM parameters: -Djava.util.logging.config.file=c:\TeamCity\bin\..\conf\logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xrs -Xmx512m -XX:MaxPermSize=270m -Dteamcity.configuration.path=../conf/teamcity-startup.properties -Dlog4j.configuration=file:../conf/teamcity-server-log4j.xml -Dteamcity_logs=../logs/ -Djava.endorsed.dirs=c:\TeamCity\bin\..\endorsed -Dcatalina.base=c:\TeamCity\bin\.. -Dcatalina.home=c:\TeamCity\bin\.. -Djava.io.tmpdir=c:\TeamCity\bin\..\temp
[2016-12-21 16:32:54,670] INFO - jetbrains.buildServer.STARTUP - Garbage collection: PS Scavenge, PS MarkSweep
[2016-12-21 16:32:54,670] INFO - jetbrains.buildServer.STARTUP - Web server version: Apache Tomcat/7.0.59
[2016-12-21 16:32:54,670] INFO - jetbrains.buildServer.STARTUP - Server IP address: 10.10.42.24
[2016-12-21 16:32:54,686] INFO - jetbrains.buildServer.STARTUP - Web server ports: 8080 (protocol: org.apache.coyote.http11.Http11NioProtocol, scheme: http), 8105 (shutdown port)
[2016-12-21 16:32:54,702] INFO - rocesses.ProcessTreeTerminator - Using jetbrains.buildServer.processes.ProcessTreeTerminatorWindows
[2016-12-21 16:32:54,920] INFO - jetbrains.buildServer.STARTUP - TeamCity server process ID (1464) stored in: C:\TeamCity\logs\teamcity.pid
[2016-12-21 16:32:54,920] INFO - jetbrains.buildServer.STARTUP - Version file lock was successfully obtained: c:\TeamCity\bin\..\webapps\ROOT\BUILD_37573
[2016-12-21 16:32:54,951] INFO - jetbrains.buildServer.STARTUP - Servlet real path: c:\TeamCity\bin\..\webapps\ROOT\
[2016-12-21 16:32:54,982] INFO - jetbrains.buildServer.STARTUP - Current stage: Looking for the TeamCity Data Directory
[2016-12-21 16:32:54,982] INFO - jetbrains.buildServer.STARTUP - The TeamCity Data Directory path is determined using the environment variable TEAMCITY_DATA_PATH
[2016-12-21 16:32:55,014] INFO - jetbrains.buildServer.STARTUP - The TeamCity Data Directory "C:\ProgramData\JetBrains\TeamCity" exists
[2016-12-21 16:32:55,029] INFO - jetbrains.buildServer.STARTUP - The main configuration file "C:\ProgramData\JetBrains\TeamCity\config\main-config.xml" exists
[2016-12-21 16:32:55,029] INFO - jetbrains.buildServer.STARTUP - The database properties file "C:\ProgramData\JetBrains\TeamCity\config\database.properties" exists
[2016-12-21 16:32:55,029] INFO - jetbrains.buildServer.STARTUP - The internal database data file "C:\ProgramData\JetBrains\TeamCity\system\buildserver.data" exists
[2016-12-21 16:32:55,138] INFO - jetbrains.buildServer.STARTUP - Data Directory version: 727
[2016-12-21 16:32:55,138] INFO - jetbrains.buildServer.STARTUP - Current stage: Looking for the database configuration
[2016-12-21 16:32:55,138] INFO - jetbrains.buildServer.STARTUP - Database properties file "C:\ProgramData\JetBrains\TeamCity\config\database.properties" exists
[2016-12-21 16:32:55,138] INFO - jetbrains.buildServer.STARTUP - Internal HSQL database file (C:\ProgramData\JetBrains\TeamCity\system\buildserver.data) exists, version: 1.8.1
[2016-12-21 16:32:55,138] INFO - jetbrains.buildServer.STARTUP - Database connection URL: jdbc:hsqldb:file:$TEAMCITY_DATA_DIRECTORY/buildserver
[2016-12-21 16:32:55,138] INFO - jetbrains.buildServer.STARTUP - Using database connection URL from the database properties file. The URL is: jdbc:hsqldb:file:$TEAMCITY_DATA_DIRECTORY/buildserver
[2016-12-21 16:32:55,138] INFO - jetbrains.buildServer.STARTUP - Using internal (HSQL) database
[2016-12-21 16:32:55,138] INFO - jetbrains.buildServer.STARTUP - Current stage: Connecting to the database
[2016-12-21 16:32:57,650] ERROR - jetbrains.buildServer.STARTUP - Unexpected exception SQLException/HsqlException: SQL error when doing: Taking a connection from the data source
SQL exception: error in script file line: C:\TeamCity\bin\$TEAMCITY_DATA_DIRECTORY\buildserver 276
[2016-12-21 16:32:57,650] INFO - jetbrains.buildServer.STARTUP - Current stage: TeamCity server startup error
I also tried to use the maintaindb.cmd script to migrate the database, and i receive the following java errors:
java.lang.OutOfMemoryError: Java heap space
The data file appears to be 131 MB in size.
Thanks
Please sign in to leave a comment.
Hello Bryan,
It looks like the HSQL database is corrupted. Do you have a TeamCity data backup? Please restore from it.
Please use TEAMCITY_MAINTAINDB_MEM_OPTS_ACTUAL option to allocate more Java heap space to the maintaindb utility.