Migrate SQL timeout problem

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?

1 comment
Comment actions Permalink

Hi, please double check that database configuration is in database.properties, not in database.xx.properties

Please change try to change the URL to autoreconnect, like jdbc:mysql://127.0.0.1/databaseName?autoReconnect=true.

0

Please sign in to leave a comment.