Restoring a TeamCity server from the HSQL data file

Somehow my TeamCity installation became corrupt. Fortunately I have a copy of the buildserver.data file which I'm assuming contains the build configurations and everything else I need to bring the server back?

I have tried doing a clean install using the same version that was in use (8.0.1) , then overwriting the buildserver.data file with my copy and restarting the service.

However when I try accessing TeamCity I get the following error message:

jetbrains.buildServer.maintenance.exceptions.UnknownServerStartupError: Unexpected error during connecting to the database: Unexpected exception SQLException/HsqlException: SQL error when doing: Connecting to HSQL2
SQL query: connect
SQL exception: error in script file line: 244 java.io.IOException: java.lang.IndexOutOfBoundsException in statement [SET TABLE PUBLIC.DB_VERSION INDEX '12161 0 1']
 at jetbrains.buildServer.maintenance.StartupProcessor.performConnectToDatabaseInternal(StartupProcessor.java:29)
 at jetbrains.buildServer.maintenance.StartupProcessor.performConnectToDatabase(StartupProcessor.java:302)
 at jetbrains.buildServer.maintenance.StartupProcessor.doDatabaseConnect(StartupProcessor.java:65)
 at jetbrains.buildServer.maintenance.StartupProcessor.processConcreteStage(StartupProcessor.java:337)
 at jetbrains.buildServer.maintenance.StartupProcessor.processConcreteStageSafe(StartupProcessor.java:76)
 at jetbrains.buildServer.maintenance.StartupProcessor.processTeamCityLifecycle(StartupProcessor.java:322)
 at jetbrains.buildServer.maintenance.StartupProcessor.access$000(StartupProcessor.java:157)
 at jetbrains.buildServer.maintenance.StartupProcessor$1.run(StartupProcessor.java)
 at java.lang.Thread.run(Unknown Source)

Would really appreciate any help. If I can't restore from this file then I will have lost many days of work. Lesson I've learnt is to probably switch to another database like MySQL.

Thanks,
Simon



Attachment(s):
teamcity.log.zip

Please sign in to leave a comment.