CleanUp of MySQL database does not finish

Dear TeamCity developers

The clean up of your TeamCity server (7.1 Enterprise, build 21424) does not finish, the last message is:
[2013-09-23 06:12:13,603]   INFO -  jetbrains.buildServer.CLEANUP - Cleaning build history data from the database...  (teamCity-server.log)

Is there a way to get more information where the process hangs? The last time I had to stop it after 9 hours ... . Before that, it took about 1 to 1.5 hours.

Thank you for you reply
Michael

1 comment
Comment actions Permalink

With debug all, the error is:

jetbrains.buildServer.serverSide.db.LockWaitTimeoutException: Lock wait timeout exceeded; try restarting transaction
SQL query: delete from history where build_id  in (???)
SQL exception: Lock wait timeout exceeded; try restarting transaction

0

Please sign in to leave a comment.