Add rake as a development dependency

[ekohl]

This is mostly to see if CI is broken in master or if https://github.com/theforeman/foreman_statistics/pull/43 broke things.

[ezr-ondrej]

I see rubocop failure here so the tests did not run, could you fix that so we get the info about the actual tests pls? :)

[ekohl]

Somehow I thought it was red for other reasons. That's green now.

[ekohl]

See, now it shows the same errors as #43 so something broke. Possibly it was previously still relying on the migrations in core to be executed?

[ezr-ondrej]

Possibly it was previously still relying on the migrations in core to be executed?

Or Rails have changed the definition of the migration paths? I don't see the migrations for the plugin being executed :(

[ekohl]

That's precisely what triggered me in the first place. I wanted to update translations and after running db:migrate it complained there were migrations that still needed to be executed. I first thought that perhaps the guard was breaking it, but not sure now. Haven't looked too carefully, but certainly something is wrong.

[ekohl]

What I see when I run db:migrate -> db:seed -> db:migrate:

$ bundle exec rake db:migrate
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/net-protocol-0.2.1/lib/net/protocol.rb:68: warning: already initialized constant Net::ProtocRetryError
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/2.7.0/net/protocol.rb:66: warning: previous definition of ProtocRetryError was here
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/net-protocol-0.2.1/lib/net/protocol.rb:214: warning: already initialized constant Net::BufferedIO::BUFSIZE
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/2.7.0/net/protocol.rb:206: warning: previous definition of BUFSIZE was here
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/net-protocol-0.2.1/lib/net/protocol.rb:541: warning: already initialized constant Net::NetPrivate::Socket
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/2.7.0/net/protocol.rb:503: warning: previous definition of Socket was here
2022-12-13T16:44:08 [I|app|] Rails cache backend: File
2022-12-13T16:44:09 [W|app|] You are trying to replace import_subnets from . Adding allowed actions from plugin permissions to the existing one.
2022-12-13T16:44:09 [W|app|] DEPRECATION WARNING: You are using a deprecated behavior, it will be removed in version 3.3, initial value of setting 'instance_id' should be created in a migration (called from block in load_definitions at /home/ekohl/dev/foreman-plugins/foreman_statistics/app/services/setting_registry.rb:131)
2022-12-13T16:44:09 [D|app|] Slow initializers:
2022-12-13T16:44:09 [D|app|]     209.16  ./config/initializers/foreman_register.rb
2022-12-13T16:44:09 [W|app|] DEPRECATION WARNING: Initialization autoloaded the constants Net::Validations, SettingRegistry, HiddenValue, SettingPresenter, Foreman::Deprecation, SettingSelectCollection, MediumProviders, MediumProviders::Provider, MediumProviders::Default, and Foreman::TelemetryHelper.
 | 
 | Being able to do this is deprecated. Autoloading during initialization is going
 | to be an error condition in future versions of Rails.
 | 
 | Reloading does not reboot the application, and therefore code executed during
 | initialization does not run again. So, if you reload Net::Validations, for example,
 | the expected changes won't be reflected in that stale Module object.
 | 
 | `config.autoloader` is set to `classic`. These autoloaded constants would have been unloaded if `config.autoloader` had been set to `:zeitwerk`.
 | 
 | In order to autoload safely at boot time, please wrap your code in a reloader
 | callback this way:
 | 
 |     Rails.application.reloader.to_prepare do
 |       # Autoload classes and modules needed at boot time here.
 |     end
 | 
 | That block runs when the application boots, and every time there is a reload.
 | For historical reasons, it may run twice, so it has to be idempotent.
 | 
 | Check the "Autoloading and Reloading Constants" guide to learn more about how
 | Rails autoloads and reloads.
 |  (called from block in run at /home/ekohl/dev/foreman-plugins/foreman_statistics/config/initializers/0_print_time_spent.rb:45)
Created database 'foreman-foreman_statistics'
== 20090714132448 CreateHosts: migrating ======================================
-- create_table(:hosts, {:id=>:integer})
   -> 0.0157s
-- add_index(:hosts, :source_file_id)
   -> 0.0112s
-- add_index(:hosts, :name)
   -> 0.0059s
-- create_table(:fact_names, {:id=>:integer})
   -> 0.0076s
-- add_index(:fact_names, :name)
   -> 0.0045s
-- create_table(:fact_values, {:id=>:integer})
   -> 0.0111s
-- add_index(:fact_values, :fact_name_id)
   -> 0.0048s
-- add_index(:fact_values, :host_id)
   -> 0.0048s
-- add_column(:hosts, :mac, :string, {:limit=>17, :default=>""})
   -> 0.0022s
-- add_column(:hosts, :sp_mac, :string, {:limit=>17, :default=>""})
   -> 0.0015s
-- add_column(:hosts, :sp_ip, :string, {:limit=>15, :default=>""})
   -> 0.0016s
-- add_column(:hosts, :sp_name, :string, {:limit=>255, :default=>""})
   -> 0.0015s
-- add_column(:hosts, :root_pass, :string, {:limit=>64})
   -> 0.0007s
-- add_column(:hosts, :serial, :string, {:limit=>12})
   -> 0.0008s
-- add_column(:hosts, :puppetmaster, :string, {:limit=>255})
   -> 0.0007s
-- add_column(:hosts, :puppet_status, :integer, {:null=>false, :default=>0})
   -> 0.0016s
-- add_column(:hosts, :domain_id, :integer, {})
   -> 0.0007s
-- add_column(:hosts, :architecture_id, :integer, {})
   -> 0.0007s
-- add_column(:hosts, :operatingsystem_id, :integer, {})
   -> 0.0007s
-- add_column(:hosts, :subnet_id, :integer, {})
   -> 0.0007s
-- add_column(:hosts, :sp_subnet_id, :integer, {})
   -> 0.0006s
-- add_column(:hosts, :ptable_id, :integer, {})
   -> 0.0005s
-- add_column(:hosts, :medium_id, :integer, {})
   -> 0.0006s
-- add_column(:hosts, :build, :boolean, {:default=>true})
   -> 0.0013s
-- add_column(:hosts, :comment, :text, {})
   -> 0.0006s
-- add_column(:hosts, :disk, :text, {})
   -> 0.0005s
-- add_column(:hosts, :installed_at, :datetime, {})
   -> 0.0006s
== 20090714132448 CreateHosts: migrated (0.0874s) =============================

== 20090714132449 AddAuditsTable: migrating ===================================
-- create_table(:audits, {:force=>true, :id=>:integer})
   -> 0.0099s
-- add_index(:audits, [:auditable_id, :auditable_type], {:name=>"auditable_index"})
   -> 0.0036s
-- add_index(:audits, [:user_id, :user_type], {:name=>"user_index"})
   -> 0.0047s
-- add_index(:audits, :created_at)
   -> 0.0098s
-- add_index(:audits, [:auditable_parent_id, :auditable_parent_type], {:name=>"auditable_parent_index"})
   -> 0.0084s
== 20090714132449 AddAuditsTable: migrated (0.0372s) ==========================

== 20090715143858 CreateArchitectures: migrating ==============================
-- create_table(:architectures, {:id=>:integer})
   -> 0.0164s
-- create_table(:architectures_operatingsystems, {:id=>false})
   -> 0.0020s
== 20090715143858 CreateArchitectures: migrated (0.0187s) =====================

== 20090717025820 CreateMedia: migrating ======================================
-- create_table(:media, {:id=>:integer})
   -> 0.0118s
== 20090717025820 CreateMedia: migrated (0.0121s) =============================

== 20090718060746 CreateDomains: migrating ====================================
-- create_table(:domains, {:id=>:integer})
   -> 0.0155s
== 20090718060746 CreateDomains: migrated (0.0157s) ===========================

== 20090718064254 CreateSubnets: migrating ====================================
-- create_table(:subnets, {:id=>:integer})
   -> 0.0113s
== 20090718064254 CreateSubnets: migrated (0.0114s) ===========================

== 20090720134126 CreateOperatingsystems: migrating ===========================
-- create_table(:operatingsystems, {:id=>:integer})
   -> 0.0083s
== 20090720134126 CreateOperatingsystems: migrated (0.0085s) ==================

== 20090722140138 CreateModels: migrating =====================================
-- create_table(:models, {:id=>:integer})
   -> 0.0106s
-- add_column(:hosts, :model_id, :integer, {})
   -> 0.0009s
== 20090722140138 CreateModels: migrated (0.0117s) ============================

== 20090729132209 CreateReports: migrating ====================================
-- create_table(:reports, {:id=>:integer})
   -> 0.0113s
== 20090729132209 CreateReports: migrated (0.0114s) ===========================

== 20090730152224 CreatePtables: migrating ====================================
-- create_table(:ptables, {:id=>:integer})
   -> 0.0115s
-- create_table(:operatingsystems_ptables, {:id=>false})
   -> 0.0018s
== 20090730152224 CreatePtables: migrated (0.0137s) ===========================

== 20090804130144 CreateParameters: migrating =================================
-- create_table(:parameters, {:id=>:integer})
   -> 0.0167s
== 20090804130144 CreateParameters: migrated (0.0170s) ========================

== 20090820130541 CreateAuthSources: migrating ================================
-- create_table(:auth_sources, {:id=>:integer})
   -> 0.0198s
== 20090820130541 CreateAuthSources: migrated (0.0200s) =======================

== 20090905150131 CreateHostgroups: migrating =================================
-- create_table(:hostgroups, {:id=>:integer})
   -> 0.0089s
-- add_column(:hosts, :hostgroup_id, :integer, {})
   -> 0.0012s
-- add_column(:parameters, :hostgroup_id, :integer, {})
   -> 0.0012s
== 20090905150131 CreateHostgroups: migrated (0.0120s) ========================

== 20090905155444 AddTypeToParameter: migrating ===============================
-- add_column(:parameters, :type, :string, {:limit=>255})
   -> 0.0021s
== 20090905155444 AddTypeToParameter: migrated (0.0024s) ======================

== 20090907045751 AddDomainToParameter: migrating =============================
-- add_column(:parameters, :domain_id, :integer, {})
   -> 0.0013s
== 20090907045751 AddDomainToParameter: migrated (0.0014s) ====================

== 20090916053824 ChangeHostBuildDefaultToFalse: migrating ====================
-- change_column(:hosts, :build, :boolean, {})
   -> 0.0015s
== 20090916053824 ChangeHostBuildDefaultToFalse: migrated (0.0055s) ===========

== 20090920043521 AddIndexToHost: migrating ===================================
-- add_index("hosts", "last_report")
   -> 0.0042s
-- add_index("hosts", "installed_at")
   -> 0.0051s
-- add_index("hosts", "puppet_status")
   -> 0.0038s
-- add_index("hosts", :domain_id, {:name=>"host_domain_id_ix"})
   -> 0.0037s
-- add_index("hosts", :architecture_id, {:name=>"host_arch_id_ix"})
   -> 0.0038s
-- add_index("hosts", :operatingsystem_id, {:name=>"host_os_id_ix"})
   -> 0.0038s
-- add_index("hosts", :medium_id, {:name=>"host_medium_id_ix"})
   -> 0.0047s
-- add_index("hosts", :hostgroup_id, {:name=>"host_group_id_ix"})
   -> 0.0048s
== 20090920043521 AddIndexToHost: migrated (0.0346s) ==========================

== 20090920064156 AddIndexToParameters: migrating =============================
-- add_index(:parameters, [:host_id, :type])
   -> 0.0064s
-- add_index(:parameters, [:hostgroup_id, :type])
   -> 0.0054s
-- add_index(:parameters, [:domain_id, :type])
   -> 0.0051s
-- add_index(:parameters, :type)
   -> 0.0049s
== 20090920064156 AddIndexToParameters: migrated (0.0225s) ====================

== 20090920065522 AddIndexToReports: migrating ================================
-- add_index(:reports, [:reported_at, :host_id])
   -> 0.0060s
== 20090920065522 AddIndexToReports: migrated (0.0062s) =======================

== 20091012135004 CreateUsers: migrating ======================================
-- create_table(:users, {:id=>:integer})
   -> 0.0129s
== 20091012135004 CreateUsers: migrated (0.0132s) =============================

== 20091016031017 CreateSessions: migrating ===================================
-- create_table(:sessions, {:id=>:integer})
   -> 0.0167s
-- add_index(:sessions, :session_id)
   -> 0.0050s
-- add_index(:sessions, :updated_at)
   -> 0.0049s
== 20091016031017 CreateSessions: migrated (0.0272s) ==========================

== 20091022054108 AddStatusToReport: migrating ================================
-- add_column(:reports, :status, :integer, {})
   -> 0.0016s
-- add_index(:reports, :status)
   -> 0.0052s
-- add_index(:reports, :host_id)
   -> 0.0055s
-- add_index(:reports, :reported_at)
   -> 0.0051s
== 20091022054108 AddStatusToReport: migrated (0.0180s) =======================

== 20091219132338 CreateLookupKeys: migrating =================================
-- create_table(:lookup_keys, {:id=>:integer})
   -> 0.0077s
-- add_index(:lookup_keys, :key)
   -> 0.0051s
== 20091219132338 CreateLookupKeys: migrated (0.0132s) ========================

== 20091219132839 CreateLookupValues: migrating ===============================
-- create_table(:lookup_values, {:id=>:integer})
   -> 0.0132s
-- add_index(:lookup_values, :priority)
   -> 0.0050s
== 20091219132839 CreateLookupValues: migrated (0.0187s) ======================

== 20100310080727 AddFamilyToOs: migrating ====================================
-- add_column(:operatingsystems, :family_id, :integer, {})
   -> 0.0019s
== 20100310080727 AddFamilyToOs: migrated (0.0022s) ===========================

== 20100414125652 AddReleasenameToOs: migrating ===============================
-- add_column(:operatingsystems, :release_name, :string, {:limit=>64})
   -> 0.0017s
== 20100414125652 AddReleasenameToOs: migrated (0.0019s) ======================

== 20100416124600 CreateUsergroups: migrating =================================
-- create_table(:usergroups, {:id=>:integer})
   -> 0.0124s
-- create_table(:usergroup_members, {:id=>:integer})
   -> 0.0140s
== 20100416124600 CreateUsergroups: migrated (0.0268s) ========================

== 20100419151910 AddOwnerToHosts: migrating ==================================
-- add_column(:hosts, :owner_id, :integer, {})
   -> 0.0018s
-- add_column(:hosts, :owner_type, :string, {:limit=>255})
   -> 0.0011s
== 20100419151910 AddOwnerToHosts: migrated (0.0033s) =========================

== 20100523141204 CreateMediaOperatingsystemsAndMigrateData: migrating ========
-- create_table(:media_operatingsystems, {:id=>false})
   -> 0.0025s
-- remove_column(:media, :operatingsystem_id)
   -> 0.0009s
== 20100523141204 CreateMediaOperatingsystemsAndMigrateData: migrated (0.0037s) 

== 20100525094200 SimplifyParameters: migrating ===============================
-- index_exists?(:parameters, :host_id, {:name=>"index_parameters_on_host_id"})
   -> 0.0080s
-- index_exists?(:parameters, :hostgroup_id, {:name=>"index_parameters_on_hostgroup_id"})
   -> 0.0036s
-- index_exists?(:parameters, :domain_id, {:name=>"index_parameters_on_domain_id"})
   -> 0.0029s
-- column_exists?(:parameters, :host_id)
   -> 0.0015s
-- rename_column(:parameters, :host_id, :reference_id)
   -> 0.0029s
-- index_exists?(:parameters, :reference_id, {:name=>"index_parameters_on_reference_id"})
   -> 0.0027s
-- column_exists?(:parameters, :hostgroup_id)
   -> 0.0014s
-- remove_column(:parameters, :hostgroup_id)
   -> 0.0005s
-- column_exists?(:parameters, :domain_id)
   -> 0.0010s
-- remove_column(:parameters, :domain_id)
   -> 0.0003s
== 20100525094200 SimplifyParameters: migrated (0.0255s) ======================

== 20100601221000 UpdateOsMinor: migrating ====================================
-- change_column(:operatingsystems, :minor, :string, {:limit=>16})
   -> 0.0007s
== 20100601221000 UpdateOsMinor: migrated (0.0042s) ===========================

== 20100616114400 ChangeFamilyInOs: migrating =================================
-- add_column(:operatingsystems, :type, :string, {:limit=>16})
   -> 0.0005s
-- add_index(:operatingsystems, :type)
   -> 0.0032s
-- remove_column(:operatingsystems, :family_id)
   -> 0.0002s
== 20100616114400 ChangeFamilyInOs: migrated (0.0041s) ========================

== 20100625155400 CreateNotices: migrating ====================================
-- create_table(:notices, {:id=>:integer})
   -> 0.0076s
-- create_table(:user_notices, {:id=>false})
   -> 0.0007s
== 20100625155400 CreateNotices: migrated (0.0084s) ===========================

== 20100628123400 AddInternalAuth: migrating ==================================
-- add_column(:users, :password_hash, :string, {:limit=>128})
   -> 0.0006s
-- add_column(:users, :password_salt, :string, {:limit=>128})
   -> 0.0003s
== 20100628123400 AddInternalAuth: migrated (0.0010s) =========================

== 20100629093200 CreateRoles: migrating ======================================
-- add_column(:users, :role_id, :integer, {})
   -> 0.0005s
-- create_table("roles", {:force=>true, :id=>:integer})
   -> 0.0082s
-- create_table(:user_roles, {:id=>:integer})
   -> 0.0041s
== 20100629093200 CreateRoles: migrated (0.0129s) =============================

== 20100701081235 AddUserDomainsAndHostgroups: migrating ======================
-- create_table(:user_domains, {:id=>false})
   -> 0.0007s
-- create_table(:user_hostgroups, {:id=>false})
   -> 0.0004s
== 20100701081235 AddUserDomainsAndHostgroups: migrated (0.0013s) =============

== 20100822072954 CreateUserFacts: migrating ==================================
-- create_table(:user_facts, {:id=>:integer})
   -> 0.0049s
== 20100822072954 CreateUserFacts: migrated (0.0050s) =========================

== 20100823181036 AddEnabledToHosts: migrating ================================
-- add_column(:hosts, :enabled, :boolean, {:default=>true})
   -> 0.0007s
== 20100823181036 AddEnabledToHosts: migrated (0.0008s) =======================

== 20100914092104 AddMyBooleansToUser: migrating ==============================
-- add_column(:users, :domains_andor, :string, {:limit=>3, :default=>"or"})
   -> 0.0008s
-- add_column(:users, :hostgroups_andor, :string, {:limit=>3, :default=>"or"})
   -> 0.0005s
-- add_column(:users, :facts_andor, :string, {:limit=>3, :default=>"or"})
   -> 0.0006s
== 20100914092104 AddMyBooleansToUser: migrated (0.0020s) =====================

== 20101018120548 CreateMessages: migrating ===================================
-- create_table(:messages, {:id=>:integer})
   -> 0.0096s
-- add_index(:messages, :value)
   -> 0.0051s
== 20101018120548 CreateMessages: migrated (0.0149s) ==========================

== 20101018120603 CreateSources: migrating ====================================
-- create_table(:sources, {:id=>:integer})
   -> 0.0117s
-- add_index(:sources, :value)
   -> 0.0088s
== 20101018120603 CreateSources: migrated (0.0209s) ===========================

== 20101018120621 CreateLogs: migrating =======================================
-- create_table(:logs, {:id=>:integer})
   -> 0.0087s
-- add_index(:logs, :report_id)
   -> 0.0050s
-- add_index(:logs, :message_id)
   -> 0.0051s
-- add_index(:logs, :level_id)
   -> 0.0052s
== 20101018120621 CreateLogs: migrated (0.0246s) ==============================

== 20101019122857 AddMetricsToReport: migrating ===============================
-- add_column(:reports, :metrics, :text, {})
   -> 0.0018s
