CleanUp of MySQL database does not finish

Permanently deleted user

Created September 23, 2013 07:20

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

Permanently deleted user

Created September 23, 2013 09:24

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

Please sign in to leave a comment.