I am trying to migrate from the internal database to a MS SQL based database, but the migrateDB.cmd command fails halfway through with a connection closed error.
I am running on a Windows machine with TeamCity 9.0.2
SQL exception: The connection is closed.
jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception
SQLServerException: SQL error when doing: Preparing query SQL query: insert into ignored_tests (build_id,test_id,test_name,reason) values (?,?,?,?)
The above exceptions happen after some time and at slightly different points indicating a timeout issue and the target database receives a lot of data.
The database.xx.properties file I am using has testOnBorrow=true, but that does not seem to help.
The database is at a couple of GB (though the administration page claims the data to be 352 MB) and apparently this is too much for the migrate script.
Is there a way to increase the timeout or workaround or would I have to cleanup old build logs before I can migrate?