== 20101019122857 AddMetricsToReport: migrated (0.0020s) ======================

== 20101019183859 ConvertReports: migrating ===================================
-- remove_column(:reports, :log)
   -> 0.0014s
== 20101019183859 ConvertReports: migrated (0.0015s) ==========================

== 20101103150254 AddOwnedFilterToUser: migrating =============================
-- add_column(:users, :filter_on_owner, :boolean, {})
   -> 0.0017s
== 20101103150254 AddOwnedFilterToUser: migrated (0.0019s) ====================

== 20101118130026 CorrectMedia: migrating =====================================
-- table_exists?(:medias)
   -> 0.0015s
== 20101118130026 CorrectMedia: migrated (0.0016s) ============================

== 20101121080425 CreateConfigTemplates: migrating ============================
-- create_table(:config_templates, {:id=>:integer})
   -> 0.0088s
== 20101121080425 CreateConfigTemplates: migrated (0.0089s) ===================

== 20101121135521 CreateTemplateCombinations: migrating =======================
-- create_table(:template_combinations, {:id=>:integer})
   -> 0.0074s
== 20101121135521 CreateTemplateCombinations: migrated (0.0076s) ==============

== 20101122132041 CreateOperatingsystemsConfigTemplates: migrating ============
-- create_table(:config_templates_operatingsystems, {:id=>false})
   -> 0.0018s
== 20101122132041 CreateOperatingsystemsConfigTemplates: migrated (0.0019s) ===

== 20101123152150 CreateTemplateKinds: migrating ==============================
-- create_table(:template_kinds, {:id=>:integer})
   -> 0.0053s
== 20101123152150 CreateTemplateKinds: migrated (0.0054s) =====================

== 20101123153303 CreateOsDefaultTemplates: migrating =========================
-- create_table(:os_default_templates, {:id=>:integer})
   -> 0.0055s
== 20101123153303 CreateOsDefaultTemplates: migrated (0.0057s) ================

== 20101130093613 AddSubSystemsToSubnet: migrating ============================
-- add_column(:subnets, :dhcp_id, :integer, {})
   -> 0.0009s
-- add_column(:subnets, :tftp_id, :integer, {})
   -> 0.0004s
-- rename_column(:subnets, :number, :network)
   -> 0.0013s
== 20101130093613 AddSubSystemsToSubnet: migrated (0.0029s) ===================

== 20101130100315 CreateProxies: migrating ====================================
-- create_table(:smart_proxies, {:id=>:integer})
   -> 0.0093s
== 20101130100315 CreateProxies: migrated (0.0094s) ===========================

== 20101202104444 AddProxyToDomain: migrating =================================
-- add_column(:domains, :dns_id, :integer, {})
   -> 0.0017s
-- remove_column(:domains, :dnsserver)
   -> 0.0008s
-- remove_column(:domains, :gateway)
   -> 0.0008s
== 20101202104444 AddProxyToDomain: migrated (0.0037s) ========================

== 20110117162722 AddHostGroupDefaults: migrating =============================
-- add_column(:hostgroups, :operatingsystem_id, :integer, {})
   -> 0.0015s
-- add_column(:hostgroups, :architecture_id, :integer, {})
   -> 0.0010s
-- add_column(:hostgroups, :medium_id, :integer, {})
   -> 0.0009s
-- add_column(:hostgroups, :ptable_id, :integer, {})
   -> 0.0006s
-- add_column(:hostgroups, :root_pass, :string, {:limit=>255})
   -> 0.0050s
-- add_column(:hostgroups, :puppetmaster, :string, {:limit=>255})
   -> 0.0006s
== 20110117162722 AddHostGroupDefaults: migrated (0.0104s) ====================

== 20110213104226 CreateProxyFeatures: migrating ==============================
-- create_table(:features, {:id=>:integer})
   -> 0.0059s
-- create_table(:features_smart_proxies, {:id=>false})
   -> 0.0018s
== 20110213104226 CreateProxyFeatures: migrated (0.0081s) =====================

== 20110216101848 ChangePuppetmasterColumn: migrating =========================
-- rename_column(:hosts, :puppetmaster, :puppetmaster_name)
   -> 0.0075s
-- add_column(:hosts, :puppetproxy_id, :integer, {})
   -> 0.0005s
-- rename_column(:hostgroups, :puppetmaster, :puppetmaster_name)
   -> 0.0016s
-- add_column(:hostgroups, :puppetproxy_id, :integer, {})
   -> 0.0006s
== 20110216101848 ChangePuppetmasterColumn: migrated (0.0106s) ================

== 20110301154453 AddManagedToHosts: migrating ================================
-- add_column(:hosts, :managed, :boolean, {})
   -> 0.0009s
== 20110301154453 AddManagedToHosts: migrated (0.0010s) =======================

== 20110327123639 AddPriorityToParameter: migrating ===========================
-- add_column(:parameters, :priority, :integer, {})
   -> 0.0017s
== 20110327123639 AddPriorityToParameter: migrated (0.0019s) ==================

== 20110404150043 AddMediaPathToMedium: migrating =============================
-- add_column(:media, :media_path, :string, {:limit=>128})
   -> 0.0010s
-- add_column(:media, :config_path, :string, {:limit=>128})
   -> 0.0005s
-- add_column(:media, :image_path, :string, {:limit=>128})
   -> 0.0044s
== 20110404150043 AddMediaPathToMedium: migrated (0.0063s) ====================

== 20110407091150 AddImageToHost: migrating ===================================
-- add_column(:hosts, :use_image, :boolean, {})
   -> 0.0009s
-- add_column(:hosts, :image_file, :string, {:limit=>128})
   -> 0.0005s
-- add_column(:hostgroups, :use_image, :boolean, {})
   -> 0.0004s
-- add_column(:hostgroups, :image_file, :string, {:limit=>128})
   -> 0.0004s
== 20110407091150 AddImageToHost: migrated (0.0025s) ==========================

== 20110417102947 AddTableBookmarks: migrating ================================
-- create_table(:bookmarks, {:force=>true, :id=>:integer})
   -> 0.0086s
-- add_index(:bookmarks, :name)
   -> 0.0037s
-- add_index(:bookmarks, :controller)
   -> 0.0051s
-- add_index(:bookmarks, [:owner_id, :owner_type])
   -> 0.0043s
== 20110417102947 AddTableBookmarks: migrated (0.0220s) =======================

== 20110616080444 AddLookUpKeyIdToPuppetClass: migrating ======================
-- add_column(:lookup_keys, :puppetclass_id, :integer, {})
   -> 0.0010s
-- add_column(:lookup_keys, :default_value, :string, {:limit=>255})
   -> 0.0040s
-- add_column(:lookup_keys, :path, :string, {:limit=>255})
   -> 0.0005s
-- add_index(:lookup_keys, :path)
   -> 0.0037s
-- add_column(:lookup_keys, :description, :string, {:limit=>255})
   -> 0.0006s
-- add_column(:lookup_keys, :validator_type, :string, {:limit=>255})
   -> 0.0004s
-- add_column(:lookup_keys, :validator_rule, :string, {:limit=>255})
   -> 0.0005s
-- rename_column(:lookup_values, :priority, :match)
   -> 0.0034s
== 20110616080444 AddLookUpKeyIdToPuppetClass: migrated (0.0146s) =============

== 20110617190131 AddSparcInfoToModel: migrating ==============================
-- add_column(:models, :vendor_class, :string, {:limit=>32})
   -> 0.0008s
-- add_column(:models, :hardware_model, :string, {:limit=>16})
   -> 0.0006s
== 20110617190131 AddSparcInfoToModel: migrated (0.0015s) =====================

== 20110619130336 AddAncestryToHostgroup: migrating ===========================
-- add_column(:hostgroups, :ancestry, :string, {:limit=>255})
   -> 0.0016s
-- add_index(:hostgroups, :ancestry)
   -> 0.0046s
== 20110619130336 AddAncestryToHostgroup: migrated (0.0065s) ==================

== 20110628115422 CreateSettings: migrating ===================================
-- create_table(:settings, {:id=>:integer})
   -> 0.0127s
-- add_index(:settings, :name, {:unique=>true})
   -> 0.0037s
== 20110628115422 CreateSettings: migrated (0.0166s) ==========================

== 20110801090318 AddVmDefaultsToHostgroup: migrating =========================
-- add_column(:hostgroups, :vm_defaults, :text, {})
   -> 0.0009s
== 20110801090318 AddVmDefaultsToHostgroup: migrated (0.0009s) ================

== 20110803114134 AddSubnetAndDomainToHostGroups: migrating ===================
-- column_exists?(:hostgroups, :subnet_id)
   -> 0.0023s
-- add_column(:hostgroups, :subnet_id, :integer, {})
   -> 0.0006s
-- column_exists?(:hostgroups, :domain_id)
   -> 0.0018s
-- add_column(:hostgroups, :domain_id, :integer, {})
   -> 0.0006s
== 20110803114134 AddSubnetAndDomainToHostGroups: migrated (0.0055s) ==========

== 20111124095053 RenameChangesToAuditedChanges: migrating ====================
-- rename_column(:audits, :changes, :audited_changes)
   -> 0.0039s
== 20111124095053 RenameChangesToAuditedChanges: migrated (0.0040s) ===========

== 20111124095054 AddRemoteAddressToAudits: migrating =========================
-- add_column(:audits, :remote_address, :string, {:limit=>255})
   -> 0.0009s
== 20111124095054 AddRemoteAddressToAudits: migrated (0.0010s) ================

== 20111124095055 RenameParentToAssociation: migrating ========================
-- rename_column(:audits, :auditable_parent_id, :association_id)
   -> 0.0039s
-- rename_column(:audits, :auditable_parent_type, :association_type)
   -> 0.0034s
== 20111124095055 RenameParentToAssociation: migrated (0.0075s) ===============

== 20111205231500 AddGatewayAndDnsToSubnets: migrating ========================
-- add_column(:subnets, :gateway, :string, {:limit=>255})
   -> 0.0015s
-- add_column(:subnets, :dns_primary, :string, {:limit=>255})
   -> 0.0010s
-- add_column(:subnets, :dns_secondary, :string, {:limit=>255})
   -> 0.0009s
== 20111205231500 AddGatewayAndDnsToSubnets: migrated (0.0039s) ===============

== 20120102071633 AddFromAndToRangesToSubnets: migrating ======================
-- add_column(:subnets, :from, :string, {:limit=>255})
   -> 0.0017s
-- add_column(:subnets, :to, :string, {:limit=>255})
   -> 0.0009s
-- remove_column(:subnets, :ranges)
   -> 0.0007s
== 20120102071633 AddFromAndToRangesToSubnets: migrated (0.0038s) =============

== 20120110113051 CreateSubnetDomain: migrating ===============================
-- create_table(:subnet_domains, {:id=>:integer})
   -> 0.0069s
-- remove_column(:subnets, :domain_id)
   -> 0.0009s
== 20120110113051 CreateSubnetDomain: migrated (0.0081s) ======================

== 20120122131037 CreateComputeResources: migrating ===========================
-- create_table(:compute_resources, {:id=>:integer})
   -> 0.0099s
== 20120122131037 CreateComputeResources: migrated (0.0100s) ==================

== 20120126113850 AddUuidAndComputeIdToHost: migrating ========================
-- add_column(:hosts, :uuid, :string, {:limit=>255})
   -> 0.0009s
-- add_column(:hosts, :compute_resource_id, :integer, {})
   -> 0.0007s
== 20120126113850 AddUuidAndComputeIdToHost: migrated (0.0018s) ===============

== 20120311081257 CreateNics: migrating =======================================
-- create_table(:nics, {:id=>:integer})
   -> 0.0103s
-- add_index(:nics, [:type], {:name=>"index_by_type"})
   -> 0.0051s
-- add_index(:nics, [:host_id], {:name=>"index_by_host"})
   -> 0.0052s
-- add_index(:nics, [:type, :id], {:name=>"index_by_type_and_id"})
   -> 0.0053s
-- remove_columns(:hosts, :sp_mac, :sp_ip, :sp_name, :sp_subnet_id)
   -> 0.0050s
== 20120311081257 CreateNics: migrated (0.0318s) ==============================

== 20120313081913 AddPuppetMasterProxyToHostAndHostGroup: migrating ===========
-- rename_column(:hosts, :puppetproxy_id, :puppet_ca_proxy_id)
   -> 0.0121s
-- add_column(:hosts, :puppet_proxy_id, :integer, {})
   -> 0.0007s
-- rename_column(:hostgroups, :puppetproxy_id, :puppet_ca_proxy_id)
   -> 0.0032s
-- add_column(:hostgroups, :puppet_proxy_id, :integer, {})
   -> 0.0005s
-- remove_column(:hosts, :puppetmaster_name)
   -> 0.0004s
-- remove_column(:hostgroups, :puppetmaster_name)
   -> 0.0004s
== 20120313081913 AddPuppetMasterProxyToHostAndHostGroup: migrated (0.0178s) ==

== 20120502105518 UpdateReportFieldToLargeInt: migrating ======================
-- change_column(:reports, :status, :bigint, {})
   -> 0.0274s
-- change_column(:hosts, :puppet_status, :bigint, {})
   -> 0.0576s
== 20120502105518 UpdateReportFieldToLargeInt: migrated (0.0854s) =============

== 20120506143325 CreateImages: migrating =====================================
-- create_table(:images, {:id=>:integer})
   -> 0.0142s
== 20120506143325 CreateImages: migrated (0.0145s) ============================

== 20120509131302 AddCertNameToHost: migrating ================================
-- add_column(:hosts, :certname, :string, {:limit=>255})
   -> 0.0021s
-- add_index("hosts", :certname)
   -> 0.0065s
== 20120509131302 AddCertNameToHost: migrated (0.0090s) =======================

== 20120510113417 CreateKeyPairs: migrating ===================================
-- create_table(:key_pairs, {:id=>:integer})
   -> 0.0150s
== 20120510113417 CreateKeyPairs: migrated (0.0152s) ==========================

== 20120521142924 AddDnsIdToSubnet: migrating =================================
-- add_column(:subnets, :dns_id, :integer, {})
   -> 0.0020s
== 20120521142924 AddDnsIdToSubnet: migrated (0.0023s) ========================

== 20120523065531 AddImageIdToHost: migrating =================================
-- add_column(:hosts, :image_id, :integer, {})
   -> 0.0019s
== 20120523065531 AddImageIdToHost: migrated (0.0021s) ========================

== 20120529113900 AddUserComputeResources: migrating ==========================
-- create_table(:user_compute_resources, {:id=>false})
   -> 0.0026s
== 20120529113900 AddUserComputeResources: migrated (0.0028s) =================

== 20120529115814 AddComputeResourcesBooleanToUser: migrating =================
-- add_column(:users, :compute_resources_andor, :string, {:limit=>3, :default=>"or"})
   -> 0.0034s
== 20120529115814 AddComputeResourcesBooleanToUser: migrated (0.0036s) ========

== 20120607074318 ConvertParamsToText: migrating ==============================
-- change_column("parameters", :value, :text, {})
   -> 0.0011s
-- change_column("lookup_values", :value, :text, {})
   -> 0.0006s
== 20120607074318 ConvertParamsToText: migrated (0.0019s) =====================

== 20120612070100 ChangeBookmarkColumnToText: migrating =======================
-- change_column("bookmarks", :query, :text, {})
   -> 0.0008s
== 20120612070100 ChangeBookmarkColumnToText: migrated (0.0009s) ==============

== 20120613082125 RenameAssociationToAssociated: migrating ====================
-- index_exists?(:audits, [:association_id, :association_type], {:name=>"association_index"})
   -> 0.0031s
-- column_exists?(:audits, :association_id)
   -> 0.0016s
-- rename_column(:audits, :association_id, :associated_id)
   -> 0.0026s
-- column_exists?(:audits, :association_type)
   -> 0.0013s
-- rename_column(:audits, :association_type, :associated_type)
   -> 0.0025s
-- index_exists?(:audits, [:association_id, :association_type], {:name=>"association_index"})
   -> 0.0022s
-- add_index(:audits, [:associated_id, :associated_type], {:name=>"associated_index"})
   -> 0.0037s
== 20120613082125 RenameAssociationToAssociated: migrated (0.0175s) ===========

== 20120621135042 CreateTaxonomies: migrating =================================
-- create_table(:taxonomies, {:id=>:integer})
   -> 0.0082s
== 20120621135042 CreateTaxonomies: migrated (0.0083s) ========================

== 20120624081510 AddAuditableNameAndAssociatedNameToAudit: migrating =========
-- column_exists?(:audits, :auditable_name)
   -> 0.0050s
-- add_column(:audits, :auditable_name, :string, {:limit=>255})
   -> 0.0012s
-- column_exists?(:audits, :associated_name)
   -> 0.0043s
-- add_column(:audits, :associated_name, :string, {:limit=>255})
   -> 0.0012s
-- index_exists?(:audits, :id, {:name=>"index_audits_on_id"})
   -> 0.0117s
-- add_index(:audits, :id)
   -> 0.0054s
== 20120624081510 AddAuditableNameAndAssociatedNameToAudit: migrated (0.0298s) 

== 20120624093958 AddOsFamilyToMedia: migrating ===============================
-- add_column(:media, :os_family, :string, {:limit=>255})
   -> 0.0018s
== 20120624093958 AddOsFamilyToMedia: migrated (0.0020s) ======================

== 20120624094034 AddOsFamilyToPtable: migrating ==============================
-- column_exists?(:ptables, :os_family)
   -> 0.0054s
-- add_column(:ptables, :os_family, :string, {:limit=>255})
   -> 0.0013s
-- column_exists?(:ptables, :operatingsystem_id)
   -> 0.0043s
-- remove_column(:ptables, :operatingsystem_id)
   -> 0.0010s
== 20120624094034 AddOsFamilyToPtable: migrated (0.0127s) =====================

== 20120705130038 AddAttributesToComputeResources: migrating ==================
-- column_exists?(:compute_resources, :attrs)
   -> 0.0046s
-- add_column(:compute_resources, :attrs, :text, {})
   -> 0.0012s
== 20120705130038 AddAttributesToComputeResources: migrated (0.0061s) =========

== 20120905131841 AddLookupKeysOverrideAndRequired: migrating =================
-- add_column(:lookup_keys, :is_param, :boolean, {:default=>false})
   -> 0.0030s
-- add_column(:lookup_keys, :key_type, :string, {:default=>nil, :limit=>255})
   -> 0.0027s
-- add_column(:lookup_keys, :override, :boolean, {:default=>false})
   -> 0.0026s
-- add_column(:lookup_keys, :required, :boolean, {:default=>false})
   -> 0.0253s
== 20120905131841 AddLookupKeysOverrideAndRequired: migrated (0.0344s) ========

== 20120916080843 AddLookupValuesCountToLookupKeys: migrating =================
-- add_column(:lookup_keys, :lookup_values_count, :integer, {:default=>0})
   -> 0.0010s
== 20120916080843 AddLookupValuesCountToLookupKeys: migrated (0.0010s) ========

== 20120921000313 AddIamRoleToImages: migrating ===============================
-- add_column(:images, :iam_role, :string, {:limit=>255})
   -> 0.0006s
== 20120921000313 AddIamRoleToImages: migrated (0.0007s) ======================

== 20120921105349 CreateTokens: migrating =====================================
-- create_table(:tokens, {:id=>:integer})
   -> 0.0047s
-- add_index(:tokens, :value)
   -> 0.0034s
-- add_index(:tokens, :host_id)
   -> 0.0033s
== 20120921105349 CreateTokens: migrated (0.0116s) ============================

== 20121003172526 AddTaxonomyIdsToHosts: migrating ============================
-- add_column(:hosts, :organization_id, :integer, {})
   -> 0.0006s
