Problem:
When running foreman-rake config | grep oauth_consumer as requried to get the foreman-proxy-oauth-consumer-key as needed when creating a new smart-proxy. The following error occurs: ActiveRecord::SubclassNotFound: Invalid single-table inheritance type: Setting::Bootdisk is not a subclass of Setting
Expected outcome:
The oauth_consumer key is shown.
Foreman and Proxy versions:
3.3.0-rc2
Foreman and Proxy plugin versions:
Both Foreman and Smart proxy are at 3.3.0-rc2.
foreman-tasks 6.0.2
oreman_ansible 7.1.0
foreman_bootdisk 19.0.5
foreman_default_hostgroup 6.0.0
foreman_dhcp_browser 0.0.8
foreman_discovery 21.0.1
foreman_monitoring 2.1.0
foreman_puppet 4.0.0
foreman_remote_execution 7.0.0
foreman_statistics 2.0.1
foreman_templates 9.3.0
foreman_webhooks 3.0.1
Distribution and version:
RHEL 8.6
Other relevant data:
I believed this issue was caused by not shutting down foreman during upgrade to either 3.2. or 3.3.0-rc2. From this post, it looks like the correct remediation was to revert the database version, then upgrade. The commands I ran were
foreman-rake db:migrate:down VERSION=20210929132645
foreman-rake db:migrate:down VERSION=20210915132645
foreman-rake db:migrate
foreman-rake db:seed
but they had no effect.
How do I fix the database?
Stacktrace from foreman-rake --trace config | grep oauth_consumer:
** Invoke config (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute config
rake aborted!
ActiveRecord::SubclassNotFound: Invalid single-table inheritance type: Setting::Bootdisk is not a subclass of Setting
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/inheritance.rb:241:in `find_sti_class'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/inheritance.rb:215:in `discriminate_class_for_record'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/persistence.rb:257:in `instantiate'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/querying.rb:58:in `block (2 levels) in find_by_sql'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/result.rb:62:in `block in each'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/result.rb:62:in `each'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/result.rb:62:in `each'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/querying.rb:58:in `map'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/querying.rb:58:in `block in find_by_sql'
/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/querying.rb:56:in `find_by_sql'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/relation.rb:824:in `block in exec_queries'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/relation.rb:842:in `skip_query_cache_if_necessary'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/relation.rb:811:in `exec_queries'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/relation.rb:626:in `load'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/relation.rb:250:in `records'
/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/relation/delegation.rb:88:in `each'
/usr/share/foreman/lib/tasks/config.rake:117:in `run_all'
/usr/share/foreman/lib/tasks/config.rake:79:in `run'
/usr/share/foreman/lib/tasks/config.rake:167:in `block in <top (required)>'
/usr/share/gems/gems/rake-13.0.1/lib/rake/task.rb:281:in `block in execute'
/usr/share/gems/gems/rake-13.0.1/lib/rake/task.rb:281:in `each'
/usr/share/gems/gems/rake-13.0.1/lib/rake/task.rb:281:in `execute'
/usr/share/gems/gems/rake-13.0.1/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
/usr/share/gems/gems/rake-13.0.1/lib/rake/task.rb:199:in `synchronize'
/usr/share/gems/gems/rake-13.0.1/lib/rake/task.rb:199:in `invoke_with_call_chain'
/usr/share/gems/gems/rake-13.0.1/lib/rake/task.rb:188:in `invoke'
/usr/share/gems/gems/rake-13.0.1/lib/rake/application.rb:160:in `invoke_task'
/usr/share/gems/gems/rake-13.0.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/usr/share/gems/gems/rake-13.0.1/lib/rake/application.rb:116:in `each'
/usr/share/gems/gems/rake-13.0.1/lib/rake/application.rb:116:in `block in top_level'
/usr/share/gems/gems/rake-13.0.1/lib/rake/application.rb:125:in `run_with_threads'
/usr/share/gems/gems/rake-13.0.1/lib/rake/application.rb:110:in `top_level'
/usr/share/gems/gems/rake-13.0.1/lib/rake/application.rb:83:in `block in run'
/usr/share/gems/gems/rake-13.0.1/lib/rake/application.rb:186:in `standard_exception_handling'
/usr/share/gems/gems/rake-13.0.1/lib/rake/application.rb:80:in `run'
/usr/share/gems/gems/rake-13.0.1/exe/rake:27:in `<top (required)>'
/usr/bin/rake:23:in `load'
/usr/bin/rake:23:in `<main>'
Tasks: TOP => config