TeamCity startup failure when loading roles

I'm running TeamCity 6.0.3 on Windows 2003. I restared my Windows box today and can't get TeamCity up and running again. At first, it failed with a "SecondTeamCityInstanceException". In response to that, I rebooted the OS again. Now TeamCity will make it to the "Loading roles" point in initialization, then go no further. I can't find any errors, it just stops. Log is below.

Please help me resolve this issue.

Thanks,


Justin Redd

[2011-12-16 09:26:17,641]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2011-12-16 09:26:17,751]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 6.0.3 (build 15925), data format version 418
[2011-12-16 09:26:18,237]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: D:\TeamCityData
[2011-12-16 09:26:19,179]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: 418
[2011-12-16 09:26:20,246]   WARN -   jetbrains.buildServer.SERVER - Enabling of prepared statements pooling is dangerous and should be avoided (can cause memory leaks), please remove poolPreparedStatements=true property from database.properties file
[2011-12-16 09:26:20,262]   INFO -   jetbrains.buildServer.SERVER - Database type: Oracle
[2011-12-16 09:26:20,294]   INFO -   jetbrains.buildServer.SERVER - Database connection URL: jdbc:oracle:thin:@ops.nike.net:1521:opsadmin
[2011-12-16 09:26:22,020]   INFO -   jetbrains.buildServer.SERVER - Database system: Oracle Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
[2011-12-16 09:26:22,020]   INFO -   jetbrains.buildServer.SERVER - Database driver: Oracle JDBC driver 10.2.0.3.0
[2011-12-16 09:26:22,020]   INFO -   jetbrains.buildServer.SERVER - Database format version: 418
[2011-12-16 09:26:22,036]   INFO - ide.db.TeamCityDatabaseManager - Attempt to capture TeamCity DB lock (java thread 23, starting code 338531061, attempt 1)
[2011-12-16 09:26:26,086]   INFO - ide.db.TeamCityDatabaseManager - The TeamCity DB lock is not captured (java thread 23, starting code 338531061, attempt 1)
[2011-12-16 09:26:35,170]   INFO - ide.db.TeamCityDatabaseManager - Attempt to capture TeamCity DB lock (java thread 23, starting code 338531061, attempt 2)
[2011-12-16 09:26:38,404]   INFO - ide.db.TeamCityDatabaseManager - The TeamCity DB lock is not captured (java thread 23, starting code 338531061, attempt 2)
[2011-12-16 09:26:45,812]   WARN - ide.db.TeamCityDatabaseManager - TeamCity server that is currently working:
 Starting code = 2108055758
 Starting time = 2011-12-12 13:28:09.0
 IP address = 146.197.89.137
 Application info = Apache Tomcat/6.0.29
[2011-12-16 09:26:45,828]  ERROR -   jetbrains.buildServer.SERVER - Server startup exception: jetbrains.buildServer.serverSide.db.SecondTeamCityInstanceException: Attempt to start more than one TeamCity server connected to the same database.
jetbrains.buildServer.serverSide.db.SecondTeamCityInstanceException: Attempt to start more than one TeamCity server connected to the same database.
 at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.lock(TeamCityDatabaseManager.java:338)
 at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:162)
 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)
