Upgrade to 17372 from 17132 problem - How to resolve?
Here is stack trace:
jetbrains.buildServer.serverSide.versioning.ConvertException: Converter jetbrains.buildServer.serverSide.versioning.converters.CreateTmpTablesForMutingConverter failed with error: SQL error when doing: Executing a SQL statementSQL query: create global temporary table build_type$ ( build_type_id varchar(30) not null ) on commit preserve rowsSQL exception: Table already exists: BUILD_TYPE$ in statement [create global temporary table build_type$] at jetbrains.buildServer.serverSide.versioning.converters.BaseSqlConverter.convertImpl(BaseSqlConverter.java:134) at jetbrains.buildServer.serverSide.versioning.converters.BaseSqlConverter.convert(BaseSqlConverter.java:69) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverterStepJavaClass(ConvertPerformer.java:168) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverterSteps(ConvertPerformer.java:138) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverter(ConvertPerformer.java:89) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverters(ConvertPerformer.java:78) at jetbrains.buildServer.serverSide.versioning.VersionManager.upgradeIt(VersionManager.java:391) at jetbrains.buildServer.serverSide.versioning.VersionManager.checkVersionsAndUpgradeSchemaIfNeeded(VersionManager.java:359) at jetbrains.buildServer.serverSide.versioning.VersionManager$2.run(VersionManager.java:415) at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.withDB(TeamCityDatabaseManager.java:568) at jetbrains.buildServer.serverSide.versioning.VersionManager.ensureActualDatabase(VersionManager.java:411) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:101) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerSafe(TeamCityDispatcherServlet.java:469) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$400(TeamCityDispatcherServlet.java:260) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$6.run(TeamCityDispatcherServlet.java) at java.lang.Thread.run(Unknown Source)caused by: jetbrains.buildServer.serverSide.db.UnexpectedDBException: SQL error when doing: Executing a SQL statementSQL query: create global temporary table build_type$ ( build_type_id varchar(30) not null ) on commit preserve rowsSQL exception: Table already exists: BUILD_TYPE$ in statement [create global temporary table build_type$] at org.hsqldb.jdbc.Util.sqlException(Util.java:63) at org.hsqldb.jdbc.jdbcStatement.fetchResult(jdbcStatement.java:1587) at org.hsqldb.jdbc.jdbcStatement.execute(jdbcStatement.java:628) at jetbrains.buildServer.serverSide.db.DBFunctions.executeSimpleInternal(DBFunctions.java:571) at jetbrains.buildServer.serverSide.db.DBFunctions.executeSimpleInternal(DBFunctions.java:554) at jetbrains.buildServer.serverSide.db.DBFunctions.executeDdls(DBFunctions.java:519) at jetbrains.buildServer.serverSide.versioning.converters.CreateTmpTablesForMutingConverter.convertInternal(CreateTmpTablesForMutingConverter.java:39) at jetbrains.buildServer.serverSide.versioning.converters.BaseSqlConverter.convertImpl(BaseSqlConverter.java:121) at jetbrains.buildServer.serverSide.versioning.converters.BaseSqlConverter.convert(BaseSqlConverter.java:69) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverterStepJavaClass(ConvertPerformer.java:168) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverterSteps(ConvertPerformer.java:138) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverter(ConvertPerformer.java:89) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverters(ConvertPerformer.java:78) at jetbrains.buildServer.serverSide.versioning.VersionManager.upgradeIt(VersionManager.java:391) at jetbrains.buildServer.serverSide.versioning.VersionManager.checkVersionsAndUpgradeSchemaIfNeeded(VersionManager.java:359) at jetbrains.buildServer.serverSide.versioning.VersionManager$2.run(VersionManager.java:415) at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.withDB(TeamCityDatabaseManager.java:568) at jetbrains.buildServer.serverSide.versioning.VersionManager.ensureActualDatabase(VersionManager.java:411) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:101) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerSafe(TeamCityDispatcherServlet.java:469) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$400(TeamCityDispatcherServlet.java:260) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$6.run(TeamCityDispatcherServlet.java) at java.lang.Thread.run(Unknown Source)caused by: java.sql.SQLException: Table already exists: BUILD_TYPE$ in statement [create global temporary table build_type$] at org.hsqldb.jdbc.Util.sqlException(Util.java:63) at org.hsqldb.jdbc.jdbcStatement.fetchResult(jdbcStatement.java:1587) at org.hsqldb.jdbc.jdbcStatement.execute(jdbcStatement.java:628) at jetbrains.buildServer.serverSide.db.DBFunctions.executeSimpleInternal(DBFunctions.java:571) at jetbrains.buildServer.serverSide.db.DBFunctions.executeSimpleInternal(DBFunctions.java:554) at jetbrains.buildServer.serverSide.db.DBFunctions.executeDdls(DBFunctions.java:519) at jetbrains.buildServer.serverSide.versioning.converters.CreateTmpTablesForMutingConverter.convertInternal(CreateTmpTablesForMutingConverter.java:39) at jetbrains.buildServer.serverSide.versioning.converters.BaseSqlConverter.convertImpl(BaseSqlConverter.java:121) at jetbrains.buildServer.serverSide.versioning.converters.BaseSqlConverter.convert(BaseSqlConverter.java:69) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverterStepJavaClass(ConvertPerformer.java:168) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverterSteps(ConvertPerformer.java:138) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverter(ConvertPerformer.java:89) at jetbrains.buildServer.serverSide.versioning.ConvertPerformer.runConverters(ConvertPerformer.java:78) at jetbrains.buildServer.serverSide.versioning.VersionManager.upgradeIt(VersionManager.java:391) at jetbrains.buildServer.serverSide.versioning.VersionManager.checkVersionsAndUpgradeSchemaIfNeeded(VersionManager.java:359) at jetbrains.buildServer.serverSide.versioning.VersionManager$2.run(VersionManager.java:415) at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.withDB(TeamCityDatabaseManager.java:568) at jetbrains.buildServer.serverSide.versioning.VersionManager.ensureActualDatabase(VersionManager.java:411) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerInternal(TeamCityDispatcherServlet.java:101) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.processStartupServerSafe(TeamCityDispatcherServlet.java:469) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$400(TeamCityDispatcherServlet.java:260) at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$6.run(TeamCityDispatcherServlet.java) at java.lang.Thread.run(Unknown Source)
Please sign in to leave a comment.
Database is HSQL DB on Windows 2008 x64. (If it's useful)
I resolved it by migrate data in backup file to MySQL, then upgrade to 17372. Seems the problem only relates with HSQL DB.