-- add_column(:hosts, :location_id, :integer, {})
   -> 0.0003s
== 20121003172526 AddTaxonomyIdsToHosts: migrated (0.0010s) ===================

== 20121011115320 ChangeDomainCharacterCount: migrating =======================
-- change_column(:domains, :fullname, :string, {:limit=>254})
   -> 0.0006s
== 20121011115320 ChangeDomainCharacterCount: migrated (0.0007s) ==============

== 20121012170851 CreateTrends: migrating =====================================
-- create_table(:trends, {})
   -> 0.0108s
-- add_index(:trends, :type)
   -> 0.0051s
-- add_index(:trends, [:trendable_type, :trendable_id])
   -> 0.0053s
-- add_index(:trends, :fact_value)
   -> 0.0051s
== 20121012170851 CreateTrends: migrated (0.0268s) ============================

== 20121012170936 CreateTrendCounters: migrating ==============================
-- create_table(:trend_counters, {})
   -> 0.0156s
== 20121012170936 CreateTrendCounters: migrated (0.0158s) =====================

== 20121015113502 UpdateMediaPathLimit: migrating =============================
-- change_column(:media, :path, :string, {:limit=>255})
   -> 0.0015s
== 20121015113502 UpdateMediaPathLimit: migrated (0.0016s) ====================

== 20121101141448 AddLocationsOrganizations: migrating ========================
-- create_table(:locations_organizations, {:id=>false})
   -> 0.0027s
== 20121101141448 AddLocationsOrganizations: migrated (0.0029s) ===============

== 20121118120028 MigrateHypervisorsToComputeResources: migrating =============
-- drop_table(:hypervisors, {:if_exists=>true})
   -> 0.0010s
== 20121118120028 MigrateHypervisorsToComputeResources: migrated (0.0011s) ====

== 20121118125341 CreateTaxableTaxonomies: migrating ==========================
-- create_table(:taxable_taxonomies, {:id=>:integer})
   -> 0.0072s
-- add_index(:taxable_taxonomies, [:taxable_id, :taxable_type])
   -> 0.0043s
-- add_index(:taxable_taxonomies, [:taxable_id, :taxable_type, :taxonomy_id], {:name=>"taxable_index"})
   -> 0.0042s
-- add_index(:taxable_taxonomies, :taxonomy_id)
   -> 0.0045s
== 20121118125341 CreateTaxableTaxonomies: migrated (0.0206s) =================

== 20121119102104 AddMyTaxonomyToUser: migrating ==============================
-- add_column(:users, :organizations_andor, :string, {:limit=>3, :default=>"or"})
   -> 0.0025s
-- add_column(:users, :locations_andor, :string, {:limit=>3, :default=>"or"})
   -> 0.0015s
== 20121119102104 AddMyTaxonomyToUser: migrated (0.0044s) =====================

== 20121210214810 AddSubscribeToAllHostgroupsToUsers: migrating ===============
-- column_exists?(:users, :subscribe_to_all_hostgroups)
   -> 0.0040s
-- add_column(:users, :subscribe_to_all_hostgroups, :boolean, {})
   -> 0.0008s
== 20121210214810 AddSubscribeToAllHostgroupsToUsers: migrated (0.0051s) ======

== 20121218084123 ChangeSmartVariableLength: migrating ========================
-- change_column(:lookup_keys, :default_value, :text, {})
   -> 0.0014s
== 20121218084123 ChangeSmartVariableLength: migrated (0.0015s) ===============

== 20130109155024 AddIgnoreTypesToTaxonomy: migrating =========================
-- add_column(:taxonomies, :ignore_types, :text, {})
   -> 0.0012s
== 20130109155024 AddIgnoreTypesToTaxonomy: migrated (0.0014s) ================

== 20130121130826 AddDigestToMessages: migrating ==============================
-- index_exists?(:messages, :value, {:name=>"index_messages_on_value"})
   -> 0.0041s
-- remove_index(:messages, :value, {:name=>"index_messages_on_value"})
   -> 0.0036s
-- add_column(:messages, :digest, :string, {:limit=>40})
   -> 0.0008s
-- add_index(:messages, :digest)
   -> 0.0046s
== 20130121130826 AddDigestToMessages: migrated (0.0155s) =====================

== 20130211160200 AddStiToHosts: migrating ====================================
-- add_column(:hosts, :type, :string, {:limit=>255})
   -> 0.0019s
-- add_index(:hosts, :type)
   -> 0.0051s
== 20130211160200 AddStiToHosts: migrated (0.0074s) ===========================

== 20130228145456 AddDigestToSources: migrating ===============================
-- index_exists?(:sources, :value, {:name=>"index_sources_on_value"})
   -> 0.0051s
-- remove_index(:sources, :value, {:name=>"index_sources_on_value"})
   -> 0.0032s
-- add_column(:sources, :digest, :string, {:limit=>40})
   -> 0.0007s
-- add_index(:sources, :digest)
   -> 0.0041s
== 20130228145456 AddDigestToSources: migrated (0.0150s) ======================

== 20130409081924 AddLabelToHostGroup: migrating ==============================
-- add_column(:hostgroups, :label, :string, {:limit=>255})
   -> 0.0008s
== 20130409081924 AddLabelToHostGroup: migrated (0.0008s) =====================

== 20130417110127 AddStiToSettings: migrating =================================
-- add_index(:settings, :category)
   -> 0.0041s
== 20130417110127 AddStiToSettings: migrated (0.0042s) ========================

== 20130419145808 AddIdToUserHostgroup: migrating =============================
-- add_column(:user_hostgroups, :id, :integer, {:primary_key=>true})
   -> 0.0076s
== 20130419145808 AddIdToUserHostgroup: migrated (0.0077s) ====================

== 20130430150500 AddLocaleToUsers: migrating =================================
-- add_column(:users, :locale, :string, {:limit=>5, :null=>true})
   -> 0.0009s
== 20130430150500 AddLocaleToUsers: migrated (0.0009s) ========================

== 20130520161514 AddUniqueConstraintToFactName: migrating ====================
-- remove_index(:fact_names, nil, {:column=>:name, :name=>"index_fact_names_on_name"})
   -> 0.0018s
-- add_index(:fact_names, :name, {:unique=>true})
   -> 0.0036s
== 20130520161514 AddUniqueConstraintToFactName: migrated (0.0066s) ===========

== 20130523131455 AddUniqueConstraintsToFactValues: migrating =================
-- add_index(:fact_values, [:fact_name_id, :host_id], {:unique=>true})
   -> 0.0037s
== 20130523131455 AddUniqueConstraintsToFactValues: migrated (0.0037s) ========

== 20130530061844 ChangeColumnLengths: migrating ==============================
-- change_column(:media, :name, :string, {:limit=>255})
   -> 0.0009s
-- change_column(:media, :media_path, :string, {:limit=>255})
   -> 0.0004s
-- change_column(:media, :config_path, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:media, :image_path, :string, {:limit=>255})
   -> 0.0004s
-- change_column(:architectures, :name, :string, {:limit=>255})
   -> 0.0004s
-- change_column(:auth_sources, :type, :string, {:limit=>255})
   -> 0.0005s
-- change_column(:auth_sources, :name, :string, {:limit=>255})
   -> 0.0005s
-- change_column(:auth_sources, :host, :string, {:limit=>255})
   -> 0.0004s
-- change_column(:auth_sources, :account_password, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:auth_sources, :attr_login, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:auth_sources, :attr_firstname, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:auth_sources, :attr_lastname, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:auth_sources, :attr_mail, :string, {:limit=>255})
   -> 0.0002s
-- change_column(:domains, :fullname, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:features, :name, :string, {:limit=>255})
   -> 0.0002s
-- change_column(:hosts, :mac, :string, {:limit=>255})
   -> 0.0004s
-- change_column(:hosts, :root_pass, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:hosts, :serial, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:models, :name, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:models, :vendor_class, :string, {:limit=>255})
   -> 0.0003s
-- change_column(:models, :hardware_model, :string, {:limit=>255})
   -> 0.0002s
-- change_column(:operatingsystems, :name, :string, {:limit=>255})
   -> 0.0002s
-- change_column(:operatingsystems, :release_name, :string, {:limit=>255})
   -> 0.0036s
-- change_column(:operatingsystems, :type, :string, {:limit=>255})
   -> 0.0007s
-- change_column(:ptables, :name, :string, {:limit=>255})
   -> 0.0005s
-- change_column(:roles, :name, :string, {:limit=>255})
   -> 0.0004s
== 20130530061844 ChangeColumnLengths: migrated (0.0280s) =====================

== 20130804131949 AddPublicToKeyPairs: migrating ==============================
-- add_column(:key_pairs, :public, :text, {})
   -> 0.0006s
== 20130804131949 AddPublicToKeyPairs: migrated (0.0007s) =====================

== 20130813105054 ChangeComputeResourcePasswordToText: migrating ==============
-- change_column(:compute_resources, :password, :text, {})
   -> 0.0005s
-- You need to run rake security:generate_encryption_key to generate an ENCRYPTION_KEY.
-- Then, you may run rake db:compute_resources:encrypt to encrypt the passwords for Compute Resources.
-- Conversely, you may run rake db:compute_resources:decrypt to decrypt the passwords for Compute Resources.
== 20130813105054 ChangeComputeResourcePasswordToText: migrated (0.0006s) =====

== 20130814132531 AddLdapFilterToAuthSources: migrating =======================
-- add_column(:auth_sources, :ldap_filter, :string, {:limit=>255, :null=>true})
   -> 0.0005s
== 20130814132531 AddLdapFilterToAuthSources: migrated (0.0006s) ==============

== 20130908170524 AddKeys: migrating ==========================================
-- execute("SET CONSTRAINTS ALL DEFERRED;")
   -> 0.0004s
-- add_foreign_key("architectures_operatingsystems", "architectures", {:name=>"architectures_operatingsystems_architecture_id_fk"})
   -> 0.0008s
-- add_foreign_key("architectures_operatingsystems", "operatingsystems", {:name=>"architectures_operatingsystems_operatingsystem_id_fk"})
   -> 0.0008s
-- add_foreign_key("audits", "users", {:name=>"audits_user_id_fk"})
   -> 0.0010s
-- add_foreign_key("config_templates_operatingsystems", "config_templates", {:name=>"config_templates_operatingsystems_config_template_id_fk"})
   -> 0.0007s
-- add_foreign_key("config_templates_operatingsystems", "operatingsystems", {:name=>"config_templates_operatingsystems_operatingsystem_id_fk"})
   -> 0.0006s
-- add_foreign_key("config_templates", "template_kinds", {:name=>"config_templates_template_kind_id_fk"})
   -> 0.0007s
-- add_foreign_key("domains", "smart_proxies", {:name=>"domains_dns_id_fk", :column=>"dns_id"})
   -> 0.0007s
-- add_foreign_key("fact_values", "fact_names", {:name=>"fact_values_fact_name_id_fk"})
   -> 0.0009s
-- add_foreign_key("fact_values", "hosts", {:name=>"fact_values_host_id_fk"})
   -> 0.0011s
-- add_foreign_key("features_smart_proxies", "features", {:name=>"features_smart_proxies_feature_id_fk"})
   -> 0.0008s
-- add_foreign_key("features_smart_proxies", "smart_proxies", {:name=>"features_smart_proxies_smart_proxy_id_fk"})
   -> 0.0006s
-- add_foreign_key("hostgroups", "architectures", {:name=>"hostgroups_architecture_id_fk"})
   -> 0.0009s
-- add_foreign_key("hostgroups", "domains", {:name=>"hostgroups_domain_id_fk"})
   -> 0.0009s
-- add_foreign_key("hostgroups", "media", {:name=>"hostgroups_medium_id_fk"})
   -> 0.0007s
-- add_foreign_key("hostgroups", "operatingsystems", {:name=>"hostgroups_operatingsystem_id_fk"})
   -> 0.0006s
-- add_foreign_key("hostgroups", "ptables", {:name=>"hostgroups_ptable_id_fk"})
   -> 0.0008s
-- add_foreign_key("hostgroups", "smart_proxies", {:name=>"hostgroups_puppet_ca_proxy_id_fk", :column=>"puppet_ca_proxy_id"})
   -> 0.0005s
-- add_foreign_key("hostgroups", "smart_proxies", {:name=>"hostgroups_puppet_proxy_id_fk", :column=>"puppet_proxy_id"})
   -> 0.0006s
-- add_foreign_key("hostgroups", "subnets", {:name=>"hostgroups_subnet_id_fk"})
   -> 0.0007s
-- add_foreign_key("hosts", "architectures", {:name=>"hosts_architecture_id_fk"})
   -> 0.0007s
-- add_foreign_key("hosts", "compute_resources", {:name=>"hosts_compute_resource_id_fk"})
   -> 0.0010s
-- add_foreign_key("hosts", "domains", {:name=>"hosts_domain_id_fk"})
   -> 0.0014s
-- add_foreign_key("hosts", "hostgroups", {:name=>"hosts_hostgroup_id_fk"})
   -> 0.0011s
-- add_foreign_key("hosts", "images", {:name=>"hosts_image_id_fk"})
   -> 0.0014s
-- add_foreign_key("hosts", "media", {:name=>"hosts_medium_id_fk"})
   -> 0.0013s
-- add_foreign_key("hosts", "models", {:name=>"hosts_model_id_fk"})
   -> 0.0010s
-- add_foreign_key("hosts", "operatingsystems", {:name=>"hosts_operatingsystem_id_fk"})
   -> 0.0010s
-- add_foreign_key("hosts", "ptables", {:name=>"hosts_ptable_id_fk"})
   -> 0.0009s
-- add_foreign_key("hosts", "smart_proxies", {:name=>"hosts_puppet_ca_proxy_id_fk", :column=>"puppet_ca_proxy_id"})
   -> 0.0008s
-- add_foreign_key("hosts", "smart_proxies", {:name=>"hosts_puppet_proxy_id_fk", :column=>"puppet_proxy_id"})
   -> 0.0007s
-- add_foreign_key("hosts", "subnets", {:name=>"hosts_subnet_id_fk"})
   -> 0.0007s
-- add_foreign_key("hosts", "taxonomies", {:name=>"hosts_location_id_fk", :column=>"location_id"})
   -> 0.0008s
-- add_foreign_key("hosts", "taxonomies", {:name=>"hosts_organization_id_fk", :column=>"organization_id"})
   -> 0.0008s
-- add_foreign_key("images", "architectures", {:name=>"images_architecture_id_fk"})
   -> 0.0006s
-- add_foreign_key("images", "compute_resources", {:name=>"images_compute_resource_id_fk"})
   -> 0.0006s
-- add_foreign_key("images", "operatingsystems", {:name=>"images_operatingsystem_id_fk"})
   -> 0.0007s
-- add_foreign_key("key_pairs", "compute_resources", {:name=>"key_pairs_compute_resource_id_fk"})
   -> 0.0008s
-- add_foreign_key("lookup_values", "lookup_keys", {:name=>"lookup_values_lookup_key_id_fk"})
   -> 0.0009s
-- add_foreign_key("media_operatingsystems", "media", {:name=>"media_operatingsystems_medium_id_fk"})
   -> 0.0007s
-- add_foreign_key("media_operatingsystems", "operatingsystems", {:name=>"media_operatingsystems_operatingsystem_id_fk"})
   -> 0.0006s
-- add_foreign_key("nics", "domains", {:name=>"nics_domain_id_fk"})
   -> 0.0008s
-- add_foreign_key("nics", "hosts", {:name=>"nics_host_id_fk"})
   -> 0.0007s
-- add_foreign_key("nics", "subnets", {:name=>"nics_subnet_id_fk"})
   -> 0.0007s
-- add_foreign_key("operatingsystems_ptables", "operatingsystems", {:name=>"operatingsystems_ptables_operatingsystem_id_fk"})
   -> 0.0007s
-- add_foreign_key("operatingsystems_ptables", "ptables", {:name=>"operatingsystems_ptables_ptable_id_fk"})
   -> 0.0006s
-- add_foreign_key("os_default_templates", "config_templates", {:name=>"os_default_templates_config_template_id_fk"})
   -> 0.0007s
-- add_foreign_key("os_default_templates", "operatingsystems", {:name=>"os_default_templates_operatingsystem_id_fk"})
   -> 0.0007s
-- add_foreign_key("os_default_templates", "template_kinds", {:name=>"os_default_templates_template_kind_id_fk"})
   -> 0.0006s
-- add_foreign_key("reports", "hosts", {:name=>"reports_host_id_fk"})
   -> 0.0009s
-- add_foreign_key("subnet_domains", "domains", {:name=>"subnet_domains_domain_id_fk"})
   -> 0.0007s
-- add_foreign_key("subnet_domains", "subnets", {:name=>"subnet_domains_subnet_id_fk"})
   -> 0.0006s
-- add_foreign_key("subnets", "smart_proxies", {:name=>"subnets_dhcp_id_fk", :column=>"dhcp_id"})
   -> 0.0006s
-- add_foreign_key("subnets", "smart_proxies", {:name=>"subnets_dns_id_fk", :column=>"dns_id"})
   -> 0.0006s
-- add_foreign_key("subnets", "smart_proxies", {:name=>"subnets_tftp_id_fk", :column=>"tftp_id"})
   -> 0.0006s
-- add_foreign_key("taxable_taxonomies", "taxonomies", {:name=>"taxable_taxonomies_taxonomy_id_fk"})
   -> 0.0008s
-- add_foreign_key("template_combinations", "config_templates", {:name=>"template_combinations_config_template_id_fk"})
   -> 0.0007s
-- add_foreign_key("template_combinations", "hostgroups", {:name=>"template_combinations_hostgroup_id_fk"})
   -> 0.0007s
-- add_foreign_key("tokens", "hosts", {:name=>"tokens_host_id_fk"})
   -> 0.0010s
-- add_foreign_key("user_compute_resources", "compute_resources", {:name=>"user_compute_resources_compute_resource_id_fk"})
   -> 0.0009s
-- add_foreign_key("user_compute_resources", "users", {:name=>"user_compute_resources_user_id_fk"})
   -> 0.0013s
-- add_foreign_key("user_domains", "domains", {:name=>"user_domains_domain_id_fk"})
   -> 0.0010s
-- add_foreign_key("user_domains", "users", {:name=>"user_domains_user_id_fk"})
   -> 0.0009s
-- add_foreign_key("user_facts", "fact_names", {:name=>"user_facts_fact_name_id_fk"})
   -> 0.0017s
-- add_foreign_key("user_facts", "users", {:name=>"user_facts_user_id_fk"})
   -> 0.0008s
-- add_foreign_key("user_hostgroups", "hostgroups", {:name=>"user_hostgroups_hostgroup_id_fk"})
   -> 0.0008s
-- add_foreign_key("user_hostgroups", "users", {:name=>"user_hostgroups_user_id_fk"})
   -> 0.0007s
-- add_foreign_key("user_notices", "notices", {:name=>"user_notices_notice_id_fk"})
   -> 0.0008s
-- add_foreign_key("user_notices", "users", {:name=>"user_notices_user_id_fk"})
   -> 0.0008s
-- add_foreign_key("user_roles", "roles", {:name=>"user_roles_role_id_fk"})
   -> 0.0008s
-- add_foreign_key("user_roles", "users", {:name=>"user_roles_user_id_fk"})
   -> 0.0007s
-- add_foreign_key("usergroup_members", "usergroups", {:name=>"usergroup_members_usergroup_id_fk"})
   -> 0.0008s
-- add_foreign_key("users", "auth_sources", {:name=>"users_auth_source_id_fk"})
   -> 0.0009s
== 20130908170524 AddKeys: migrated (0.0622s) =================================

== 20130924145800 RemoveUnusedRoleFields: migrating ===========================
-- remove_column(:users, :role_id)
   -> 0.0008s
