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)

2 comments
Comment actions Permalink

Database is HSQL DB on Windows 2008 x64. (If it's useful)

0
Comment actions Permalink

I resolved it by migrate data in backup file to MySQL, then upgrade to 17372. Seems the problem only relates with HSQL DB.

0

Please sign in to leave a comment.