SQL exception on upgrade in IntroduceAgentTypeIdConverter due to table already exists

Ran into an issue while trying to upgrade an existing TeamCity deployment.

Following these directions "Manual Upgrading on Linux and for WAR Distributions": http://confluence.jetbrains.net/display/TCD5/Upgrade 

Original version:5.0.3 (BUILD_10821)
Original db_version: 346

Upgrading to: 5.1.2 (BUILD_13430)
db_version after exception: 360



Expected db_version: 378

Full teamcity-server.log attached

Snippet below for convenience:

[2010-06-25 17:52:00,198]   INFO - Side.versioning.VersionManager - Start applying converter CommentTransformationsConverter (359)
[2010-06-25 17:52:00,210]   INFO - Side.versioning.VersionManager - Done applying converter CommentTransformationsConverter
[2010-06-25 17:52:00,210]   INFO - Side.versioning.VersionManager - Start applying converter Temporary table "build_set_tmp". (360)
[2010-06-25 17:52:00,213]   INFO - Side.versioning.VersionManager - Done applying converter Temporary table "build_set_tmp".
[2010-06-25 17:52:00,213]   INFO - Side.versioning.VersionManager - Start applying converter Add agent_type_id to agent_type_table (361)
[2010-06-25 17:52:00,234]  ERROR -   jetbrains.buildServer.SERVER - Exception occured while applying converters
jetbrains.buildServer.serverSide.versioning.ConvertException: Converter jetbrains.buildServer.serverSide.versioning.converters.IntroduceAgentTypeIdConverter failed with error: SQL error when doing: Execute DDL
SQL query: rename table agent_type to agent_type_old
SQL exception: Table 'agent_type_old' already exists
at jetbrains.buildServer.serverSide.versioning.converters.BaseSqlConverter.convertImpl(BaseSqlConverter.java:6)




Any suggestions?
Is this worth submitting a bug tracker request for?

Attachment(s):
teamcity-server.log.zip
1 comment

After removing the following tables from the database: agent_type_old, agent_old, agent_info, we were able to upgrade the db_version to:364.

Know we are running into a different issue we are raising in another thread.

I have marked this question as answered.

Thanks for your support.

0

Please sign in to leave a comment.