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.