-- remove_column(:user_roles, :inherited_from)
   -> 0.0003s
== 20130924145800 RemoveUnusedRoleFields: migrated (0.0011s) ==================

== 20131014133347 AddComposeFlagAndShortNameToFactName: migrating =============
-- add_column(:fact_names, :compose, :boolean, {:default=>false, :null=>false})
   -> 0.0007s
-- add_column(:fact_names, :short_name, :string, {:limit=>255})
   -> 0.0043s
== 20131014133347 AddComposeFlagAndShortNameToFactName: migrated (0.0052s) ====

== 20131017142515 AllowNullValuesOnFactValue: migrating =======================
-- change_column(:fact_values, :value, :text, {})
   -> 0.0016s
== 20131017142515 AllowNullValuesOnFactValue: migrated (0.0025s) ==============

== 20131021125612 AddTypeToFactName: migrating ================================
-- add_column(:fact_names, :type, :string, {:default=>"FactName", :limit=>255})
   -> 0.0037s
== 20131021125612 AddTypeToFactName: migrated (0.0039s) =======================

== 20131021152315 ChangeNameIndexOnFactName: migrating ========================
-- remove_index(:fact_names, nil, {:column=>:name, :unique=>true, :name=>"index_fact_names_on_name"})
   -> 0.0054s
-- add_index(:fact_names, [:name, :type], {:unique=>true})
   -> 0.0055s
== 20131021152315 ChangeNameIndexOnFactName: migrated (0.0141s) ===============

== 20131107094849 AddAncestryToFactNames: migrating ===========================
-- add_column(:fact_names, :ancestry, :string, {:limit=>255})
   -> 0.0017s
-- add_index(:fact_names, :ancestry)
   -> 0.0059s
== 20131107094849 AddAncestryToFactNames: migrated (0.0079s) ==================

== 20131114084718 ExtendUserRole: migrating ===================================
-- foreign_key_exists?("user_roles", {:name=>"user_roles_user_id_fk"})
   -> 0.0097s
-- remove_foreign_key("user_roles", {:name=>"user_roles_user_id_fk"})
   -> 0.0080s
-- add_column(:user_roles, :owner_type, :string, {:default=>"User", :null=>false, :limit=>255})
   -> 0.0013s
-- rename_column(:user_roles, :user_id, :owner_id)
   -> 0.0023s
-- add_index(:user_roles, :owner_type)
   -> 0.0042s
-- add_index(:user_roles, :owner_id)
   -> 0.0036s
-- add_index(:user_roles, [:owner_id, :owner_type])
   -> 0.0035s
-- change_column(:user_roles, :owner_id, :integer, {})
   -> 0.0010s
== 20131114084718 ExtendUserRole: migrated (0.0347s) ==========================

== 20131114094841 CreateCachedUserRoles: migrating ============================
-- create_table(:cached_user_roles, {:id=>:integer})
   -> 0.0054s
-- add_index(:cached_user_roles, :user_id)
   -> 0.0050s
-- add_index(:cached_user_roles, :role_id)
   -> 0.0052s
-- add_index(:cached_user_roles, :user_role_id)
   -> 0.0063s
== 20131114094841 CreateCachedUserRoles: migrated (0.0224s) ===================

== 20131122170726 CreateCachedUsergroupMembers: migrating =====================
-- create_table(:cached_usergroup_members, {:id=>:integer})
   -> 0.0068s
-- add_index(:cached_usergroup_members, :user_id)
   -> 0.0042s
-- add_index(:cached_usergroup_members, :usergroup_id)
   -> 0.0043s
== 20131122170726 CreateCachedUsergroupMembers: migrated (0.0157s) ============

== 20131125230654 CreateRealms: migrating =====================================
-- create_table(:realms, {:id=>:integer})
   -> 0.0137s
-- add_index(:realms, :name, {:unique=>true})
   -> 0.0044s
-- column_exists?(:hosts, :otp)
   -> 0.0051s
-- add_column(:hosts, :otp, :string, {:limit=>255})
   -> 0.0009s
-- column_exists?(:hosts, :realm_id)
   -> 0.0061s
-- add_column(:hosts, :realm_id, :integer, {})
   -> 0.0012s
-- column_exists?(:hostgroups, :realm_id)
   -> 0.0027s
-- add_column(:hostgroups, :realm_id, :integer, {})
   -> 0.0007s
-- add_foreign_key(:realms, :smart_proxies, {:name=>"realms_realm_proxy_id_fk", :column=>"realm_proxy_id"})
   -> 0.0013s
-- add_foreign_key(:hosts, :realms, {:name=>"hosts_realms_id_fk"})
   -> 0.0014s
-- add_foreign_key(:hostgroups, :realms, {:name=>"hostgroups_realms_id_fk"})
   -> 0.0012s
== 20131125230654 CreateRealms: migrated (0.0399s) ============================

== 20131128150357 AddAdminFlagToUsergroup: migrating ==========================
-- add_column(:usergroups, :admin, :boolean, {:null=>false, :default=>false})
   -> 0.0011s
== 20131128150357 AddAdminFlagToUsergroup: migrated (0.0011s) =================

== 20131202120621 CreatePermissions: migrating ================================
-- create_table(:permissions, {:id=>:integer})
   -> 0.0081s
-- add_index(:permissions, [:name, :resource_type])
   -> 0.0036s
== 20131202120621 CreatePermissions: migrated (0.0118s) =======================

== 20131202131847 CreateFilters: migrating ====================================
-- create_table(:filters, {:id=>:integer})
   -> 0.0086s
== 20131202131847 CreateFilters: migrated (0.0087s) ===========================

== 20131202144415 CreateFilterings: migrating =================================
-- create_table(:filterings, {:id=>:integer})
   -> 0.0055s
-- add_index(:filterings, :filter_id)
   -> 0.0052s
-- add_index(:filterings, :permission_id)
   -> 0.0049s
== 20131202144415 CreateFilterings: migrated (0.0160s) ========================

== 20131204174455 AddDescriptionToOperatingsystem: migrating ==================
-- add_column(:operatingsystems, :description, :string, {:limit=>255})
   -> 0.0023s
== 20131204174455 AddDescriptionToOperatingsystem: migrated (0.0025s) =========

== 20131212125626 AddLdapAvatarSupport: migrating =============================
-- add_column(:auth_sources, :attr_photo, :string, {:limit=>255})
   -> 0.0019s
-- add_column(:users, :avatar_hash, :string, {:limit=>128})
   -> 0.0013s
== 20131212125626 AddLdapAvatarSupport: migrated (0.0036s) ====================

== 20131223120945 AddUserdataFlagToImages: migrating ==========================
-- add_column(:images, :user_data, :boolean, {:default=>false})
   -> 0.0020s
== 20131223120945 AddUserdataFlagToImages: migrated (0.0022s) =================

== 20131224153518 CreateComputeProfiles: migrating ============================
-- create_table(:compute_profiles, {:id=>:integer})
   -> 0.0068s
== 20131224153518 CreateComputeProfiles: migrated (0.0069s) ===================

== 20131224153743 CreateComputeAttributes: migrating ==========================
-- create_table(:compute_attributes, {:id=>:integer})
   -> 0.0088s
-- add_index(:compute_attributes, :compute_profile_id)
   -> 0.0037s
-- add_index(:compute_attributes, :compute_resource_id)
   -> 0.0038s
-- add_foreign_key("compute_attributes", "compute_resources", {:name=>"compute_attributes_compute_resource_id_fk"})
   -> 0.0014s
-- add_foreign_key("compute_attributes", "compute_profiles", {:name=>"compute_attributes_compute_profile_id_fk"})
   -> 0.0013s
== 20131224153743 CreateComputeAttributes: migrated (0.0194s) =================

== 20131224154836 AddComputeProfileToHostgroup: migrating =====================
-- add_column(:hostgroups, :compute_profile_id, :integer, {})
   -> 0.0010s
-- add_column(:hosts, :compute_profile_id, :integer, {})
   -> 0.0006s
-- add_index(:hostgroups, :compute_profile_id)
   -> 0.0044s
-- add_index(:hosts, :compute_profile_id)
   -> 0.0059s
-- add_foreign_key("hostgroups", "compute_profiles", {:name=>"hostgroups_compute_profile_id_fk"})
   -> 0.0032s
-- add_foreign_key("hosts", "compute_profiles", {:name=>"hosts_compute_profile_id_fk"})
   -> 0.0032s
== 20131224154836 AddComputeProfileToHostgroup: migrated (0.0192s) ============

== 20140110164135 AddForeignKeysToFiltersAndFilterings: migrating =============
-- add_foreign_key("filters", "roles", {:name=>"filters_roles_id_fk"})
   -> 0.0038s
-- add_foreign_key("filterings", "filters", {:name=>"filterings_filters_id_fk"})
   -> 0.0035s
-- add_foreign_key("filterings", "permissions", {:name=>"filterings_permissions_id_fk"})
   -> 0.0038s
== 20140110164135 AddForeignKeysToFiltersAndFilterings: migrated (0.0117s) ====

== 20140115130443 AddPasswordToImages: migrating ==============================
-- add_column(:images, :password, :string, {:limit=>255})
   -> 0.0017s
== 20140115130443 AddPasswordToImages: migrated (0.0018s) =====================

== 20140123185537 AddDefaultOrganizationIdToUsers: migrating ==================
-- add_column(:users, :default_organization_id, :integer, {})
   -> 0.0011s
== 20140123185537 AddDefaultOrganizationIdToUsers: migrated (0.0011s) =========

== 20140123194519 AddDefaultLocationIdToUsers: migrating ======================
-- add_column(:users, :default_location_id, :integer, {})
   -> 0.0009s
== 20140123194519 AddDefaultLocationIdToUsers: migrated (0.0009s) =============

== 20140128123153 AddAncestryToTaxonomies: migrating ==========================
-- add_column(:taxonomies, :ancestry, :string, {:limit=>255})
   -> 0.0010s
-- add_index(:taxonomies, :ancestry)
   -> 0.0038s
-- add_column(:taxonomies, :label, :string, {:limit=>255})
   -> 0.0005s
== 20140128123153 AddAncestryToTaxonomies: migrated (0.0070s) =================

== 20140219183342 ChangeLabelToTitle: migrating ===============================
-- rename_column(:hostgroups, :label, :title)
   -> 0.0027s
-- rename_column(:taxonomies, :label, :title)
   -> 0.0018s
== 20140219183342 ChangeLabelToTitle: migrated (0.0054s) ======================

== 20140219183345 AddTaxonomySearchesToFilter: migrating ======================
-- add_column(:filters, :taxonomy_search, :text, {})
   -> 0.0006s
== 20140219183345 AddTaxonomySearchesToFilter: migrated (0.0006s) =============

== 20140304184854 AddProvisionMethodToHosts: migrating ========================
-- add_column(:hosts, :provision_method, :string, {:limit=>255})
   -> 0.0006s
== 20140304184854 AddProvisionMethodToHosts: migrated (0.0007s) ===============

== 20140314004243 AddCounterCaches: migrating =================================
-- add_column(:architectures, :hosts_count, :integer, {:default=>0})
   -> 0.0008s
-- add_column(:architectures, :hostgroups_count, :integer, {:default=>0})
   -> 0.0005s
-- add_column(:domains, :hosts_count, :integer, {:default=>0})
   -> 0.0005s
-- add_column(:domains, :hostgroups_count, :integer, {:default=>0})
   -> 0.0005s
-- add_column(:models, :hosts_count, :integer, {:default=>0})
   -> 0.0005s
-- add_column(:operatingsystems, :hosts_count, :integer, {:default=>0})
   -> 0.0005s
-- add_column(:operatingsystems, :hostgroups_count, :integer, {:default=>0})
   -> 0.0005s
== 20140314004243 AddCounterCaches: migrated (0.0042s) ========================

== 20140318221513 ChangeHostManagedDefaultToFalse: migrating ==================
-- change_column(:hosts, :managed, :boolean, {})
   -> 0.0006s
== 20140318221513 ChangeHostManagedDefaultToFalse: migrated (0.0067s) =========

== 20140320000449 AddServerTypeToAuthSource: migrating ========================
-- add_column(:auth_sources, :server_type, :string, {:default=>"posix", :limit=>255})
   -> 0.0010s
== 20140320000449 AddServerTypeToAuthSource: migrated (0.0011s) ===============

== 20140320004050 AddGroupsBaseToAuthSource: migrating ========================
-- add_column(:auth_sources, :groups_base, :string, {:limit=>255})
   -> 0.0006s
== 20140320004050 AddGroupsBaseToAuthSource: migrated (0.0007s) ===============

== 20140325093623 AddLowerloginToUsers: migrating =============================
-- add_column(:users, :lower_login, :string, {:limit=>255})
   -> 0.0007s
-- add_index(:users, :lower_login, {:unique=>true})
   -> 0.0034s
== 20140325093623 AddLowerloginToUsers: migrated (0.0044s) ====================

== 20140409031625 CreateExternalUsergroups: migrating =========================
-- create_table(:external_usergroups, {:id=>:integer})
   -> 0.0044s
-- add_index(:external_usergroups, :usergroup_id)
   -> 0.0037s
-- add_foreign_key("external_usergroups", "usergroups", {:name=>"external_usergroups_usergroup_id_fk"})
   -> 0.0031s
-- add_foreign_key("external_usergroups", "auth_sources", {:name=>"external_usergroups_auth_source_id_fk"})
   -> 0.0027s
== 20140409031625 CreateExternalUsergroups: migrated (0.0144s) ================

== 20140410134234 RemoveSubscribeToAllHostgroupsFromUsers: migrating ==========
-- column_exists?(:users, :subscribe_to_all_hostgroups)
   -> 0.0055s
-- remove_column(:users, :subscribe_to_all_hostgroups)
   -> 0.0008s
== 20140410134234 RemoveSubscribeToAllHostgroupsFromUsers: migrated (0.0065s) =

== 20140415052549 CleanupUsersProperties: migrating ===========================
-- column_exists?(:users, :domains_andor)
   -> 0.0032s
-- remove_column(:users, :domains_andor)
   -> 0.0006s
-- column_exists?(:users, :hostgroups_andor)
   -> 0.0024s
-- remove_column(:users, :hostgroups_andor)
   -> 0.0006s
-- column_exists?(:users, :facts_andor)
   -> 0.0023s
-- remove_column(:users, :facts_andor)
   -> 0.0005s
-- column_exists?(:users, :compute_resources_andor)
   -> 0.0018s
-- remove_column(:users, :compute_resources_andor)
   -> 0.0005s
-- column_exists?(:users, :organizations_andor)
   -> 0.0024s
-- remove_column(:users, :organizations_andor)
   -> 0.0007s
-- column_exists?(:users, :locations_andor)
   -> 0.0019s
-- remove_column(:users, :locations_andor)
   -> 0.0006s
-- column_exists?(:users, :filter_on_owner)
   -> 0.0015s
-- remove_column(:users, :filter_on_owner)
   -> 0.0005s
== 20140415052549 CleanupUsersProperties: migrated (0.0204s) ==================

== 20140415053029 RemoveUserJoinTables: migrating =============================
-- table_exists?(:user_compute_resources)
   -> 0.0006s
-- remove_foreign_key("user_compute_resources", "users")
   -> 0.0026s
-- remove_foreign_key("user_compute_resources", "compute_resources")
   -> 0.0025s
-- drop_table(:user_compute_resources)
   -> 0.0003s
-- table_exists?(:user_notices)
   -> 0.0004s
-- remove_foreign_key("user_notices", "notices")
   -> 0.0025s
-- remove_foreign_key("user_notices", "users")
   -> 0.0025s
-- drop_table(:user_notices)
   -> 0.0003s
-- table_exists?(:user_facts)
   -> 0.0004s
-- remove_foreign_key("user_facts", "fact_names")
   -> 0.0025s
-- remove_foreign_key("user_facts", "users")
   -> 0.0024s
-- drop_table(:user_facts)
   -> 0.0005s
-- table_exists?(:user_hostgroups)
   -> 0.0004s
-- remove_foreign_key("user_hostgroups", "hostgroups")
   -> 0.0030s
-- remove_foreign_key("user_hostgroups", "users")
   -> 0.0035s
-- drop_table(:user_hostgroups)
   -> 0.0006s
-- table_exists?(:user_domains)
   -> 0.0004s
-- remove_foreign_key("user_domains", "domains")
   -> 0.0027s
-- remove_foreign_key("user_domains", "users")
   -> 0.0026s
-- drop_table(:user_domains)
   -> 0.0003s
-- table_exists?(:notices)
   -> 0.0004s
-- drop_table(:notices)
   -> 0.0006s
== 20140415053029 RemoveUserJoinTables: migrated (0.0327s) ====================

== 20140522122215 AddHiddenValueToParameter: migrating ========================
-- add_column(:parameters, :hidden_value, :boolean, {:default=>false})
   -> 0.0009s
== 20140522122215 AddHiddenValueToParameter: migrated (0.0009s) ===============

== 20140630114339 AddBootModeToSubnet: migrating ==============================
-- add_column(:subnets, :boot_mode, :string, {:default=>"Static", :null=>false, :limit=>255})
   -> 0.0014s
== 20140630114339 AddBootModeToSubnet: migrated (0.0160s) =====================

== 20140705173549 AddLockedAndDefaultAndVendorToConfigTemplate: migrating =====
-- add_column(:config_templates, :locked, :boolean, {:default=>false})
   -> 0.0027s
-- add_column(:config_templates, :default, :boolean, {:default=>false})
   -> 0.0019s
-- add_column(:config_templates, :vendor, :string, {:limit=>255})
   -> 0.0010s
== 20140705173549 AddLockedAndDefaultAndVendorToConfigTemplate: migrated (0.0061s) 

== 20140707113214 RemoveArchitectureDefault: migrating ========================
-- change_column(:architectures, :name, :string, {})
   -> 0.0075s
== 20140707113214 RemoveArchitectureDefault: migrated (0.0123s) ===============

== 20140710132249 ExtractNicAttributes: migrating =============================
-- add_column(:nics, :provider, :string, {:limit=>255})
   -> 0.0012s
-- add_column(:nics, :username, :string, {:limit=>255})
   -> 0.0006s
-- add_column(:nics, :password, :string, {:limit=>255})
   -> 0.0006s
== 20140710132249 ExtractNicAttributes: migrated (0.0028s) ====================

== 20140711142510 AddAttributesToNicBase: migrating ===========================
-- add_column(:nics, :virtual, :boolean, {:default=>false, :null=>false})
   -> 0.0015s
-- add_column(:nics, :link, :boolean, {:default=>true, :null=>false})
   -> 0.0010s
-- add_column(:nics, :identifier, :string, {:limit=>255})
   -> 0.0006s
-- add_column(:nics, :tag, :string, {:default=>"", :null=>false, :limit=>255})
   -> 0.0010s
-- add_column(:nics, :physical_device, :string, {:default=>"", :null=>false, :limit=>255})
   -> 0.0009s
== 20140711142510 AddAttributesToNicBase: migrated (0.0053s) ==================

== 20140716102950 AddManagedToNics: migrating =================================
-- add_column(:nics, :managed, :boolean, {:default=>true})
   -> 0.0011s
== 20140716102950 AddManagedToNics: migrated (0.0012s) ========================

== 20140716140436 ChangeAuditableNameColumnToText: migrating ==================
-- change_column(:audits, :auditable_name, :text, {})
   -> 0.0007s
== 20140716140436 ChangeAuditableNameColumnToText: migrated (0.0008s) =========

== 20140725101621 AddPrimaryInterfaceToHosts: migrating =======================
-- add_column(:hosts, :primary_interface, :string, {:limit=>255})
   -> 0.0009s
== 20140725101621 AddPrimaryInterfaceToHosts: migrated (0.0010s) ==============

