Migrating from HSQLDB to MySQL on Version 3.0

I have inherited a TeamCity installation on version 3.0 and can no longer access the database on startup:

I get a 404: error in the browser.   This just started happening.  There were no changes made to the system other than adding some new users

In the stdout log I see the error that it can not create the bean with name 'buildserver'

I feel that there is an issue with the HSQLDB and I wanted to migrate it to MySQL (this is the only other supported DB i believe on this version)

I have tried to use the migrateToMySQL.bat utility but then I receive the error

Wed Jan 18 19:29:14 EST 2012 .BuildServer path: C:\Utils\.BuildServer
Wed Jan 18 19:29:14 EST 2012 Connecting to the source database jdbc:hsqldb:file:
C:\Utils\.BuildServer\system\buildserver
Exception in thread "main" java.sql.SQLException: User not found: SA
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at jetbrains.buildServer.serverSide.HSQL2MySQL.main(HSQL2MySQL.java:9)
An error has occured during migration. Could not proceed.
Done.


Any thoughts why it can't access the HSQLDB? Why SA is not found?

I did notice the buildserver.data file was exactly 64MB (65,536 KB).  That did seem odd almost as if the DB max'd out at 64MB and it was Full.  I don't much about HSQLDB....

Thanks for any tips

Mike

2 comments
Comment actions Permalink

Hi Mike

This error happens after HSQLDB files become corrupted.
You'll have to restore server configuration from previous backup.

0
Comment actions Permalink

Thanks.
I restored the database from a backup and was able to successfully migrate.
Mike

0

Please sign in to leave a comment.