I am currently running TeamCity Version 3.1.2 (build 6881) and want to upgrade to the newest version (which is 4.5.1a right now, but I tried with 4.5 and 4.0.2 and had the same problems).
I am using the war version of TeamCity (runs in a tomcat 6 instance), configured against a MySQL database. The upgrade goes wrong for me, even though I have been following the documentation (http://www.jetbrains.net/confluence/display/TCD4/Upgrade) carefully.
What I get in the logs is looking like that:
[2009-05-11 06:51:44,273] INFO - Side.versioning.VersionManager - ---------------> Start applying converters
[2009-05-11 06:51:44,274] INFO - Side.versioning.VersionManager - Start applying converter BuildStateTableConverter
[2009-05-11 06:51:44,357] ERROR - jetbrains.buildServer.SERVER - Failed to initialize TeamCity server, due to error (enable debug to see the whole stacktrace):
org.springframework.jdbc.UncategorizedSQLException: Error executing query with params:; uncategorized SQLException for SQL [CREATE TABLE build_state (ID BIGINT, BUILD_TYPE_ID VARCHAR(30),MODIFICATION_ID BIGINT, PRIMARY KEY (ID))]; SQL state [42S01]; error code ; Table 'build_state' already exists;
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'build_state' already exists
I tried to delete this table, then got a similar error telling me that the build_queue table is crashed (I run a repair on the table but it does not help, I still run in other errors).
Can someone please help me with this one, I have not been able to find the information I need to fix it.
And by the way, my .BuildServer/system/version.dat is:
#Mon May 04 10:06:28 CEST 2009