== 20140728190218 AddIpSuggestionToSubnets: migrating =========================
-- add_column(:subnets, :ipam, :boolean, {:default=>true})
   -> 0.0013s
== 20140728190218 AddIpSuggestionToSubnets: migrated (0.0014s) ================

== 20140805114754 AddUniqueIndexToParameter: migrating ========================
-- add_index(:parameters, [:type, :reference_id, :name], {:unique=>true})
   -> 0.0040s
== 20140805114754 AddUniqueIndexToParameter: migrated (0.0041s) ===============

== 20140826104209 AddMergeOverridesAndAvoidDuplicatesToLookupKey: migrating ===
-- add_column(:lookup_keys, :merge_overrides, :boolean, {})
   -> 0.0007s
-- add_column(:lookup_keys, :avoid_duplicates, :boolean, {})
   -> 0.0003s
== 20140826104209 AddMergeOverridesAndAvoidDuplicatesToLookupKey: migrated (0.0011s) 

== 20140901115249 AddRequestUuidToAudits: migrating ===========================
-- column_exists?(:audits, :request_uuid)
   -> 0.0019s
-- index_exists?(:audits, :request_uuid, {:name=>"index_audits_on_request_uuid"})
   -> 0.0035s
-- add_index(:audits, :request_uuid)
   -> 0.0036s
== 20140901115249 AddRequestUuidToAudits: migrated (0.0092s) ==================

== 20140902102858 ConvertIpamToString: migrating ==============================
-- change_column(:subnets, :ipam, :string, {:limit=>255})
   -> 0.0104s
== 20140902102858 ConvertIpamToString: migrated (0.0250s) =====================

== 20140908192300 ChangeNilAdminUsersToFalse: migrating =======================
-- change_column(:users, :admin, :boolean, {})
   -> 0.0011s
== 20140908192300 ChangeNilAdminUsersToFalse: migrated (0.0088s) ==============

== 20140910111148 AddBondAttributesToNicBase: migrating =======================
-- add_column(:nics, :mode, :string, {:null=>false, :default=>"balance-rr", :limit=>255})
   -> 0.0012s
-- add_column(:nics, :attached_devices, :string, {:default=>"", :null=>false, :limit=>255})
   -> 0.0008s
-- add_column(:nics, :bond_options, :string, {:default=>"", :null=>false, :limit=>255})
   -> 0.0007s
-- rename_column(:nics, :physical_device, :attached_to)
   -> 0.0023s
== 20140910111148 AddBondAttributesToNicBase: migrated (0.0053s) ==============

== 20140910153654 MoveHostNicsToInterfaces: migrating =========================
-- add_column(:nics, :primary, :boolean, {:default=>false})
   -> 0.0027s
-- add_column(:nics, :provision, :boolean, {:default=>false})
   -> 0.0014s
-- remove_column(:hosts, :ip)
   -> 0.0009s
-- remove_column(:hosts, :mac)
   -> 0.0009s
-- remove_column(:hosts, :primary_interface)
   -> 0.0006s
-- remove_foreign_key("hosts", {:name=>"hosts_subnet_id_fk"})
   -> 0.0058s
-- remove_column(:hosts, :subnet_id)
   -> 0.0005s
-- remove_foreign_key("hosts", {:name=>"hosts_domain_id_fk"})
   -> 0.0048s
-- remove_column(:hosts, :domain_id)
   -> 0.0005s
== 20140910153654 MoveHostNicsToInterfaces: migrated (0.0190s) ================

== 20140912113254 AddPasswordHashToOperatingsystem: migrating =================
-- add_column(:operatingsystems, :password_hash, :string, {:default=>"MD5", :limit=>255})
   -> 0.0011s
== 20140912113254 AddPasswordHashToOperatingsystem: migrated (0.0012s) ========

== 20140912114124 AddGrubPasswordToHosts: migrating ===========================
-- add_column(:hosts, :grub_pass, :string, {:default=>"", :limit=>255})
   -> 0.0011s
== 20140912114124 AddGrubPasswordToHosts: migrated (0.0012s) ==================

== 20140912145052 AddGrubPasswordToHostgroup: migrating =======================
-- add_column(:hostgroups, :grub_pass, :string, {:default=>"", :limit=>255})
   -> 0.0010s
== 20140912145052 AddGrubPasswordToHostgroup: migrated (0.0011s) ==============

== 20140915141937 AddShouldUsePuppetDefaultToLookupValueAndKey: migrating =====
-- add_column(:lookup_values, :use_puppet_default, :boolean, {:default=>false})
   -> 0.0008s
-- add_column(:lookup_keys, :use_puppet_default, :boolean, {})
   -> 0.0003s
== 20140915141937 AddShouldUsePuppetDefaultToLookupValueAndKey: migrated (0.0012s) 

== 20140928131124 AddTitleToOs: migrating =====================================
-- add_column(:operatingsystems, :title, :string, {:limit=>255})
   -> 0.0005s
== 20140928131124 AddTitleToOs: migrated (0.0006s) ============================

== 20140928140206 CreateWidgets: migrating ====================================
-- create_table(:widgets, {:id=>:integer})
   -> 0.0122s
== 20140928140206 CreateWidgets: migrated (0.0122s) ===========================

== 20140929073150 CreateMailNotifications: migrating ==========================
-- create_table(:mail_notifications, {:id=>:integer})
   -> 0.0161s
== 20140929073150 CreateMailNotifications: migrated (0.0163s) =================

== 20140929073343 CreateUserMailNotifications: migrating ======================
-- create_table(:user_mail_notifications, {:id=>:integer})
   -> 0.0101s
-- add_foreign_key(:user_mail_notifications, :users, {:name=>"user_mail_notifications_user_id_fk"})
   -> 0.0034s
-- add_foreign_key(:user_mail_notifications, :mail_notifications, {:name=>"user_mail_notifications_mail_notification_id_fk"})
   -> 0.0033s
== 20140929073343 CreateUserMailNotifications: migrated (0.0175s) =============

== 20140930201523 AddMailEnabledToUser: migrating =============================
-- add_column(:users, :mail_enabled, :boolean, {:default=>true})
   -> 0.0034s
== 20140930201523 AddMailEnabledToUser: migrated (0.0036s) ====================

== 20141014131912 AddSubscriptionTypeToMailNotifications: migrating ===========
-- add_column(:mail_notifications, :subscription_type, :string, {:limit=>255})
   -> 0.0018s
== 20141014131912 AddSubscriptionTypeToMailNotifications: migrated (0.0020s) ==

== 20141023114229 AddTimezoneToUser: migrating ================================
-- add_column(:users, :timezone, :string, {:limit=>255})
   -> 0.0011s
== 20141023114229 AddTimezoneToUser: migrated (0.0012s) =======================

== 20141112165600 AddTypeToParameterIndex: migrating ==========================
-- index_exists?(:parameters, [:reference_id, :name], {:unique=>true, :name=>"index_parameters_on_reference_id_and_name"})
   -> 0.0034s
== 20141112165600 AddTypeToParameterIndex: migrated (0.0035s) =================

== 20141116131324 AddMailQueryToUserMailNotification: migrating ===============
-- add_column(:user_mail_notifications, :mail_query, :string, {:limit=>255})
   -> 0.0050s
== 20141116131324 AddMailQueryToUserMailNotification: migrated (0.0050s) ======

== 20141117093914 AddQueryableToMailNotification: migrating ===================
-- add_column(:mail_notifications, :queryable, :boolean, {:default=>false})
   -> 0.0016s
== 20141117093914 AddQueryableToMailNotification: migrated (0.0017s) ==========

== 20141120140051 RemoveAuditUserFk: migrating ================================
-- remove_foreign_key(:audits, :users)
   -> 0.0045s
== 20141120140051 RemoveAuditUserFk: migrated (0.0045s) =======================

== 20141124055509 RenameSmartProxyAuthRelatedSettings: migrating ==============
== 20141124055509 RenameSmartProxyAuthRelatedSettings: migrated (0.0000s) =====

== 20141217101211 AddComputeAttributesToNics: migrating =======================
-- add_column(:nics, :compute_attributes, :text, {})
   -> 0.0007s
== 20141217101211 AddComputeAttributesToNics: migrated (0.0007s) ==============

== 20141225073211 AddDescriptionToTaxonomies: migrating =======================
-- column_exists?(:taxonomies, :description)
   -> 0.0018s
-- add_column(:taxonomies, :description, :text, {})
   -> 0.0003s
== 20141225073211 AddDescriptionToTaxonomies: migrated (0.0023s) ==============

== 20150127085513 SetPtableLayoutToText: migrating ============================
-- change_column(:ptables, :layout, :text, {})
   -> 0.0005s
== 20150127085513 SetPtableLayoutToText: migrated (0.0007s) ===================

== 20150202094307 AddRangeToTrendCounters: migrating ==========================
-- add_column(:trend_counters, :interval_start, :datetime)
   -> 0.0005s
-- add_column(:trend_counters, :interval_end, :datetime)
   -> 0.0002s
== 20150202094307 AddRangeToTrendCounters: migrated (0.0008s) =================

== 20150212161904 MoveDescriptionFieldsToText: migrating ======================
-- change_column(:compute_resources, :description, :text, {})
   -> 0.0007s
-- change_column(:operatingsystems, :description, :text, {})
   -> 0.0003s
-- change_column(:lookup_keys, :description, :text, {})
   -> 0.0003s
-- change_column(:mail_notifications, :description, :text, {})
   -> 0.0004s
== 20150212161904 MoveDescriptionFieldsToText: migrated (0.0017s) =============

== 20150225131946 ChangeDefaultSubnetBootMode: migrating ======================
-- change_column(:subnets, :boot_mode, :string, {})
   -> 0.0009s
== 20150225131946 ChangeDefaultSubnetBootMode: migrated (0.0025s) =============

== 20150428070436 AddIndexToLogsSourceId: migrating ===========================
-- add_index(:logs, :source_id)
   -> 0.0037s
== 20150428070436 AddIndexToLogsSourceId: migrated (0.0038s) ==================

== 20150428110835 ChangeOsDefaultPasswordHash: migrating ======================
-- change_column_default(:operatingsystems, :password_hash, "SHA256")
   -> 0.0021s
== 20150428110835 ChangeOsDefaultPasswordHash: migrated (0.0021s) =============

== 20150514072626 AddTypeToConfigTemplate: migrating ==========================
-- add_column(:config_templates, :type, :string, {:default=>"ConfigTemplate", :limit=>255})
   -> 0.0011s
-- rename_table(:config_templates, :templates)
   -> 0.0025s
== 20150514072626 AddTypeToConfigTemplate: migrated (0.0037s) =================

== 20150514114044 MigratePtablesToTemplates: migrating ========================
-- foreign_key_exists?("operatingsystems_ptables", {:name=>"operatingsystems_ptables_ptable_id_fk"})
   -> 0.0021s
-- remove_foreign_key("operatingsystems_ptables", {:name=>"operatingsystems_ptables_ptable_id_fk"})
   -> 0.0035s
-- foreign_key_exists?("hostgroups", {:name=>"hostgroups_ptable_id_fk"})
   -> 0.0027s
-- remove_foreign_key("hostgroups", {:name=>"hostgroups_ptable_id_fk"})
   -> 0.0031s
-- foreign_key_exists?("hosts", {:name=>"hosts_ptable_id_fk"})
   -> 0.0021s
-- remove_foreign_key("hosts", {:name=>"hosts_ptable_id_fk"})
   -> 0.0028s
-- add_column(:templates, :os_family, :string, {:limit=>255})
   -> 0.0004s
-- add_foreign_key("operatingsystems_ptables", "templates", {:name=>"operatingsystems_ptables_ptable_id_fk", :column=>"ptable_id"})
   -> 0.0007s
-- add_foreign_key("hostgroups", "templates", {:name=>"hostgroups_ptable_id_fk", :column=>"ptable_id"})
   -> 0.0007s
-- add_foreign_key("hosts", "templates", {:name=>"hosts_ptable_id_fk", :column=>"ptable_id"})
   -> 0.0008s
== 20150514114044 MigratePtablesToTemplates: migrated (0.0196s) ===============

== 20150514121649 AddUsergroupSyncToAuthSources: migrating ====================
-- add_column(:auth_sources, :usergroup_sync, :boolean, {:null=>false, :default=>true})
   -> 0.0033s
== 20150514121649 AddUsergroupSyncToAuthSources: migrated (0.0035s) ===========

== 20150521121315 RenameConfigTemplateToProvisioningTemplate: migrating =======
-- foreign_key_exists?("os_default_templates", {:name=>"os_default_templates_config_template_id_fk"})
   -> 0.0146s
-- remove_foreign_key("os_default_templates", {:name=>"os_default_templates_config_template_id_fk"})
   -> 0.0107s
-- foreign_key_exists?("template_combinations", {:name=>"template_combinations_config_template_id_fk"})
   -> 0.0048s
-- remove_foreign_key("template_combinations", {:name=>"template_combinations_config_template_id_fk"})
   -> 0.0058s
-- foreign_key_exists?("config_templates_operatingsystems", {:name=>"config_templates_operatingsystems_config_template_id_fk"})
   -> 0.0040s
-- remove_foreign_key("config_templates_operatingsystems", {:name=>"config_templates_operatingsystems_config_template_id_fk"})
   -> 0.0038s
-- rename_column(:template_combinations, :config_template_id, :provisioning_template_id)
   -> 0.0011s
-- rename_column(:os_default_templates, :config_template_id, :provisioning_template_id)
   -> 0.0010s
-- rename_table(:config_templates_operatingsystems, :operatingsystems_provisioning_templates)
   -> 0.0030s
-- rename_column(:operatingsystems_provisioning_templates, :config_template_id, :provisioning_template_id)
   -> 0.0010s
-- add_foreign_key("os_default_templates", "templates", {:name=>"os_default_templates_provisioning_template_id_fk", :column=>"provisioning_template_id"})
   -> 0.0008s
-- add_foreign_key("template_combinations", "templates", {:name=>"template_combinations_provisioning_template_id_fk", :column=>"provisioning_template_id"})
   -> 0.0007s
-- add_foreign_key("operatingsystems_provisioning_templates", "templates", {:name=>"os_provisioning_template_id_fk", :column=>"provisioning_template_id"})
   -> 0.0006s
== 20150521121315 RenameConfigTemplateToProvisioningTemplate: migrated (0.0532s) 

== 20150525081931 RemoveDuplicateTokens: migrating ============================
-- foreign_key_exists?(:tokens, {:name=>"tokens_host_id_fk"})
   -> 0.0023s
-- remove_foreign_key(:tokens, {:column=>:host_id})
   -> 0.0026s
-- index_exists?(:tokens, :host_id, {:name=>"index_tokens_on_host_id"})
   -> 0.0015s
-- remove_index(:tokens, :host_id, {:name=>"index_tokens_on_host_id"})
   -> 0.0016s
-- add_index(:tokens, :host_id, {:unique=>true})
   -> 0.0079s
-- foreign_key_exists?(:tokens, {:name=>"tokens_host_id_fk"})
   -> 0.0019s
-- add_foreign_key(:tokens, :hosts, {:name=>"tokens_host_id_fk"})
   -> 0.0010s
== 20150525081931 RemoveDuplicateTokens: migrated (0.0198s) ===================

== 20150602153751 ChangeUsergroupNameToBeRequired: migrating ==================
-- change_column(:usergroups, :name, :string, {})
   -> 0.0040s
== 20150602153751 ChangeUsergroupNameToBeRequired: migrated (0.0043s) =========

== 20150605073820 FixTemplateSnippetFlag: migrating ===========================
-- change_column(:templates, :snippet, :boolean, {})
   -> 0.0004s
== 20150605073820 FixTemplateSnippetFlag: migrated (0.0034s) ==================

== 20150606065713 AddStiToLookupKeys: migrating ===============================
-- add_column(:lookup_keys, :type, :string, {:limit=>255})
   -> 0.0005s
-- add_index(:lookup_keys, :type)
   -> 0.0034s
== 20150606065713 AddStiToLookupKeys: migrated (0.0040s) ======================

== 20150612135546 CreateHostStatus: migrating =================================
-- create_table(:host_status, {:id=>:integer})
   -> 0.0045s
-- add_index(:host_status, :host_id)
   -> 0.0039s
-- add_foreign_key("host_status", "hosts", {:name=>"host_status_hosts_host_id_fk", :column=>"host_id"})
   -> 0.0035s
-- add_column(:hosts, :global_status, :integer, {:default=>0, :null=>false})
   -> 0.0023s
-- remove_column(:hosts, :puppet_status)
   -> 0.0015s
== 20150612135546 CreateHostStatus: migrated (0.0164s) ========================

== 20150616080015 CreateCoreTemplateInput: migrating ==========================
-- create_table(:template_inputs, {:id=>:integer})
   -> 0.0178s
-- add_foreign_key(:template_inputs, :templates, {:name=>"templates_template_id_fk", :column=>"template_id"})
   -> 0.0015s
== 20150616080015 CreateCoreTemplateInput: migrated (0.0196s) =================

== 20150618093433 RemoveUnusedFieldsFromHosts: migrating ======================
-- remove_index(:hosts, :source_file_id, {:name=>"index_hosts_on_source_file_id"})
   -> 0.0071s
-- remove_columns(:hosts, :last_freshcheck, :serial, :source_file_id)
   -> 0.0013s
== 20150618093433 RemoveUnusedFieldsFromHosts: migrated (0.0103s) =============

== 20150622090115 ChangeReportedAt: migrating =================================
-- change_column(:reports, :reported_at, :datetime, {})
   -> 0.0014s
== 20150622090115 ChangeReportedAt: migrated (0.0018s) ========================

== 20150705131449 AddTypeToReports: migrating =================================
-- add_column(:reports, :type, :string, {:null=>false, :default=>"ConfigReport", :limit=>255})
   -> 0.0012s
== 20150705131449 AddTypeToReports: migrated (0.0013s) ========================

== 20150708070742 AddFullNameToSetting: migrating =============================
-- add_column(:settings, :full_name, :string, {:limit=>255})
   -> 0.0019s
== 20150708070742 AddFullNameToSetting: migrated (0.0022s) ====================

== 20150713143226 AddUniqueToOperatingsystemsTitle: migrating =================
-- add_index(:operatingsystems, :title, {:unique=>true})
   -> 0.0049s
-- change_column_null(:operatingsystems, :name, false)
   -> 0.0006s
-- add_index(:operatingsystems, [:name, :major, :minor], {:unique=>true})
   -> 0.0040s
== 20150713143226 AddUniqueToOperatingsystemsTitle: migrated (0.0098s) ========

== 20150714132601 RemoveIsParam: migrating ====================================
-- remove_column(:lookup_keys, :is_param)
   -> 0.0011s
== 20150714132601 RemoveIsParam: migrated (0.0012s) ===========================

== 20150811170401 AddMergeDefaultToLookupKey: migrating =======================
-- add_column(:lookup_keys, :merge_default, :boolean, {:null=>false, :default=>false})
   -> 0.0019s
== 20150811170401 AddMergeDefaultToLookupKey: migrated (0.0021s) ==============

== 20150819105725 AddLookupValueMatchToHostAndHostgroup: migrating ============
-- add_column(:hosts, :lookup_value_matcher, :string, {:limit=>255})
   -> 0.0009s
-- add_column(:hostgroups, :lookup_value_matcher, :string, {:limit=>255})
   -> 0.0005s
== 20150819105725 AddLookupValueMatchToHostAndHostgroup: migrated (0.0016s) ===

== 20150827152730 AddOptionsToCoreTemplateInput: migrating ====================
-- add_column(:template_inputs, :options, :text, {})
   -> 0.0007s
== 20150827152730 AddOptionsToCoreTemplateInput: migrated (0.0008s) ===========