[2011-12-16 09:41:07,333]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2011-12-16 09:41:07,364]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 6.0.3 (build 15925), data format version 418
[2011-12-16 09:41:07,427]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: D:\TeamCityData
[2011-12-16 09:41:07,943]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: 418
[2011-12-16 09:41:08,490]   WARN -   jetbrains.buildServer.SERVER - Enabling of prepared statements pooling is dangerous and should be avoided (can cause memory leaks), please remove poolPreparedStatements=true property from database.properties file
[2011-12-16 09:41:08,490]   INFO -   jetbrains.buildServer.SERVER - Database type: Oracle
[2011-12-16 09:41:08,490]   INFO -   jetbrains.buildServer.SERVER - Database connection URL: jdbc:oracle:thin:@ops.nike.net:1521:opsadmin
[2011-12-16 09:41:09,475]   INFO -   jetbrains.buildServer.SERVER - Database system: Oracle Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
[2011-12-16 09:41:09,475]   INFO -   jetbrains.buildServer.SERVER - Database driver: Oracle JDBC driver 10.2.0.3.0
[2011-12-16 09:41:09,475]   INFO -   jetbrains.buildServer.SERVER - Database format version: 418
[2011-12-16 09:41:09,475]   INFO - ide.db.TeamCityDatabaseManager - Attempt to capture TeamCity DB lock (java thread 28, starting code 2005873743, attempt 1)
[2011-12-16 09:41:09,647]   INFO - ide.db.TeamCityDatabaseManager - The TeamCity DB lock has been captured successfully (java thread 28, starting code 2005873743, attempt 1)
[2011-12-16 09:41:09,944]   INFO - Side.versioning.VersionManager - Configuration and Database versions are 418
[2011-12-16 09:41:14,712]   INFO -   jetbrains.buildServer.SERVER - Loading roles from the configuration file: D:\TeamCityData\config\roles-config.xml
[2011-12-16 09:59:19,031]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2011-12-16 09:59:19,171]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 6.0.3 (build 15925), data format version 418
[2011-12-16 09:59:19,609]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: D:\TeamCityData
[2011-12-16 09:59:21,171]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: 418
[2011-12-16 09:59:21,905]   WARN -   jetbrains.buildServer.SERVER - Enabling of prepared statements pooling is dangerous and should be avoided (can cause memory leaks), please remove poolPreparedStatements=true property from database.properties file
[2011-12-16 09:59:21,920]   INFO -   jetbrains.buildServer.SERVER - Database type: Oracle
[2011-12-16 09:59:21,920]   INFO -   jetbrains.buildServer.SERVER - Database connection URL: jdbc:oracle:thin:@ops.nike.net:1521:opsadmin
[2011-12-16 09:59:23,029]   INFO -   jetbrains.buildServer.SERVER - Database system: Oracle Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
[2011-12-16 09:59:23,029]   INFO -   jetbrains.buildServer.SERVER - Database driver: Oracle JDBC driver 10.2.0.3.0
[2011-12-16 09:59:23,029]   INFO -   jetbrains.buildServer.SERVER - Database format version: 418
[2011-12-16 09:59:23,045]   INFO - ide.db.TeamCityDatabaseManager - Attempt to capture TeamCity DB lock (java thread 31, starting code 1822308207, attempt 1)
[2011-12-16 09:59:23,279]   INFO - ide.db.TeamCityDatabaseManager - The TeamCity DB lock has been captured successfully (java thread 31, starting code 1822308207, attempt 1)
[2011-12-16 09:59:23,670]   INFO - Side.versioning.VersionManager - Configuration and Database versions are 418
[2011-12-16 09:59:39,149]   INFO -   jetbrains.buildServer.SERVER - Loading roles from the configuration file: D:\TeamCityData\config\roles-config.xml
[2011-12-16 10:40:41,205]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2011-12-16 10:40:41,236]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 6.0.3 (build 15925), data format version 418
[2011-12-16 10:40:41,361]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: D:\TeamCityData
[2011-12-16 10:40:42,799]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: 418
[2011-12-16 10:40:43,736]   WARN -   jetbrains.buildServer.SERVER - Enabling of prepared statements pooling is dangerous and should be avoided (can cause memory leaks), please remove poolPreparedStatements=true property from database.properties file
[2011-12-16 10:40:43,752]   INFO -   jetbrains.buildServer.SERVER - Database type: Oracle
[2011-12-16 10:40:43,767]   INFO -   jetbrains.buildServer.SERVER - Database connection URL: jdbc:oracle:thin:@ops.nike.net:1521:opsadmin
[2011-12-16 10:40:44,830]   INFO -   jetbrains.buildServer.SERVER - Database system: Oracle Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
[2011-12-16 10:40:44,830]   INFO -   jetbrains.buildServer.SERVER - Database driver: Oracle JDBC driver 10.2.0.3.0
[2011-12-16 10:40:44,830]   INFO -   jetbrains.buildServer.SERVER - Database format version: 418
[2011-12-16 10:40:44,845]   INFO - ide.db.TeamCityDatabaseManager - Attempt to capture TeamCity DB lock (java thread 38, starting code 960597515, attempt 1)
[2011-12-16 10:40:45,033]   INFO - ide.db.TeamCityDatabaseManager - The TeamCity DB lock has been captured successfully (java thread 38, starting code 960597515, attempt 1)
[2011-12-16 10:40:45,345]   INFO - Side.versioning.VersionManager - Configuration and Database versions are 418
[2011-12-16 10:40:51,158]   INFO -   jetbrains.buildServer.SERVER - Loading roles from the configuration file: D:\TeamCityData\config\roles-config.xml
[2011-12-16 10:43:27,831]   INFO -   jetbrains.buildServer.SERVER - Starting TeamCity server
[2011-12-16 10:43:27,846]   INFO -   jetbrains.buildServer.SERVER - TeamCity version: 6.0.3 (build 15925), data format version 418
[2011-12-16 10:43:27,893]   INFO -   jetbrains.buildServer.SERVER - TeamCity data directory: D:\TeamCityData
[2011-12-16 10:43:28,440]   INFO -   jetbrains.buildServer.SERVER - Data directory format version: 418
[2011-12-16 10:43:28,815]   WARN -   jetbrains.buildServer.SERVER - Enabling of prepared statements pooling is dangerous and should be avoided (can cause memory leaks), please remove poolPreparedStatements=true property from database.properties file
[2011-12-16 10:43:28,831]   INFO -   jetbrains.buildServer.SERVER - Database type: Oracle
[2011-12-16 10:43:28,831]   INFO -   jetbrains.buildServer.SERVER - Database connection URL: jdbc:oracle:thin:@ops.nike.net:1521:opsadmin
[2011-12-16 10:43:29,706]   INFO -   jetbrains.buildServer.SERVER - Database system: Oracle Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
[2011-12-16 10:43:29,706]   INFO -   jetbrains.buildServer.SERVER - Database driver: Oracle JDBC driver 10.2.0.3.0
[2011-12-16 10:43:29,706]   INFO -   jetbrains.buildServer.SERVER - Database format version: 418
[2011-12-16 10:43:29,706]   INFO - ide.db.TeamCityDatabaseManager - Attempt to capture TeamCity DB lock (java thread 30, starting code 1652953055, attempt 1)
[2011-12-16 10:43:29,878]   INFO - ide.db.TeamCityDatabaseManager - The TeamCity DB lock has been captured successfully (java thread 30, starting code 1652953055, attempt 1)
[2011-12-16 10:43:30,174]   INFO - Side.versioning.VersionManager - Configuration and Database versions are 418
[2011-12-16 10:43:35,081]   INFO -   jetbrains.buildServer.SERVER - Loading roles from the configuration file: D:\TeamCityData\config\roles-config.xml

2 comments
Comment actions Permalink

I was able to resolve this by rebooting the Oracle DB supporting TeamCity, then restarting the TeamCity service.

The best theory I have about the problem is that the SecondTeamCityInstanceException was the beginning of a DB communication problem.


Thanks,


Justin Redd

0
Comment actions Permalink

I was able to resolve this by restarting the Oracle DB that supports TeamCity, then the TeamCity service. I assumed that the SecondTeamCityInstanceException indicated a DB connectivity problem. Even though the exception didn't repeat, I suspected something was still wrong.


Thanks,


Justin Redd

0

Please sign in to leave a comment.