Redmine slow Repository view（SVN) issue again(redmine and svn not in the same server)
Added by li an about 9 years ago
I am so sad...that the speed issue when browsing repository in redmine occurs again...I reported this bug before, and try the method-unchecking auto fetching changesets in configuration, make fetching changesets each per 10 mins as a cronjob.
But these days, the speed is so slow again,Redmine slow Repository view, everything else fast :(
I use redmine2.3.2, and svn is set to https, svn server is not the same server that redmine installed, so I cannot use this solution http://www.redmine.org/boards/2/topics/13443?r=13444, is there any way to sovle the slow speed for repository view? now 5 or 6 minutes needed when clicking to repository...and sometimes 500 error occurs like below:
Completed 500 Internal Server Error in 52993ms
ActiveRecord::StatementInvalid (Mysql2::Error: Lock wait timeout exceeded; try restarting transaction: DELETE FROM changes WHERE changes.changeset_id IN (SELECT changesets.id FROM changesets WHERE changesets.repository_id = 118)):
app/models/repository.rb:429:in `clear_changesets'
app/controllers/repositories_controller.rb:109:in `destroy'