== 20150917155300 UpdateHostStatusStatusFieldInt: migrating ===================
-- change_column(:host_status, :status, :integer, {:limit=>5})
   -> 0.0024s
== 20150917155300 UpdateHostStatusStatusFieldInt: migrated (0.0026s) ==========

== 20151009084350 DropPtables: migrating ======================================
-- drop_table(:ptables)
   -> 0.0035s
== 20151009084350 DropPtables: migrated (0.0037s) =============================

== 20151019174035 RenameDomainHostCount: migrating ============================
-- rename_column(:domains, :hosts_count, :total_hosts)
   -> 0.0024s
== 20151019174035 RenameDomainHostCount: migrated (0.0025s) ===================

== 20151025120534 AddHiddenValueToLookupKey: migrating ========================
-- add_column(:lookup_keys, :hidden_value, :boolean, {:default=>false})
   -> 0.0015s
== 20151025120534 AddHiddenValueToLookupKey: migrated (0.0015s) ===============

== 20151104100257 AddHostsCountToHostgroup: migrating =========================
-- add_column(:hostgroups, :hosts_count, :integer, {:default=>0})
   -> 0.0032s
== 20151104100257 AddHostsCountToHostgroup: migrated (0.0035s) ================

== 20151109152507 AddHostStatusHostIdIndex: migrating =========================
-- add_index(:host_status, [:type, :host_id], {:unique=>true})
   -> 0.0073s
== 20151109152507 AddHostStatusHostIdIndex: migrated (0.0077s) ================

== 20151210143537 AddTypeToMailNotification: migrating ========================
-- add_column(:mail_notifications, :type, :string, {:limit=>255})
   -> 0.0011s
== 20151210143537 AddTypeToMailNotification: migrated (0.0012s) ===============

== 20160127134031 AddAdvancedToCoreTemplateInput: migrating ===================
-- add_column(:template_inputs, :advanced, :boolean, {:default=>false, :null=>false})
   -> 0.0014s
== 20160127134031 AddAdvancedToCoreTemplateInput: migrated (0.0015s) ==========

== 20160201131211 AddExpiredLogsToSmartProxy: migrating =======================
-- add_column(:smart_proxies, :expired_logs, :string, {:default=>"0", :limit=>255})
   -> 0.0012s
== 20160201131211 AddExpiredLogsToSmartProxy: migrated (0.0013s) ==============

== 20160203110216 AddDefaultValueForBookmarkPublicField: migrating ============
-- change_column(:bookmarks, :public, :boolean, {})
   -> 0.0006s
== 20160203110216 AddDefaultValueForBookmarkPublicField: migrated (0.0043s) ===

== 20160215143900 AddSubnetDomainRelationConstraints: migrating ===============
-- change_column(:subnet_domains, :subnet_id, :integer, {})
   -> 0.0018s
-- change_column(:subnet_domains, :domain_id, :integer, {})
   -> 0.0009s
-- add_index(:subnet_domains, [:subnet_id, :domain_id], {:unique=>true})
   -> 0.0044s
== 20160215143900 AddSubnetDomainRelationConstraints: migrated (0.0080s) ======

== 20160308102459 RemovePermissionsFromRoles: migrating =======================
-- remove_column(:roles, :permissions)
   -> 0.0013s
== 20160308102459 RemovePermissionsFromRoles: migrated (0.0014s) ==============

== 20160315161936 AddEncryptedToSettings: migrating ===========================
-- add_column(:settings, :encrypted, :boolean, {:null=>false, :default=>false})
   -> 0.0016s
== 20160315161936 AddEncryptedToSettings: migrated (0.0017s) ==================

== 20160414063050 AddStiToSubnets: migrating ==================================
-- add_column(:subnets, :type, :string, {:default=>"Subnet::Ipv4", :null=>false})
   -> 0.0013s
-- add_index(:subnets, :type)
   -> 0.0040s
== 20160414063050 AddStiToSubnets: migrated (0.0054s) =========================

== 20160415134454 AddIpv6ToHosts: migrating ===================================
-- change_column(:nics, :ip, :string, {:limit=>15})
   -> 0.0242s
-- add_index(:nics, :ip)
   -> 0.0056s
-- add_column(:nics, :ip6, :string, {:limit=>45})
   -> 0.0014s
-- add_index(:nics, :ip6)
   -> 0.0064s
-- add_column(:hostgroups, :subnet6_id, :integer, {})
   -> 0.0024s
-- add_column(:nics, :subnet6_id, :integer, {})
   -> 0.0016s
== 20160415134454 AddIpv6ToHosts: migrated (0.0428s) ==========================

== 20160415135858 AddIpv6Subnet: migrating ====================================
-- change_column(:subnets, :network, :string, {:limit=>45})
   -> 0.0021s
-- change_column(:subnets, :mask, :string, {:limit=>45})
   -> 0.0011s
-- change_column(:subnets, :gateway, :string, {:limit=>45})
   -> 0.0201s
-- change_column(:subnets, :dns_primary, :string, {:limit=>45})
   -> 0.0232s
-- change_column(:subnets, :dns_secondary, :string, {:limit=>45})
   -> 0.0310s
-- change_column(:subnets, :from, :string, {:limit=>45})
   -> 0.0275s
-- change_column(:subnets, :to, :string, {:limit=>45})
   -> 0.0198s
-- change_column_default(:subnets, :ipam, "None")
   -> 0.0074s
== 20160415135858 AddIpv6Subnet: migrated (0.1338s) ===========================

== 20160527093031 LimitOsDescription: migrating ===============================
-- change_column(:operatingsystems, :description, :string, {:limit=>255})
   -> 0.0420s
== 20160527093031 LimitOsDescription: migrated (0.0424s) ======================

== 20160609092110 RemoveNilFromMergeOverride: migrating =======================
-- change_column_null(:lookup_keys, :merge_overrides, false, false)
   -> 0.0109s
-- change_column_default(:lookup_keys, :merge_overrides, false)
   -> 0.0077s
-- change_column_null(:lookup_keys, :avoid_duplicates, false, false)
   -> 0.0074s
-- change_column_default(:lookup_keys, :avoid_duplicates, false)
   -> 0.0065s
-- change_column_null(:lookup_keys, :merge_default, false, false)
   -> 0.0084s
-- change_column_default(:lookup_keys, :merge_default, false)
   -> 0.0050s
== 20160609092110 RemoveNilFromMergeOverride: migrated (0.0470s) ==============

== 20160616074718 RemoveHostCounterCache: migrating ===========================
-- remove_column(:domains, :total_hosts, :integer, {:default=>0})
   -> 0.0011s
-- remove_column(:domains, :hostgroups_count, :integer, {:default=>0})
   -> 0.0006s
-- remove_column(:architectures, :hosts_count, :integer, {:default=>0})
   -> 0.0006s
-- remove_column(:architectures, :hostgroups_count, :integer, {:default=>0})
   -> 0.0006s
-- remove_column(:operatingsystems, :hosts_count, :integer, {:default=>0})
   -> 0.0008s
-- remove_column(:operatingsystems, :hostgroups_count, :integer, {:default=>0})
   -> 0.0006s
-- remove_column(:realms, :hosts_count, :integer, {:default=>0})
   -> 0.0006s
-- remove_column(:realms, :hostgroups_count, :integer, {:default=>0})
   -> 0.0005s
-- remove_column(:hostgroups, :hosts_count, :integer, {:default=>0})
   -> 0.0008s
-- remove_column(:models, :hosts_count, :integer, {:default=>0})
   -> 0.0007s
== 20160616074718 RemoveHostCounterCache: migrated (0.0075s) ==================

== 20160715131352 SetRoleBuiltinDefault: migrating ============================
-- change_column_default(:roles, :builtin, 0)
   -> 0.0028s
== 20160715131352 SetRoleBuiltinDefault: migrated (0.0029s) ===================

== 20160717125402 UnifyPermissions: migrating =================================
-- add_index(:permissions, :name, {:unique=>true})
   -> 0.0057s
== 20160717125402 UnifyPermissions: migrated (0.0058s) ========================

== 20160719081324 ChangeTemplatesTypeDefault: migrating =======================
-- change_column_default(:templates, :type, "Template")
   -> 0.0067s
== 20160719081324 ChangeTemplatesTypeDefault: migrated (0.0069s) ==============

== 20160725142557 AddPxeLoaderToHost: migrating ===============================
-- add_column(:hosts, :pxe_loader, :string, {:limit=>255})
   -> 0.0027s
== 20160725142557 AddPxeLoaderToHost: migrated (0.0029s) ======================

== 20160726085358 RenameLookupValueUsePuppetDefault: migrating ================
-- rename_column(:lookup_values, :use_puppet_default, :omit)
   -> 0.0065s
== 20160726085358 RenameLookupValueUsePuppetDefault: migrated (0.0067s) =======

== 20160727084256 AddDescriptionToUser: migrating =============================
-- add_column(:users, :description, :text, {})
   -> 0.0020s
== 20160727084256 AddDescriptionToUser: migrated (0.0022s) ====================

== 20160727142242 AddPxeLoaderToHostgroup: migrating ==========================
-- add_column(:hostgroups, :pxe_loader, :string, {:limit=>255})
   -> 0.0026s
== 20160727142242 AddPxeLoaderToHostgroup: migrated (0.0027s) =================

== 20160728095626 AddDescriptionToRole: migrating =============================
-- add_column(:roles, :description, :text, {})
   -> 0.0016s
== 20160728095626 AddDescriptionToRole: migrated (0.0017s) ====================

== 20160818091420 AddOverrideFlagToFilter: migrating ==========================
-- add_column(:filters, :override, :boolean, {:default=>false, :null=>false})
   -> 0.0033s
== 20160818091420 AddOverrideFlagToFilter: migrated (0.0035s) =================

== 20160831121418 RenameLookupKeyUsePuppetDefault: migrating ==================
-- rename_column(:lookup_keys, :use_puppet_default, :omit)
   -> 0.0109s
== 20160831121418 RenameLookupKeyUsePuppetDefault: migrated (0.0112s) =========

== 20160927071039 CreateNotificationBlueprints: migrating =====================
-- create_table(:notification_blueprints, {:id=>:integer})
   -> 0.0330s
== 20160927071039 CreateNotificationBlueprints: migrated (0.0332s) ============

== 20160927071147 CreateNotifications: migrating ==============================
-- create_table(:notifications, {:id=>:integer})
   -> 0.0259s
== 20160927071147 CreateNotifications: migrated (0.0262s) =====================

== 20160927073233 CreateNotificationRecipients: migrating =====================
-- create_table(:notification_recipients, {:id=>:integer})
   -> 0.0295s
== 20160927073233 CreateNotificationRecipients: migrated (0.0298s) ============

== 20161227082709 ChangeArchitectureNameLimit: migrating ======================
-- change_column(:architectures, :name, :string, {:limit=>255})
   -> 0.0109s
== 20161227082709 ChangeArchitectureNameLimit: migrated (0.0162s) =============

== 20161227082721 ChangeUsergroupNameLimit: migrating =========================
-- change_column(:usergroups, :name, :string, {:limit=>255})
   -> 0.0089s
== 20161227082721 ChangeUsergroupNameLimit: migrated (0.0098s) ================

== 20170110113824 ChangeIdValueRange: migrating ===============================
-- change_column(:logs, :id, :bigint, {})
   -> 0.0215s
-- change_column(:reports, :id, :bigint, {})
   -> 0.0318s
-- change_column(:fact_values, :id, :bigint, {})
   -> 0.0272s
== 20170110113824 ChangeIdValueRange: migrated (0.0811s) ======================

== 20170118142654 AddAutoIncrementToBigintIds: migrating ======================
== 20170118142654 AddAutoIncrementToBigintIds: migrated (0.0000s) =============

== 20170118154134 AddTypeIndexToReports: migrating ============================
-- add_index(:reports, :type)
   -> 0.0111s
-- add_index(:reports, [:type, :host_id])
   -> 0.0057s
== 20170118154134 AddTypeIndexToReports: migrated (0.0171s) ===================

== 20170127094357 AddCachingEnabledToComputeResource: migrating ===============
-- add_column(:compute_resources, :caching_enabled, :boolean, {:default=>true})
   -> 0.0034s
== 20170127094357 AddCachingEnabledToComputeResource: migrated (0.0036s) ======

== 20170201135815 AddDomainToComputeResources: migrating ======================
-- add_column(:compute_resources, :domain, :string, {})
   -> 0.0020s
== 20170201135815 AddDomainToComputeResources: migrated (0.0022s) =============

== 20170209084517 AddActionsToNotificationBlueprint: migrating ================
-- add_column(:notification_blueprints, :actions, :text, {})
   -> 0.0014s
== 20170209084517 AddActionsToNotificationBlueprint: migrated (0.0016s) =======

== 20170213154641 AddIndexReportsOnHostIdTypeId: migrating ====================
-- add_index(:reports, [:host_id, :type, :id])
   -> 0.0049s
== 20170213154641 AddIndexReportsOnHostIdTypeId: migrated (0.0051s) ===========

== 20170214132230 CreateSshKeys: migrating ====================================
-- create_table(:ssh_keys, {:id=>:integer})
   -> 0.0089s
== 20170214132230 CreateSshKeys: migrated (0.0091s) ===========================

== 20170221100747 AddOriginToRoles: migrating =================================
-- add_column(:roles, :origin, :string, {})
   -> 0.0009s
== 20170221100747 AddOriginToRoles: migrated (0.0010s) ========================

== 20170226193446 MoveSubjectToNotifications: migrating =======================
-- add_reference(:notifications, :subject, {:type=>:integer, :polymorphic=>true, :index=>true, :_uses_legacy_reference_index_name=>true})
   -> 0.0055s
-- remove_reference(:notification_blueprints, :subject, {:polymorphic=>true, :index=>true})
   -> 0.0020s
== 20170226193446 MoveSubjectToNotifications: migrated (0.0079s) ==============

== 20170228134258 AddCloneInfoToRole: migrating ===============================
-- add_column(:roles, :cloned_from_id, :integer, {})
   -> 0.0019s
== 20170228134258 AddCloneInfoToRole: migrated (0.0021s) ======================

== 20170301155205 RemoveWidgetHide: migrating =================================
-- remove_column(:widgets, :hide, :boolean, {:default=>false})
   -> 0.0016s
== 20170301155205 RemoveWidgetHide: migrated (0.0018s) ========================

== 20170306100129 AddMessageToNotification: migrating =========================
-- add_column(:notifications, :message, :string, {})
   -> 0.0011s
-- add_column(:notifications, :actions, :text, {})
   -> 0.0006s
== 20170306100129 AddMessageToNotification: migrated (0.0019s) ================

== 20170315154334 AddReportTimeTypeHostIndex: migrating =======================
-- add_index(:reports, [:reported_at, :host_id, :type])
   -> 0.0043s
== 20170315154334 AddReportTimeTypeHostIndex: migrated (0.0043s) ==============

== 20170316142703 AddMissingIndexesToNotification: migrating ==================
-- add_index(:notifications, :expired_at)
   -> 0.0041s
-- add_index(:notification_recipients, [:user_id, :notification_id])
   -> 0.0043s
== 20170316142703 AddMissingIndexesToNotification: migrated (0.0087s) =========

== 20170319131341 AddAncestryNameIndexOnFactName: migrating ===================
-- add_index(:fact_names, [:ancestry, :name])
   -> 0.0066s
== 20170319131341 AddAncestryNameIndexOnFactName: migrated (0.0068s) ==========

== 20170404134531 AddDescriptionToSubnets: migrating ==========================
-- add_column(:subnets, :description, :text, {})
   -> 0.0023s
== 20170404134531 AddDescriptionToSubnets: migrated (0.0025s) =================

== 20170424131346 AddDescriptionToHostgroup: migrating ========================
-- add_column(:hostgroups, :description, :text, {})
   -> 0.0017s
== 20170424131346 AddDescriptionToHostgroup: migrated (0.0019s) ===============

== 20170604082313 AddComputeResourceToHostgroup: migrating ====================
-- add_column(:hostgroups, :compute_resource_id, :integer, {})
   -> 0.0013s
-- add_foreign_key(:hostgroups, :compute_resources)
   -> 0.0018s
== 20170604082313 AddComputeResourceToHostgroup: migrated (0.0033s) ===========

== 20170606115344 ChangeLookupKeyPathToText: migrating ========================
-- remove_index(:lookup_keys, :path, {:name=>"index_lookup_keys_on_path"})
   -> 0.0030s
-- change_column(:lookup_keys, :path, :text, {})
   -> 0.0007s
== 20170606115344 ChangeLookupKeyPathToText: migrated (0.0050s) ===============

== 20170608130132 AddUseNetgroupsToLdapAuthSource: migrating ==================
-- add_column(:auth_sources, :use_netgroups, :boolean, {:default=>false})
   -> 0.0012s
== 20170608130132 AddUseNetgroupsToLdapAuthSource: migrated (0.0013s) =========

== 20170610132326 CreatePersonalAccessTokens: migrating =======================
-- create_table(:personal_access_tokens, {:id=>:integer})
   -> 0.0196s
== 20170610132326 CreatePersonalAccessTokens: migrated (0.0198s) ==============

== 20170622011347 AddHttpProxies: migrating ===================================
-- create_table(:http_proxies, {:id=>:integer})
   -> 0.0141s
-- add_reference(:compute_resources, :http_proxy, {:type=>:integer, :index=>false, :_uses_legacy_reference_index_name=>true})
   -> 0.0016s
== 20170622011347 AddHttpProxies: migrated (0.0162s) ==========================

== 20170815130257 AddIndexToSshKeys: migrating ================================
-- add_index(:ssh_keys, :user_id)
   -> 0.0066s
== 20170815130257 AddIndexToSshKeys: migrated (0.0068s) =======================

== 20170911133318 DropDefaultTypeInTemplates: migrating =======================
-- change_column(:templates, :type, :string, {})
   -> 0.0026s
== 20170911133318 DropDefaultTypeInTemplates: migrated (0.0096s) ==============

== 20171016202300 IncreaseFactValueSize: migrating ============================
-- change_column(:fact_values, :value, :text, {:limit=>16777215})
   -> 0.0014s
== 20171016202300 IncreaseFactValueSize: migrated (0.0016s) ===================

== 20171109095957 AddKeyTypeToParameters: migrating ===========================
-- add_column(:parameters, :key_type, :string, {:limit=>255})
   -> 0.0010s
== 20171109095957 AddKeyTypeToParameters: migrated (0.0012s) ==================

== 20171119094913 AddMtuToSubnet: migrating ===================================
-- add_column(:subnets, :mtu, :integer, {:default=>1500, :null=>false, :limit=>8})
   -> 0.0013s
== 20171119094913 AddMtuToSubnet: migrated (0.0014s) ==========================

== 20171126131104 RemoveDuplicateTaxableTaxonomies: migrating =================
-- remove_index(:taxable_taxonomies, nil, {:name=>"taxable_index"})
   -> 0.0004s
-- add_index(:taxable_taxonomies, [:taxable_id, :taxable_type, :taxonomy_id], {:name=>"taxable_index", :unique=>true})
   -> 0.0043s
== 20171126131104 RemoveDuplicateTaxableTaxonomies: migrated (0.0061s) ========

== 20171213161035 AddIndexesOnImages: migrating ===============================
-- add_index(:images, [:name, :compute_resource_id, :operatingsystem_id], {:name=>"image_name_index", :unique=>true})
   -> 0.0050s
-- add_index(:images, [:uuid, :compute_resource_id], {:name=>"image_uuid_index", :unique=>true})
   -> 0.0039s
== 20171213161035 AddIndexesOnImages: migrated (0.0092s) ======================

== 20171225122601 AddVersionToAuditableIndex: migrating =======================
-- remove_index(:audits, nil, {:name=>"auditable_index"})
   -> 0.0004s
-- add_index(:audits, [:auditable_id, :auditable_type, :version], {:name=>"auditable_index"})
   -> 0.0042s
