Redmine

Same here. Redmin 2.4.2 stable using Mercurial repository. Getting this:

The single-table inheritance mechanism failed to locate the subclass: 'Repository::Mercurial'.

Just like in the original post for git.

Added the same command with --trace:

root@server:/var/www/redmine# RAILS_ENV=production; bundle exec rake redmine:fetch_changesets  --trace
** Invoke redmine:fetch_changesets (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute redmine:fetch_changesets
rake aborted!
The single-table inheritance mechanism failed to locate the subclass: 'Repository::Git'. This error is raised because the column 'type' is reserved for storing the class in case of inheritance. Please rename this column if you didn't intend it to be used for storing the inheritance class or overwrite Repository.inheritance_column to use another column for that information.
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/inheritance.rb:143:in `rescue in find_sti_class'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/inheritance.rb:136:in `find_sti_class'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/inheritance.rb:62:in `instantiate'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/querying.rb:38:in `block (2 levels) in find_by_sql'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/querying.rb:38:in `collect!'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/querying.rb:38:in `block in find_by_sql'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/explain.rb:41:in `logging_query_plan'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/querying.rb:37:in `find_by_sql'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/relation.rb:171:in `exec_queries'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/relation.rb:160:in `block in to_a'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/explain.rb:41:in `logging_query_plan'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/relation.rb:159:in `to_a'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/relation/finder_methods.rb:159:in `all'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/associations/collection_association.rb:382:in `find_target'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/associations/collection_association.rb:335:in `load_target'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/associations/collection_proxy.rb:44:in `load_target'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.16/lib/active_record/associations/collection_proxy.rb:89:in `method_missing'
/var/www/redmine-2.4.2/app/models/repository.rb:330:in `block in fetch_changesets'
/var/www/redmine-2.4.2/app/models/repository.rb:329:in `each'
/var/www/redmine-2.4.2/app/models/repository.rb:329:in `fetch_changesets'
/var/www/redmine-2.4.2/lib/tasks/redmine.rake:47:in `block (2 levels) in <top (required)>'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/task.rb:236:in `call'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/task.rb:236:in `block in execute'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/task.rb:231:in `each'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/task.rb:231:in `execute'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/task.rb:175:in `block in invoke_with_call_chain'
/usr/local/rvm/rubies/ruby-1.9.3-p362/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/task.rb:168:in `invoke_with_call_chain'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/task.rb:161:in `invoke'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/application.rb:149:in `invoke_task'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/application.rb:106:in `block (2 levels) in top_level'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/application.rb:106:in `each'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/application.rb:106:in `block in top_level'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/application.rb:115:in `run_with_threads'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/application.rb:100:in `top_level'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/application.rb:78:in `block in run'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/application.rb:165:in `standard_exception_handling'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/lib/rake/application.rb:75:in `run'
/usr/local/rvm/gems/ruby-1.9.3-p362/gems/rake-10.1.1/bin/rake:33:in `<top (required)>'
/usr/local/rvm/gems/ruby-1.9.3-p362/bin/rake:19:in `load'
/usr/local/rvm/gems/ruby-1.9.3-p362/bin/rake:19:in `<main>'
/usr/local/rvm/gems/ruby-1.9.3-p362/bin/ruby_noexec_wrapper:14:in `eval'
/usr/local/rvm/gems/ruby-1.9.3-p362/bin/ruby_noexec_wrapper:14:in `<main>'
Tasks: TOP => redmine:fetch_changesets

I tried a bit around with my rails colleague and we found out that we dont know whats going on.

We are easily able to start the rails console and the rake task from within without issues.

bundle exec rails c production

Repository.fetch_changesets

and it goes trough without an error. Thats weird.

Update 5:55pm:

We tried our own Rake Task which is the file foo.rake in lib/tasks with following content:

namespace :foo do
  task :bar => :environment do
    Repository.fetch_changesets
  end
end

bundle exec rake foo:bar RAILS_ENV=production

We tried setting up Redmine 2.4.2 from scratch, added a new DB with own seed data and then only added an existing git repo to a new project. Even then the rake task fails!

But we figured out a workaround which may also work for other SCMs. Our Cronjob now looks like this (we dont use rake anymore):

*/3 8-23 * * * cd /var/www/redmine && echo "Repository.fetch_changesets" | bundle exec rails c production >/dev/null 2>&1

With this, we just pipe the command to fetch the changes directly into the rails console, which works great and does not use rake.

Hi there, I got "almost the same problem". First, I'm using SVN instead of GIT.
Then, I decide to try your solution and seem to be working but got this error a little bit down the line:

NoMethodError: undefined method `created_on' for #<Repository::Subversion:0x000000060d2798>
        from /var/lib/gems/1.9.1/gems/activemodel-3.2.16/lib/active_model/attribute_methods.rb:407:in `method_missing'
        from /var/lib/gems/1.9.1/gems/activerecord-3.2.16/lib/active_record/attribute_methods.rb:149:in `method_missing'
        from /var/www/redmine/app/models/changeset.rb:136:in `block (2 levels) in scan_comment_for_issue_ids'
        from /var/www/redmine/app/models/changeset.rb:131:in `each'
        from /var/www/redmine/app/models/changeset.rb:131:in `block in scan_comment_for_issue_ids'
        from /var/www/redmine/app/models/changeset.rb:127:in `scan'
        from /var/www/redmine/app/models/changeset.rb:127:in `scan_comment_for_issue_ids'
        from /var/www/redmine/app/models/changeset.rb:100:in `scan_for_issues'
        from /var/lib/gems/1.9.1/gems/activesupport-3.2.16/lib/active_support/callbacks.rb:432:in `_run__1515758292348163996__create__3917711451105029760__callbacks'
        from /var/lib/gems/1.9.1/gems/activesupport-3.2.16/lib/active_support/callbacks.rb:405:in `__run_callback'
        from /var/lib/gems/1.9.1/gems/activesupport-3.2.16/lib/active_support/callbacks.rb:385:in `_run_create_callbacks'
        from /var/lib/gems/1.9.1/gems/activesupport-3.2.16/lib/active_support/callbacks.rb:81:in `run_callbacks'
        from /var/lib/gems/1.9.1/gems/activerecord-3.2.16/lib/active_record/callbacks.rb:268:in `create'
        from /var/lib/gems/1.9.1/gems/activerecord-3.2.16/lib/active_record/persistence.rb:348:in `create_or_update'
        from /var/lib/gems/1.9.1/gems/activerecord-3.2.16/lib/active_record/callbacks.rb:264:in `block in create_or_update'
        from /var/lib/gems/1.9.1/gems/activesupport-3.2.16/lib/active_support/callbacks.rb:436:in `_run__1515758292348163996__save__3917711451105029760__callbacks'
... 19 levels...
        from /var/lib/gems/1.9.1/gems/activerecord-3.2.16/lib/active_record/transactions.rb:250:in `transaction'
        from /var/www/redmine/app/models/repository/subversion.rb:71:in `block in fetch_changesets'
        from /var/www/redmine/app/models/repository/subversion.rb:70:in `reverse_each'
        from /var/www/redmine/app/models/repository/subversion.rb:70:in `fetch_changesets'
        from /var/www/redmine/app/models/repository.rb:332:in `block (2 levels) in fetch_changesets'
        from /var/lib/gems/1.9.1/gems/activerecord-3.2.16/lib/active_record/associations/collection_proxy.rb:91:in `each'
        from /var/lib/gems/1.9.1/gems/activerecord-3.2.16/lib/active_record/associations/collection_proxy.rb:91:in `method_missing'
        from /var/www/redmine/app/models/repository.rb:330:in `block in fetch_changesets'
        from /var/www/redmine/app/models/repository.rb:329:in `each'
        from /var/www/redmine/app/models/repository.rb:329:in `fetch_changesets'
        from (irb):1
        from /var/lib/gems/1.9.1/gems/railties-3.2.16/lib/rails/commands/console.rb:47:in `start'
        from /var/lib/gems/1.9.1/gems/railties-3.2.16/lib/rails/commands/console.rb:8:in `start'
        from /var/lib/gems/1.9.1/gems/railties-3.2.16/lib/rails/commands.rb:41:in `<top (required)>'
        from script/rails:6:in `require'
        from script/rails:6:in `<main>'

I have the same problem with SNV, please find a fix for this.

Did you run all database migrations? It seems that the column "created_on" is missing.

It appears that r12389 was the change that broke this. The following patch partially reverts this and fixes the issue for us (note: this is unlikely to be the real fix, as the CommandFailed class definition is now duplicated, which doesn't bother ruby per se but is ugly nevertheless):

--- ./lib/redmine/scm/adapters/abstract_adapter.rb.orig    2014-02-02 00:10:30.391088211 -0800
+++ ./lib/redmine/scm/adapters/abstract_adapter.rb    2014-02-02 00:02:16.051390905 -0800
@@ -24,6 +24,9 @@
 module Redmine
   module Scm
     module Adapters
+      class CommandFailed < StandardError #:nodoc:
+      end
+
       class AbstractAdapter #:nodoc:

         # raised if scm command exited with error, e.g. unknown revision.