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?
Please sign in to leave a comment.
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.