== 20171225122601 AddVersionToAuditableIndex: migrated (0.0059s) ==============

== 20171231134017 ChangeVlanToInt: migrating ==================================
-- change_column(:subnets, :vlanid, :integer, {:using=>"vlanid::integer"})
   -> 0.0170s
== 20171231134017 ChangeVlanToInt: migrated (0.0172s) =========================

== 20180102082705 AddTaxonomyIndexToHosts: migrating ==========================
-- add_index(:hosts, [:type, :organization_id, :location_id])
   -> 0.0058s
-- add_index(:hosts, [:type, :location_id])
   -> 0.0048s
== 20180102082705 AddTaxonomyIndexToHosts: migrated (0.0108s) =================

== 20180111130853 AddConfigReportsOrigin: migrating ===========================
-- add_column(:reports, :origin, :string)
   -> 0.0015s
== 20180111130853 AddConfigReportsOrigin: migrated (0.0016s) ==================

== 20180123140634 RemoveLimitLdapFilter: migrating ============================
-- change_column("auth_sources", :ldap_filter, :text, {:limit=>nil})
   -> 0.0014s
== 20180123140634 RemoveLimitLdapFilter: migrated (0.0015s) ===================

== 20180129143410 CreateJwtSecrets: migrating =================================
-- create_table(:jwt_secrets, {})
   -> 0.0221s
== 20180129143410 CreateJwtSecrets: migrated (0.0222s) ========================

== 20180208053256 CreateTablePreferences: migrating ===========================
-- create_table(:table_preferences, {})
   -> 0.0118s
-- add_foreign_key(:table_preferences, :users, {:name=>"table_preferences_user_id_fk"})
   -> 0.0023s
-- add_index(:table_preferences, [:user_id, :name], {:unique=>true})
   -> 0.0049s
== 20180208053256 CreateTablePreferences: migrated (0.0193s) ==================

== 20180216094550 AddTemplateToSubnets: migrating =============================
-- add_column(:subnets, :template_id, :integer)
   -> 0.0018s
== 20180216094550 AddTemplateToSubnets: migrated (0.0020s) ====================

== 20180305111232 AddBuildErrorsToHosts: migrating ============================
-- add_column(:hosts, :initiated_at, :datetime)
   -> 0.0022s
-- add_column(:hosts, :build_errors, :text)
   -> 0.0013s
== 20180305111232 AddBuildErrorsToHosts: migrated (0.0039s) ===================

== 20180312080251 ChangeDigestsLimit: migrating ===============================
-- change_column(:messages, :digest, :string, {:limit=>40})
   -> 0.0029s
-- change_column(:sources, :digest, :string, {:limit=>40})
   -> 0.0021s
== 20180312080251 ChangeDigestsLimit: migrated (0.0055s) ======================

== 20180424080702 ChangeSubnetVlanidSize: migrating ===========================
-- change_column(:subnets, :vlanid, :integer, {:limit=>4})
   -> 0.0025s
== 20180424080702 ChangeSubnetVlanidSize: migrated (0.0028s) ==================

== 20180613100703 AddTypeToToken: migrating ===================================
-- foreign_key_exists?(:tokens, {:name=>"tokens_host_id_fk"})
   -> 0.0063s
-- remove_foreign_key(:tokens, {:column=>:host_id})
   -> 0.0054s
-- index_exists?(:tokens, :host_id)
   -> 0.0022s
-- remove_index(:tokens, :host_id)
   -> 0.0023s
-- add_index(:tokens, :host_id)
   -> 0.0035s
-- foreign_key_exists?(:tokens, {:name=>"tokens_host_id_fk"})
   -> 0.0029s
-- add_foreign_key(:tokens, :hosts, {:name=>"tokens_host_id_fk"})
   -> 0.0018s
-- add_column(:tokens, :type, :string, {:default=>"Token::Build", :null=>false, :index=>true})
   -> 0.0042s
-- change_column(:tokens, :value, :text, {})
   -> 0.0007s
== 20180613100703 AddTypeToToken: migrated (0.0301s) ==========================

== 20180702102759 RemoveParamsValueLimit: migrating ===========================
-- change_column(:parameters, :value, :text, {:limit=>nil})
   -> 0.0005s
-- change_column(:lookup_values, :value, :text, {:limit=>nil})
   -> 0.0003s
-- change_column(:lookup_keys, :default_value, :text, {:limit=>nil})
   -> 0.0003s
== 20180702102759 RemoveParamsValueLimit: migrated (0.0012s) ==================

== 20180705191153 AddUpgradeTask: migrating ===================================
-- create_table(:upgrade_tasks, {})
   -> 0.0109s
-- add_index(:upgrade_tasks, :name, {:unique=>true})
   -> 0.0058s
== 20180705191153 AddUpgradeTask: migrated (0.0170s) ==========================

== 20180705230311 SmartProxyCapabilities: migrating ===========================
-- rename_table(:features_smart_proxies, :smart_proxy_features)
   -> 0.0099s
-- change_table(:smart_proxy_features, {:bulk=>true})
   -> 0.0175s
== 20180705230311 SmartProxyCapabilities: migrated (0.0277s) ==================

== 20180713154128 AddIndexOnRoleNames: migrating ==============================
-- add_index(:roles, :name, {:unique=>true})
   -> 0.0076s
== 20180713154128 AddIndexOnRoleNames: migrated (0.0077s) =====================

== 20180715202514 OptimizeIndices: migrating ==================================
-- remove_index(:audits, :id)
   -> 0.0037s
-- remove_index(:audits, {:name=>"auditable_parent_index"})
   -> 0.0002s
-- remove_index(:audits, {:name=>"associated_index"})
   -> 0.0002s
-- add_index(:audits, [:associated_type, :associated_id])
   -> 0.0035s
-- remove_index(:audits, {:name=>"auditable_index"})
   -> 0.0003s
-- add_index(:audits, [:auditable_type, :auditable_id, :version])
   -> 0.0034s
-- remove_index(:audits, [:user_id, :user_type])
   -> 0.0031s
-- add_index(:audits, [:user_type, :user_id])
   -> 0.0036s
-- remove_index(:bookmarks, [:owner_id, :owner_type])
   -> 0.0022s
-- add_index(:bookmarks, [:owner_type, :owner_id])
   -> 0.0036s
-- remove_index(:fact_names, :ancestry)
   -> 0.0023s
-- remove_index(:fact_values, :fact_name_id)
   -> 0.0019s
-- remove_index(:hosts, :type)
   -> 0.0036s
-- index_name_exists?(:lookup_values, "index_lookup_values_on_priority")
   -> 0.0007s
-- remove_index(:nics, {:name=>"index_by_type"})
   -> 0.0003s
-- remove_index(:notification_recipients, :user_id)
   -> 0.0023s
-- index_name_exists?(:parameters, "index_parameters_on_domain_id_and_type")
   -> 0.0006s
-- index_name_exists?(:parameters, "index_parameters_on_hostgroup_id_and_type")
   -> 0.0006s
-- index_name_exists?(:parameters, "index_parameters_on_host_id_and_type")
   -> 0.0006s
-- index_exists?(:parameters, [:reference_id, :type])
   -> 0.0018s
-- remove_index(:parameters, [:reference_id, :type])
   -> 0.0020s
-- remove_index(:parameters, :type)
   -> 0.0018s
-- remove_index(:permissions, :name)
   -> 0.0021s
-- remove_index(:reports, :host_id)
   -> 0.0043s
-- remove_index(:reports, :type)
   -> 0.0034s
-- remove_index(:reports, :reported_at)
   -> 0.0026s
-- remove_index(:reports, [:reported_at, :host_id])
   -> 0.0028s
-- remove_index(:taxable_taxonomies, [:taxable_id, :taxable_type])
   -> 0.0023s
-- remove_index(:taxable_taxonomies, {:name=>"taxable_index"})
   -> 0.0002s
-- add_index(:taxable_taxonomies, [:taxable_type, :taxable_id, :taxonomy_id], {:name=>"taxable_index", :unique=>true})
   -> 0.0034s
-- remove_index(:user_roles, :owner_type)
   -> 0.0019s
-- remove_index(:user_roles, [:owner_id, :owner_type])
   -> 0.0018s
-- add_index(:user_roles, [:owner_type, :owner_id])
   -> 0.0035s
== 20180715202514 OptimizeIndices: migrated (0.0721s) =========================

== 20180806151925 AddSubnetNameUniqueConstraint: migrating ====================
-- add_index(:subnets, :name, {:unique=>true})
   -> 0.0038s
== 20180806151925 AddSubnetNameUniqueConstraint: migrated (0.0039s) ===========

== 20180816110716 AddHttpbootDoSubnet: migrating ==============================
-- add_column(:subnets, :httpboot_id, :integer)
   -> 0.0005s
-- add_index(:subnets, :httpboot_id)
   -> 0.0039s
== 20180816110716 AddHttpbootDoSubnet: migrated (0.0045s) =====================

== 20180820072858 AddHelpTextToTemplateKinds: migrating =======================
-- add_column(:template_kinds, :description, :text)
   -> 0.0080s
== 20180820072858 AddHelpTextToTemplateKinds: migrated (0.0082s) ==============

== 20180904142922 AddNicDelayToSubnet: migrating ==============================
-- add_column(:subnets, :nic_delay, :integer, {:limit=>4})
   -> 0.0021s
== 20180904142922 AddNicDelayToSubnet: migrated (0.0024s) =====================

== 20181031155025 AddTrendCounterCreatedAtUniqueConstraint: migrating =========
-- add_index(:trend_counters, [:trend_id, :created_at], {:unique=>true})
   -> 0.0056s
== 20181031155025 AddTrendCounterCreatedAtUniqueConstraint: migrated (0.0059s) 

== 20181101101145 AddIndexToLookupValues: migrating ===========================
-- add_index(:lookup_values, :lookup_key_id)
   -> 0.0043s
== 20181101101145 AddIndexToLookupValues: migrated (0.0045s) ==================

== 20190116120705 RemoveTimestampsFromLogs: migrating =========================
-- remove_column(:logs, :created_at, :datetime)
   -> 0.0007s
-- remove_column(:logs, :updated_at, :datetime)
   -> 0.0004s
== 20190116120705 RemoveTimestampsFromLogs: migrated (0.0012s) ================

== 20190121084601 ChangeComputeResourcePasswordLength: migrating ==============
-- change_column(:compute_resources, :password, :text, {:limit=>nil})
   -> 0.0022s
== 20190121084601 ChangeComputeResourcePasswordLength: migrated (0.0025s) =====

== 20190225115728 CreateStoredValues: migrating ===============================
-- create_table(:stored_values, {})
   -> 0.0136s
== 20190225115728 CreateStoredValues: migrated (0.0137s) ======================

== 20190226182746 CreateRegistrationFacets: migrating =========================
-- create_table(:registration_facets, {})
   -> 0.0253s
== 20190226182746 CreateRegistrationFacets: migrated (0.0255s) ================

== 20190228160047 AddValueTypeAndResourceTypeToTemplateInput: migrating =======
-- add_column(:template_inputs, :value_type, :string, {:default=>"plain", :null=>false})
   -> 0.0035s
-- add_column(:template_inputs, :resource_type, :string)
   -> 0.0012s
== 20190228160047 AddValueTypeAndResourceTypeToTemplateInput: migrated (0.0052s) 

== 20190510082811 AddTaxonomyIdTaxableTypeIndicesToTaxableTaxonomies: migrating 
-- add_index(:taxable_taxonomies, ["taxonomy_id", "taxable_type"])
   -> 0.0072s
-- remove_index(:taxable_taxonomies, :taxonomy_id)
   -> 0.0044s
== 20190510082811 AddTaxonomyIdTaxableTypeIndicesToTaxableTaxonomies: migrated (0.0120s) 

== 20190604081000 ChangeRootPassInHost: migrating =============================
-- change_table(:hosts, {})
   -> 0.0009s
-- change_table(:hostgroups, {})
   -> 0.0005s
== 20190604081000 ChangeRootPassInHost: migrated (0.0016s) ====================

== 20190627083110 ChangeTokenValueType: migrating =============================
-- column_exists?(:tokens, :value, :text)
   -> 0.0016s
== 20190627083110 ChangeTokenValueType: migrated (0.0017s) ====================

== 20190630034751 CreateHostFacetsReportedDataFacets: migrating ===============
-- create_table(:host_facets_reported_data_facets, {})
   -> 0.0089s
== 20190630034751 CreateHostFacetsReportedDataFacets: migrated (0.0090s) ======

== 20190705060630 AddSearchableValueToParameters: migrating ===================
-- add_column(:parameters, :searchable_value, :text)
   -> 0.0006s
== 20190705060630 AddSearchableValueToParameters: migrated (0.0007s) ==========

== 20190821135704 FeatureUniqueName: migrating ================================
-- add_index(:features, :name, {:unique=>true})
   -> 0.0037s
== 20190821135704 FeatureUniqueName: migrated (0.0037s) =======================

== 20190829102315 HttpProxyUniqueName: migrating ==============================
-- add_index(:http_proxies, :name, {:unique=>true})
   -> 0.0039s
== 20190829102315 HttpProxyUniqueName: migrated (0.0041s) =====================

== 20190918170516 AddDefaultToTemplateInputs: migrating =======================
-- add_column(:template_inputs, :default, :string)
   -> 0.0018s
== 20190918170516 AddDefaultToTemplateInputs: migrated (0.0021s) ==============

== 20190919155550 AddDescriptionToTemplates: migrating ========================
-- add_column(:templates, :description, :text)
   -> 0.0014s
== 20190919155550 AddDescriptionToTemplates: migrated (0.0015s) ===============

== 20191001120743 AddFieldsToReportedDataFacet: migrating =====================
-- add_column(:host_facets_reported_data_facets, :virtual, :boolean)
   -> 0.0010s
-- add_column(:host_facets_reported_data_facets, :sockets, :integer)
   -> 0.0006s
-- add_column(:host_facets_reported_data_facets, :cores, :integer)
   -> 0.0004s
-- add_column(:host_facets_reported_data_facets, :ram, :integer)
   -> 0.0004s
== 20191001120743 AddFieldsToReportedDataFacet: migrated (0.0027s) ============

== 20191017151119 AddExternalIpamIdToSubnets: migrating =======================
-- add_column(:subnets, :externalipam_id, :integer)
   -> 0.0008s
-- add_column(:subnets, :externalipam_group, :text)
   -> 0.0005s
-- add_index(:subnets, :externalipam_id)
   -> 0.0034s
== 20191017151119 AddExternalIpamIdToSubnets: migrated (0.0048s) ==============

== 20191028082812 RemoveLimitFromRootPass: migrating ==========================
-- change_table(:hosts, {})
   -> 0.0007s
-- change_table(:hostgroups, {})
   -> 0.0004s
== 20191028082812 RemoveLimitFromRootPass: migrated (0.0012s) =================

== 20200107181613 AddForemanInternalTable: migrating ==========================
-- create_table(:foreman_internals, {})
   -> 0.0119s
== 20200107181613 AddForemanInternalTable: migrated (0.0120s) =================

== 20200127103144 SshKeysFingerprintsSha1: migrating ==========================
== 20200127103144 SshKeysFingerprintsSha1: migrated (0.0175s) =================

== 20200129123555 AddDisabledToUsers: migrating ===============================
-- add_column(:users, :disabled, :boolean, {:default=>false})
   -> 0.0016s
== 20200129123555 AddDisabledToUsers: migrated (0.0016s) ======================

== 20200205105956 DropParameterizedClassesSetting: migrating ==================
== 20200205105956 DropParameterizedClassesSetting: migrated (0.0080s) =========

== 20200217110708 AlterSessionSequenceToCycle: migrating ======================
-- change_column(:sessions, :id, :bigint)
   -> 0.0176s
== 20200217110708 AlterSessionSequenceToCycle: migrated (0.0199s) =============

== 20200311131527 DropSmartVariablePermissions: migrating =====================
== 20200311131527 DropSmartVariablePermissions: migrated (0.0110s) ============

== 20200311134414 ChangeMatchToTextInLookupvalue: migrating ===================
-- change_column(:lookup_values, :match, :text, {:limit=>nil})
   -> 0.0012s
== 20200311134414 ChangeMatchToTextInLookupvalue: migrated (0.0013s) ==========

== 20200318135632 RenameReportTemplates: migrating ============================
== 20200318135632 RenameReportTemplates: migrated (0.0422s) ===================

== 20200324210540 RenameDefaultVariableLookupPath: migrating ==================
== 20200324210540 RenameDefaultVariableLookupPath: migrated (0.0009s) =========

== 20200326164755 ChangeOidcAudienceSettingType: migrating ====================
== 20200326164755 ChangeOidcAudienceSettingType: migrated (0.0010s) ===========

== 20200402190048 AddHiddenValueToTemplateInput: migrating ====================
-- add_column(:template_inputs, :hidden_value, :boolean, {:default=>false, :null=>false})
   -> 0.0008s
== 20200402190048 AddHiddenValueToTemplateInput: migrated (0.0009s) ===========

== 20200406113832 DropVariableLookupKey: migrating ============================
== 20200406113832 DropVariableLookupKey: migrated (0.0275s) ===================

== 20200427151946 DropRackspaceCr: migrating ==================================
== 20200427151946 DropRackspaceCr: migrated (0.1108s) =========================

== 20200513092446 ChangeConfigChartClass: migrating ===========================
== 20200513092446 ChangeConfigChartClass: migrated (0.0063s) ==================

== 20200521082853 RenameCentOs7InstallMedia: migrating ========================
2022-12-13T16:44:15 [W|app|] Creating scope :completer_scope. Overwriting existing method Location.completer_scope.
2022-12-13T16:44:15 [W|app|] Creating scope :completer_scope. Overwriting existing method Organization.completer_scope.
== 20200521082853 RenameCentOs7InstallMedia: migrated (0.0410s) ===============

== 20200525073201 DropPuppetClassIdFromLookUpKey: migrating ===================
-- remove_column(:lookup_keys, :puppetclass_id, :integer)
   -> 0.0005s
== 20200525073201 DropPuppetClassIdFromLookUpKey: migrated (0.0005s) ==========

== 20200602155700 DropPuppetRun: migrating ====================================
== 20200602155700 DropPuppetRun: migrated (0.0015s) ===========================

== 20200605153005 MigrateCoreTypes: migrating =================================
== 20200605153005 MigrateCoreTypes: migrated (0.0079s) ========================

== 20200615071719 AddBmcToSubnet: migrating ===================================
-- add_column(:subnets, :bmc_id, :integer)
   -> 0.0007s
== 20200615071719 AddBmcToSubnet: migrated (0.0016s) ==========================

== 20200616134403 RemoveSettingEnableOrchestration: migrating =================
== 20200616134403 RemoveSettingEnableOrchestration: migrated (0.0009s) ========

== 20200625081552 AddUniqueIndexToLookupValue: migrating ======================
-- add_index(:lookup_values, [:lookup_key_id, :match], {:unique=>true})
   -> 0.0041s
== 20200625081552 AddUniqueIndexToLookupValue: migrated (0.0051s) =============

== 20200709160133 SetEmptyFilterTaxonomySearchNil: migrating ==================
== 20200709160133 SetEmptyFilterTaxonomySearchNil: migrated (0.0129s) =========

== 20200825121733 DropCompareContentHostTemplate: migrating ===================
== 20200825121733 DropCompareContentHostTemplate: migrated (0.0009s) ==========

== 20200908120905 RebuildTaxonomySearch: migrating ============================
2022-12-13T16:44:15 [W|app|] Scoped order is ignored, it's forced to be batch order.
== 20200908120905 RebuildTaxonomySearch: migrated (0.0014s) ===================

== 20200911083030 UseHashIndexForReports: migrating ===========================
-- remove_index(:messages, :digest)
   -> 0.0016s
