Migration to External Database Fails

Permanently deleted user

Created June 25, 2018 13:14

Hello there!

We're trying to migrate from internal HSQLDB to external PostgreSQL installation, but maintaindb tool crashes with the following error:

Error while performing backup: jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception: SQL error when doing 'Querying for a single value ' while performing SQL query: SQL SELECT: select count (*) from inspection_data: java.sql.SQLException: org.hsqldb.HsqlException: java.io.UTFDataFormatException. Caused by: org.hsqldb.HsqlException: org.hsqldb.HsqlException: java.io.UTFDataFormatException Cannot proceed with 'migrate' command: Database export failed after 7s,812ms. Error: jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception: SQL error when doing 'Querying for a single value ' while performing SQL query: SQL SELECT: select count (*) from inspection_data: java.sql.SQLException: org.hsqldb.HsqlException: java.io.UTFDataFormatException. Caused by: org.hsqldb.HsqlException: org.hsqldb.HsqlException: java.io.UTFDataFormatException

I guess it might be a performance issue since we have lots of code inspection issues in our projects. Am I right?
Is there a way to provide internal hsqldb with more resources?

4 comments

Permanently deleted user

Created July 05, 2018 16:39

Official comment

Aleksei,

Can you make a database backup while TeamCity is running (from the UI)?
What are the values of your TEAMCITY_* environment variables, if any (e.g.: TEAMCITY_SERVER_OPTS, TEAMCITY_SERVER_MEM_OPTS, TEAMCITY_MAINTAINDB_MEM_OPTS)?
What is the total size of your ${TEAMCITY_DATA_PATH}/system/buildserver.* files?

Regards,

Andrey.