-- remove_index(:sources, :digest)
   -> 0.0012s
-- remove_column(:messages, :digest, :string, {:limit=>40})
   -> 0.0002s
-- remove_column(:sources, :digest, :string, {:limit=>40})
   -> 0.0002s
-- add_index(:messages, :value, {:using=>"hash"})
   -> 0.0005s
-- add_index(:sources, :value, {:using=>"hash"})
   -> 0.0004s
== 20200911083030 UseHashIndexForReports: migrated (0.0044s) ==================

== 20200918223816 UpdateLoginDelegationDescription: migrating =================
== 20200918223816 UpdateLoginDelegationDescription: migrated (0.0016s) ========

== 20200921135723 CreateHostFacetsInfrastructureFacets: migrating =============
-- create_table(:host_facets_infrastructure_facets, {})
   -> 0.0167s
== 20200921135723 CreateHostFacetsInfrastructureFacets: migrated (0.0168s) ====

== 20201030102020 EnlargeReportStatus: migrating ==============================
-- remove_index(:reports, :status)
   -> 0.0038s
== 20201030102020 EnlargeReportStatus: migrated (0.0080s) =====================

== 20201224095619 RemoveOvirtUseApiFromAttr: migrating ========================
== 20201224095619 RemoveOvirtUseApiFromAttr: migrated (0.0022s) ===============

== 20210114143800 NilifyEmptyProxyCredentials: migrating ======================
== 20210114143800 NilifyEmptyProxyCredentials: migrated (0.0111s) =============

== 20210115124508 TemplateKindRegistration: migrating =========================
== 20210115124508 TemplateKindRegistration: migrated (0.0218s) ================

== 20210317090500 AddDisksTotalToHostFacets: migrating ========================
-- add_column(:host_facets_reported_data_facets, :disks_total, :bigint)
   -> 0.0009s
== 20210317090500 AddDisksTotalToHostFacets: migrated (0.0009s) ===============

== 20210317170111 RemoveTheRemoteAddSetting: migrating ========================
== 20210317170111 RemoveTheRemoteAddSetting: migrated (0.0009s) ===============

== 20210401124332 DropDbPendingMigrationSetting: migrating ====================
== 20210401124332 DropDbPendingMigrationSetting: migrated (0.0009s) ===========

== 20210407104300 DowncaseMacAddresses: migrating =============================
-- execute("UPDATE nics SET mac=LOWER(mac)")
   -> 0.0006s
== 20210407104300 DowncaseMacAddresses: migrated (0.0006s) ====================

== 20210502113529 DropViewBookmarksPermission: migrating ======================
== 20210502113529 DropViewBookmarksPermission: migrated (0.0048s) =============

== 20210523143005 MigrateEnvironments: migrating ==============================
== 20210523143005 MigrateEnvironments: migrated (0.0018s) =====================

== 20210525144427 EnforceUniqueTemplates: migrating ===========================
-- add_index(:templates, [:type, :name], {:unique=>true})
   -> 0.0040s
== 20210525144427 EnforceUniqueTemplates: migrated (0.0070s) ==================

== 20210609093404 DropOverrideTaxonomiesFromFilter: migrating =================
== 20210609093404 DropOverrideTaxonomiesFromFilter: migrated (0.0105s) ========

== 20210610131920 RestrictSendmailLocation: migrating =========================
== 20210610131920 RestrictSendmailLocation: migrated (0.0010s) ================

== 20210901081438 DropViewTasksPermission: migrating ==========================
== 20210901081438 DropViewTasksPermission: migrated (0.0019s) =================

== 20210915132645 GeneralSettingToDsl: migrating ==============================
== 20210915132645 GeneralSettingToDsl: migrated (0.0011s) =====================

== 20210929132645 CoreSettingToDsl: migrating =================================
== 20210929132645 CoreSettingToDsl: migrated (0.0031s) ========================

== 20211111115000 DropFixDbCacheSetting: migrating ============================
== 20211111115000 DropFixDbCacheSetting: migrated (0.0020s) ===================

== 20220111110149 DropRequireSslSmartProxiesSetting: migrating ================
== 20220111110149 DropRequireSslSmartProxiesSetting: migrated (0.0022s) =======

== 20220124174632 DropSettingFields: migrating ================================
-- remove_column(:settings, :description)
   -> 0.0010s
-- remove_column(:settings, :settings_type)
   -> 0.0004s
-- remove_column(:settings, :default)
   -> 0.0004s
-- remove_column(:settings, :full_name)
   -> 0.0003s
-- remove_column(:settings, :encrypted)
   -> 0.0005s
== 20220124174632 DropSettingFields: migrated (0.0040s) =======================

== 20220204155632 RenameJobReportTemplate: migrating ==========================
== 20220204155632 RenameJobReportTemplate: migrated (0.0025s) =================

== 20220208134539 RenameCentOsStreamOs: migrating =============================
== 20220208134539 RenameCentOsStreamOs: migrated (0.0033s) ====================

== 20220515130414 DropUnnecessaryTimestamps: migrating ========================
-- remove_column(:taxable_taxonomies, :created_at, :datetime)
   -> 0.0006s
-- remove_column(:taxable_taxonomies, :updated_at, :datetime)
   -> 0.0002s
== 20220515130414 DropUnnecessaryTimestamps: migrated (0.0008s) ===============

== 20220628083024 ChangeDefaultValueForMailEnabledToUser: migrating ===========
-- change_column_default(:users, :mail_enabled, {:from=>true, :to=>false})
   -> 0.0025s
== 20220628083024 ChangeDefaultValueForMailEnabledToUser: migrated (0.0025s) ==

== 20220630104300 FixFacetAudits: migrating ===================================
== 20220630104300 FixFacetAudits: migrated (0.0071s) ==========================

== 20220809191656 AddSslCaToHttpProxy: migrating ==============================
-- add_column(:http_proxies, :cacert, :text)
   -> 0.0005s
== 20220809191656 AddSslCaToHttpProxy: migrated (0.0006s) =====================

== 20220907145552 CleanTrendsAndForemanDockerData: migrating ==================
== 20220907145552 CleanTrendsAndForemanDockerData: migrated (0.0042s) =========

== 20221010174230 AddKernelVersionToHostFacets: migrating =====================
-- add_column(:host_facets_reported_data_facets, :kernel_version, :string, {:limit=>255})
   -> 0.0013s
== 20221010174230 AddKernelVersionToHostFacets: migrated (0.0014s) ============

== 20221017161042 RemoveHostPowerStatusFromSettings: migrating ================
== 20221017161042 RemoveHostPowerStatusFromSettings: migrated (0.0021s) =======

== 20221025151600 AddCreatorIdToHosts: migrating ==============================
-- add_reference(:hosts, :creator, {:foreign_key=>{:to_table=>:users, :on_delete=>:nullify}})
   -> 0.0127s
== 20221025151600 AddCreatorIdToHosts: migrated (0.0129s) =====================

== 20221102134032 AddBiosToHostFacets: migrating ==============================
-- add_column(:host_facets_reported_data_facets, :bios_vendor, :string, {:limit=>255})
   -> 0.0067s
-- add_column(:host_facets_reported_data_facets, :bios_release_date, :string, {:limit=>255})
   -> 0.0012s
-- add_column(:host_facets_reported_data_facets, :bios_version, :string, {:limit=>255})
   -> 0.0012s
== 20221102134032 AddBiosToHostFacets: migrated (0.0096s) =====================
$ bundle exec rake db:seed
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/net-protocol-0.2.1/lib/net/protocol.rb:68: warning: already initialized constant Net::ProtocRetryError
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/2.7.0/net/protocol.rb:66: warning: previous definition of ProtocRetryError was here
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/net-protocol-0.2.1/lib/net/protocol.rb:214: warning: already initialized constant Net::BufferedIO::BUFSIZE
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/2.7.0/net/protocol.rb:206: warning: previous definition of BUFSIZE was here
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/net-protocol-0.2.1/lib/net/protocol.rb:541: warning: already initialized constant Net::NetPrivate::Socket
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/2.7.0/net/protocol.rb:503: warning: previous definition of Socket was here
2022-12-13T16:44:18 [I|app|] Rails cache backend: File
2022-12-13T16:44:18 [W|app|] You are trying to replace import_subnets from . Adding allowed actions from plugin permissions to the existing one.
2022-12-13T16:44:18 [W|app|] DEPRECATION WARNING: You are using a deprecated behavior, it will be removed in version 3.3, initial value of setting 'instance_id' should be created in a migration (called from block in load_definitions at /home/ekohl/dev/foreman-plugins/foreman_statistics/app/services/setting_registry.rb:131)
2022-12-13T16:44:19 [D|app|] Slow initializers:
2022-12-13T16:44:19 [D|app|]     105.89  ./config/initializers/foreman_register.rb
2022-12-13T16:44:19 [W|app|] DEPRECATION WARNING: Initialization autoloaded the constants Net::Validations, SettingRegistry, HiddenValue, SettingPresenter, Foreman::Deprecation, SettingSelectCollection, MediumProviders, MediumProviders::Provider, MediumProviders::Default, and Foreman::TelemetryHelper.
 | 
 | Being able to do this is deprecated. Autoloading during initialization is going
 | to be an error condition in future versions of Rails.
 | 
 | Reloading does not reboot the application, and therefore code executed during
 | initialization does not run again. So, if you reload Net::Validations, for example,
 | the expected changes won't be reflected in that stale Module object.
 | 
 | `config.autoloader` is set to `classic`. These autoloaded constants would have been unloaded if `config.autoloader` had been set to `:zeitwerk`.
 | 
 | In order to autoload safely at boot time, please wrap your code in a reloader
 | callback this way:
 | 
 |     Rails.application.reloader.to_prepare do
 |       # Autoload classes and modules needed at boot time here.
 |     end
 | 
 | That block runs when the application boots, and every time there is a reload.
 | For historical reasons, it may run twice, so it has to be idempotent.
 | 
 | Check the "Autoloading and Reloading Constants" guide to learn more about how
 | Rails autoloads and reloads.
 |  (called from block in run at /home/ekohl/dev/foreman-plugins/foreman_statistics/config/initializers/0_print_time_spent.rb:45)
2022-12-13T16:44:19 [W|app|] DEPRECATION WARNING: You are using a deprecated behavior, it will be removed in version 3.3, initial value of setting 'instance_id' should be created in a migration (called from block in load_definitions at /home/ekohl/dev/foreman-plugins/foreman_statistics/app/services/setting_registry.rb:131)
You have 4 pending migrations:
  20121012170851 CreateTrends
  20121012170936 CreateTrendCounters
  20150202094307 AddRangeToTrendCounters
  20181031155025 AddTrendCounterCreatedAtUniqueConstraint
$  bundle exec rake db:migrate
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/net-protocol-0.2.1/lib/net/protocol.rb:68: warning: already initialized constant Net::ProtocRetryError
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/2.7.0/net/protocol.rb:66: warning: previous definition of ProtocRetryError was here
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/net-protocol-0.2.1/lib/net/protocol.rb:214: warning: already initialized constant Net::BufferedIO::BUFSIZE
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/2.7.0/net/protocol.rb:206: warning: previous definition of BUFSIZE was here
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/gems/2.7.0/gems/net-protocol-0.2.1/lib/net/protocol.rb:541: warning: already initialized constant Net::NetPrivate::Socket
/home/ekohl/.rbenv/versions/2.7.6/lib/ruby/2.7.0/net/protocol.rb:503: warning: previous definition of Socket was here
2022-12-13T16:46:59 [I|app|] Rails cache backend: File
2022-12-13T16:46:59 [W|app|] You are trying to replace import_subnets from . Adding allowed actions from plugin permissions to the existing one.
2022-12-13T16:46:59 [W|app|] DEPRECATION WARNING: You are using a deprecated behavior, it will be removed in version 3.3, initial value of setting 'instance_id' should be created in a migration (called from block in load_definitions at /home/ekohl/dev/foreman-plugins/foreman_statistics/app/services/setting_registry.rb:131)
2022-12-13T16:46:59 [D|app|] Slow initializers:
2022-12-13T16:46:59 [D|app|]     178.25  ./config/initializers/foreman_register.rb
2022-12-13T16:46:59 [W|app|] DEPRECATION WARNING: Initialization autoloaded the constants Net::Validations, SettingRegistry, HiddenValue, SettingPresenter, Foreman::Deprecation, SettingSelectCollection, MediumProviders, MediumProviders::Provider, MediumProviders::Default, and Foreman::TelemetryHelper.
 | 
 | Being able to do this is deprecated. Autoloading during initialization is going
 | to be an error condition in future versions of Rails.
 | 
 | Reloading does not reboot the application, and therefore code executed during
 | initialization does not run again. So, if you reload Net::Validations, for example,
 | the expected changes won't be reflected in that stale Module object.
 | 
 | `config.autoloader` is set to `classic`. These autoloaded constants would have been unloaded if `config.autoloader` had been set to `:zeitwerk`.
 | 
 | In order to autoload safely at boot time, please wrap your code in a reloader
 | callback this way:
 | 
 |     Rails.application.reloader.to_prepare do
 |       # Autoload classes and modules needed at boot time here.
 |     end
 | 
 | That block runs when the application boots, and every time there is a reload.
 | For historical reasons, it may run twice, so it has to be idempotent.
 | 
 | Check the "Autoloading and Reloading Constants" guide to learn more about how
 | Rails autoloads and reloads.
 |  (called from block in run at /home/ekohl/dev/foreman-plugins/foreman_statistics/config/initializers/0_print_time_spent.rb:45)
== 20121012170851 CreateTrends: migrating =====================================
-- create_table(:trends, {})
   -> 0.0160s
-- add_index(:trends, :type)
   -> 0.0052s
-- add_index(:trends, [:trendable_type, :trendable_id])
   -> 0.0050s
-- add_index(:trends, :fact_value)
   -> 0.0054s
== 20121012170851 CreateTrends: migrated (0.0321s) ============================

== 20121012170936 CreateTrendCounters: migrating ==============================
-- create_table(:trend_counters, {})
   -> 0.0155s
== 20121012170936 CreateTrendCounters: migrated (0.0157s) =====================

== 20150202094307 AddRangeToTrendCounters: migrating ==========================
-- add_column(:trend_counters, :interval_start, :datetime)
   -> 0.0020s
-- add_column(:trend_counters, :interval_end, :datetime)
   -> 0.0010s
== 20150202094307 AddRangeToTrendCounters: migrated (0.0033s) =================

== 20181031155025 AddTrendCounterCreatedAtUniqueConstraint: migrating =========
-- add_index(:trend_counters, [:trend_id, :created_at], {:unique=>true})
   -> 0.0064s
== 20181031155025 AddTrendCounterCreatedAtUniqueConstraint: migrated (0.0067s) 

[ezr-ondrej]

Interesting... The migrations are not executed for some reason, did we bump Rails version recently in core?

[ekohl]

Yes, https://github.com/theforeman/foreman/commit/180f62f3971f69527656327e1bff17763f2655e7 allowed a newer version.

[ezr-ondrej]

I wonder if that might be it. I'll try to find time tomorrow to debug what paths the migration paths resolve to now...

[ezr-ondrej]

Interesting, my local setup runs the migrations, sharing the relevant excerpt

== 20121012170851 CreateTrends: migrating =====================================
-- create_table(:trends, {})
   -> 0.0157s
-- add_index(:trends, :type)
   -> 0.0067s
-- add_index(:trends, [:trendable_type, :trendable_id])
   -> 0.0068s
-- add_index(:trends, :fact_value)
   -> 0.0069s
== 20121012170851 CreateTrends: migrated (0.0364s) ============================

== 20121012170936 CreateTrendCounters: migrating ==============================
-- create_table(:trend_counters, {})
   -> 0.0170s
== 20121012170936 CreateTrendCounters: migrated (0.0171s) =====================

My setup:

~/Theforeman/foreman (develop) 👾 rbenv local
2.7.6
~/Theforeman/foreman (develop) 👾 ruby -v
ruby 2.7.6p219 (2022-04-12 revision c9c2245c0a) [x86_64-linux]
~/Theforeman/foreman (develop) 👾 cat Gemfile.lock | grep rails
      rails-dom-testing (~> 2.0)
      rails-dom-testing (~> 2.0)
      rails-html-sanitizer (~> 1.0, >= 1.2.0)
      rails-dom-testing (~> 2.0)
      rails-html-sanitizer (~> 1.1, >= 1.2.0)
    apipie-rails (0.8.2)
    autoprefixer-rails (10.4.7.0)
      autoprefixer-rails (>= 5.2.1)
    coffee-rails (5.0.0)
    factory_bot_rails (5.2.0)
    gettext_i18n_rails (1.9.0)
    gettext_i18n_rails_js (1.3.1)
      gettext_i18n_rails (>= 0.7.1)
      rails (>= 3.2.0)
    graphiql-rails (1.8.0)
      sprockets-rails
    jquery-ui-rails (6.0.1)
    minitest-spec-rails (6.2.0)
    pry-rails (0.3.9)
    rails (6.1.7)
      sprockets-rails (>= 2.0.0)
    rails-controller-testing (1.0.5)
    rails-dom-testing (2.0.3)
    rails-html-sanitizer (1.4.3)
    rails-i18n (7.0.6)
    roadie-rails (3.0.0)
    rubocop-rails (2.8.1)
    sass-rails (6.0.0)
      sassc-rails (~> 2.1, >= 2.1.1)
    sassc-rails (2.1.2)
      sprockets-rails
    sprockets-rails (3.4.2)
      rubocop-rails (~> 2.8.1)
    webpack-rails (0.9.11)
  apipie-rails (~> 0.8.0)
  coffee-rails (~> 5.0.0)
  factory_bot_rails (~> 5.0)
  gettext_i18n_rails (~> 1.8)
  gettext_i18n_rails_js (~> 1.3.1)
  graphiql-rails (~> 1.7)
  jquery-ui-rails (~> 6.0)
  minitest-spec-rails (~> 6.0)
  pry-rails
  rails (~> 6.1.6)
  rails-controller-testing (~> 1.0)
  rails-i18n (~> 7.0)
  roadie-rails (~> 3.0)
  sass-rails (~> 6.0)
  sprockets-rails (~> 3.0)
  webpack-rails (~> 0.9.8)
~/Theforeman/foreman (develop) 👾

[ekohl]

Can you also try it with Rails 6.1.7? It could be a regression there. My env:

$ ruby -v
ruby 2.7.6p219 (2022-04-12 revision c9c2245c0a) [x86_64-linux]
$ bundle show | grep rails
[DEPRECATED] use `bundle list` instead of `bundle show`
  * apipie-rails (0.8.2)
  * autoprefixer-rails (10.4.7.0)
  * coffee-rails (5.0.0)
  * factory_bot_rails (5.2.0)
  * gettext_i18n_rails (1.9.0)
  * gettext_i18n_rails_js (1.3.1)
  * graphiql-rails (1.8.0)
  * jquery-ui-rails (6.0.1)
  * minitest-spec-rails (6.2.0)
  * pry-rails (0.3.9)
  * rails (6.1.7)
  * rails-controller-testing (1.0.5)
  * rails-dom-testing (2.0.3)
  * rails-html-sanitizer (1.4.4)
  * rails-i18n (7.0.6)
  * roadie-rails (3.0.0)
  * rubocop-rails (2.8.1)
  * sass-rails (6.0.0)
  * sassc-rails (2.1.2)
  * sprockets-rails (3.4.2)
  * webpack-rails (0.9.11)

[ezr-ondrej]

I've figured it out, the https://github.com/theforeman/foreman/pull/9343 forgot to include a check for this plugin being installed.

[ezr-ondrej]

https://github.com/theforeman/foreman/pull/9559 should fix this.

[ezr-ondrej]

:green_apple: