Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [root@lts-mgmt01 foreman]# foreman-rake db:migrate --trace
- ** Invoke db:migrate (first_time)
- ** Invoke environment (first_time)
- ** Execute environment
- foreman_bootdisk: skipping engine hook (PGError: ERROR: relation "template_kinds" does not exist
- LINE 4: WHERE a.attrelid = '"template_kinds"'::regclass
- ^
- : SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"template_kinds"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- )
- ** Invoke db:load_config (first_time)
- ** Execute db:load_config
- ** Execute db:migrate
- == CreateHosts: migrating ====================================================
- -- create_table(:hosts)
- NOTICE: CREATE TABLE will create implicit sequence "hosts_id_seq" for serial column "hosts.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "hosts_pkey" for table "hosts"
- -> 0.0218s
- -- add_index(:hosts, :source_file_id, {:integer=>true})
- -> 0.0072s
- -- add_index(:hosts, :name)
- -> 0.0073s
- -- create_table(:fact_names)
- NOTICE: CREATE TABLE will create implicit sequence "fact_names_id_seq" for serial column "fact_names.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "fact_names_pkey" for table "fact_names"
- -> 0.0074s
- -- add_index(:fact_names, :name)
- -> 0.0076s
- -- create_table(:fact_values)
- NOTICE: CREATE TABLE will create implicit sequence "fact_values_id_seq" for serial column "fact_values.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "fact_values_pkey" for table "fact_values"
- -> 0.0156s
- -- add_index(:fact_values, :fact_name_id, {:integer=>true})
- -> 0.0074s
- -- add_index(:fact_values, :host_id, {:integer=>true})
- -> 0.0074s
- -- add_column(:hosts, :mac, :string, {:limit=>17, :default=>""})
- -> 0.0311s
- -- add_column(:hosts, :sp_mac, :string, {:limit=>17, :default=>""})
- -> 0.0370s
- -- add_column(:hosts, :sp_ip, :string, {:limit=>15, :default=>""})
- -> 0.0340s
- -- add_column(:hosts, :sp_name, :string, {:default=>""})
- -> 0.0455s
- -- add_column(:hosts, :root_pass, :string, {:limit=>64})
- -> 0.0005s
- -- add_column(:hosts, :serial, :string, {:limit=>12})
- -> 0.0004s
- -- add_column(:hosts, :puppetmaster, :string)
- -> 0.0003s
- -- add_column(:hosts, :puppet_status, :integer, {:null=>false, :default=>0})
- -> 0.1302s
- -- add_column(:hosts, :domain_id, :integer)
- -> 0.0005s
- -- add_column(:hosts, :architecture_id, :integer)
- -> 0.0004s
- -- add_column(:hosts, :operatingsystem_id, :integer)
- -> 0.0003s
- -- add_column(:hosts, :environment_id, :integer)
- -> 0.0005s
- -- add_column(:hosts, :subnet_id, :integer)
- -> 0.0003s
- -- add_column(:hosts, :sp_subnet_id, :integer)
- -> 0.0003s
- -- add_column(:hosts, :ptable_id, :integer)
- -> 0.0003s
- -- add_column(:hosts, :medium_id, :integer)
- -> 0.0003s
- -- add_column(:hosts, :build, :boolean, {:default=>true})
- -> 0.0118s
- -- add_column(:hosts, :comment, :text)
- -> 0.0005s
- -- add_column(:hosts, :disk, :text)
- -> 0.0003s
- -- add_column(:hosts, :installed_at, :datetime)
- -> 0.0003s
- == CreateHosts: migrated (0.3789s) ===========================================
- == AddAuditsTable: migrating =================================================
- -- create_table(:audits, {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "audits_id_seq" for serial column "audits.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "audits_pkey" for table "audits"
- -> 0.0082s
- -- add_index(:audits, [:auditable_id, :auditable_type], {:name=>"auditable_index"})
- -> 0.0036s
- -- add_index(:audits, [:user_id, :user_type], {:name=>"user_index"})
- -> 0.0038s
- -- add_index(:audits, :created_at)
- -> 0.0039s
- -- add_index(:audits, [:auditable_parent_id, :auditable_parent_type], {:name=>"auditable_parent_index"})
- -> 0.0047s
- == AddAuditsTable: migrated (0.0247s) ========================================
- == CreateArchitectures: migrating ============================================
- -- create_table(:architectures)
- NOTICE: CREATE TABLE will create implicit sequence "architectures_id_seq" for serial column "architectures.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "architectures_pkey" for table "architectures"
- -> 0.0047s
- -- create_table(:architectures_operatingsystems, {:id=>false})
- -> 0.0007s
- == CreateArchitectures: migrated (0.0057s) ===================================
- == CreateMedia: migrating ====================================================
- -- create_table(:media)
- NOTICE: CREATE TABLE will create implicit sequence "media_id_seq" for serial column "media.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "media_pkey" for table "media"
- -> 0.0052s
- == CreateMedia: migrated (0.0054s) ===========================================
- == CreateDomains: migrating ==================================================
- -- create_table(:domains)
- NOTICE: CREATE TABLE will create implicit sequence "domains_id_seq" for serial column "domains.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "domains_pkey" for table "domains"
- -> 0.0073s
- == CreateDomains: migrated (0.0074s) =========================================
- == CreateSubnets: migrating ==================================================
- -- create_table(:subnets)
- NOTICE: CREATE TABLE will create implicit sequence "subnets_id_seq" for serial column "subnets.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "subnets_pkey" for table "subnets"
- -> 0.0104s
- == CreateSubnets: migrated (0.0106s) =========================================
- == CreateOperatingsystems: migrating =========================================
- -- create_table(:operatingsystems)
- NOTICE: CREATE TABLE will create implicit sequence "operatingsystems_id_seq" for serial column "operatingsystems.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "operatingsystems_pkey" for table "operatingsystems"
- -> 0.0050s
- == CreateOperatingsystems: migrated (0.0052s) ================================
- == CreateModels: migrating ===================================================
- -- create_table(:models)
- NOTICE: CREATE TABLE will create implicit sequence "models_id_seq" for serial column "models.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "models_pkey" for table "models"
- -> 0.0075s
- -- add_column(:hosts, :model_id, :integer)
- -> 0.0009s
- == CreateModels: migrated (0.0088s) ==========================================
- == CreateEnvironments: migrating =============================================
- -- create_table(:environments)
- NOTICE: CREATE TABLE will create implicit sequence "environments_id_seq" for serial column "environments.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "environments_pkey" for table "environments"
- -> 0.0041s
- -- create_table(:environments_puppetclasses, {:id=>false})
- -> 0.0006s
- == CreateEnvironments: migrated (0.0048s) ====================================
- == CreateReports: migrating ==================================================
- -- create_table(:reports)
- NOTICE: CREATE TABLE will create implicit sequence "reports_id_seq" for serial column "reports.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "reports_pkey" for table "reports"
- -> 0.0066s
- == CreateReports: migrated (0.0067s) =========================================
- == CreatePtables: migrating ==================================================
- -- create_table(:ptables)
- NOTICE: CREATE TABLE will create implicit sequence "ptables_id_seq" for serial column "ptables.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ptables_pkey" for table "ptables"
- -> 0.0074s
- -- create_table(:operatingsystems_ptables, {:id=>false})
- -> 0.0009s
- == CreatePtables: migrated (0.0085s) =========================================
- == CreatePuppetclasses: migrating ============================================
- -- create_table(:puppetclasses)
- NOTICE: CREATE TABLE will create implicit sequence "puppetclasses_id_seq" for serial column "puppetclasses.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "puppetclasses_pkey" for table "puppetclasses"
- -> 0.0069s
- -- create_table(:hosts_puppetclasses, {:id=>false})
- -> 0.0008s
- -- create_table(:operatingsystems_puppetclasses, {:id=>false})
- -> 0.0009s
- == CreatePuppetclasses: migrated (0.0089s) ===================================
- == CreateParameters: migrating ===============================================
- -- create_table(:parameters)
- NOTICE: CREATE TABLE will create implicit sequence "parameters_id_seq" for serial column "parameters.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameters_pkey" for table "parameters"
- -> 0.0068s
- == CreateParameters: migrated (0.0069s) ======================================
- == CreateAuthSources: migrating ==============================================
- -- create_table(:auth_sources)
- NOTICE: CREATE TABLE will create implicit sequence "auth_sources_id_seq" for serial column "auth_sources.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "auth_sources_pkey" for table "auth_sources"
- -> 0.0075s
- == CreateAuthSources: migrated (0.0076s) =====================================
- == CreateHostgroups: migrating ===============================================
- -- create_table(:hostgroups)
- NOTICE: CREATE TABLE will create implicit sequence "hostgroups_id_seq" for serial column "hostgroups.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "hostgroups_pkey" for table "hostgroups"
- -> 0.0042s
- -- create_table(:hostgroups_puppetclasses, {:id=>false})
- -> 0.0007s
- -- add_column(:hosts, :hostgroup_id, :integer)
- -> 0.0004s
- -- add_column(:parameters, :hostgroup_id, :integer)
- -> 0.0004s
- == CreateHostgroups: migrated (0.0060s) ======================================
- == AddTypeToParameter: migrating =============================================
- -- add_column(:parameters, :type, :string)
- -> 0.0009s
- == AddTypeToParameter: migrated (0.0010s) ====================================
- == AddDomainToParameter: migrating ===========================================
- -- add_column(:parameters, :domain_id, :integer)
- -> 0.0007s
- == AddDomainToParameter: migrated (0.0008s) ==================================
- == ChangeReportFieldTypeToText: migrating ====================================
- == ChangeReportFieldTypeToText: migrated (0.0002s) ===========================
- == ChangeHostBuildDefaultToFalse: migrating ==================================
- -- change_column(:hosts, :build, :boolean, {:default=>false})
- -> 0.0134s
- == ChangeHostBuildDefaultToFalse: migrated (0.0195s) =========================
- == AddIndexToHost: migrating =================================================
- -- add_index("hosts", "last_report")
- -> 0.0057s
- -- add_index("hosts", "installed_at")
- -> 0.0065s
- -- add_index("hosts", "puppet_status")
- -> 0.0062s
- -- add_index("hosts", :domain_id, {:name=>"host_domain_id_ix"})
- -> 0.0057s
- -- add_index("hosts", :architecture_id, {:name=>"host_arch_id_ix"})
- -> 0.0063s
- -- add_index("hosts", :operatingsystem_id, {:name=>"host_os_id_ix"})
- -> 0.0072s
- -- add_index("hosts", :environment_id, {:name=>"host_env_id_ix"})
- -> 0.0072s
- -- add_index("hosts", :medium_id, {:name=>"host_medium_id_ix"})
- -> 0.0071s
- -- add_index("hosts", :hostgroup_id, {:name=>"host_group_id_ix"})
- -> 0.0061s
- == AddIndexToHost: migrated (0.0590s) ========================================
- == AddIndexToParameters: migrating ===========================================
- -- add_index(:parameters, [:host_id, :type])
- -> 0.0144s
- -- add_index(:parameters, [:hostgroup_id, :type])
- -> 0.0058s
- -- add_index(:parameters, [:domain_id, :type])
- -> 0.0049s
- -- add_index(:parameters, :type)
- -> 0.0043s
- == AddIndexToParameters: migrated (0.0299s) ==================================
- == AddIndexToReports: migrating ==============================================
- -- add_index(:reports, [:reported_at, :host_id])
- -> 0.0041s
- == AddIndexToReports: migrated (0.0042s) =====================================
- == CreateUsers: migrating ====================================================
- -- create_table(:users)
- NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
- -> 0.0071s
- == CreateUsers: migrated (0.0072s) ===========================================
- == CreateSessions: migrating =================================================
- -- create_table(:sessions)
- NOTICE: CREATE TABLE will create implicit sequence "sessions_id_seq" for serial column "sessions.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sessions_pkey" for table "sessions"
- -> 0.0070s
- -- add_index(:sessions, :session_id)
- -> 0.0035s
- -- add_index(:sessions, :updated_at)
- -> 0.0038s
- == CreateSessions: migrated (0.0146s) ========================================
- == AddStatusToReport: migrating ==============================================
- -- add_column(:reports, :status, :integer)
- -> 0.0007s
- -- add_index(:reports, :status)
- -> 0.0040s
- -- add_index(:reports, :host_id)
- -> 0.0041s
- -- add_index(:reports, :reported_at)
- -> 0.0043s
- == AddStatusToReport: migrated (0.0134s) =====================================
- == CalcExistingReports: migrating ============================================
- == CalcExistingReports: migrated (0.0039s) ===================================
- == CreateLookupKeys: migrating ===============================================
- -- create_table(:lookup_keys)
- NOTICE: CREATE TABLE will create implicit sequence "lookup_keys_id_seq" for serial column "lookup_keys.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lookup_keys_pkey" for table "lookup_keys"
- -> 0.0043s
- -- add_index(:lookup_keys, :key)
- -> 0.0037s
- == CreateLookupKeys: migrated (0.0083s) ======================================
- == CreateLookupValues: migrating =============================================
- -- create_table(:lookup_values)
- NOTICE: CREATE TABLE will create implicit sequence "lookup_values_id_seq" for serial column "lookup_values.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lookup_values_pkey" for table "lookup_values"
- -> 0.0073s
- -- add_index(:lookup_values, :priority)
- -> 0.0036s
- == CreateLookupValues: migrated (0.0111s) ====================================
- == ChangeMysqlReportsColumn: migrating =======================================
- == ChangeMysqlReportsColumn: migrated (0.0001s) ==============================
- == AddFamilyToOs: migrating ==================================================
- -- add_column(:operatingsystems, :family_id, :integer)
- -> 0.0007s
- == AddFamilyToOs: migrated (0.0054s) =========================================
- == UpdateFactNamesAndValuesToBin: migrating ==================================
- == UpdateFactNamesAndValuesToBin: migrated (0.0002s) =========================
- == AddReleasenameToOs: migrating =============================================
- -- add_column(:operatingsystems, :release_name, :string, {:limit=>64})
- -> 0.0007s
- == AddReleasenameToOs: migrated (0.0062s) ====================================
- == CreateUsergroups: migrating ===============================================
- -- create_table(:usergroups)
- NOTICE: CREATE TABLE will create implicit sequence "usergroups_id_seq" for serial column "usergroups.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usergroups_pkey" for table "usergroups"
- -> 0.0047s
- -- create_table(:usergroup_members)
- NOTICE: CREATE TABLE will create implicit sequence "usergroup_members_id_seq" for serial column "usergroup_members.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usergroup_members_pkey" for table "usergroup_members"
- -> 0.0043s
- == CreateUsergroups: migrated (0.0092s) ======================================
- == AddOwnerToHosts: migrating ================================================
- -- add_column(:hosts, :owner_id, :integer)
- -> 0.0010s
- -- add_column(:hosts, :owner_type, :string)
- -> 0.0004s
- == AddOwnerToHosts: migrated (0.0600s) =======================================
- == AddUbuntuCustomLvmPtable: migrating =======================================
- == AddUbuntuCustomLvmPtable: migrated (0.0000s) ==============================
- == CreateMediaOperatingsystemsAndMigrateData: migrating ======================
- -- create_table(:media_operatingsystems, {:id=>false})
- -> 0.0012s
- -- remove_column(:media, :operatingsystem_id)
- -> 0.0005s
- == CreateMediaOperatingsystemsAndMigrateData: migrated (0.0061s) =============
- == MigrateInstallationMediumUri: migrating ===================================
- == MigrateInstallationMediumUri: migrated (0.0029s) ==========================
- == SimplifyParameters: migrating =============================================
- -- index_exists?(:parameters, :host_id)
- -> 0.0027s
- -- index_exists?(:parameters, :hostgroup_id)
- -> 0.0019s
- -- index_exists?(:parameters, :domain_id)
- -> 0.0020s
- -- column_exists?(:parameters, :host_id)
- -> 0.0007s
- -- rename_column(:parameters, :host_id, :reference_id)
- -> 0.0006s
- -- index_exists?(:parameters, :reference_id)
- -> 0.0021s
- -- Everything migrated ok so we remove the old columns
- -- column_exists?(:parameters, :hostgroup_id)
- -> 0.0007s
- -- remove_column(:parameters, :hostgroup_id)
- -> 0.0005s
- -- column_exists?(:parameters, :domain_id)
- -> 0.0007s
- -- remove_column(:parameters, :domain_id)
- -> 0.0005s
- == SimplifyParameters: migrated (0.0310s) ====================================
- == UpdateOsMinor: migrating ==================================================
- -- change_column(:operatingsystems, :minor, :string, {:limit=>16, :default=>"", :null=>false})
- -> 0.0042s
- == UpdateOsMinor: migrated (0.0061s) =========================================
- == ChangeFamilyInOs: migrating ===============================================
- -- add_column(:operatingsystems, :type, :string, {:limit=>16})
- -> 0.0006s
- -- add_index(:operatingsystems, :type)
- -> 0.0035s
- -- remove_column(:operatingsystems, :family_id)
- -> 0.0004s
- == ChangeFamilyInOs: migrated (0.0093s) ======================================
- == CreateNotices: migrating ==================================================
- -- create_table(:notices)
- NOTICE: CREATE TABLE will create implicit sequence "notices_id_seq" for serial column "notices.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "notices_pkey" for table "notices"
- -> 0.0071s
- -- create_table(:user_notices, {:id=>false})
- -> 0.0008s
- == CreateNotices: migrated (0.0081s) =========================================
- == AddInternalAuth: migrating ================================================
- -- add_column(:users, :password_hash, :string, {:limit=>128})
- -> 0.0009s
- -- add_column(:users, :password_salt, :string, {:limit=>128})
- -> 0.0006s
- == AddInternalAuth: migrated (0.0018s) =======================================
- == CreateRoles: migrating ====================================================
- -- add_column(:users, :role_id, :integer)
- -> 0.0008s
- -- create_table("roles", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "roles_id_seq" for serial column "roles.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "roles_pkey" for table "roles"
- -> 0.0095s
- -- create_table(:user_roles)
- NOTICE: CREATE TABLE will create implicit sequence "user_roles_id_seq" for serial column "user_roles.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_roles_pkey" for table "user_roles"
- -> 0.0055s
- == CreateRoles: migrated (0.0162s) ===========================================
- == AddUserDomainsAndHostgroups: migrating ====================================
- -- create_table(:user_domains, {:id=>false})
- -> 0.0011s
- -- create_table(:user_hostgroups, {:id=>false})
- -> 0.0006s
- == AddUserDomainsAndHostgroups: migrated (0.0021s) ===========================
- == CreateUserFacts: migrating ================================================
- -- create_table(:user_facts)
- NOTICE: CREATE TABLE will create implicit sequence "user_facts_id_seq" for serial column "user_facts.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_facts_pkey" for table "user_facts"
- -> 0.0046s
- == CreateUserFacts: migrated (0.0047s) =======================================
- == AddEnabledToHosts: migrating ==============================================
- -- add_column(:hosts, :enabled, :boolean, {:default=>true})
- -> 0.0308s
- == AddEnabledToHosts: migrated (0.0310s) =====================================
- == AddMyBooleansToUser: migrating ============================================
- -- add_column(:users, :domains_andor, :string, {:limit=>3, :default=>"or"})
- -> 0.0070s
- -- add_column(:users, :hostgroups_andor, :string, {:limit=>3, :default=>"or"})
- -> 0.0069s
- -- add_column(:users, :facts_andor, :string, {:limit=>3, :default=>"or"})
- -> 0.0072s
- == AddMyBooleansToUser: migrated (0.0214s) ===================================
- == CreateMessages: migrating =================================================
- -- create_table(:messages)
- NOTICE: CREATE TABLE will create implicit sequence "messages_id_seq" for serial column "messages.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages"
- -> 0.0204s
- -- add_index(:messages, :value)
- -> 0.0050s
- == CreateMessages: migrated (0.0260s) ========================================
- == CreateSources: migrating ==================================================
- -- create_table(:sources)
- NOTICE: CREATE TABLE will create implicit sequence "sources_id_seq" for serial column "sources.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sources_pkey" for table "sources"
- -> 0.0075s
- -- add_index(:sources, :value)
- -> 0.0035s
- == CreateSources: migrated (0.0113s) =========================================
- == CreateLogs: migrating =====================================================
- -- create_table(:logs)
- NOTICE: CREATE TABLE will create implicit sequence "logs_id_seq" for serial column "logs.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "logs_pkey" for table "logs"
- -> 0.0044s
- -- add_index(:logs, :report_id)
- -> 0.0037s
- -- add_index(:logs, :message_id)
- -> 0.0038s
- -- add_index(:logs, :level_id)
- -> 0.0039s
- == CreateLogs: migrated (0.0161s) ============================================
- == AddMetricsToReport: migrating =============================================
- -- add_column(:reports, :metrics, :text)
- -> 0.0008s
- == AddMetricsToReport: migrated (0.0009s) ====================================
- == ConvertReports: migrating =================================================
- -- About to convert all of the 0 reports log field into a more DB optimized way... this might take a while.....
- -- remove_column(:reports, :log)
- -> 0.0005s
- == ConvertReports: migrated (0.0029s) ========================================
- == AddOwnedFilterToUser: migrating ===========================================
- -- add_column(:users, :filter_on_owner, :boolean)
- -> 0.0006s
- == AddOwnedFilterToUser: migrated (0.0006s) ==================================
- == CorrectMedia: migrating ===================================================
- -- table_exists?(:medias)
- -> 0.0006s
- == CorrectMedia: migrated (0.0008s) ==========================================
- == CreateConfigTemplates: migrating ==========================================
- -- create_table(:config_templates)
- NOTICE: CREATE TABLE will create implicit sequence "config_templates_id_seq" for serial column "config_templates.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "config_templates_pkey" for table "config_templates"
- -> 0.0071s
- == CreateConfigTemplates: migrated (0.0072s) =================================
- == CreateTemplateCombinations: migrating =====================================
- -- create_table(:template_combinations)
- NOTICE: CREATE TABLE will create implicit sequence "template_combinations_id_seq" for serial column "template_combinations.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "template_combinations_pkey" for table "template_combinations"
- -> 0.0045s
- == CreateTemplateCombinations: migrated (0.0047s) ============================
- == CreateOperatingsystemsConfigTemplates: migrating ==========================
- -- create_table(:config_templates_operatingsystems, {:id=>false})
- -> 0.0010s
- == CreateOperatingsystemsConfigTemplates: migrated (0.0011s) =================
- == CreateTemplateKinds: migrating ============================================
- -- create_table(:template_kinds)
- NOTICE: CREATE TABLE will create implicit sequence "template_kinds_id_seq" for serial column "template_kinds.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "template_kinds_pkey" for table "template_kinds"
- -> 0.0042s
- == CreateTemplateKinds: migrated (0.0043s) ===================================
- == CreateOsDefaultTemplates: migrating =======================================
- -- create_table(:os_default_templates)
- NOTICE: CREATE TABLE will create implicit sequence "os_default_templates_id_seq" for serial column "os_default_templates.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "os_default_templates_pkey" for table "os_default_templates"
- -> 0.0039s
- == CreateOsDefaultTemplates: migrated (0.0040s) ==============================
- == AddDefaultTemplates: migrating ============================================
- == AddDefaultTemplates: migrated (0.0000s) ===================================
- == AddSubSystemsToSubnet: migrating ==========================================
- -- add_column(:subnets, :dhcp_id, :integer)
- -> 0.0008s
- -- add_column(:subnets, :tftp_id, :integer)
- -> 0.0003s
- -- rename_column(:subnets, :number, :network)
- -> 0.0004s
- == AddSubSystemsToSubnet: migrated (0.0017s) =================================
- == CreateProxies: migrating ==================================================
- -- create_table(:smart_proxies)
- NOTICE: CREATE TABLE will create implicit sequence "smart_proxies_id_seq" for serial column "smart_proxies.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "smart_proxies_pkey" for table "smart_proxies"
- -> 0.0074s
- == CreateProxies: migrated (0.0075s) =========================================
- == AddProxyToDomain: migrating ===============================================
- -- add_column(:domains, :dns_id, :integer)
- -> 0.0006s
- -- remove_column(:domains, :dnsserver)
- -> 0.0003s
- -- remove_column(:domains, :gateway)
- -> 0.0004s
- == AddProxyToDomain: migrated (0.0016s) ======================================
- == AddGrubbyTemplate: migrating ==============================================
- == AddGrubbyTemplate: migrated (0.0000s) =====================================
- == AddHostGroupDefaults: migrating ===========================================
- -- add_column(:hostgroups, :environment_id, :integer)
- -> 0.0006s
- -- add_column(:hostgroups, :operatingsystem_id, :integer)
- -> 0.0004s
- -- add_column(:hostgroups, :architecture_id, :integer)
- -> 0.0004s
- -- add_column(:hostgroups, :medium_id, :integer)
- -> 0.0003s
- -- add_column(:hostgroups, :ptable_id, :integer)
- -> 0.0003s
- -- add_column(:hostgroups, :root_pass, :string)
- -> 0.0029s
- -- add_column(:hostgroups, :puppetmaster, :string)
- -> 0.0004s
- == AddHostGroupDefaults: migrated (0.0057s) ==================================
- == AddDefaultPxeMenuTemplate: migrating ======================================
- == AddDefaultPxeMenuTemplate: migrated (0.0000s) =============================
- == CreateProxyFeatures: migrating ============================================
- -- create_table(:features)
- NOTICE: CREATE TABLE will create implicit sequence "features_id_seq" for serial column "features.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "features_pkey" for table "features"
- -> 0.0045s
- -- create_table(:features_smart_proxies, {:id=>false})
- -> 0.0009s
- == CreateProxyFeatures: migrated (0.0055s) ===================================
- == ChangePuppetmasterColumn: migrating =======================================
- -- rename_column(:hosts, :puppetmaster, :puppetmaster_name)
- -> 0.0006s
- -- add_column(:hosts, :puppetproxy_id, :integer)
- -> 0.0004s
- -- rename_column(:hostgroups, :puppetmaster, :puppetmaster_name)
- -> 0.0003s
- -- add_column(:hostgroups, :puppetproxy_id, :integer)
- -> 0.0005s
- == ChangePuppetmasterColumn: migrated (0.0020s) ==============================
- == AddManagedToHosts: migrating ==============================================
- -- add_column(:hosts, :managed, :boolean)
- -> 0.0008s
- == AddManagedToHosts: migrated (0.0045s) =====================================
- == RevertFaceNamesAndValuesToTextRecords: migrating ==========================
- == RevertFaceNamesAndValuesToTextRecords: migrated (0.0001s) =================
- == AddPriorityToParameter: migrating =========================================
- -- add_column(:parameters, :priority, :integer)
- -> 0.0007s
- == AddPriorityToParameter: migrated (0.0039s) ================================
- == AddMediaPathToMedium: migrating ===========================================
- -- add_column(:media, :media_path, :string, {:limit=>128})
- -> 0.0007s
- -- add_column(:media, :config_path, :string, {:limit=>128})
- -> 0.0003s
- -- add_column(:media, :image_path, :string, {:limit=>128})
- -> 0.0029s
- == AddMediaPathToMedium: migrated (0.0042s) ==================================
- == AddImageToHost: migrating =================================================
- -- add_column(:hosts, :use_image, :boolean)
- -> 0.0007s
- -- add_column(:hosts, :image_file, :string, {:limit=>128})
- -> 0.0003s
- -- add_column(:hostgroups, :use_image, :boolean)
- -> 0.0004s
- -- add_column(:hostgroups, :image_file, :string, {:limit=>128})
- -> 0.0004s
- == AddImageToHost: migrated (0.0021s) ========================================
- == RemoveUnusedFieldsFromPuppetClasses: migrating ============================
- -- remove_column(:puppetclasses, :nameindicator)
- -> 0.0005s
- -- remove_column(:puppetclasses, :operatingsystem_id)
- -> 0.0003s
- == RemoveUnusedFieldsFromPuppetClasses: migrated (0.0010s) ===================
- == AddTableBookmarks: migrating ==============================================
- -- create_table(:bookmarks, {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "bookmarks_id_seq" for serial column "bookmarks.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "bookmarks_pkey" for table "bookmarks"
- -> 0.0092s
- -- add_index(:bookmarks, :name)
- -> 0.0040s
- -- add_index(:bookmarks, :controller)
- -> 0.0038s
- -- add_index(:bookmarks, [:owner_id, :owner_type])
- -> 0.0042s
- == AddTableBookmarks: migrated (0.0216s) =====================================
- == AddSolarisTemplates: migrating ============================================
- == AddSolarisTemplates: migrated (0.0000s) ===================================
- == AddSolarisDisks: migrating ================================================
- == AddSolarisDisks: migrated (0.0000s) =======================================
- == AddLookUpKeyIdToPuppetClass: migrating ====================================
- -- add_column(:lookup_keys, :puppetclass_id, :integer)
- -> 0.0006s
- -- add_index(:lookup_keys, :puppetclass_id)
- -> 0.0035s
- -- add_column(:lookup_keys, :default_value, :string)
- -> 0.0028s
- -- add_column(:lookup_keys, :path, :string)
- -> 0.0003s
- -- add_index(:lookup_keys, :path)
- -> 0.0039s
- -- add_column(:lookup_keys, :description, :string)
- -> 0.0004s
- -- add_column(:lookup_keys, :validator_type, :string)
- -> 0.0003s
- -- add_column(:lookup_keys, :validator_rule, :string)
- -> 0.0003s
- -- rename_column(:lookup_values, :priority, :match)
- -> 0.0003s
- -- add_index(:lookup_values, :match)
- -> 0.0038s
- == AddLookUpKeyIdToPuppetClass: migrated (0.0168s) ===========================
- == AddSparcInfoToModel: migrating ============================================
- -- add_column(:models, :vendor_class, :string, {:limit=>32})
- -> 0.0008s
- -- add_column(:models, :hardware_model, :string, {:limit=>16})
- -> 0.0004s
- == AddSparcInfoToModel: migrated (0.0015s) ===================================
- == AddAncestryToHostgroup: migrating =========================================
- -- add_column(:hostgroups, :ancestry, :string)
- -> 0.0005s
- -- add_index(:hostgroups, :ancestry)
- -> 0.0042s
- == AddAncestryToHostgroup: migrated (0.0048s) ================================
- == CreateSettings: migrating =================================================
- -- create_table(:settings)
- NOTICE: CREATE TABLE will create implicit sequence "settings_id_seq" for serial column "settings.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "settings_pkey" for table "settings"
- -> 0.0116s
- -- add_index(:settings, :name, {:unique=>true})
- -> 0.0042s
- == CreateSettings: migrated (0.0160s) ========================================
- == UpdateAuditsTable: migrating ==============================================
- == UpdateAuditsTable: migrated (0.0026s) =====================================
- == CreateHostClass: migrating ================================================
- -- rename_table(:hosts_puppetclasses, :host_classes)
- -> 0.0035s
- -- add_column(:host_classes, :id, :primary_key)
- NOTICE: ALTER TABLE will create implicit sequence "host_classes_id_seq" for serial column "host_classes.id"
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "host_classes_pkey" for table "host_classes"
- -> 0.0044s
- == CreateHostClass: migrated (0.0081s) =======================================
- == AddSuseTemplates: migrating ===============================================
- == AddSuseTemplates: migrated (0.0000s) ======================================
- == AddVmDefaultsToHostgroup: migrating =======================================
- -- add_column(:hostgroups, :vm_defaults, :text)
- -> 0.0008s
- == AddVmDefaultsToHostgroup: migrated (0.0009s) ==============================
- == AddSubnetAndDomainToHostGroups: migrating =================================
- -- column_exists?(:hostgroups, :subnet_id)
- -> 0.0010s
- -- add_column(:hostgroups, :subnet_id, :integer)
- -> 0.0006s
- -- column_exists?(:hostgroups, :domain_id)
- -> 0.0009s
- -- add_column(:hostgroups, :domain_id, :integer)
- -> 0.0003s
- == AddSubnetAndDomainToHostGroups: migrated (0.0032s) ========================
- == RenameChangesToAuditedChanges: migrating ==================================
- -- rename_column(:audits, :changes, :audited_changes)
- -> 0.1051s
- == RenameChangesToAuditedChanges: migrated (0.1052s) =========================
- == AddRemoteAddressToAudits: migrating =======================================
- -- add_column(:audits, :remote_address, :string)
- -> 0.0008s
- == AddRemoteAddressToAudits: migrated (0.0009s) ==============================
- == RenameParentToAssociation: migrating ======================================
- -- rename_column(:audits, :auditable_parent_id, :association_id)
- -> 0.0006s
- -- rename_column(:audits, :auditable_parent_type, :association_type)
- -> 0.0004s
- == RenameParentToAssociation: migrated (0.0012s) =============================
- == AddGatewayAndDnsToSubnets: migrating ======================================
- -- add_column(:subnets, :gateway, :string)
- -> 0.0007s
- -- add_column(:subnets, :dns_primary, :string)
- -> 0.0004s
- -- add_column(:subnets, :dns_secondary, :string)
- -> 0.0004s
- == AddGatewayAndDnsToSubnets: migrated (0.0017s) =============================
- == EnsureAllHostnamesAreLowercase: migrating =================================
- -- execute("UPDATE hosts SET name=LOWER(name)")
- -> 0.0005s
- == EnsureAllHostnamesAreLowercase: migrated (0.0006s) ========================
- == AddFromAndToRangesToSubnets: migrating ====================================
- -- add_column(:subnets, :from, :string)
- -> 0.0006s
- -- add_column(:subnets, :to, :string)
- -> 0.0003s
- -- remove_column(:subnets, :ranges)
- -> 0.0005s
- == AddFromAndToRangesToSubnets: migrated (0.0016s) ===========================
- == CreateSubnetDomain: migrating =============================================
- -- create_table(:subnet_domains)
- NOTICE: CREATE TABLE will create implicit sequence "subnet_domains_id_seq" for serial column "subnet_domains.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "subnet_domains_pkey" for table "subnet_domains"
- -> 0.0059s
- -- remove_column(:subnets, :domain_id)
- -> 0.0005s
- == CreateSubnetDomain: migrated (0.0097s) ====================================
- == CreateComputeResources: migrating =========================================
- -- create_table(:compute_resources)
- NOTICE: CREATE TABLE will create implicit sequence "compute_resources_id_seq" for serial column "compute_resources.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "compute_resources_pkey" for table "compute_resources"
- -> 0.0075s
- == CreateComputeResources: migrated (0.0076s) ================================
- == AddUuidAndComputeIdToHost: migrating ======================================
- -- add_column(:hosts, :uuid, :string)
- -> 0.0007s
- -- add_column(:hosts, :compute_resource_id, :integer)
- -> 0.0004s
- == AddUuidAndComputeIdToHost: migrated (0.0013s) =============================
- == AddWindowsTemplates: migrating ============================================
- == AddWindowsTemplates: migrated (0.0000s) ===================================
- == CreateNics: migrating =====================================================
- -- create_table(:nics)
- NOTICE: CREATE TABLE will create implicit sequence "nics_id_seq" for serial column "nics.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nics_pkey" for table "nics"
- -> 0.0075s
- -- add_index(:nics, [:type], {:name=>"index_by_type"})
- -> 0.0038s
- -- add_index(:nics, [:host_id], {:name=>"index_by_host"})
- -> 0.0038s
- -- add_index(:nics, [:type, :id], {:name=>"index_by_type_and_id"})
- -> 0.0040s
- -- remove_columns(:hosts, :sp_mac, :sp_ip, :sp_name, :sp_subnet_id)
- -> 0.0015s
- == CreateNics: migrated (0.0226s) ============================================
- == AddPuppetMasterProxyToHostAndHostGroup: migrating =========================
- -- rename_column(:hosts, :puppetproxy_id, :puppet_ca_proxy_id)
- -> 0.0007s
- -- add_column(:hosts, :puppet_proxy_id, :integer)
- -> 0.0005s
- -- rename_column(:hostgroups, :puppetproxy_id, :puppet_ca_proxy_id)
- -> 0.0003s
- -- add_column(:hostgroups, :puppet_proxy_id, :integer)
- -> 0.0003s
- -- remove_column(:hosts, :puppetmaster_name)
- -> 0.0005s
- -- remove_column(:hostgroups, :puppetmaster_name)
- -> 0.0003s
- == AddPuppetMasterProxyToHostAndHostGroup: migrated (0.0086s) ================
- == UpdateReportFieldToLargeInt: migrating ====================================
- -- change_column(:reports, :status, :bigint)
- -> 0.0227s
- -- change_column(:hosts, :puppet_status, :bigint)
- -> 0.0637s
- == UpdateReportFieldToLargeInt: migrated (0.0867s) ===========================
- == CreateImages: migrating ===================================================
- -- create_table(:images)
- NOTICE: CREATE TABLE will create implicit sequence "images_id_seq" for serial column "images.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "images_pkey" for table "images"
- -> 0.0105s
- == CreateImages: migrated (0.0106s) ==========================================
- == AddCertNameToHost: migrating ==============================================
- -- add_column(:hosts, :certname, :string)
- -> 0.0008s
- -- add_index("hosts", :certname)
- -> 0.0081s
- == AddCertNameToHost: migrated (0.0090s) =====================================
- == CreateKeyPairs: migrating =================================================
- -- create_table(:key_pairs)
- NOTICE: CREATE TABLE will create implicit sequence "key_pairs_id_seq" for serial column "key_pairs.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "key_pairs_pkey" for table "key_pairs"
- -> 0.0076s
- == CreateKeyPairs: migrated (0.0077s) ========================================
- == AddDnsIdToSubnet: migrating ===============================================
- -- add_column(:subnets, :dns_id, :integer)
- -> 0.0006s
- == AddDnsIdToSubnet: migrated (0.0007s) ======================================
- == AddImageIdToHost: migrating ===============================================
- -- add_column(:hosts, :image_id, :integer)
- -> 0.0006s
- == AddImageIdToHost: migrated (0.0007s) ======================================
- == AddUserComputeResources: migrating ========================================
- -- create_table(:user_compute_resources, {:id=>false})
- -> 0.0014s
- == AddUserComputeResources: migrated (0.0016s) ===============================
- == AddComputeResourcesBooleanToUser: migrating ===============================
- -- add_column(:users, :compute_resources_andor, :string, {:limit=>3, :default=>"or"})
- -> 0.0127s
- == AddComputeResourcesBooleanToUser: migrated (0.0128s) ======================
- == AddEpelSnippets: migrating ================================================
- == AddEpelSnippets: migrated (0.0000s) =======================================
- == ConvertParamsToText: migrating ============================================
- -- change_column("parameters", :value, :text)
- -> 0.0303s
- -- change_column("lookup_values", :value, :text)
- -> 0.0323s
- == ConvertParamsToText: migrated (0.0628s) ===================================
- == ChangeBookmarkColumnToText: migrating =====================================
- -- change_column("bookmarks", :query, :text)
- -> 0.0258s
- == ChangeBookmarkColumnToText: migrated (0.0260s) ============================
- == RenameAssociationToAssociated: migrating ==================================
- -- index_exists?(:audits, [:association_id, :association_type], {:name=>"association_index"})
- -> 0.0027s
- -- column_exists?(:audits, :association_id)
- -> 0.0008s
- -- rename_column(:audits, :association_id, :associated_id)
- -> 0.0006s
- -- column_exists?(:audits, :association_type)
- -> 0.0007s
- -- rename_column(:audits, :association_type, :associated_type)
- -> 0.0003s
- -- index_exists?(:audits, [:association_id, :association_type], {:name=>"association_index"})
- -> 0.0020s
- -- add_index(:audits, [:associated_id, :associated_type], {:name=>"associated_index"})
- -> 0.0078s
- == RenameAssociationToAssociated: migrated (0.0153s) =========================
- == FixAuditableType: migrating ===============================================
- -- execute("UPDATE audits SET auditable_type='Host' WHERE auditable_type='Puppet::Rails::Host'")
- -> 0.0007s
- == FixAuditableType: migrated (0.0008s) ======================================
- == FixAssociatedType: migrating ==============================================
- -- execute("UPDATE audits SET associated_type='Host' WHERE associated_type='Puppet::Rails::Host'")
- -> 0.0006s
- == FixAssociatedType: migrated (0.0007s) =====================================
- == CreateTaxonomies: migrating ===============================================
- -- create_table(:taxonomies)
- NOTICE: CREATE TABLE will create implicit sequence "taxonomies_id_seq" for serial column "taxonomies.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxonomies_pkey" for table "taxonomies"
- -> 0.0115s
- == CreateTaxonomies: migrated (0.0117s) ======================================
- == AddOkHostsBookMark: migrating =============================================
- == AddOkHostsBookMark: migrated (0.0000s) ====================================
- == AddAuditableNameAndAssociatedNameToAudit: migrating =======================
- -- column_exists?(:audits, :auditable_name)
- -> 0.0010s
- -- add_column(:audits, :auditable_name, :string)
- -> 0.0006s
- -- column_exists?(:audits, :associated_name)
- -> 0.0008s
- -- add_column(:audits, :associated_name, :string)
- -> 0.0003s
- -- index_exists?(:audits, :id)
- -> 0.0026s
- -- add_index(:audits, :id)
- -> 0.0052s
- -- About to review all audits, this may take a while...
- == AddAuditableNameAndAssociatedNameToAudit: migrated (0.0195s) ==============
- == AddOsFamilyToMedia: migrating =============================================
- -- add_column(:media, :os_family, :string)
- -> 0.0006s
- == AddOsFamilyToMedia: migrated (0.0028s) ====================================
- == AddOsFamilyToPtable: migrating ============================================
- -- column_exists?(:ptables, :os_family)
- -> 0.0007s
- -- add_column(:ptables, :os_family, :string)
- -> 0.0007s
- -- column_exists?(:ptables, :operatingsystem_id)
- -> 0.0006s
- -- remove_column(:ptables, :operatingsystem_id)
- -> 0.0003s
- == AddOsFamilyToPtable: migrated (0.1377s) ===================================
- == AddAttributesToComputeResources: migrating ================================
- -- column_exists?(:compute_resources, :attrs)
- -> 0.0007s
- -- add_column(:compute_resources, :attrs, :text)
- -> 0.0005s
- == AddAttributesToComputeResources: migrated (0.0013s) =======================
- == AddSomeIndexes: migrating =================================================
- -- add_index(:environments_puppetclasses, :puppetclass_id)
- -> 0.0030s
- -- add_index(:environments_puppetclasses, :environment_id)
- -> 0.0102s
- -- add_index(:puppetclasses, :name)
- -> 0.0057s
- -- add_index(:hostgroups_puppetclasses, :puppetclass_id)
- -> 0.0073s
- -- add_index(:hostgroups_puppetclasses, :hostgroup_id)
- -> 0.0083s
- == AddSomeIndexes: migrated (0.0349s) ========================================
- == CreateEnvironmentClasses: migrating =======================================
- -- rename_table(:environments_puppetclasses, :environment_classes)
- -> 0.0029s
- -- add_column(:environment_classes, :id, :primary_key)
- NOTICE: ALTER TABLE will create implicit sequence "environment_classes_id_seq" for serial column "environment_classes.id"
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "environment_classes_pkey" for table "environment_classes"
- -> 0.0169s
- -- add_column(:environment_classes, :lookup_key_id, :integer)
- -> 0.0005s
- == CreateEnvironmentClasses: migrated (0.0205s) ==============================
- == AddLookupKeysOverrideAndRequired: migrating ===============================
- -- add_column(:lookup_keys, :is_param, :boolean, {:default=>false})
- -> 0.0224s
- -- add_column(:lookup_keys, :key_type, :string, {:default=>nil})
- -> 0.0313s
- -- add_column(:lookup_keys, :override, :boolean, {:default=>false})
- -> 0.0250s
- -- add_column(:lookup_keys, :required, :boolean, {:default=>false})
- -> 0.0254s
- == AddLookupKeysOverrideAndRequired: migrated (0.1048s) ======================
- == AddLookupValuesCountToLookupKeys: migrating ===============================
- -- add_column(:lookup_keys, :lookup_values_count, :integer, {:default=>0})
- -> 0.0238s
- == AddLookupValuesCountToLookupKeys: migrated (0.0240s) ======================
- == CacheLookupValuesCount: migrating =========================================
- -- execute("update lookup_keys set lookup_values_count=(select count(*) from lookup_values where lookup_key_id=lookup_keys.id)")
- -> 0.0009s
- == CacheLookupValuesCount: migrated (0.0010s) ================================
- == AddIamRoleToImages: migrating =============================================
- -- add_column(:images, :iam_role, :string)
- -> 0.0009s
- == AddIamRoleToImages: migrated (0.0012s) ====================================
- == CreateTokens: migrating ===================================================
- -- create_table(:tokens)
- NOTICE: CREATE TABLE will create implicit sequence "tokens_id_seq" for serial column "tokens.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tokens_pkey" for table "tokens"
- -> 0.0085s
- -- add_index(:tokens, :value)
- -> 0.0073s
- -- add_index(:tokens, :host_id)
- -> 0.0086s
- == CreateTokens: migrated (0.0247s) ==========================================
- == AddBmcFeatureToProxy: migrating ===========================================
- == AddBmcFeatureToProxy: migrated (0.0000s) ==================================
- == AddTaxonomyIdsToHosts: migrating ==========================================
- -- add_column(:hosts, :organization_id, :integer)
- -> 0.0008s
- -- add_column(:hosts, :location_id, :integer)
- -> 0.0004s
- == AddTaxonomyIdsToHosts: migrated (0.0013s) =================================
- == ChangeDomainCharacterCount: migrating =====================================
- -- change_column(:domains, :fullname, :string, {:limit=>254})
- -> 0.0114s
- == ChangeDomainCharacterCount: migrated (0.0116s) ============================
- == CreateTrends: migrating ===================================================
- -- create_table(:trends)
- NOTICE: CREATE TABLE will create implicit sequence "trends_id_seq" for serial column "trends.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trends_pkey" for table "trends"
- -> 0.0067s
- -- add_index(:trends, :type)
- -> 0.0033s
- -- add_index(:trends, [:trendable_type, :trendable_id])
- -> 0.0030s
- -- add_index(:trends, :fact_value)
- -> 0.0068s
- == CreateTrends: migrated (0.0203s) ==========================================
- == CreateTrendCounters: migrating ============================================
- -- create_table(:trend_counters)
- NOTICE: CREATE TABLE will create implicit sequence "trend_counters_id_seq" for serial column "trend_counters.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trend_counters_pkey" for table "trend_counters"
- -> 0.0038s
- -- add_index(:trend_counters, :trend_id)
- -> 0.0026s
- == CreateTrendCounters: migrated (0.0066s) ===================================
- == UpdateMediaPathLimit: migrating ===========================================
- -- change_column(:media, :path, :string, {:limit=>255})
- -> 0.0065s
- == UpdateMediaPathLimit: migrated (0.0066s) ==================================
- == CreateHostgroupClasses: migrating =========================================
- -- rename_table(:hostgroups_puppetclasses, :hostgroup_classes)
- -> 0.0029s
- -- add_column(:hostgroup_classes, :id, :primary_key)
- NOTICE: ALTER TABLE will create implicit sequence "hostgroup_classes_id_seq" for serial column "hostgroup_classes.id"
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "hostgroup_classes_pkey" for table "hostgroup_classes"
- -> 0.0072s
- == CreateHostgroupClasses: migrated (0.0103s) ================================
- == AddLocalbootTemplate: migrating ===========================================
- == AddLocalbootTemplate: migrated (0.0000s) ==================================
- == RenameReplyAdressSetting: migrating =======================================
- -- execute("UPDATE settings SET name='email_reply_address' WHERE name='email_replay_adress'")
- -> 0.0006s
- == RenameReplyAdressSetting: migrated (0.0007s) ==============================
- == AddLocationsOrganizations: migrating ======================================
- -- create_table(:locations_organizations, {:id=>false})
- -> 0.0010s
- == AddLocationsOrganizations: migrated (0.0011s) =============================
- == MigrateHypervisorsToComputeResources: migrating ===========================
- == MigrateHypervisorsToComputeResources: migrated (0.0011s) ==================
- == CreateTaxableTaxonomies: migrating ========================================
- -- create_table(:taxable_taxonomies)
- NOTICE: CREATE TABLE will create implicit sequence "taxable_taxonomies_id_seq" for serial column "taxable_taxonomies.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxable_taxonomies_pkey" for table "taxable_taxonomies"
- -> 0.0038s
- -- add_index(:taxable_taxonomies, [:taxable_id, :taxable_type])
- -> 0.0027s
- -- add_index(:taxable_taxonomies, [:taxable_id, :taxable_type, :taxonomy_id], {:name=>"taxable_index"})
- -> 0.0029s
- -- add_index(:taxable_taxonomies, :taxonomy_id)
- -> 0.0032s
- == CreateTaxableTaxonomies: migrated (0.0129s) ===============================
- == AddMyTaxonomyToUser: migrating ============================================
- -- add_column(:users, :organizations_andor, :string, {:limit=>3, :default=>"or"})
- -> 0.0057s
- -- add_column(:users, :locations_andor, :string, {:limit=>3, :default=>"or"})
- -> 0.0053s
- == AddMyTaxonomyToUser: migrated (0.0112s) ===================================
- == AddSubscribeToAllHostgroupsToUsers: migrating =============================
- -- column_exists?(:users, :subscribe_to_all_hostgroups)
- -> 0.0013s
- -- add_column(:users, :subscribe_to_all_hostgroups, :boolean)
- -> 0.0006s
- == AddSubscribeToAllHostgroupsToUsers: migrated (0.0021s) ====================
- == ChangeSmartVariableLength: migrating ======================================
- -- change_column(:lookup_keys, :default_value, :text)
- -> 0.0255s
- == ChangeSmartVariableLength: migrated (0.0257s) =============================
- == RemoveReplayAddressSetting: migrating =====================================
- -- execute("DELETE FROM settings WHERE name='email_replay_address'")
- -> 0.0004s
- == RemoveReplayAddressSetting: migrated (0.0005s) ============================
- == AddIgnoreTypesToTaxonomy: migrating =======================================
- -- add_column(:taxonomies, :ignore_types, :text)
- -> 0.0010s
- == AddIgnoreTypesToTaxonomy: migrated (0.0011s) ==============================
- == AddDigestToMessages: migrating ============================================
- -- index_exists?(:messages, :value)
- -> 0.0013s
- -- remove_index(:messages, :value)
- -> 0.0013s
- -- add_column(:messages, :digest, :string)
- -> 0.0004s
- -- add_index(:messages, :digest)
- -> 0.0033s
- == AddDigestToMessages: migrated (0.0214s) ===================================
- == AddStiToHosts: migrating ==================================================
- -- add_column(:hosts, :type, :string)
- -> 0.0010s
- -- execute("UPDATE hosts set type='Host::Managed'")
- -> 0.0007s
- -- add_index(:hosts, :type)
- -> 0.0065s
- == AddStiToHosts: migrated (0.0084s) =========================================
- == AddDigestToSources: migrating =============================================
- -- index_exists?(:sources, :value)
- -> 0.0016s
- -- remove_index(:sources, :value)
- -> 0.0014s
- -- add_column(:sources, :digest, :string)
- -> 0.0006s
- -- add_index(:sources, :digest)
- -> 0.0035s
- == AddDigestToSources: migrated (0.0229s) ====================================
- == RemoveDuplicateSnippets: migrating ========================================
- == RemoveDuplicateSnippets: migrated (0.1683s) ===============================
- == AddLabelToHostGroup: migrating ============================================
- -- add_column(:hostgroups, :label, :string)
- -> 0.0011s
- -- execute("UPDATE hostgroups set label = name WHERE ancestry IS NULL")
- -> 0.0003s
- == AddLabelToHostGroup: migrated (0.0043s) ===================================
- == AddStiToSettings: migrating ===============================================
- -- execute("UPDATE settings set category='Setting::Auth' where category='Auth'")
- -> 0.0003s
- -- execute("UPDATE settings set category='Setting::General' where category='General'")
- -> 0.0003s
- -- execute("UPDATE settings set category='Setting::Puppet' where category='Puppet'")
- -> 0.0002s
- -- execute("UPDATE settings set category='Setting::Provisioning' where category='Provisioning'")
- -> 0.0002s
- -- add_index(:settings, :category)
- -> 0.0036s
- == AddStiToSettings: migrated (0.0048s) ======================================
- == FixStiHostAuditableType: migrating ========================================
- -- execute("UPDATE audits SET auditable_type='Host' WHERE auditable_type='Host::Base'")
- -> 0.0004s
- == FixStiHostAuditableType: migrated (0.0005s) ===============================
- == AddIdToUserHostgroup: migrating ===========================================
- -- add_column(:user_hostgroups, :id, :primary_key)
- NOTICE: ALTER TABLE will create implicit sequence "user_hostgroups_id_seq" for serial column "user_hostgroups.id"
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "user_hostgroups_pkey" for table "user_hostgroups"
- -> 0.0044s
- == AddIdToUserHostgroup: migrated (0.0045s) ==================================
- == AddLocaleToUsers: migrating ===============================================
- -- add_column(:users, :locale, :string, {:limit=>5, :null=>true})
- -> 0.0011s
- == AddLocaleToUsers: migrated (0.0013s) ======================================
- == RemoveDuplicateFactNames: migrating =======================================
- == RemoveDuplicateFactNames: migrated (0.0195s) ==============================
- == AddUniqueConstraintToFactName: migrating ==================================
- -- remove_index(:fact_names, {:column=>:name})
- -> 0.0019s
- -- add_index(:fact_names, :name, {:unique=>true})
- -> 0.0055s
- == AddUniqueConstraintToFactName: migrated (0.0077s) =========================
- == AddUniqueConstraintsToFactValues: migrating ===============================
- -- add_index(:fact_values, [:fact_name_id, :host_id], {:unique=>true})
- -> 0.0064s
- == AddUniqueConstraintsToFactValues: migrated (0.0066s) ======================
- == ChangeColumnLengths: migrating ============================================
- -- change_column(:media, :name, :string, {:null=>false, :default=>"", :limit=>255})
- -> 0.0076s
- -- change_column(:media, :media_path, :string, {:limit=>255})
- -> 0.0056s
- -- change_column(:media, :config_path, :string, {:limit=>255})
- -> 0.0056s
- -- change_column(:media, :image_path, :string, {:limit=>255})
- -> 0.0054s
- -- change_column(:architectures, :name, :string, {:default=>"x86_64", :null=>false, :limit=>255})
- -> 0.0045s
- -- change_column(:auth_sources, :type, :string, {:null=>false, :default=>"", :limit=>255})
- -> 0.0067s
- -- change_column(:auth_sources, :name, :string, {:null=>false, :default=>"", :limit=>255})
- -> 0.0072s
- -- change_column(:auth_sources, :host, :string, {:limit=>255})
- -> 0.0058s
- -- change_column(:auth_sources, :account_password, :string, {:limit=>255})
- -> 0.0059s
- -- change_column(:auth_sources, :attr_login, :string, {:limit=>255})
- -> 0.0063s
- -- change_column(:auth_sources, :attr_firstname, :string, {:limit=>255})
- -> 0.0061s
- -- change_column(:auth_sources, :attr_lastname, :string, {:limit=>255})
- -> 0.0055s
- -- change_column(:auth_sources, :attr_mail, :string, {:limit=>255})
- -> 0.0056s
- -- change_column(:domains, :fullname, :string, {:limit=>255})
- -> 0.0056s
- -- change_column(:features, :name, :string, {:limit=>255})
- -> 0.0036s
- -- change_column(:hosts, :mac, :string, {:default=>"", :limit=>255})
- -> 0.0399s
- -- change_column(:hosts, :root_pass, :string, {:limit=>255})
- -> 0.0284s
- -- change_column(:hosts, :serial, :string, {:limit=>255})
- -> 0.0282s
- -- change_column(:models, :name, :string, {:null=>false, :limit=>255})
- -> 0.0061s
- -- change_column(:models, :vendor_class, :string, {:limit=>255})
- -> 0.0054s
- -- change_column(:models, :hardware_model, :string, {:limit=>255})
- -> 0.0055s
- -- change_column(:operatingsystems, :name, :string, {:limit=>255})
- -> 0.0044s
- -- change_column(:operatingsystems, :release_name, :string, {:limit=>255})
- -> 0.0091s
- -- change_column(:operatingsystems, :type, :string, {:limit=>255})
- -> 0.0077s
- -- change_column(:ptables, :name, :string, {:null=>false, :limit=>255})
- -> 0.1120s
- -- change_column(:roles, :name, :string, {:limit=>255})
- -> 0.0177s
- == ChangeColumnLengths: migrated (0.3544s) ===================================
- == AddTemplatesToFeatures: migrating =========================================
- == AddTemplatesToFeatures: migrated (0.1537s) ================================
- == RemoveEnvironmentFromHost: migrating ======================================
- -- remove_column(:hosts, :environment)
- -> 0.0012s
- == RemoveEnvironmentFromHost: migrated (0.0013s) =============================
- == AddPublicToKeyPairs: migrating ============================================
- -- add_column(:key_pairs, :public, :text)
- -> 0.0012s
- == AddPublicToKeyPairs: migrated (0.0014s) ===================================
- == ChangeComputeResourcePasswordToText: migrating ============================
- -- change_column(:compute_resources, :password, :text)
- -> 0.0069s
- -- 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.
- == ChangeComputeResourcePasswordToText: migrated (0.0071s) ===================
- == AddLdapFilterToAuthSources: migrating =====================================
- -- add_column(:auth_sources, :ldap_filter, :string, {:limit=>255, :null=>true})
- -> 0.0009s
- == AddLdapFilterToAuthSources: migrated (0.0011s) ============================
- == DeleteOrphanedRecords: migrating ==========================================
- -- execute("DELETE FROM architectures_operatingsystems WHERE architecture_id NOT IN (SELECT id FROM architectures) OR operatingsystem_id NOT IN (SELECT id FROM operatingsystems)")
- -> 0.0008s
- -- execute("DELETE FROM config_templates_operatingsystems WHERE config_template_id NOT IN (SELECT id FROM config_templates) OR operatingsystem_id NOT IN (SELECT id FROM operatingsystems)")
- -> 0.0005s
- -- execute("DELETE FROM features_smart_proxies WHERE feature_id NOT IN (SELECT id FROM features) OR smart_proxy_id NOT IN (SELECT id FROM smart_proxies)")
- -> 0.0007s
- -- execute("DELETE FROM features_smart_proxies WHERE feature_id NOT IN (SELECT id FROM features) OR smart_proxy_id NOT IN (SELECT id FROM smart_proxies)")
- -> 0.0003s
- -- execute("DELETE FROM media_operatingsystems WHERE medium_id NOT IN (SELECT id FROM media) OR operatingsystem_id NOT IN (SELECT id FROM operatingsystems)")
- -> 0.0007s
- -- execute("DELETE FROM operatingsystems_ptables WHERE ptable_id NOT IN (SELECT id FROM ptables) OR operatingsystem_id NOT IN (SELECT id FROM operatingsystems)")
- -> 0.0006s
- -- execute("DELETE FROM operatingsystems_puppetclasses WHERE puppetclass_id NOT IN (SELECT id FROM puppetclasses) OR operatingsystem_id NOT IN (SELECT id FROM operatingsystems)")
- -> 0.0006s
- -- execute("DELETE FROM subnet_domains WHERE domain_id NOT IN (SELECT id FROM domains) OR subnet_id NOT IN (SELECT id FROM subnets)")
- -> 0.0008s
- -- execute("DELETE FROM user_compute_resources WHERE compute_resource_id NOT IN (SELECT id FROM compute_resources) OR user_id NOT IN (SELECT id FROM users)")
- -> 0.0008s
- -- execute("DELETE FROM user_domains WHERE domain_id NOT IN (SELECT id FROM domains) OR user_id NOT IN (SELECT id FROM users)")
- -> 0.0005s
- -- execute("DELETE FROM user_facts WHERE fact_name_id NOT IN (SELECT id FROM fact_names) OR user_id NOT IN (SELECT id FROM users)")
- -> 0.0007s
- -- execute("DELETE FROM user_hostgroups WHERE hostgroup_id NOT IN (SELECT id FROM hostgroups) OR user_id NOT IN (SELECT id FROM users)")
- -> 0.0008s
- -- execute("DELETE FROM user_roles WHERE role_id NOT IN (SELECT id FROM roles) OR user_id NOT IN (SELECT id FROM users)")
- -> 0.0006s
- -- execute("DELETE FROM environment_classes WHERE environment_id NOT IN (SELECT id FROM environments) OR lookup_key_id NOT IN (SELECT id FROM lookup_keys) OR puppetclass_id NOT IN (SELECT id FROM puppetclasses)")
- -> 0.0006s
- == DeleteOrphanedRecords: migrated (0.9994s) =================================
- == AddKeys: migrating ========================================================
- -- execute("SET CONSTRAINTS ALL DEFERRED;")
- -> 0.0002s
- -- add_foreign_key("architectures_operatingsystems", "architectures", {:name=>"architectures_operatingsystems_architecture_id_fk"})
- -> 0.0020s
- -- add_foreign_key("architectures_operatingsystems", "operatingsystems", {:name=>"architectures_operatingsystems_operatingsystem_id_fk"})
- -> 0.0012s
- -- add_foreign_key("audits", "users", {:name=>"audits_user_id_fk"})
- -> 0.0014s
- -- add_foreign_key("config_templates_operatingsystems", "config_templates", {:name=>"config_templates_operatingsystems_config_template_id_fk"})
- -> 0.0012s
- -- add_foreign_key("config_templates_operatingsystems", "operatingsystems", {:name=>"config_templates_operatingsystems_operatingsystem_id_fk"})
- -> 0.0011s
- -- add_foreign_key("config_templates", "template_kinds", {:name=>"config_templates_template_kind_id_fk"})
- -> 0.0012s
- -- add_foreign_key("domains", "smart_proxies", {:name=>"domains_dns_id_fk", :column=>"dns_id"})
- -> 0.0009s
- -- add_foreign_key("environment_classes", "environments", {:name=>"environment_classes_environment_id_fk"})
- -> 0.0012s
- -- add_foreign_key("environment_classes", "lookup_keys", {:name=>"environment_classes_lookup_key_id_fk"})
- -> 0.0013s
- -- add_foreign_key("environment_classes", "puppetclasses", {:name=>"environment_classes_puppetclass_id_fk"})
- -> 0.0012s
- -- add_foreign_key("fact_values", "fact_names", {:name=>"fact_values_fact_name_id_fk"})
- -> 0.0011s
- -- add_foreign_key("fact_values", "hosts", {:name=>"fact_values_host_id_fk"})
- -> 0.0013s
- -- add_foreign_key("features_smart_proxies", "features", {:name=>"features_smart_proxies_feature_id_fk"})
- -> 0.0011s
- -- add_foreign_key("features_smart_proxies", "smart_proxies", {:name=>"features_smart_proxies_smart_proxy_id_fk"})
- -> 0.0011s
- -- add_foreign_key("host_classes", "hosts", {:name=>"host_classes_host_id_fk"})
- -> 0.0015s
- -- add_foreign_key("host_classes", "puppetclasses", {:name=>"host_classes_puppetclass_id_fk"})
- -> 0.0013s
- -- add_foreign_key("hostgroup_classes", "hostgroups", {:name=>"hostgroup_classes_hostgroup_id_fk"})
- -> 0.0012s
- -- add_foreign_key("hostgroup_classes", "puppetclasses", {:name=>"hostgroup_classes_puppetclass_id_fk"})
- -> 0.0011s
- -- add_foreign_key("hostgroups", "architectures", {:name=>"hostgroups_architecture_id_fk"})
- -> 0.0012s
- -- add_foreign_key("hostgroups", "domains", {:name=>"hostgroups_domain_id_fk"})
- -> 0.0013s
- -- add_foreign_key("hostgroups", "environments", {:name=>"hostgroups_environment_id_fk"})
- -> 0.0012s
- -- add_foreign_key("hostgroups", "media", {:name=>"hostgroups_medium_id_fk"})
- -> 0.0013s
- -- add_foreign_key("hostgroups", "operatingsystems", {:name=>"hostgroups_operatingsystem_id_fk"})
- -> 0.0015s
- -- add_foreign_key("hostgroups", "ptables", {:name=>"hostgroups_ptable_id_fk"})
- -> 0.0013s
- -- add_foreign_key("hostgroups", "smart_proxies", {:name=>"hostgroups_puppet_ca_proxy_id_fk", :column=>"puppet_ca_proxy_id"})
- -> 0.0012s
- -- add_foreign_key("hostgroups", "smart_proxies", {:name=>"hostgroups_puppet_proxy_id_fk", :column=>"puppet_proxy_id"})
- -> 0.0011s
- -- add_foreign_key("hostgroups", "subnets", {:name=>"hostgroups_subnet_id_fk"})
- -> 0.0013s
- -- add_foreign_key("hosts", "architectures", {:name=>"hosts_architecture_id_fk"})
- -> 0.0016s
- -- add_foreign_key("hosts", "compute_resources", {:name=>"hosts_compute_resource_id_fk"})
- -> 0.0013s
- -- add_foreign_key("hosts", "domains", {:name=>"hosts_domain_id_fk"})
- -> 0.0014s
- -- add_foreign_key("hosts", "environments", {:name=>"hosts_environment_id_fk"})
- -> 0.0014s
- -- add_foreign_key("hosts", "hostgroups", {:name=>"hosts_hostgroup_id_fk"})
- -> 0.0014s
- -- add_foreign_key("hosts", "images", {:name=>"hosts_image_id_fk"})
- -> 0.0014s
- -- add_foreign_key("hosts", "media", {:name=>"hosts_medium_id_fk"})
- -> 0.0014s
- -- add_foreign_key("hosts", "models", {:name=>"hosts_model_id_fk"})
- -> 0.0015s
- -- add_foreign_key("hosts", "operatingsystems", {:name=>"hosts_operatingsystem_id_fk"})
- -> 0.0013s
- -- add_foreign_key("hosts", "ptables", {:name=>"hosts_ptable_id_fk"})
- -> 0.0014s
- -- add_foreign_key("hosts", "smart_proxies", {:name=>"hosts_puppet_ca_proxy_id_fk", :column=>"puppet_ca_proxy_id"})
- -> 0.0013s
- -- add_foreign_key("hosts", "smart_proxies", {:name=>"hosts_puppet_proxy_id_fk", :column=>"puppet_proxy_id"})
- -> 0.0011s
- -- add_foreign_key("hosts", "subnets", {:name=>"hosts_subnet_id_fk"})
- -> 0.0014s
- -- add_foreign_key("hosts", "taxonomies", {:name=>"hosts_location_id_fk", :column=>"location_id"})
- -> 0.0013s
- -- add_foreign_key("hosts", "taxonomies", {:name=>"hosts_organization_id_fk", :column=>"organization_id"})
- -> 0.0014s
- -- add_foreign_key("images", "architectures", {:name=>"images_architecture_id_fk"})
- -> 0.0016s
- -- add_foreign_key("images", "compute_resources", {:name=>"images_compute_resource_id_fk"})
- -> 0.0012s
- -- add_foreign_key("images", "operatingsystems", {:name=>"images_operatingsystem_id_fk"})
- -> 0.0014s
- -- add_foreign_key("key_pairs", "compute_resources", {:name=>"key_pairs_compute_resource_id_fk"})
- -> 0.0014s
- -- add_foreign_key("lookup_keys", "puppetclasses", {:name=>"lookup_keys_puppetclass_id_fk"})
- -> 0.0013s
- -- add_foreign_key("lookup_values", "lookup_keys", {:name=>"lookup_values_lookup_key_id_fk"})
- -> 0.0012s
- -- add_foreign_key("media_operatingsystems", "media", {:name=>"media_operatingsystems_medium_id_fk"})
- -> 0.0012s
- -- add_foreign_key("media_operatingsystems", "operatingsystems", {:name=>"media_operatingsystems_operatingsystem_id_fk"})
- -> 0.0012s
- -- add_foreign_key("nics", "domains", {:name=>"nics_domain_id_fk"})
- -> 0.0013s
- -- add_foreign_key("nics", "hosts", {:name=>"nics_host_id_fk"})
- -> 0.0016s
- -- add_foreign_key("nics", "subnets", {:name=>"nics_subnet_id_fk"})
- -> 0.0013s
- -- add_foreign_key("operatingsystems_ptables", "operatingsystems", {:name=>"operatingsystems_ptables_operatingsystem_id_fk"})
- -> 0.0012s
- -- add_foreign_key("operatingsystems_ptables", "ptables", {:name=>"operatingsystems_ptables_ptable_id_fk"})
- -> 0.0012s
- -- add_foreign_key("operatingsystems_puppetclasses", "operatingsystems", {:name=>"operatingsystems_puppetclasses_operatingsystem_id_fk"})
- -> 0.0012s
- -- add_foreign_key("operatingsystems_puppetclasses", "puppetclasses", {:name=>"operatingsystems_puppetclasses_puppetclass_id_fk"})
- -> 0.0013s
- -- add_foreign_key("os_default_templates", "config_templates", {:name=>"os_default_templates_config_template_id_fk"})
- -> 0.0013s
- -- add_foreign_key("os_default_templates", "operatingsystems", {:name=>"os_default_templates_operatingsystem_id_fk"})
- -> 0.1178s
- -- add_foreign_key("os_default_templates", "template_kinds", {:name=>"os_default_templates_template_kind_id_fk"})
- -> 0.0016s
- -- add_foreign_key("reports", "hosts", {:name=>"reports_host_id_fk"})
- -> 0.0017s
- -- add_foreign_key("subnet_domains", "domains", {:name=>"subnet_domains_domain_id_fk"})
- -> 0.0015s
- -- add_foreign_key("subnet_domains", "subnets", {:name=>"subnet_domains_subnet_id_fk"})
- -> 0.0015s
- -- add_foreign_key("subnets", "smart_proxies", {:name=>"subnets_dhcp_id_fk", :column=>"dhcp_id"})
- -> 0.0013s
- -- add_foreign_key("subnets", "smart_proxies", {:name=>"subnets_dns_id_fk", :column=>"dns_id"})
- -> 0.0014s
- -- add_foreign_key("subnets", "smart_proxies", {:name=>"subnets_tftp_id_fk", :column=>"tftp_id"})
- -> 0.0011s
- -- add_foreign_key("taxable_taxonomies", "taxonomies", {:name=>"taxable_taxonomies_taxonomy_id_fk"})
- -> 0.0015s
- -- add_foreign_key("template_combinations", "config_templates", {:name=>"template_combinations_config_template_id_fk"})
- -> 0.0013s
- -- add_foreign_key("template_combinations", "environments", {:name=>"template_combinations_environment_id_fk"})
- -> 0.0013s
- -- add_foreign_key("template_combinations", "hostgroups", {:name=>"template_combinations_hostgroup_id_fk"})
- -> 0.0013s
- -- add_foreign_key("tokens", "hosts", {:name=>"tokens_host_id_fk"})
- -> 0.0015s
- -- add_foreign_key("trend_counters", "trends", {:name=>"trend_counters_trend_id_fk"})
- -> 0.0013s
- -- add_foreign_key("user_compute_resources", "compute_resources", {:name=>"user_compute_resources_compute_resource_id_fk"})
- -> 0.0012s
- -- 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.0013s
- -- add_foreign_key("user_domains", "users", {:name=>"user_domains_user_id_fk"})
- -> 0.0012s
- -- add_foreign_key("user_facts", "fact_names", {:name=>"user_facts_fact_name_id_fk"})
- -> 0.0013s
- -- add_foreign_key("user_facts", "users", {:name=>"user_facts_user_id_fk"})
- -> 0.0013s
- -- add_foreign_key("user_hostgroups", "hostgroups", {:name=>"user_hostgroups_hostgroup_id_fk"})
- -> 0.0012s
- -- add_foreign_key("user_hostgroups", "users", {:name=>"user_hostgroups_user_id_fk"})
- -> 0.0014s
- -- add_foreign_key("user_notices", "notices", {:name=>"user_notices_notice_id_fk"})
- -> 0.0014s
- -- add_foreign_key("user_notices", "users", {:name=>"user_notices_user_id_fk"})
- -> 0.0013s
- -- add_foreign_key("user_roles", "roles", {:name=>"user_roles_role_id_fk"})
- -> 0.0012s
- -- add_foreign_key("user_roles", "users", {:name=>"user_roles_user_id_fk"})
- -> 0.0013s
- -- add_foreign_key("usergroup_members", "usergroups", {:name=>"usergroup_members_usergroup_id_fk"})
- -> 0.0015s
- -- add_foreign_key("users", "auth_sources", {:name=>"users_auth_source_id_fk"})
- -> 0.0019s
- == AddKeys: migrated (0.2360s) ===============================================
- == CreateHostBootdiskTemplate: migrating =====================================
- == CreateHostBootdiskTemplate: migrated (0.0000s) ============================
- == EditHostBootdiskTemplateMultinic: migrating ===============================
- == EditHostBootdiskTemplateMultinic: migrated (0.0000s) ======================
- == CreateKickstartBootdiskTemplate: migrating ================================
- == CreateKickstartBootdiskTemplate: migrated (0.0000s) =======================
- == CreateGenericHostBootdiskTemplate: migrating ==============================
- == CreateGenericHostBootdiskTemplate: migrated (0.0000s) =====================
- == RemoveUnusedRoleFields: migrating =========================================
- -- remove_column(:users, :role_id)
- -> 0.0006s
- -- remove_column(:user_roles, :inherited_from)
- -> 0.0004s
- == RemoveUnusedRoleFields: migrated (0.0011s) ================================
- == FixAuditableType2: migrating ==============================================
- == FixAuditableType2: migrated (0.0021s) =====================================
- == AddComposeFlagAndShortNameToFactName: migrating ===========================
- -- add_column(:fact_names, :compose, :boolean, {:default=>false, :null=>false})
- -> 0.0052s
- -- add_column(:fact_names, :short_name, :string)
- -> 0.0024s
- == AddComposeFlagAndShortNameToFactName: migrated (0.0077s) ==================
- == KatelloTables: migrating ==================================================
- -- create_table("katello_activation_keys", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_activation_keys_id_seq" for serial column "katello_activation_keys.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_activation_keys_pkey" for table "katello_activation_keys"
- -> 0.0076s
- -- add_index("katello_activation_keys", ["content_view_id"], {:name=>"index_activation_keys_on_content_view_id"})
- -> 0.0031s
- -- add_index("katello_activation_keys", ["environment_id"], {:name=>"index_activation_keys_on_environment_id"})
- -> 0.0031s
- -- add_index("katello_activation_keys", ["name", "organization_id"], {:name=>"index_activation_keys_on_name_and_organization_id", :unique=>true})
- -> 0.0032s
- -- add_index("katello_activation_keys", ["organization_id"], {:name=>"index_activation_keys_on_organization_id"})
- -> 0.0042s
- -- add_index("katello_activation_keys", ["user_id"], {:name=>"index_activation_keys_on_user_id"})
- -> 0.0038s
- -- create_table("katello_changeset_content_views", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_changeset_content_views_id_seq" for serial column "katello_changeset_content_views.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_changeset_content_views_pkey" for table "katello_changeset_content_views"
- -> 0.0037s
- -- create_table("katello_changeset_users", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_changeset_users_id_seq" for serial column "katello_changeset_users.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_changeset_users_pkey" for table "katello_changeset_users"
- -> 0.0039s
- -- add_index("katello_changeset_users", ["changeset_id"], {:name=>"index_changeset_users_on_changeset_id"})
- -> 0.0028s
- -- add_index("katello_changeset_users", ["user_id"], {:name=>"index_changeset_users_on_user_id"})
- -> 0.0028s
- -- create_table("katello_changesets", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_changesets_id_seq" for serial column "katello_changesets.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_changesets_pkey" for table "katello_changesets"
- -> 0.0062s
- -- add_index("katello_changesets", ["environment_id"], {:name=>"index_changesets_on_environment_id"})
- -> 0.0028s
- -- add_index("katello_changesets", ["name", "environment_id"], {:name=>"index_changesets_on_name_and_environment_id", :unique=>true})
- -> 0.0028s
- -- add_index("katello_changesets", ["task_status_id"], {:name=>"index_changesets_on_task_status_id"})
- -> 0.0031s
- -- create_table("katello_component_content_views", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_component_content_views_id_seq" for serial column "katello_component_content_views.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_component_content_views_pkey" for table "katello_component_content_views"
- -> 0.0037s
- -- add_index("katello_component_content_views", ["content_view_definition_id", "content_view_id"], {:name=>"component_content_views_index"})
- -> 0.0026s
- -- create_table("katello_content_view_definition_bases", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_definition_bases_id_seq" for serial column "katello_content_view_definition_bases.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_definition_bases_pkey" for table "katello_content_view_definition_bases"
- -> 0.0057s
- -- add_index("katello_content_view_definition_bases", ["name", "organization_id"], {:name=>"index_content_view_definitions_on_name_and_organization_id"})
- -> 0.0026s
- -- create_table("katello_content_view_definition_products", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_definition_products_id_seq" for serial column "katello_content_view_definition_products.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_definition_products_pkey" for table "katello_content_view_definition_products"
- -> 0.0036s
- -- add_index("katello_content_view_definition_products", ["content_view_definition_id", "product_id"], {:name=>"content_view_def_product_index"})
- -> 0.0026s
- -- create_table("katello_content_view_definition_repositories", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_definition_repositories_id_seq" for serial column "katello_content_view_definition_repositories.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_definition_repositories_pkey" for table "katello_content_view_definition_repositories"
- -> 0.0037s
- -- add_index("katello_content_view_definition_repositories", ["content_view_definition_id", "repository_id"], {:name=>"cvd_repo_index"})
- -> 0.0029s
- -- create_table("katello_content_view_environments", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_environments_id_seq" for serial column "katello_content_view_environments.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_environments_pkey" for table "katello_content_view_environments"
- -> 0.0058s
- -- add_index("katello_content_view_environments", ["content_view_id"], {:name=>"index_content_view_environments_on_content_view_id"})
- -> 0.0026s
- -- add_index("katello_content_view_environments", ["cp_id"], {:name=>"index_cve_cp_id", :unique=>true})
- -> 0.0027s
- -- add_index("katello_content_view_environments", ["environment_id", "content_view_id"], {:name=>"index_cve_eid_cv_id", :unique=>true})
- -> 0.0031s
- -- add_index("katello_content_view_environments", ["environment_id"], {:name=>"index_content_view_environments_on_environment_id"})
- -> 0.0033s
- -- create_table("katello_content_view_version_environments", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_version_environments_id_seq" for serial column "katello_content_view_version_environments.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_version_environments_pkey" for table "katello_content_view_version_environments"
- -> 0.0038s
- -- add_index("katello_content_view_version_environments", ["content_view_version_id", "environment_id"], {:name=>"cvv_env_index", :unique=>true})
- -> 0.0031s
- -- create_table("katello_content_view_versions", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_versions_id_seq" for serial column "katello_content_view_versions.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_versions_pkey" for table "katello_content_view_versions"
- -> 0.0047s
- -- add_index("katello_content_view_versions", ["id", "content_view_id"], {:name=>"cvv_cv_index"})
- -> 0.0035s
- -- create_table("katello_content_views", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_views_id_seq" for serial column "katello_content_views.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_views_pkey" for table "katello_content_views"
- -> 0.0062s
- -- add_index("katello_content_views", ["content_view_definition_id"], {:name=>"index_content_views_on_content_view_definition_id"})
- -> 0.0027s
- -- add_index("katello_content_views", ["name", "organization_id"], {:name=>"index_content_views_on_name_and_organization_id"})
- -> 0.0136s
- -- add_index("katello_content_views", ["organization_id", "label"], {:name=>"index_content_views_on_organization_id_and_label", :unique=>true})
- -> 0.0033s
- -- add_index("katello_content_views", ["organization_id"], {:name=>"index_content_views_on_organization_id"})
- -> 0.0033s
- -- create_table("katello_custom_info", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_custom_info_id_seq" for serial column "katello_custom_info.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_custom_info_pkey" for table "katello_custom_info"
- -> 0.0059s
- -- add_index("katello_custom_info", ["informable_type", "informable_id", "keyname"], {:name=>"index_custom_info_on_type_id_keyname"})
- -> 0.0030s
- -- create_table("delayed_jobs", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "delayed_jobs_id_seq" for serial column "delayed_jobs.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "delayed_jobs_pkey" for table "delayed_jobs"
- -> 0.0058s
- -- add_index("delayed_jobs", ["priority", "run_at"], {:name=>"delayed_jobs_priority"})
- -> 0.0027s
- -- create_table("katello_distributors", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_distributors_id_seq" for serial column "katello_distributors.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_distributors_pkey" for table "katello_distributors"
- -> 0.0059s
- -- add_index("katello_distributors", ["content_view_id"], {:name=>"index_distributors_on_content_view_id"})
- -> 0.0029s
- -- add_index("katello_distributors", ["environment_id"], {:name=>"index_distributors_on_environment_id"})
- -> 0.0030s
- -- create_table("katello_environment_priors", {:id=>false, :force=>true})
- -> 0.0010s
- -- add_index("katello_environment_priors", ["environment_id"], {:name=>"index_environment_priors_on_environment_id"})
- -> 0.0026s
- -- add_index("katello_environment_priors", ["prior_id"], {:name=>"index_environment_priors_on_prior_id"})
- -> 0.0028s
- -- create_table("katello_environments", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_environments_id_seq" for serial column "katello_environments.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_environments_pkey" for table "katello_environments"
- -> 0.0061s
- -- add_index("katello_environments", ["label", "organization_id"], {:name=>"index_environments_on_label_and_organization_id", :unique=>true})
- -> 0.0040s
- -- add_index("katello_environments", ["name", "organization_id"], {:name=>"index_environments_on_name_and_organization_id", :unique=>true})
- -> 0.0030s
- -- add_index("katello_environments", ["organization_id"], {:name=>"index_environments_on_organization_id"})
- -> 0.0031s
- -- create_table("katello_filter_rules", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_filter_rules_id_seq" for serial column "katello_filter_rules.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_filter_rules_pkey" for table "katello_filter_rules"
- -> 0.0058s
- -- add_index("katello_filter_rules", ["filter_id"], {:name=>"index_filter_rules_on_filter_id"})
- -> 0.0031s
- -- create_table("katello_filters", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_filters_id_seq" for serial column "katello_filters.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_filters_pkey" for table "katello_filters"
- -> 0.0036s
- -- add_index("katello_filters", ["content_view_definition_id"], {:name=>"index_filters_on_content_view_definition_id"})
- -> 0.0026s
- -- add_index("katello_filters", ["name", "content_view_definition_id"], {:name=>"index_filters_on_name_and_content_view_definition_id", :unique=>true})
- -> 0.0029s
- -- create_table("katello_filters_products", {:id=>false, :force=>true})
- -> 0.0010s
- -- add_index("katello_filters_products", ["filter_id", "product_id"], {:name=>"index_filters_products_on_filter_id_and_product_id", :unique=>true})
- -> 0.0026s
- -- add_index("katello_filters_products", ["filter_id"], {:name=>"index_filters_products_on_filter_id"})
- -> 0.0030s
- -- add_index("katello_filters_products", ["product_id"], {:name=>"index_filters_products_on_product_id"})
- -> 0.0030s
- -- create_table("katello_filters_repositories", {:id=>false, :force=>true})
- -> 0.0009s
- -- add_index("katello_filters_repositories", ["filter_id", "repository_id"], {:name=>"index_filters_repositories_on_filter_id_and_repository_id", :unique=>true})
- -> 0.0027s
- -- add_index("katello_filters_repositories", ["filter_id"], {:name=>"index_filters_repositories_on_filter_id"})
- -> 0.0028s
- -- add_index("katello_filters_repositories", ["repository_id"], {:name=>"index_filters_repositories_on_repository_id"})
- -> 0.0029s
- -- create_table("katello_gpg_keys", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_gpg_keys_id_seq" for serial column "katello_gpg_keys.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_gpg_keys_pkey" for table "katello_gpg_keys"
- -> 0.0061s
- -- add_index("katello_gpg_keys", ["organization_id", "name"], {:name=>"index_gpg_keys_on_organization_id_and_name", :unique=>true})
- -> 0.0034s
- -- create_table("katello_help_tips", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_help_tips_id_seq" for serial column "katello_help_tips.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_help_tips_pkey" for table "katello_help_tips"
- -> 0.0044s
- -- add_index("katello_help_tips", ["user_id"], {:name=>"index_help_tips_on_user_id"})
- -> 0.0032s
- -- create_table("katello_job_tasks", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_job_tasks_id_seq" for serial column "katello_job_tasks.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_job_tasks_pkey" for table "katello_job_tasks"
- -> 0.0045s
- -- add_index("katello_job_tasks", ["job_id"], {:name=>"index_job_tasks_on_job_id"})
- -> 0.0026s
- -- add_index("katello_job_tasks", ["task_status_id"], {:name=>"index_job_tasks_on_task_status_id"})
- -> 0.0029s
- -- create_table("katello_jobs", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_jobs_id_seq" for serial column "katello_jobs.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_jobs_pkey" for table "katello_jobs"
- -> 0.0058s
- -- add_index("katello_jobs", ["job_owner_id"], {:name=>"index_jobs_on_job_owner_id"})
- -> 0.0026s
- -- add_index("katello_jobs", ["pulp_id"], {:name=>"index_jobs_on_pulp_id"})
- -> 0.0028s
- -- create_table("katello_key_pools", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_key_pools_id_seq" for serial column "katello_key_pools.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_key_pools_pkey" for table "katello_key_pools"
- -> 0.0037s
- -- add_index("katello_key_pools", ["activation_key_id"], {:name=>"index_key_pools_on_activation_key_id"})
- -> 0.0025s
- -- add_index("katello_key_pools", ["pool_id"], {:name=>"index_key_pools_on_pool_id"})
- -> 0.0028s
- -- create_table("katello_key_system_groups", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_key_system_groups_id_seq" for serial column "katello_key_system_groups.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_key_system_groups_pkey" for table "katello_key_system_groups"
- -> 0.0037s
- -- add_index("katello_key_system_groups", ["activation_key_id"], {:name=>"index_key_system_groups_on_activation_key_id"})
- -> 0.0025s
- -- add_index("katello_key_system_groups", ["system_group_id"], {:name=>"index_key_system_groups_on_system_group_id"})
- -> 0.0027s
- -- create_table("katello_marketing_engineering_products", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_marketing_engineering_products_id_seq" for serial column "katello_marketing_engineering_products.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_marketing_engineering_products_pkey" for table "katello_marketing_engineering_products"
- -> 0.0037s
- -- add_index("katello_marketing_engineering_products", ["engineering_product_id"], {:name=>"index_marketing_engineering_products_on_engineering_product_id"})
- -> 0.0027s
- -- add_index("katello_marketing_engineering_products", ["marketing_product_id"], {:name=>"index_marketing_engineering_products_on_marketing_product_id"})
- -> 0.0030s
- -- create_table("katello_notices", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_notices_id_seq" for serial column "katello_notices.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_notices_pkey" for table "katello_notices"
- -> 0.0206s
- -- add_index("katello_notices", ["organization_id"], {:name=>"index_notices_on_organization_id"})
- -> 0.0029s
- -- create_table("katello_pools", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_pools_id_seq" for serial column "katello_pools.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_pools_pkey" for table "katello_pools"
- -> 0.0039s
- -- add_index("katello_pools", ["cp_id"], {:name=>"index_pools_on_cp_id"})
- -> 0.0027s
- -- create_table("katello_products", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_products_id_seq" for serial column "katello_products.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_products_pkey" for table "katello_products"
- -> 0.0062s
- -- add_index("katello_products", ["cp_id"], {:name=>"index_products_on_cp_id"})
- -> 0.0029s
- -- add_index("katello_products", ["gpg_key_id"], {:name=>"index_products_on_gpg_key_id"})
- -> 0.0028s
- -- add_index("katello_products", ["provider_id"], {:name=>"index_products_on_provider_id"})
- -> 0.0033s
- -- add_index("katello_products", ["sync_plan_id"], {:name=>"index_products_on_sync_plan_id"})
- -> 0.0033s
- -- create_table("katello_providers", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_providers_id_seq" for serial column "katello_providers.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_providers_pkey" for table "katello_providers"
- -> 0.0062s
- -- add_index("katello_providers", ["name", "organization_id"], {:name=>"index_providers_on_name_and_organization_id", :unique=>true})
- -> 0.0028s
- -- add_index("katello_providers", ["organization_id"], {:name=>"index_providers_on_organization_id"})
- -> 0.0027s
- -- add_index("katello_providers", ["task_status_id"], {:name=>"index_providers_on_task_status_id"})
- -> 0.0031s
- -- create_table("katello_repositories", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_repositories_id_seq" for serial column "katello_repositories.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_repositories_pkey" for table "katello_repositories"
- -> 0.0070s
- -- add_index("katello_repositories", ["content_view_version_id"], {:name=>"index_repositories_on_content_view_version_id"})
- -> 0.0027s
- -- add_index("katello_repositories", ["cp_label"], {:name=>"index_repositories_on_cp_label"})
- -> 0.0028s
- -- add_index("katello_repositories", ["environment_id"], {:name=>"index_repositories_on_environment_id"})
- -> 0.0030s
- -- add_index("katello_repositories", ["gpg_key_id"], {:name=>"index_repositories_on_gpg_key_id"})
- -> 0.0032s
- -- add_index("katello_repositories", ["library_instance_id"], {:name=>"index_repositories_on_library_instance_id"})
- -> 0.0036s
- -- add_index("katello_repositories", ["product_id"], {:name=>"index_repositories_on_product_id"})
- -> 0.0129s
- -- add_index("katello_repositories", ["pulp_id"], {:name=>"index_repositories_on_pulp_id"})
- -> 0.0078s
- -- create_table("katello_search_favorites", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_search_favorites_id_seq" for serial column "katello_search_favorites.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_search_favorites_pkey" for table "katello_search_favorites"
- -> 0.0059s
- -- add_index("katello_search_favorites", ["user_id"], {:name=>"index_search_favorites_on_user_id"})
- -> 0.0026s
- -- create_table("katello_search_histories", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_search_histories_id_seq" for serial column "katello_search_histories.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_search_histories_pkey" for table "katello_search_histories"
- -> 0.0057s
- -- add_index("katello_search_histories", ["user_id"], {:name=>"index_search_histories_on_user_id"})
- -> 0.0025s
- -- create_table("katello_sync_plans", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_sync_plans_id_seq" for serial column "katello_sync_plans.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_sync_plans_pkey" for table "katello_sync_plans"
- -> 0.0057s
- -- add_index("katello_sync_plans", ["name", "organization_id"], {:name=>"index_sync_plans_on_name_and_organization_id", :unique=>true})
- -> 0.0025s
- -- add_index("katello_sync_plans", ["organization_id"], {:name=>"index_sync_plans_on_organization_id"})
- -> 0.0027s
- -- create_table("katello_system_activation_keys", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_system_activation_keys_id_seq" for serial column "katello_system_activation_keys.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_activation_keys_pkey" for table "katello_system_activation_keys"
- -> 0.0038s
- -- add_index("katello_system_activation_keys", ["activation_key_id"], {:name=>"index_system_activation_keys_on_activation_key_id"})
- -> 0.0024s
- -- add_index("katello_system_activation_keys", ["system_id"], {:name=>"index_system_activation_keys_on_system_id"})
- -> 0.0027s
- -- create_table("katello_system_groups", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_system_groups_id_seq" for serial column "katello_system_groups.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_groups_pkey" for table "katello_system_groups"
- -> 0.0060s
- -- add_index("katello_system_groups", ["name", "organization_id"], {:name=>"index_system_groups_on_name_and_organization_id", :unique=>true})
- -> 0.0029s
- -- add_index("katello_system_groups", ["organization_id"], {:name=>"index_system_groups_on_organization_id"})
- -> 0.0030s
- -- create_table("katello_system_system_groups", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_system_system_groups_id_seq" for serial column "katello_system_system_groups.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_system_groups_pkey" for table "katello_system_system_groups"
- -> 0.0078s
- -- add_index("katello_system_system_groups", ["system_group_id"], {:name=>"index_system_system_groups_on_system_group_id"})
- -> 0.0028s
- -- add_index("katello_system_system_groups", ["system_id"], {:name=>"index_system_system_groups_on_system_id"})
- -> 0.0028s
- -- create_table("katello_systems", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_systems_id_seq" for serial column "katello_systems.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_systems_pkey" for table "katello_systems"
- -> 0.0060s
- -- add_index("katello_systems", ["content_view_id"], {:name=>"index_systems_on_content_view_id"})
- -> 0.0027s
- -- add_index("katello_systems", ["environment_id"], {:name=>"index_systems_on_environment_id"})
- -> 0.0028s
- -- create_table("katello_task_statuses", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_task_statuses_id_seq" for serial column "katello_task_statuses.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_task_statuses_pkey" for table "katello_task_statuses"
- -> 0.0061s
- -- add_index("katello_task_statuses", ["organization_id"], {:name=>"index_task_statuses_on_organization_id"})
- -> 0.0029s
- -- add_index("katello_task_statuses", ["task_owner_id"], {:name=>"index_task_statuses_on_task_owner_id"})
- -> 0.0030s
- -- add_index("katello_task_statuses", ["user_id"], {:name=>"index_task_statuses_on_user_id"})
- -> 0.0031s
- -- add_index("katello_task_statuses", ["uuid"], {:name=>"index_task_statuses_on_uuid"})
- -> 0.0034s
- -- create_table("katello_user_notices", {:force=>true})
- NOTICE: CREATE TABLE will create implicit sequence "katello_user_notices_id_seq" for serial column "katello_user_notices.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_user_notices_pkey" for table "katello_user_notices"
- -> 0.0199s
- -- add_index("katello_user_notices", ["notice_id"], {:name=>"index_user_notices_on_notice_id"})
- -> 0.0030s
- -- add_index("katello_user_notices", ["user_id"], {:name=>"index_user_notices_on_user_id"})
- -> 0.0030s
- == KatelloTables: migrated (0.5316s) =========================================
- == AddUsersFields: migrating =================================================
- -- add_column(:users, :helptips_enabled, :boolean, {:default=>true})
- -> 0.0064s
- -- add_column(:users, :hidden, :boolean, {:default=>false, :null=>false})
- -> 0.0055s
- -- add_column(:users, :page_size, :integer, {:default=>25, :null=>false})
- -> 0.0060s
- -- add_column(:users, :disabled, :boolean, {:default=>false})
- -> 0.0055s
- -- add_column(:users, :preferences, :text)
- -> 0.0003s
- -- add_column(:users, :remote_id, :string)
- -> 0.0004s
- == AddUsersFields: migrated (0.0247s) ========================================
- == AddForeignKeysEngine: migrating ===========================================
- -- add_foreign_key("katello_activation_keys", "katello_content_views", {:column=>"content_view_id", :name=>"activation_keys_content_view_id_fk"})
- -> 0.0018s
- -- add_foreign_key("katello_activation_keys", "katello_environments", {:column=>"environment_id", :name=>"activation_keys_environment_id_fk"})
- -> 0.0012s
- -- add_foreign_key("katello_activation_keys", "users", {:column=>"user_id", :name=>"activation_keys_user_id_fk"})
- -> 0.0013s
- -- add_foreign_key("katello_component_content_views", "katello_content_view_definition_bases", {:name=>"component_content_views_content_view_definition_id_fk", :column=>"content_view_definition_id"})
- -> 0.0013s
- -- add_foreign_key("katello_component_content_views", "katello_content_views", {:name=>"component_content_views_content_view_id_fk", :column=>"content_view_id"})
- -> 0.0010s
- -- add_foreign_key("katello_content_view_definition_bases", "katello_content_view_definition_bases", {:name=>"content_view_definition_bases_source_id_fk", :column=>"source_id"})
- -> 0.0010s
- -- add_foreign_key("katello_content_view_definition_products", "katello_content_view_definition_bases", {:name=>"content_view_definition_products_content_view_definition_id_fk", :column=>"content_view_definition_id"})
- -> 0.0011s
- -- add_foreign_key("katello_content_view_definition_products", "katello_products", {:name=>"content_view_definition_products_product_id_fk", :column=>"product_id"})
- -> 0.0012s
- -- add_foreign_key("katello_content_view_definition_repositories", "katello_content_view_definition_bases", {:name=>"CV_definition_repositories_CV_definition_id_fk", :column=>"content_view_definition_id"})
- -> 0.0011s
- -- add_foreign_key("katello_content_view_definition_repositories", "katello_repositories", {:name=>"content_view_definition_repositories_repository_id_fk", :column=>"repository_id"})
- -> 0.0014s
- -- add_foreign_key("katello_content_view_environments", "katello_content_views", {:name=>"content_view_environments_content_view_id_fk", :column=>"content_view_id"})
- -> 0.0012s
- -- add_foreign_key("katello_content_view_environments", "katello_environments", {:name=>"content_view_environments_environment_id_fk", :column=>"environment_id"})
- -> 0.0010s
- -- add_foreign_key("katello_content_view_version_environments", "katello_content_view_versions", {:name=>"content_view_version_environments_content_view_version_id_fk", :column=>"content_view_version_id"})
- -> 0.0014s
- -- add_foreign_key("katello_content_view_version_environments", "katello_environments", {:name=>"content_view_version_environments_environment_id_fk", :column=>"environment_id"})
- -> 0.0011s
- -- add_foreign_key("katello_content_view_versions", "katello_content_view_definition_bases", {:name=>"content_view_versions_content_view_definition_archive_id_fk", :column=>"definition_archive_id"})
- -> 0.0012s
- -- add_foreign_key("katello_content_view_versions", "katello_content_view_definition_bases", {:name=>"content_view_versions_definition_archive_id_fk", :column=>"definition_archive_id"})
- -> 0.0011s
- -- add_foreign_key("katello_content_view_versions", "katello_content_views", {:name=>"content_view_versions_content_view_id_fk", :column=>"content_view_id"})
- -> 0.0011s
- -- add_foreign_key("katello_content_views", "katello_content_view_definition_bases", {:name=>"content_views_content_view_definition_id_fk", :column=>"content_view_definition_id"})
- -> 0.0011s
- -- add_foreign_key("katello_distributors", "katello_content_views", {:name=>"distributors_content_view_id_fk", :column=>"content_view_id"})
- -> 0.0012s
- -- add_foreign_key("katello_distributors", "katello_environments", {:name=>"distributors_environment_id_fk", :column=>"environment_id"})
- -> 0.0011s
- -- add_foreign_key("katello_environment_priors", "katello_environments", {:name=>"environment_priors_environment_id_fk", :column=>"environment_id"})
- -> 0.0011s
- -- add_foreign_key("katello_environment_priors", "katello_environments", {:name=>"environment_priors_prior_id_fk", :column=>"prior_id"})
- -> 0.0012s
- -- add_foreign_key("katello_filter_rules", "katello_filters", {:name=>"filters_rules_filter_id_fk", :column=>"filter_id"})
- -> 0.0012s
- -- add_foreign_key("katello_filters", "katello_content_view_definition_bases", {:name=>"filters_content_view_definition_id_fk", :column=>"content_view_definition_id"})
- -> 0.0010s
- -- add_foreign_key("katello_filters_products", "katello_filters", {:name=>"filters_product_filter_id_fk", :column=>"filter_id"})
- -> 0.0011s
- -- add_foreign_key("katello_filters_products", "katello_products", {:name=>"filters_product_product_id_fk", :column=>"product_id"})
- -> 0.0011s
- -- add_foreign_key("katello_filters_repositories", "katello_filters", {:name=>"filters_repositories_filter_id_fk", :column=>"filter_id"})
- -> 0.0010s
- -- add_foreign_key("katello_filters_repositories", "katello_repositories", {:name=>"filters_repositories_repository_id_fk", :column=>"repository_id"})
- -> 0.0020s
- -- add_foreign_key("katello_help_tips", "users", {:name=>"help_tips_user_id_fk", :column=>"user_id"})
- -> 0.0013s
- -- add_foreign_key("katello_job_tasks", "katello_jobs", {:name=>"job_tasks_job_id_fk", :column=>"job_id"})
- -> 0.0012s
- -- add_foreign_key("katello_job_tasks", "katello_task_statuses", {:name=>"job_tasks_task_status_id_fk", :column=>"task_status_id"})
- -> 0.0013s
- -- add_foreign_key("katello_key_pools", "katello_activation_keys", {:name=>"key_pools_activation_key_id_fk", :column=>"activation_key_id"})
- -> 0.0013s
- -- add_foreign_key("katello_key_pools", "katello_pools", {:name=>"key_pools_pool_id_fk", :column=>"pool_id"})
- -> 0.0011s
- -- add_foreign_key("katello_key_system_groups", "katello_activation_keys", {:name=>"key_system_groups_activation_key_id_fk", :column=>"activation_key_id"})
- -> 0.0013s
- -- add_foreign_key("katello_key_system_groups", "katello_system_groups", {:name=>"key_system_groups_system_group_id_fk", :column=>"system_group_id"})
- -> 0.0011s
- -- add_foreign_key("katello_marketing_engineering_products", "katello_products", {:name=>"marketing_engineering_products_engineering_product_id_fk", :column=>"engineering_product_id"})
- -> 0.0012s
- -- add_foreign_key("katello_marketing_engineering_products", "katello_products", {:name=>"marketing_engineering_products_marketing_product_id_fk", :column=>"marketing_product_id"})
- -> 0.0011s
- -- add_foreign_key("katello_products", "katello_gpg_keys", {:name=>"products_gpg_key_id_fk", :column=>"gpg_key_id"})
- -> 0.0012s
- -- add_foreign_key("katello_products", "katello_providers", {:name=>"products_provider_id_fk", :column=>"provider_id"})
- -> 0.0012s
- -- add_foreign_key("katello_products", "katello_sync_plans", {:name=>"products_sync_plan_id_fk", :column=>"sync_plan_id"})
- -> 0.0012s
- -- add_foreign_key("katello_providers", "katello_task_statuses", {:name=>"providers_discovery_task_id_fk", :column=>"discovery_task_id"})
- -> 0.0011s
- -- add_foreign_key("katello_providers", "katello_task_statuses", {:name=>"providers_task_status_id_fk", :column=>"task_status_id"})
- -> 0.0012s
- -- add_foreign_key("katello_repositories", "katello_content_view_versions", {:name=>"repositories_content_view_version_id_fk", :column=>"content_view_version_id"})
- -> 0.0012s
- -- add_foreign_key("katello_repositories", "katello_gpg_keys", {:name=>"repositories_gpg_key_id_fk", :column=>"gpg_key_id"})
- -> 0.0013s
- -- add_foreign_key("katello_repositories", "katello_repositories", {:name=>"repositories_library_instance_id_fk", :column=>"library_instance_id"})
- -> 0.0011s
- -- add_foreign_key("katello_search_favorites", "users", {:name=>"search_favorites_user_id_fk", :column=>"user_id"})
- -> 0.0013s
- -- add_foreign_key("katello_search_histories", "users", {:name=>"search_histories_user_id_fk", :column=>"user_id"})
- -> 0.0012s
- -- add_foreign_key("katello_system_activation_keys", "katello_activation_keys", {:name=>"system_activation_keys_activation_key_id_fk", :column=>"activation_key_id"})
- -> 0.0012s
- -- add_foreign_key("katello_system_activation_keys", "katello_systems", {:name=>"system_activation_keys_system_id_fk", :column=>"system_id"})
- -> 0.0012s
- -- add_foreign_key("katello_system_system_groups", "katello_system_groups", {:name=>"system_system_groups_system_group_id_fk", :column=>"system_group_id"})
- -> 0.0013s
- -- add_foreign_key("katello_system_system_groups", "katello_systems", {:name=>"system_system_groups_system_id_fk", :column=>"system_id"})
- -> 0.0011s
- -- add_foreign_key("katello_systems", "katello_content_views", {:name=>"systems_content_view_id_fk", :column=>"content_view_id"})
- -> 0.0012s
- -- add_foreign_key("katello_systems", "katello_environments", {:name=>"systems_environment_id_fk", :column=>"environment_id"})
- -> 0.0012s
- -- add_foreign_key("katello_task_statuses", "users", {:name=>"task_statuses_user_id_fk", :column=>"user_id"})
- -> 0.0012s
- -- add_foreign_key("katello_user_notices", "katello_notices", {:name=>"user_notices_notice_id_fk", :column=>"notice_id"})
- -> 0.0013s
- -- add_foreign_key("katello_user_notices", "users", {:name=>"user_notices_user_id_fk", :column=>"user_id"})
- -> 0.0011s
- == AddForeignKeysEngine: migrated (0.0711s) ==================================
- == AllowNullValuesOnFactValue: migrating =====================================
- -- change_column(:fact_values, :value, :text, {:null=>true})
- -> 0.0121s
- == AllowNullValuesOnFactValue: migrated (0.0122s) ============================
- == EditHostBootdiskTemplateDnsSecondary: migrating ===========================
- == EditHostBootdiskTemplateDnsSecondary: migrated (0.0000s) ==================
- == AddTypeToFactName: migrating ==============================================
- -- add_column(:fact_names, :type, :string, {:default=>"FactName"})
- -> 0.0077s
- == AddTypeToFactName: migrated (0.0080s) =====================================
- == ChangeNameIndexOnFactName: migrating ======================================
- -- remove_index(:fact_names, {:column=>:name, :unique=>true})
- -> 0.0022s
- -- add_index(:fact_names, [:name, :type], {:unique=>true})
- -> 0.0028s
- == ChangeNameIndexOnFactName: migrated (0.0054s) =============================
- == UpdateForemanUrl: migrating ===============================================
- == UpdateForemanUrl: migrated (0.0044s) ======================================
- == AddAncestryToFactNames: migrating =========================================
- -- add_column(:fact_names, :ancestry, :string)
- -> 0.0007s
- -- add_index(:fact_names, :ancestry)
- -> 0.0035s
- == AddAncestryToFactNames: migrated (0.0045s) ================================
- == ExtendUserRole: migrating =================================================
- -- foreign_keys("user_roles")
- -> 0.1195s
- -- remove_foreign_key("user_roles", {:name=>"user_roles_user_id_fk"})
- -> 0.0013s
- -- add_column(:user_roles, :owner_type, :string, {:default=>"User", :null=>false})
- -> 0.0034s
- -- rename_column(:user_roles, :user_id, :owner_id)
- -> 0.0003s
- -- add_index(:user_roles, :owner_type)
- -> 0.0029s
- -- add_index(:user_roles, :owner_id)
- -> 0.0030s
- -- add_index(:user_roles, [:owner_id, :owner_type])
- -> 0.0035s
- -- change_column(:user_roles, :owner_id, :integer, {:null=>false})
- -> 0.0087s
- == ExtendUserRole: migrated (0.1434s) ========================================
- == CreateCachedUserRoles: migrating ==========================================
- -- create_table(:cached_user_roles)
- NOTICE: CREATE TABLE will create implicit sequence "cached_user_roles_id_seq" for serial column "cached_user_roles.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cached_user_roles_pkey" for table "cached_user_roles"
- -> 0.0046s
- -- add_index(:cached_user_roles, :user_id)
- -> 0.0031s
- -- add_index(:cached_user_roles, :role_id)
- -> 0.0028s
- -- add_index(:cached_user_roles, :user_role_id)
- -> 0.0031s
- == CreateCachedUserRoles: migrated (0.0139s) =================================
- == AddOrganizationFields: migrating ==========================================
- -- column_exists?(:taxonomies, :description)
- -> 0.0010s
- -- add_column(:taxonomies, :description, :text)
- -> 0.0006s
- -- add_column(:taxonomies, :label, :string)
- -> 0.0004s
- -- add_column(:taxonomies, :deletion_task_id, :integer)
- -> 0.0003s
- -- add_column(:taxonomies, :default_info, :text)
- -> 0.0003s
- -- add_column(:taxonomies, :apply_info_task_id, :integer)
- -> 0.0004s
- -- add_column(:taxonomies, :owner_auto_attach_all_systems_task_id, :integer)
- -> 0.0003s
- -- add_index(:taxonomies, [:deletion_task_id], {:name=>"index_organizations_on_task_id"})
- -> 0.0032s
- -- add_index(:taxonomies, [:label], {:name=>"index_organizations_on_cp_key", :unique=>true})
- -> 0.0031s
- == AddOrganizationFields: migrated (0.0103s) =================================
- == CalculateCacheForUserRole: migrating ======================================
- == CalculateCacheForUserRole: migrated (0.0042s) =============================
- == AddPxegrubLocalbootTemplate: migrating ====================================
- == AddPxegrubLocalbootTemplate: migrated (0.0000s) ===========================
- == CreateCachedUsergroupMembers: migrating ===================================
- -- create_table(:cached_usergroup_members)
- NOTICE: CREATE TABLE will create implicit sequence "cached_usergroup_members_id_seq" for serial column "cached_usergroup_members.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cached_usergroup_members_pkey" for table "cached_usergroup_members"
- -> 0.0048s
- -- add_index(:cached_usergroup_members, :user_id)
- -> 0.0029s
- -- add_index(:cached_usergroup_members, :usergroup_id)
- -> 0.0028s
- == CreateCachedUsergroupMembers: migrated (0.1333s) ==========================
- == CreateRealms: migrating ===================================================
- -- create_table(:realms)
- NOTICE: CREATE TABLE will create implicit sequence "realms_id_seq" for serial column "realms.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "realms_pkey" for table "realms"
- -> 0.0076s
- -- add_index(:realms, :name, {:unique=>true})
- -> 0.0035s
- -- column_exists?(:hosts, :otp)
- -> 0.0018s
- -- add_column(:hosts, :otp, :string)
- -> 0.0008s
- -- column_exists?(:hosts, :realm_id)
- -> 0.0012s
- -- add_column(:hosts, :realm_id, :integer)
- -> 0.0004s
- -- column_exists?(:hostgroups, :realm_id)
- -> 0.0008s
- -- add_column(:hostgroups, :realm_id, :integer)
- -> 0.0004s
- -- 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.0018s
- -- add_foreign_key(:hostgroups, :realms, {:name=>"hostgroups_realms_id_fk"})
- -> 0.0014s
- == CreateRealms: migrated (0.0218s) ==========================================
- == RenameSeededTemplates: migrating ==========================================
- == RenameSeededTemplates: migrated (0.0235s) =================================
- == AddAdminFlagToUsergroup: migrating ========================================
- -- add_column(:usergroups, :admin, :boolean, {:null=>false, :default=>false})
- -> 0.0037s
- == AddAdminFlagToUsergroup: migrated (0.0039s) ===============================
- == CreatePermissions: migrating ==============================================
- -- create_table(:permissions)
- NOTICE: CREATE TABLE will create implicit sequence "permissions_id_seq" for serial column "permissions.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "permissions_pkey" for table "permissions"
- -> 0.0063s
- -- add_index(:permissions, [:name, :resource_type])
- -> 0.0029s
- == CreatePermissions: migrated (0.0094s) =====================================
- == CreateFilters: migrating ==================================================
- -- create_table(:filters)
- NOTICE: CREATE TABLE will create implicit sequence "filters_id_seq" for serial column "filters.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "filters_pkey" for table "filters"
- -> 0.0063s
- == CreateFilters: migrated (0.0064s) =========================================
- == CreateFilterings: migrating ===============================================
- -- create_table(:filterings)
- NOTICE: CREATE TABLE will create implicit sequence "filterings_id_seq" for serial column "filterings.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "filterings_pkey" for table "filterings"
- -> 0.0161s
- -- add_index(:filterings, :filter_id)
- -> 0.0032s
- -- add_index(:filterings, :permission_id)
- -> 0.0029s
- == CreateFilterings: migrated (0.0223s) ======================================
- == AddDescriptionToOperatingsystem: migrating ================================
- -- add_column(:operatingsystems, :description, :string)
- -> 0.0009s
- == AddDescriptionToOperatingsystem: migrated (0.0010s) =======================
- == CreateForemanTasks: migrating =============================================
- -- create_table(:foreman_tasks_tasks, {:id=>false})
- -> 0.0037s
- == CreateForemanTasks: migrated (0.0039s) ====================================
- == CreateForemanTasksLocks: migrating ========================================
- -- create_table(:foreman_tasks_locks)
- NOTICE: CREATE TABLE will create implicit sequence "foreman_tasks_locks_id_seq" for serial column "foreman_tasks_locks.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foreman_tasks_locks_pkey" for table "foreman_tasks_locks"
- -> 0.0062s
- -- add_index(:foreman_tasks_locks, [:resource_type, :resource_id])
- -> 0.0031s
- == CreateForemanTasksLocks: migrated (0.0096s) ===============================
- == AddLdapAvatarSupport: migrating ===========================================
- -- add_column(:auth_sources, :attr_photo, :string)
- -> 0.0008s
- -- add_column(:users, :avatar_hash, :string, {:limit=>128})
- -> 0.0005s
- == AddLdapAvatarSupport: migrated (0.0015s) ==================================
- == AddQuantityToKatelloKeyPools: migrating ===================================
- -- add_column(:katello_key_pools, :quantity, :integer)
- -> 0.0007s
- == AddQuantityToKatelloKeyPools: migrated (0.0008s) ==========================
- == AddCpIdToKatelloActivationKeys: migrating =================================
- -- add_column(:katello_activation_keys, :cp_id, :string)
- -> 0.0007s
- -- add_column(:katello_activation_keys, :label, :string)
- -> 0.0003s
- -- add_index(:katello_activation_keys, :cp_id)
- -> 0.0045s
- -- add_index(:katello_activation_keys, :label, {:name=>"index_activation_keys_on_label", :unique=>true})
- -> 0.0046s
- == AddCpIdToKatelloActivationKeys: migrated (0.0105s) ========================
- == DropKatelloKeyPoolsTable: migrating =======================================
- -- drop_table(:katello_key_pools)
- -> 0.0020s
- == DropKatelloKeyPoolsTable: migrated (0.0021s) ==============================
- == AddUserdataFlagToImages: migrating ========================================
- -- add_column(:images, :user_data, :boolean, {:default=>false})
- -> 0.0059s
- == AddUserdataFlagToImages: migrated (0.0060s) ===============================
- == CreateComputeProfiles: migrating ==========================================
- -- create_table(:compute_profiles)
- NOTICE: CREATE TABLE will create implicit sequence "compute_profiles_id_seq" for serial column "compute_profiles.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "compute_profiles_pkey" for table "compute_profiles"
- -> 0.0042s
- == CreateComputeProfiles: migrated (0.0043s) =================================
- == CreateComputeAttributes: migrating ========================================
- -- create_table(:compute_attributes)
- NOTICE: CREATE TABLE will create implicit sequence "compute_attributes_id_seq" for serial column "compute_attributes.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "compute_attributes_pkey" for table "compute_attributes"
- -> 0.0064s
- -- add_index(:compute_attributes, :compute_profile_id)
- -> 0.0030s
- -- add_index(:compute_attributes, :compute_resource_id)
- -> 0.0028s
- -- add_foreign_key("compute_attributes", "compute_resources", {:name=>"compute_attributes_compute_resource_id_fk"})
- -> 0.0015s
- -- add_foreign_key("compute_attributes", "compute_profiles", {:name=>"compute_attributes_compute_profile_id_fk"})
- -> 0.0012s
- == CreateComputeAttributes: migrated (0.0154s) ===============================
- == AddComputeProfileToHostgroup: migrating ===================================
- -- add_column(:hostgroups, :compute_profile_id, :integer)
- -> 0.0010s
- -- add_column(:hosts, :compute_profile_id, :integer)
- -> 0.0004s
- -- add_index(:hostgroups, :compute_profile_id)
- -> 0.0037s
- -- add_index(:hosts, :compute_profile_id)
- -> 0.0067s
- -- add_foreign_key("hostgroups", "compute_profiles", {:name=>"hostgroups_compute_profile_id_fk"})
- -> 0.0017s
- -- add_foreign_key("hosts", "compute_profiles", {:name=>"hosts_compute_profile_id_fk"})
- -> 0.0014s
- == AddComputeProfileToHostgroup: migrated (0.0154s) ==========================
- == UpdateEnvironmentsAddKatelloId: migrating =================================
- -- add_column(:environments, :katello_id, :string)
- -> 0.0032s
- -- add_index(:environments, :katello_id)
- -> 0.0031s
- == UpdateEnvironmentsAddKatelloId: migrated (0.0065s) ========================
- == AddForeignKeysToFiltersAndFilterings: migrating ===========================
- -- add_foreign_key("filters", "roles", {:name=>"filters_roles_id_fk"})
- -> 0.0018s
- -- add_foreign_key("filterings", "filters", {:name=>"filterings_filters_id_fk"})
- -> 0.0014s
- -- add_foreign_key("filterings", "permissions", {:name=>"filterings_permissions_id_fk"})
- -> 0.0014s
- == AddForeignKeysToFiltersAndFilterings: migrated (0.0049s) ==================
- == AddPasswordToImages: migrating ============================================
- -- add_column(:images, :password, :string)
- -> 0.0008s
- == AddPasswordToImages: migrated (0.0009s) ===================================
- == RefactorContentViews: migrating ===========================================
- -- remove_foreign_key("katello_component_content_views", {:name=>"component_content_views_content_view_definition_id_fk"})
- -> 0.0009s
- -- remove_foreign_key("katello_content_view_definition_bases", {:name=>"content_view_definition_bases_source_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_content_view_definition_products", {:name=>"content_view_definition_products_content_view_definition_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_content_view_definition_products", {:name=>"content_view_definition_products_product_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_content_view_definition_repositories", {:name=>"CV_definition_repositories_CV_definition_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_content_view_versions", {:name=>"content_view_versions_content_view_definition_archive_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_content_view_versions", {:name=>"content_view_versions_definition_archive_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_content_views", {:name=>"content_views_content_view_definition_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_filters", {:name=>"filters_content_view_definition_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_filters_products", {:name=>"filters_product_filter_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_filters_products", {:name=>"filters_product_product_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_filter_rules", {:name=>"filters_rules_filter_id_fk"})
- -> 0.0006s
- -- drop_table(:katello_content_view_definition_bases)
- -> 0.0014s
- -- drop_table(:katello_content_view_definition_products)
- -> 0.0009s
- -- drop_table(:katello_filters_products)
- -> 0.0008s
- -- drop_table(:katello_filter_rules)
- -> 0.0012s
- -- drop_table(:katello_content_view_version_environments)
- -> 0.0015s
- -- add_column(:katello_content_views, :composite, :boolean)
- -> 0.0005s
- -- add_column(:katello_content_view_environments, :content_view_version_id, :integer)
- -> 0.0004s
- -- remove_column(:katello_content_views, :content_view_definition_id)
- -> 0.0005s
- -- rename_column(:katello_component_content_views, :content_view_definition_id, :content_view_version_id)
- -> 0.0004s
- -- rename_table(:katello_component_content_views, :katello_content_view_components)
- -> 0.0024s
- -- rename_table(:katello_content_view_definition_repositories, :katello_content_view_repositories)
- -> 0.0022s
- -- rename_column(:katello_content_view_repositories, :content_view_definition_id, :content_view_id)
- -> 0.0004s
- -- rename_table(:katello_filters, :katello_content_view_filters)
- -> 0.0023s
- -- rename_table(:katello_filters_repositories, :katello_content_view_filters_repositories)
- -> 0.0027s
- -- rename_column(:katello_content_view_filters_repositories, :filter_id, :content_view_filter_id)
- -> 0.0005s
- -- rename_column(:katello_content_view_filters, :content_view_definition_id, :content_view_id)
- -> 0.0004s
- -- add_column(:katello_content_view_filters, :type, :string)
- -> 0.0029s
- -- add_column(:katello_content_view_filters, :inclusion, :boolean, {:default=>false, :null=>false})
- -> 0.0084s
- == RefactorContentViews: migrated (0.0395s) ==================================
- == AddDefaultOrganizationIdToUsers: migrating ================================
- -- add_column(:users, :default_organization_id, :integer)
- -> 0.0011s
- == AddDefaultOrganizationIdToUsers: migrated (0.0012s) =======================
- == AddDefaultLocationIdToUsers: migrating ====================================
- -- add_column(:users, :default_location_id, :integer)
- -> 0.0008s
- == AddDefaultLocationIdToUsers: migrated (0.0009s) ===========================
- == AddAncestryToTaxonomies: migrating ========================================
- -- add_column(:taxonomies, :ancestry, :string)
- -> 0.0007s
- -- add_index(:taxonomies, :ancestry)
- -> 0.0043s
- == AddAncestryToTaxonomies: migrated (0.0059s) ===============================
- == CreateContentViewPuppetModules: migrating =================================
- -- create_table(:katello_content_view_puppet_modules)
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_puppet_modules_id_seq" for serial column "katello_content_view_puppet_modules.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_puppet_modules_pkey" for table "katello_content_view_puppet_modules"
- -> 0.0067s
- -- add_index(:katello_content_view_puppet_modules, :content_view_id)
- -> 0.0036s
- -- add_index(:katello_content_view_puppet_modules, [:name, :content_view_id], {:unique=>true, :name=>:katello_cv_puppet_modules_name})
- -> 0.0038s
- -- add_index(:katello_content_view_puppet_modules, [:name, :author, :content_view_id], {:unique=>true, :name=>:katello_cv_puppet_modules_name_author})
- -> 0.0046s
- -- add_index(:katello_content_view_puppet_modules, [:uuid, :content_view_id], {:unique=>true, :name=>:katello_cv_puppet_modules_uuid})
- -> 0.0044s
- == CreateContentViewPuppetModules: migrated (0.0239s) ========================
- == CreateContentViewPackageFilterRules: migrating ============================
- -- create_table(:katello_content_view_package_filter_rules)
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_package_filter_rules_id_seq" for serial column "katello_content_view_package_filter_rules.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_package_filter_rules_pkey" for table "katello_content_view_package_filter_rules"
- -> 0.0071s
- == CreateContentViewPackageFilterRules: migrated (0.0073s) ===================
- == CreateContentViewPackageGroupFilterRules: migrating =======================
- -- create_table(:katello_content_view_package_group_filter_rules)
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_package_group_filter_rules_id_seq" for serial column "katello_content_view_package_group_filter_rules.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_package_group_filter_rules_pkey" for table "katello_content_view_package_group_filter_rules"
- -> 0.0043s
- == CreateContentViewPackageGroupFilterRules: migrated (0.0044s) ==============
- == CreateContentViewErratumFilterRules: migrating ============================
- -- create_table(:katello_content_view_erratum_filter_rules)
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_erratum_filter_rules_id_seq" for serial column "katello_content_view_erratum_filter_rules.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_erratum_filter_rules_pkey" for table "katello_content_view_erratum_filter_rules"
- -> 0.0068s
- == CreateContentViewErratumFilterRules: migrated (0.0069s) ===================
- == RemoveChangeset: migrating ================================================
- -- drop_table("katello_changeset_content_views")
- -> 0.0012s
- -- drop_table("katello_changeset_users")
- -> 0.0011s
- -- drop_table("katello_changesets")
- -> 0.0016s
- == RemoveChangeset: migrated (0.0042s) =======================================
- == CreateContentViewHistory: migrating =======================================
- -- create_table("katello_content_view_histories")
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_histories_id_seq" for serial column "katello_content_view_histories.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_histories_pkey" for table "katello_content_view_histories"
- -> 0.0070s
- -- add_index("katello_content_view_histories", ["katello_content_view_version_id"], {:name=>"index_cvh_cvvid"})
- -> 0.0036s
- -- add_index("katello_content_view_histories", ["katello_environment_id"], {:name=>"index_cvh_environment_id"})
- -> 0.0044s
- -- add_foreign_key("katello_content_view_histories", "katello_environments", {:name=>"content_view_histories_cvh_environment_id", :column=>"katello_environment_id"})
- -> 0.0020s
- -- add_foreign_key("katello_content_view_histories", "katello_content_view_versions", {:name=>"content_view_histories_cvh_cvv_id", :column=>"katello_content_view_version_id"})
- -> 0.0015s
- == CreateContentViewHistory: migrated (0.0189s) ==============================
- == ChangeLabelToTitle: migrating =============================================
- -- rename_column(:hostgroups, :label, :title)
- -> 0.0007s
- -- add_column(:taxonomies, :title, :string)
- -> 0.0004s
- -- execute("UPDATE taxonomies set title = name WHERE ancestry IS NULL")
- -> 0.0005s
- == ChangeLabelToTitle: migrated (0.0046s) ====================================
- == MigratePermissions: migrating =============================================
- -- Skipping migration of permissions, since old permissions are not present
- == MigratePermissions: migrated (0.1687s) ====================================
- == AddTaxonomySearchesToFilter: migrating ====================================
- -- add_column(:filters, :taxonomy_search, :text)
- -> 0.0008s
- == AddTaxonomySearchesToFilter: migrated (0.0371s) ===========================
- == RemoveProviderDiscovery: migrating ========================================
- -- remove_column(:katello_providers, :discovery_url)
- -> 0.0006s
- -- remove_column(:katello_providers, :discovery_task_id)
- -> 0.0007s
- -- remove_column(:katello_providers, :discovered_repos)
- -> 0.0003s
- == RemoveProviderDiscovery: migrated (0.0018s) ===============================
- == AddProvisionMethodToHosts: migrating ======================================
- -- add_column(:hosts, :provision_method, :string)
- -> 0.0012s
- == AddProvisionMethodToHosts: migrated (0.0030s) =============================
- == AllowNullForRepositoryContentId: migrating ================================
- -- change_column(:katello_repositories, :content_id, :string, {:null=>true})
- -> 0.0505s
- == AllowNullForRepositoryContentId: migrated (0.0506s) =======================
- == CreateContentViewPuppetEnvironments: migrating ============================
- -- create_table(:katello_content_view_puppet_environments)
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_puppet_environments_id_seq" for serial column "katello_content_view_puppet_environments.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_puppet_environments_pkey" for table "katello_content_view_puppet_environments"
- -> 0.0170s
- -- add_index(:katello_content_view_puppet_environments, [:content_view_version_id], {:name=>:index_cvpe_on_content_view_version_id})
- -> 0.0077s
- -- add_index(:katello_content_view_puppet_environments, [:environment_id], {:name=>:index_cvpe_on_environment_id})
- -> 0.0076s
- -- add_index(:katello_content_view_puppet_environments, [:pulp_id], {:name=>:index_cvpe_on_pulp_id})
- -> 0.0089s
- == CreateContentViewPuppetEnvironments: migrated (0.0418s) ===================
- == RepositoryAddChecksumType: migrating ======================================
- -- add_column(:katello_repositories, :checksum_type, :string, {:null=>true})
- -> 0.0008s
- == RepositoryAddChecksumType: migrated (0.0009s) =============================
- == AddCounterCaches: migrating ===============================================
- -- add_column(:architectures, :hosts_count, :integer, {:default=>0})
- -> 0.0237s
- -- add_column(:architectures, :hostgroups_count, :integer, {:default=>0})
- -> 0.0078s
- -- add_column(:domains, :hosts_count, :integer, {:default=>0})
- -> 0.0083s
- -- add_column(:domains, :hostgroups_count, :integer, {:default=>0})
- -> 0.0133s
- -- add_column(:environments, :hosts_count, :integer, {:default=>0})
- -> 0.0152s
- -- add_column(:environments, :hostgroups_count, :integer, {:default=>0})
- -> 0.0114s
- -- add_column(:models, :hosts_count, :integer, {:default=>0})
- -> 0.0105s
- -- add_column(:operatingsystems, :hosts_count, :integer, {:default=>0})
- -> 0.0116s
- -- add_column(:operatingsystems, :hostgroups_count, :integer, {:default=>0})
- -> 0.0166s
- -- add_column(:puppetclasses, :hosts_count, :integer, {:default=>0})
- -> 0.0073s
- -- add_column(:puppetclasses, :hostgroups_count, :integer, {:default=>0})
- -> 0.0086s
- -- add_column(:puppetclasses, :lookup_keys_count, :integer, {:default=>0})
- -> 0.0063s
- == AddCounterCaches: migrated (0.1657s) ======================================
- == FixPuppetclassCounters: migrating =========================================
- -- rename_column(:puppetclasses, :lookup_keys_count, :global_class_params_count)
- -> 0.0010s
- -- add_column(:puppetclasses, :lookup_keys_count, :integer, {:default=>0})
- -> 0.0084s
- == FixPuppetclassCounters: migrated (0.0112s) ================================
- == DropCdnImportSuccessColumn: migrating =====================================
- -- remove_column(:katello_products, :cdn_import_success)
- -> 0.0009s
- == DropCdnImportSuccessColumn: migrated (0.0010s) ============================
- == ChangeHostManagedDefaultToFalse: migrating ================================
- -- change_column(:hosts, :managed, :boolean, {:null=>false, :default=>false})
- -> 0.0655s
- == ChangeHostManagedDefaultToFalse: migrated (0.0672s) =======================
- == AddServerTypeToAuthSource: migrating ======================================
- -- add_column(:auth_sources, :server_type, :string, {:default=>"posix"})
- -> 0.0138s
- == AddServerTypeToAuthSource: migrated (0.0140s) =============================
- == AddGroupsBaseToAuthSource: migrating ======================================
- -- add_column(:auth_sources, :groups_base, :string)
- -> 0.0008s
- == AddGroupsBaseToAuthSource: migrated (0.0009s) =============================
- == RemoveForemanTasksProgress: migrating =====================================
- -- remove_column(:foreman_tasks_tasks, :progress)
- -> 0.0005s
- == RemoveForemanTasksProgress: migrated (0.0005s) ============================
- == AddLowerloginToUsers: migrating ===========================================
- -- add_column(:users, :lower_login, :string)
- -> 0.0007s
- -- add_index(:users, :lower_login, {:unique=>true})
- -> 0.0041s
- == AddLowerloginToUsers: migrated (0.0093s) ==================================
- == CreateContentViewForeignKeys: migrating ===================================
- -- add_foreign_key(:katello_content_view_environments, :katello_content_view_versions, {:name=>"katello_content_view_environments_version_fk", :column=>"content_view_version_id"})
- -> 0.0025s
- -- add_foreign_key(:katello_content_view_components, :katello_content_view_versions, {:name=>"katello_content_view_components_version_fk", :column=>"content_view_version_id"})
- -> 0.0015s
- -- add_foreign_key(:katello_content_view_components, :katello_content_views, {:name=>"katello_content_view_components_view_fk", :column=>"content_view_id"})
- -> 0.0012s
- -- add_foreign_key(:katello_content_view_repositories, :katello_content_views, {:name=>"katello_content_view_repostories_content_view_fk", :column=>"content_view_id"})
- -> 0.0014s
- -- add_foreign_key(:katello_content_view_repositories, :katello_repositories, {:name=>"katello_content_view_repositories_repository_view_fk", :column=>"repository_id"})
- -> 0.0017s
- -- add_foreign_key(:katello_content_view_filters_repositories, :katello_content_view_filters, {:name=>"katello_content_view_filters_repositories_filter_fk", :column=>"content_view_filter_id"})
- -> 0.0022s
- -- add_foreign_key(:katello_content_view_filters_repositories, :katello_repositories, {:name=>"katello_content_view_filters_repositories_repository_fk", :column=>"repository_id"})
- -> 0.0019s
- -- add_foreign_key(:katello_content_view_filters, :katello_content_views, {:name=>"katello_content_view_filters_view_fk", :column=>"content_view_id"})
- -> 0.0019s
- -- add_foreign_key(:katello_content_view_puppet_modules, :katello_content_views, {:name=>"katello_content_view_puppet_modules_view_fk", :column=>"content_view_id"})
- -> 0.0023s
- -- add_foreign_key(:katello_content_view_package_filter_rules, :katello_content_view_filters, {:name=>"katello_content_view_package_filter_rules_filter_fk", :column=>"content_view_filter_id"})
- -> 0.0020s
- -- add_foreign_key(:katello_content_view_package_group_filter_rules, :katello_content_view_filters, {:name=>"katello_content_view_package_group_filter_rules_filter_fk", :column=>"content_view_filter_id"})
- -> 0.0019s
- -- add_foreign_key(:katello_content_view_erratum_filter_rules, :katello_content_view_filters, {:name=>"katello_content_view_erratum_filter_rules_filter_fk", :column=>"content_view_filter_id"})
- -> 0.0020s
- -- add_foreign_key(:katello_content_view_puppet_environments, :katello_content_view_versions, {:name=>"katello_content_view_puppet_environments_view_version_fk", :column=>"content_view_version_id"})
- -> 0.0022s
- -- add_foreign_key(:katello_content_view_puppet_environments, :katello_environments, {:name=>"katello_content_view_puppet_environments_environment_fk", :column=>"environment_id"})
- -> 0.0021s
- -- add_foreign_key(:katello_content_views, :taxonomies, {:name=>"katello_content_views_organization_fk", :column=>"organization_id"})
- -> 0.0019s
- == CreateContentViewForeignKeys: migrated (0.0303s) ==========================
- == DropRepositoriesEnabledColumn: migrating ==================================
- -- remove_column(:katello_repositories, :enabled)
- -> 0.0011s
- == DropRepositoriesEnabledColumn: migrated (0.0013s) =========================
- == CreateConfigGroups: migrating =============================================
- -- create_table(:config_groups)
- NOTICE: CREATE TABLE will create implicit sequence "config_groups_id_seq" for serial column "config_groups.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "config_groups_pkey" for table "config_groups"
- -> 0.0079s
- == CreateConfigGroups: migrated (0.0081s) ====================================
- == CreateConfigGroupClasses: migrating =======================================
- -- create_table(:config_group_classes)
- NOTICE: CREATE TABLE will create implicit sequence "config_group_classes_id_seq" for serial column "config_group_classes.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "config_group_classes_pkey" for table "config_group_classes"
- -> 0.0072s
- == CreateConfigGroupClasses: migrated (0.0073s) ==============================
- == CreateHostConfigGroups: migrating =========================================
- -- create_table(:host_config_groups)
- NOTICE: CREATE TABLE will create implicit sequence "host_config_groups_id_seq" for serial column "host_config_groups.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "host_config_groups_pkey" for table "host_config_groups"
- -> 0.0065s
- == CreateHostConfigGroups: migrated (0.0066s) ================================
- == CreateExternalUsergroups: migrating =======================================
- -- create_table(:external_usergroups)
- NOTICE: CREATE TABLE will create implicit sequence "external_usergroups_id_seq" for serial column "external_usergroups.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "external_usergroups_pkey" for table "external_usergroups"
- -> 0.0041s
- -- add_index(:external_usergroups, :usergroup_id)
- -> 0.0047s
- -- add_foreign_key("external_usergroups", "usergroups", {:name=>"external_usergroups_usergroup_id_fk"})
- -> 0.0022s
- -- add_foreign_key("external_usergroups", "auth_sources", {:name=>"external_usergroups_auth_source_id_fk"})
- -> 0.0014s
- == CreateExternalUsergroups: migrated (0.0128s) ==============================
- == RemoveSubscribeToAllHostgroupsFromUsers: migrating ========================
- -- column_exists?(:users, :subscribe_to_all_hostgroups)
- -> 0.0027s
- -- remove_column(:users, :subscribe_to_all_hostgroups)
- -> 0.0008s
- == RemoveSubscribeToAllHostgroupsFromUsers: migrated (0.0037s) ===============
- == UpdateContentViewDescriptionType: migrating ===============================
- -- change_column(:katello_content_views, :description, :string, {:limit=>255})
- -> 0.0110s
- == UpdateContentViewDescriptionType: migrated (0.0112s) ======================
- == AddCountersToConfigGroups: migrating ======================================
- -- add_column(:config_groups, :hosts_count, :integer)
- -> 0.0009s
- -- add_column(:config_groups, :hostgroups_count, :integer)
- -> 0.0003s
- -- add_column(:config_groups, :config_group_classes_count, :integer)
- -> 0.0005s
- == AddCountersToConfigGroups: migrated (0.0018s) =============================
- == AllowNullContentViewToActivationKey: migrating ============================
- -- change_column(:katello_activation_keys, :environment_id, :integer, {:null=>true})
- -> 0.0188s
- == AllowNullContentViewToActivationKey: migrated (0.0190s) ===================
- == AddConfigGroupCounterDefaults: migrating ==================================
- -- change_column(:config_groups, :hosts_count, :integer, {:default=>0})
- -> 0.0040s
- -- change_column(:config_groups, :hostgroups_count, :integer, {:default=>0})
- -> 0.0030s
- -- change_column(:config_groups, :config_group_classes_count, :integer, {:default=>0})
- -> 0.0032s
- == AddConfigGroupCounterDefaults: migrated (0.1723s) =========================
- == CleanupUsersProperties: migrating =========================================
- -- column_exists?(:users, :domains_andor)
- -> 0.0015s
- -- remove_column(:users, :domains_andor)
- -> 0.0008s
- -- column_exists?(:users, :hostgroups_andor)
- -> 0.0010s
- -- remove_column(:users, :hostgroups_andor)
- -> 0.0005s
- -- column_exists?(:users, :facts_andor)
- -> 0.0009s
- -- remove_column(:users, :facts_andor)
- -> 0.0005s
- -- column_exists?(:users, :compute_resources_andor)
- -> 0.0009s
- -- remove_column(:users, :compute_resources_andor)
- -> 0.0005s
- -- column_exists?(:users, :organizations_andor)
- -> 0.0010s
- -- remove_column(:users, :organizations_andor)
- -> 0.0005s
- -- column_exists?(:users, :locations_andor)
- -> 0.0009s
- -- remove_column(:users, :locations_andor)
- -> 0.0005s
- -- column_exists?(:users, :filter_on_owner)
- -> 0.0009s
- -- remove_column(:users, :filter_on_owner)
- -> 0.0003s
- == CleanupUsersProperties: migrated (0.0114s) ================================
- == RemoveUserJoinTables: migrating ===========================================
- -- table_exists?(:user_compute_resources)
- -> 0.0005s
- -- remove_foreign_key("user_compute_resources", "users")
- -> 0.0010s
- -- remove_foreign_key("user_compute_resources", "compute_resources")
- -> 0.0007s
- -- drop_table(:user_compute_resources)
- -> 0.0005s
- -- table_exists?(:user_notices)
- -> 0.0003s
- -- remove_foreign_key("user_notices", "notices")
- -> 0.0008s
- -- remove_foreign_key("user_notices", "users")
- -> 0.0008s
- -- drop_table(:user_notices)
- -> 0.0003s
- -- table_exists?(:user_facts)
- -> 0.0003s
- -- remove_foreign_key("user_facts", "fact_names")
- -> 0.0008s
- -- remove_foreign_key("user_facts", "users")
- -> 0.0007s
- -- drop_table(:user_facts)
- -> 0.0010s
- -- table_exists?(:user_hostgroups)
- -> 0.0003s
- -- remove_foreign_key("user_hostgroups", "hostgroups")
- -> 0.0008s
- -- remove_foreign_key("user_hostgroups", "users")
- -> 0.0007s
- -- drop_table(:user_hostgroups)
- -> 0.0008s
- -- table_exists?(:user_domains)
- -> 0.0003s
- -- remove_foreign_key("user_domains", "domains")
- -> 0.0008s
- -- remove_foreign_key("user_domains", "users")
- -> 0.0008s
- -- drop_table(:user_domains)
- -> 0.0003s
- -- table_exists?(:notices)
- -> 0.0003s
- -- drop_table(:notices)
- -> 0.0012s
- == RemoveUserJoinTables: migrated (0.0150s) ==================================
- == AddNextVersionToKatelloContentViews: migrating ============================
- -- add_column(:katello_content_views, :next_version, :int, {:null=>false, :default=>1})
- -> 0.0108s
- == AddNextVersionToKatelloContentViews: migrated (0.3522s) ===================
- == UpdateProductsAddOrganization: migrating ==================================
- -- add_column(:katello_products, :organization_id, :integer, {:null=>true})
- -> 0.0010s
- -- change_column(:katello_products, :organization_id, :integer, {:null=>false})
- -> 0.0129s
- -- add_index(:katello_products, :organization_id)
- -> 0.0048s
- == UpdateProductsAddOrganization: migrated (0.0239s) =========================
- == AddAnonymousProvidersToOrgs: migrating ====================================
- == AddAnonymousProvidersToOrgs: migrated (0.0020s) ===========================
- == AddHostIdToSystem: migrating ==============================================
- -- add_column(:katello_systems, :host_id, :integer)
- -> 0.0008s
- -- add_index(:katello_systems, :host_id)
- -> 0.0039s
- -- add_foreign_key("katello_systems", "hosts", {:name=>"katello_systems_host_id", :column=>"host_id"})
- -> 0.0019s
- == AddHostIdToSystem: migrated (0.0068s) =====================================
- == AddReleaseVersionToActivationKeys: migrating ==============================
- -- add_column(:katello_activation_keys, :release_version, :string)
- -> 0.0006s
- == AddReleaseVersionToActivationKeys: migrated (0.0007s) =====================
- == RenameSystemGroupsToHostCollections: migrating ============================
- -- rename_index(:katello_key_system_groups, "katello_key_system_groups_pkey", "katello_key_host_collections_pkey")
- -> 0.0005s
- -- rename_index(:katello_key_system_groups, "index_key_system_groups_on_activation_key_id", "index_key_host_collections_on_activation_key_id")
- -> 0.0003s
- -- rename_index(:katello_key_system_groups, "index_key_system_groups_on_system_group_id", "index_key_host_collections_on_host_collection_id")
- -> 0.0004s
- -- rename_column(:katello_key_system_groups, :system_group_id, :host_collection_id)
- -> 0.0004s
- -- rename_table(:katello_key_system_groups, :katello_key_host_collections)
- -> 0.0023s
- -- rename_index(:katello_system_groups, "katello_system_groups_pkey", "katello_host_collections_pkey")
- -> 0.0003s
- -- rename_index(:katello_system_groups, "index_system_groups_on_name_and_organization_id", "index_host_collections_on_name_and_organization_id")
- -> 0.0003s
- -- rename_index(:katello_system_groups, "index_system_groups_on_organization_id", "index_host_collections_on_organization_id")
- -> 0.0004s
- -- rename_column(:katello_system_groups, :max_systems, :max_content_hosts)
- -> 0.0003s
- -- rename_table(:katello_system_groups, :katello_host_collections)
- -> 0.0021s
- -- rename_index(:katello_system_system_groups, "katello_system_system_groups_pkey", "katello_system_host_collections_pkey")
- -> 0.0004s
- -- rename_index(:katello_system_system_groups, "index_system_system_groups_on_system_group_id", "index_system_host_collections_on_host_collection_id")
- -> 0.0003s
- -- rename_index(:katello_system_system_groups, "index_system_system_groups_on_system_id", "index_system_host_collections_on_system_id")
- -> 0.0004s
- -- rename_column(:katello_system_system_groups, :system_group_id, :host_collection_id)
- -> 0.0004s
- -- rename_table(:katello_system_system_groups, :katello_system_host_collections)
- -> 0.0021s
- == RenameSystemGroupsToHostCollections: migrated (0.0117s) ===================
- == UpdateHostCollectionsForeignKeys: migrating ===============================
- -- remove_foreign_key("katello_key_host_collections", {:name=>"key_system_groups_activation_key_id_fk"})
- -> 0.0008s
- -- remove_foreign_key("katello_key_host_collections", {:name=>"key_system_groups_system_group_id_fk"})
- -> 0.0007s
- -- remove_foreign_key("katello_system_host_collections", {:name=>"system_system_groups_system_group_id_fk"})
- -> 0.0006s
- -- remove_foreign_key("katello_system_host_collections", {:name=>"system_system_groups_system_id_fk"})
- -> 0.0007s
- -- add_foreign_key("katello_key_host_collections", "katello_activation_keys", {:name=>"key_host_collections_activation_key_id_fk", :column=>"activation_key_id"})
- -> 0.0017s
- -- add_foreign_key("katello_key_host_collections", "katello_host_collections", {:name=>"key_host_collections_host_collection_id_fk", :column=>"host_collection_id"})
- -> 0.0013s
- -- add_foreign_key("katello_system_host_collections", "katello_host_collections", {:name=>"system_host_collections_host_collection_id_fk", :column=>"host_collection_id"})
- -> 0.0012s
- -- add_foreign_key("katello_system_host_collections", "katello_systems", {:name=>"system_host_collections_system_id_fk", :column=>"system_id"})
- -> 0.0012s
- == UpdateHostCollectionsForeignKeys: migrated (0.0089s) ======================
- == CreateCapsuleLifecycleEnvironments: migrating =============================
- -- create_table(:katello_capsule_lifecycle_environments)
- NOTICE: CREATE TABLE will create implicit sequence "katello_capsule_lifecycle_environments_id_seq" for serial column "katello_capsule_lifecycle_environments.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_capsule_lifecycle_environments_pkey" for table "katello_capsule_lifecycle_environments"
- -> 0.0039s
- -- add_index(:katello_capsule_lifecycle_environments, [:capsule_id], {:name=>:index_cle_on_capsule_id})
- -> 0.0026s
- -- add_index(:katello_capsule_lifecycle_environments, [:lifecycle_environment_id], {:name=>:index_cle_on_lifecycle_environment_id})
- -> 0.0028s
- == CreateCapsuleLifecycleEnvironments: migrated (0.0096s) ====================
- == AddHiddenValueToParameter: migrating ======================================
- -- add_column(:parameters, :hidden_value, :boolean, {:default=>false})
- -> 0.0091s
- == AddHiddenValueToParameter: migrated (0.0092s) =============================
- == ChangeTemplatekindToBootdisk: migrating ===================================
- == ChangeTemplatekindToBootdisk: migrated (0.0143s) ==========================
- == PackageFilterAddOriginalPackages: migrating ===============================
- -- add_column(:katello_content_view_filters, :original_packages, :boolean, {:default=>false, :null=>false})
- -> 0.0299s
- == PackageFilterAddOriginalPackages: migrated (0.0301s) ======================
- == AddPulpProxyToHost: migrating =============================================
- -- add_column(:hosts, :content_source_id, :integer)
- -> 0.0010s
- -- add_column(:hostgroups, :content_source_id, :integer)
- -> 0.0005s
- -- add_index(:hosts, :content_source_id)
- -> 0.0110s
- -- add_index(:hostgroups, :content_source_id)
- -> 0.0064s
- -- add_foreign_key(:hosts, :smart_proxies, {:name=>"hosts_content_source_id_fk", :column=>"content_source_id"})
- -> 0.0016s
- -- add_foreign_key(:hostgroups, :smart_proxies, {:name=>"hostgroups_content_source_id_fk", :column=>"content_source_id"})
- -> 0.0012s
- == AddPulpProxyToHost: migrated (0.0222s) ====================================
- == ContentViewPuppetEnvironmentId: migrating =================================
- -- add_column(:katello_content_view_puppet_environments, :puppet_environment_id, :integer, {:null=>true})
- -> 0.0008s
- -- add_foreign_key("katello_content_view_puppet_environments", "environments", {:name=>"katello_cvpe_pe_id", :column=>"puppet_environment_id"})
- -> 0.0013s
- == ContentViewPuppetEnvironmentId: migrated (0.0062s) ========================
- == AddUuidToContentViewPackageGroupFilterRule: migrating =====================
- -- add_column(:katello_content_view_package_group_filter_rules, :uuid, :string)
- -> 0.0071s
- == AddUuidToContentViewPackageGroupFilterRule: migrated (0.0072s) ============
- == AddDescriptionToContentViewFilterRules: migrating =========================
- -- add_column(:katello_content_view_filters, :description, :string)
- -> 0.0007s
- == AddDescriptionToContentViewFilterRules: migrated (0.0008s) ================
- == DropTaxonomiesOwnerAutoAttachAllSystemsTaskIdColumn: migrating ============
- -- remove_column(:taxonomies, :owner_auto_attach_all_systems_task_id)
- -> 0.0006s
- == DropTaxonomiesOwnerAutoAttachAllSystemsTaskIdColumn: migrated (0.0007s) ===
- == FixIntegerSettings: migrating =============================================
- == FixIntegerSettings: migrated (0.0012s) ====================================
- == AddForeignKeysForOrganizations: migrating =================================
- -- add_foreign_key(:katello_task_statuses, :taxonomies, {:name=>"katello_task_statuses_organization_fk", :column=>"organization_id"})
- -> 0.0020s
- -- add_foreign_key(:katello_sync_plans, :taxonomies, {:name=>"katello_sync_plans_organization_fk", :column=>"organization_id"})
- -> 0.0012s
- -- add_foreign_key(:katello_providers, :taxonomies, {:name=>"katello_providers_organization_fk", :column=>"organization_id"})
- -> 0.0013s
- -- add_foreign_key(:katello_gpg_keys, :taxonomies, {:name=>"katello_gpg_keys_organization_fk", :column=>"organization_id"})
- -> 0.0011s
- -- add_foreign_key(:katello_products, :taxonomies, {:name=>"katello_products_organization_fk", :column=>"organization_id"})
- -> 0.0012s
- -- add_foreign_key(:katello_activation_keys, :taxonomies, {:name=>"katello_activation_keys_organization_fk", :column=>"organization_id"})
- -> 0.0012s
- -- add_foreign_key(:katello_notices, :taxonomies, {:name=>"katello_notices_organization_fk", :column=>"organization_id"})
- -> 0.0011s
- -- add_foreign_key(:katello_host_collections, :taxonomies, {:name=>"katello_host_collections_organization_fk", :column=>"organization_id"})
- -> 0.0015s
- -- add_foreign_key(:katello_environments, :taxonomies, {:name=>"katello_environments_organization_fk", :column=>"organization_id"})
- -> 0.0012s
- == AddForeignKeysForOrganizations: migrated (0.0126s) ========================
- == RemoveLabelFromActivationKey: migrating ===================================
- -- remove_column(:katello_activation_keys, :label)
- -> 0.0008s
- == RemoveLabelFromActivationKey: migrated (0.0009s) ==========================
- == AddMissingForeignKeys: migrating ==========================================
- -- add_foreign_key(:katello_capsule_lifecycle_environments, :smart_proxies, {:name=>"katello_capsule_lifecycle_environments_capsule_fk", :column=>"capsule_id"})
- -> 0.0017s
- -- add_foreign_key(:katello_capsule_lifecycle_environments, :katello_environments, {:name=>"katello_capsule_lifecycle_environments_environment_fk", :column=>"lifecycle_environment_id"})
- -> 0.0013s
- -- add_foreign_key(:katello_repositories, :katello_environments, {:name=>"katello_repositories_environment_fk", :column=>"environment_id"})
- -> 0.0012s
- -- add_foreign_key(:katello_repositories, :katello_products, {:name=>"katello_repositories_product_fk", :column=>"product_id"})
- -> 0.0013s
- == AddMissingForeignKeys: migrated (0.0059s) =================================
- == AddUnlimitedToActivationKeys: migrating ===================================
- -- add_column(:katello_activation_keys, :unlimited_content_hosts, :boolean, {:default=>true})
- -> 0.0420s
- -- rename_column(:katello_activation_keys, :usage_limit, :max_content_hosts)
- -> 0.0005s
- -- change_column_default(:katello_activation_keys, :max_content_hosts, nil)
- -> 0.0006s
- -- update("UPDATE katello_activation_keys\n SET unlimited_content_hosts = true, max_content_hosts = null\n WHERE max_content_hosts = -1")
- -> 0.0006s
- -> 0 rows
- -- update("UPDATE katello_activation_keys\n SET unlimited_content_hosts = false\n WHERE max_content_hosts > 0")
- -> 0.0003s
- -> 0 rows
- == AddUnlimitedToActivationKeys: migrated (0.0443s) ==========================
- == AddUnlimitedToHostCollection: migrating ===================================
- -- add_column(:katello_host_collections, :unlimited_content_hosts, :boolean, {:default=>true})
- -> 0.0221s
- -- change_column(:katello_host_collections, :max_content_hosts, :integer, {:null=>true, :default=>nil})
- -> 0.0269s
- -- update("UPDATE katello_host_collections\n SET unlimited_content_hosts = true, max_content_hosts = null\n WHERE max_content_hosts = -1")
- -> 0.0005s
- -> 0 rows
- -- update("UPDATE katello_host_collections\n SET unlimited_content_hosts = false\n WHERE max_content_hosts > 0")
- -> 0.0003s
- -> 0 rows
- == AddUnlimitedToHostCollection: migrated (0.0504s) ==========================
- == AddBootModeToSubnet: migrating ============================================
- -- add_column(:subnets, :boot_mode, :string, {:default=>"Static", :null=>false})
- -> 0.0112s
- == AddBootModeToSubnet: migrated (0.0152s) ===================================
- == AddLockedAndDefaultAndVendorToConfigTemplate: migrating ===================
- -- add_column(:config_templates, :locked, :boolean, {:default=>false})
- -> 0.0127s
- -- add_column(:config_templates, :default, :boolean, {:default=>false})
- -> 0.0148s
- -- add_column(:config_templates, :vendor, :string)
- -> 0.0005s
- == AddLockedAndDefaultAndVendorToConfigTemplate: migrated (0.0283s) ==========
- == RemoveArchitectureDefault: migrating ======================================
- -- change_column(:architectures, :name, :string, {:default=>nil})
- -> 0.0054s
- == RemoveArchitectureDefault: migrated (0.0055s) =============================
- == LocationAddKatelloDefault: migrating ======================================
- -- add_column(:taxonomies, :katello_default, :boolean, {:null=>false, :default=>true})
- -> 0.0306s
- == LocationAddKatelloDefault: migrated (0.0307s) =============================
- == RemoveDeletionTaskIdFromTaxonomies: migrating =============================
- -- remove_column(:taxonomies, :deletion_task_id)
- -> 0.0012s
- == RemoveDeletionTaskIdFromTaxonomies: migrated (0.0012s) ====================
- == ExtractNicAttributes: migrating ===========================================
- -- add_column(:nics, :provider, :string)
- -> 0.0007s
- -- add_column(:nics, :username, :string)
- -> 0.0004s
- -- add_column(:nics, :password, :string)
- -> 0.0004s
- -- Extracting serialized attributes
- == ExtractNicAttributes: migrated (0.0033s) ==================================
- == AddAttributesToNicBase: migrating =========================================
- -- add_column(:nics, :virtual, :boolean, {:default=>false, :null=>false})
- -> 0.0113s
- -- add_column(:nics, :link, :boolean, {:default=>true, :null=>false})
- -> 0.0104s
- -- add_column(:nics, :identifier, :string)
- -> 0.0004s
- -- add_column(:nics, :tag, :string, {:default=>"", :null=>false})
- -> 0.0099s
- -- add_column(:nics, :physical_device, :string, {:default=>"", :null=>false})
- -> 0.0105s
- == AddAttributesToNicBase: migrated (0.0429s) ================================
- == AddManagedToNics: migrating ===============================================
- -- add_column(:nics, :managed, :boolean, {:default=>true})
- -> 0.0125s
- == AddManagedToNics: migrated (0.0126s) ======================================
- == ChangeAuditableNameColumnToText: migrating ================================
- -- change_column(:audits, :auditable_name, :text)
- -> 0.0156s
- == ChangeAuditableNameColumnToText: migrated (0.0157s) =======================
- == RepoRenameFeedToUrl: migrating ============================================
- -- rename_column(:katello_repositories, :feed, :url)
- -> 0.0007s
- == RepoRenameFeedToUrl: migrated (0.0008s) ===================================
- == AddPrimaryInterfaceToHosts: migrating =====================================
- -- add_column(:hosts, :primary_interface, :string)
- -> 0.0007s
- == AddPrimaryInterfaceToHosts: migrated (0.0009s) ============================
- == AddIpSuggestionToSubnets: migrating =======================================
- -- add_column(:subnets, :ipam, :boolean, {:default=>true})
- -> 0.0067s
- == AddIpSuggestionToSubnets: migrated (0.0068s) ==============================
- == AddUniqueIndexToParameter: migrating ======================================
- -- add_index(:parameters, [:type, :reference_id, :name], {:unique=>true})
- -> 0.0045s
- == AddUniqueIndexToParameter: migrated (0.0046s) =============================
- == RemoveHiddenColumnFromUser: migrating =====================================
- -- remove_column(:users, :hidden)
- -> 0.0008s
- == RemoveHiddenColumnFromUser: migrated (0.0009s) ============================
- == RemoveDelayedJobs: migrating ==============================================
- -- drop_table("delayed_jobs")
- -> 0.0016s
- == RemoveDelayedJobs: migrated (0.0017s) =====================================
- == AddParentTaskId: migrating ================================================
- -- add_column(:foreman_tasks_tasks, :parent_task_id, :string, {:index=>true})
- -> 0.0007s
- == AddParentTaskId: migrated (0.0008s) =======================================
- == AddSyncPlanEnabledToSyncPlan: migrating ===================================
- -- add_column(:katello_sync_plans, :enabled, :boolean, {:default=>true, :null=>false})
- -> 0.0092s
- == AddSyncPlanEnabledToSyncPlan: migrated (0.0093s) ==========================
- == AddMergeOverridesAndAvoidDuplicatesToLookupKey: migrating =================
- -- add_column(:lookup_keys, :merge_overrides, :boolean)
- -> 0.0008s
- -- add_column(:lookup_keys, :avoid_duplicates, :boolean)
- -> 0.0004s
- == AddMergeOverridesAndAvoidDuplicatesToLookupKey: migrated (0.0013s) ========
- == FixCounters: migrating ====================================================
- ** Invoke fix_cached_counters (first_time)
- ** Invoke environment
- ** Execute fix_cached_counters
- Correcting cached counters: (this may take a few minutes)
- Architecture corrected
- Environment corrected
- Operatingsystem corrected
- Domain corrected
- Realm corrected
- Puppetclass corrected
- Model corrected
- ConfigGroup corrected
- LookupKey corrected
- == FixCounters: migrated (0.1594s) ===========================================
- == ConvertIpamToString: migrating ============================================
- -- add_column(:subnets, :ipam_tmp, :string, {:default=>"DHCP", :null=>false})
- -> 0.0063s
- -- remove_column(:subnets, :ipam)
- -> 0.0006s
- -- rename_column(:subnets, :ipam_tmp, :ipam)
- -> 0.0004s
- == ConvertIpamToString: migrated (0.0114s) ===================================
- == RemoveSignoSetting: migrating =============================================
- == RemoveSignoSetting: migrated (0.0008s) ====================================
- == ChangeNilAdminUsersToFalse: migrating =====================================
- -- change_column(:users, :admin, :boolean, {:null=>false, :default=>false})
- -> 0.0079s
- == ChangeNilAdminUsersToFalse: migrated (0.0100s) ============================
- == AddBondAttributesToNicBase: migrating =====================================
- -- add_column(:nics, :mode, :string, {:null=>false, :default=>"balance-rr"})
- -> 0.0099s
- -- add_column(:nics, :attached_devices, :string, {:default=>"", :null=>false})
- -> 0.0104s
- -- add_column(:nics, :bond_options, :string, {:default=>"", :null=>false})
- -> 0.0119s
- -- rename_column(:nics, :physical_device, :attached_to)
- -> 0.0003s
- == AddBondAttributesToNicBase: migrated (0.0329s) ============================
- == MoveHostNicsToInterfaces: migrating =======================================
- -- add_column(:nics, :primary, :boolean, {:default=>false})
- -> 0.0106s
- -- add_column(:nics, :provision, :boolean, {:default=>false})
- -> 0.0504s
- -- Migrating Host interfaces to standalone Interfaces
- -- remove_column(:hosts, :ip)
- -> 0.0004s
- -- remove_column(:hosts, :mac)
- -> 0.0005s
- -- remove_column(:hosts, :primary_interface)
- -> 0.0004s
- -- remove_foreign_key(:hosts, {:name=>"hosts_subnet_id_fk"})
- -> 0.0008s
- -- remove_column(:hosts, :subnet_id)
- -> 0.0003s
- -- remove_foreign_key(:hosts, {:name=>"hosts_domain_id_fk"})
- -> 0.0007s
- -- remove_column(:hosts, :domain_id)
- -> 0.0006s
- == MoveHostNicsToInterfaces: migrated (0.0673s) ==============================
- == AddPasswordHashToOperatingsystem: migrating ===============================
- -- add_column(:operatingsystems, :password_hash, :string, {:default=>"MD5"})
- -> 0.0074s
- == AddPasswordHashToOperatingsystem: migrated (0.0075s) ======================
- == AddGrubPasswordToHosts: migrating =========================================
- -- add_column(:hosts, :grub_pass, :string, {:default=>""})
- -> 0.0267s
- == AddGrubPasswordToHosts: migrated (0.0268s) ================================
- == AddGrubPasswordToHostgroup: migrating =====================================
- -- add_column(:hostgroups, :grub_pass, :string, {:default=>""})
- -> 0.0111s
- == AddGrubPasswordToHostgroup: migrated (0.0112s) ============================
- == AddShouldUsePuppetDefaultToLookupValueAndKey: migrating ===================
- -- add_column(:lookup_values, :use_puppet_default, :boolean, {:default=>false})
- -> 0.0085s
- -- add_column(:lookup_keys, :use_puppet_default, :boolean)
- -> 0.0004s
- == AddShouldUsePuppetDefaultToLookupValueAndKey: migrated (0.0091s) ==========
- == AddTitleToOs: migrating ===================================================
- -- add_column(:operatingsystems, :title, :string)
- -> 0.0006s
- == AddTitleToOs: migrated (0.0030s) ==========================================
- == AddDescriptionToContentViewVersions: migrating ============================
- -- add_column(:katello_content_view_versions, :description, :text)
- -> 0.0029s
- == AddDescriptionToContentViewVersions: migrated (0.0030s) ===================
- == CreateMailNotifications: migrating ========================================
- -- create_table(:mail_notifications)
- NOTICE: CREATE TABLE will create implicit sequence "mail_notifications_id_seq" for serial column "mail_notifications.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "mail_notifications_pkey" for table "mail_notifications"
- -> 0.0061s
- == CreateMailNotifications: migrated (0.0062s) ===============================
- == CreateUserMailNotifications: migrating ====================================
- -- create_table(:user_mail_notifications)
- NOTICE: CREATE TABLE will create implicit sequence "user_mail_notifications_id_seq" for serial column "user_mail_notifications.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_mail_notifications_pkey" for table "user_mail_notifications"
- -> 0.0042s
- -- add_foreign_key(:user_mail_notifications, :users, {:name=>"user_mail_notifications_user_id_fk"})
- -> 0.0015s
- -- add_foreign_key(:user_mail_notifications, :mail_notifications, {:name=>"user_mail_notifications_mail_notification_id_fk"})
- -> 0.0014s
- == CreateUserMailNotifications: migrated (0.0073s) ===========================
- == AddErrata: migrating ======================================================
- -- create_table("katello_errata")
- NOTICE: CREATE TABLE will create implicit sequence "katello_errata_id_seq" for serial column "katello_errata.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_errata_pkey" for table "katello_errata"
- -> 0.0059s
- -- add_index(:katello_errata, :uuid, {:unique=>true})
- -> 0.0029s
- -- create_table("katello_erratum_packages")
- NOTICE: CREATE TABLE will create implicit sequence "katello_erratum_packages_id_seq" for serial column "katello_erratum_packages.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_erratum_packages_pkey" for table "katello_erratum_packages"
- -> 0.0053s
- -- add_index(:katello_erratum_packages, [:erratum_id, :nvrea, :name, :filename], {:unique=>true, :name=>"katello_erratum_packages_eid_nvrea_n_f"})
- -> 0.0027s
- -- add_foreign_key("katello_erratum_packages", "katello_errata", {:name=>"katello_erratum_packages_errata_id_fk", :column=>"erratum_id"})
- -> 0.0013s
- -- create_table("katello_erratum_cves")
- NOTICE: CREATE TABLE will create implicit sequence "katello_erratum_cves_id_seq" for serial column "katello_erratum_cves.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_erratum_cves_pkey" for table "katello_erratum_cves"
- -> 0.0070s
- -- add_index(:katello_erratum_cves, [:erratum_id, :cve_id, :href], {:unique=>true})
- -> 0.0028s
- -- add_foreign_key("katello_erratum_cves", "katello_errata", {:name=>"katello_erratum_cves_errata_id_fk", :column=>"erratum_id"})
- -> 0.0012s
- -- create_table("katello_erratum_bugzillas")
- NOTICE: CREATE TABLE will create implicit sequence "katello_erratum_bugzillas_id_seq" for serial column "katello_erratum_bugzillas.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_erratum_bugzillas_pkey" for table "katello_erratum_bugzillas"
- -> 0.0058s
- -- add_index(:katello_erratum_bugzillas, [:erratum_id, :bug_id, :href], {:unique=>true, :name=>"katello_erratum_bz_eid_bid_href"})
- -> 0.0027s
- -- add_foreign_key("katello_erratum_bugzillas", "katello_errata", {:name=>"katello_erratum_bugzillas_errata_id_fk", :column=>"erratum_id"})
- -> 0.0014s
- -- create_table("katello_repository_errata")
- NOTICE: CREATE TABLE will create implicit sequence "katello_repository_errata_id_seq" for serial column "katello_repository_errata.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_repository_errata_pkey" for table "katello_repository_errata"
- -> 0.0037s
- -- add_index(:katello_repository_errata, [:erratum_id, :repository_id], {:unique=>true})
- -> 0.0026s
- -- add_foreign_key("katello_repository_errata", "katello_errata", {:name=>"katello_repository_errata_errata_id_fk", :column=>"erratum_id"})
- -> 0.0013s
- -- add_foreign_key("katello_repository_errata", "katello_repositories", {:name=>"katello_repository_errata_repo_id_fk", :column=>"repository_id"})
- -> 0.0013s
- -- create_table("katello_system_errata")
- NOTICE: CREATE TABLE will create implicit sequence "katello_system_errata_id_seq" for serial column "katello_system_errata.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_errata_pkey" for table "katello_system_errata"
- -> 0.0037s
- -- add_index(:katello_system_errata, [:erratum_id, :system_id], {:unique=>true, :name=>:katello_system_errata_eid_sid})
- -> 0.0027s
- -- add_foreign_key("katello_system_errata", "katello_errata", {:name=>"katello_system_errata_errata_id", :column=>"erratum_id"})
- -> 0.0013s
- -- add_foreign_key("katello_system_errata", "katello_systems", {:name=>"katello_system_errata_system_id", :column=>"system_id"})
- -> 0.0012s
- == AddErrata: migrated (0.0583s) =============================================
- == AddEmailToComputeResource: migrating ======================================
- -- add_column(:compute_resources, :email, :string)
- -> 0.0007s
- == AddEmailToComputeResource: migrated (0.0008s) =============================
- == AddMailEnabledToUser: migrating ===========================================
- -- add_column(:users, :mail_enabled, :boolean, {:default=>true})
- -> 0.0082s
- == AddMailEnabledToUser: migrated (0.0084s) ==================================
- == AddSystemRepository: migrating ============================================
- -- create_table("katello_system_repositories")
- NOTICE: CREATE TABLE will create implicit sequence "katello_system_repositories_id_seq" for serial column "katello_system_repositories.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_repositories_pkey" for table "katello_system_repositories"
- -> 0.0040s
- -- add_index(:katello_system_repositories, [:system_id, :repository_id], {:unique=>true, :name=>:katello_system_repositories_sid_rid})
- -> 0.0029s
- -- add_foreign_key("katello_system_repositories", "katello_systems", {:name=>"katello_system_repositories_system_id_fk", :column=>"system_id"})
- -> 0.0014s
- -- add_foreign_key("katello_system_repositories", "katello_repositories", {:name=>"katello_system_repositories_repo_id_fk", :column=>"repository_id"})
- -> 0.0014s
- == AddSystemRepository: migrated (0.0100s) ===================================
- == AddDockerContainerRegistryUrlToProviders: migrating =======================
- -- add_column(:katello_providers, :docker_registry_url, :string)
- -> 0.0007s
- == AddDockerContainerRegistryUrlToProviders: migrated (0.1681s) ==============
- == CreateContainers: migrating ===============================================
- -- create_table(:containers)
- NOTICE: CREATE TABLE will create implicit sequence "containers_id_seq" for serial column "containers.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "containers_pkey" for table "containers"
- -> 0.0089s
- == CreateContainers: migrated (0.0090s) ======================================
- == AddComputeResourceIdToContainer: migrating ================================
- -- add_column(:containers, :compute_resource_id, :integer)
- -> 0.0007s
- == AddComputeResourceIdToContainer: migrated (0.0010s) =======================
- == AddTagToContainer: migrating ==============================================
- -- add_column(:containers, :tag, :string)
- -> 0.0010s
- == AddTagToContainer: migrated (0.0011s) =====================================
- == AddAttributesToContainer: migrating =======================================
- -- add_column(:containers, :entrypoint, :string)
- -> 0.0010s
- -- add_column(:containers, :cpu_set, :integer)
- -> 0.0006s
- -- add_column(:containers, :cpu_shares, :float)
- -> 0.0006s
- -- add_column(:containers, :memory, :integer)
- -> 0.0006s
- -- add_column(:containers, :tty, :boolean)
- -> 0.0006s
- -- add_column(:containers, :attach_stdin, :boolean, {:default=>true})
- -> 0.0071s
- -- add_column(:containers, :attach_stdout, :boolean, {:default=>true})
- -> 0.0073s
- -- add_column(:containers, :attach_stderr, :boolean, {:default=>true})
- -> 0.0063s
- == AddAttributesToContainer: migrated (0.0249s) ==============================
- == CreateDockerImages: migrating =============================================
- -- create_table(:docker_images)
- NOTICE: CREATE TABLE will create implicit sequence "docker_images_id_seq" for serial column "docker_images.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_images_pkey" for table "docker_images"
- -> 0.0053s
- -- create_table(:docker_tags)
- NOTICE: CREATE TABLE will create implicit sequence "docker_tags_id_seq" for serial column "docker_tags.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_tags_pkey" for table "docker_tags"
- -> 0.0038s
- -- add_foreign_key(:docker_tags, :docker_images, {:column=>:docker_image_id})
- -> 0.0013s
- -- remove_column(:containers, :image)
- -> 0.0004s
- -- remove_column(:containers, :tag)
- -> 0.0004s
- -- add_column(:containers, :docker_image_id, :integer)
- -> 0.0005s
- -- add_column(:containers, :docker_tag_id, :integer)
- -> 0.0003s
- -- add_foreign_key(:containers, :docker_images, {:column=>:docker_image_id})
- -> 0.0012s
- -- add_foreign_key(:containers, :docker_tags, {:column=>:docker_tag_id})
- -> 0.0012s
- == CreateDockerImages: migrated (0.0149s) ====================================
- == AddSubscriptionTypeToMailNotifications: migrating =========================
- -- add_column(:mail_notifications, :subscription_type, :string)
- -> 0.0010s
- == AddSubscriptionTypeToMailNotifications: migrated (0.0011s) ================
- == RemoveFailedReportSetting: migrating ======================================
- == RemoveFailedReportSetting: migrated (0.0007s) =============================
- == AddDockerImageFields: migrating ===========================================
- -- add_column(:docker_images, :katello_uuid, :string)
- -> 0.0027s
- -- add_column(:docker_images, :katello_repository_id, :integer)
- -> 0.0003s
- -- add_column(:docker_tags, :katello_repository_id, :integer)
- -> 0.0004s
- -- create_table(:katello_repository_docker_images)
- NOTICE: CREATE TABLE will create implicit sequence "katello_repository_docker_images_id_seq" for serial column "katello_repository_docker_images.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_repository_docker_images_pkey" for table "katello_repository_docker_images"
- -> 0.0034s
- -- add_index(:docker_images, :katello_uuid, {:unique=>true})
- -> 0.0028s
- -- add_index(:katello_repository_docker_images, [:docker_image_id, :repository_id], {:name=>:katello_repo_docker_imgs_image_repo_id, :unique=>true})
- -> 0.0028s
- -- add_index(:docker_tags, [:docker_image_id, :katello_repository_id, :tag], {:name=>:katello_repo_docker_tags_image_repo_id, :unique=>true})
- -> 0.0026s
- -- add_foreign_key(:katello_repository_docker_images, :docker_images, {:column=>:docker_image_id})
- -> 0.0013s
- -- add_foreign_key(:katello_repository_docker_images, :katello_repositories, {:column=>:repository_id})
- -> 0.0013s
- -- add_foreign_key(:docker_tags, :katello_repositories, {:column=>:katello_repository_id})
- -> 0.0013s
- == AddDockerImageFields: migrated (0.0196s) ==================================
- == AddUuidToContainers: migrating ============================================
- -- add_column(:containers, :uuid, :string)
- -> 0.0007s
- -- add_index(:containers, [:uuid, :compute_resource_id])
- -> 0.0034s
- == AddUuidToContainers: migrated (0.0043s) ===================================
- == RenameSubnetNameToUnique: migrating =======================================
- == RenameSubnetNameToUnique: migrated (0.0013s) ==============================
- == AddTimezoneToUser: migrating ==============================================
- -- add_column(:users, :timezone, :string)
- -> 0.0008s
- == AddTimezoneToUser: migrated (0.0009s) =====================================
- == CreateDockerRegistries: migrating =========================================
- -- create_table(:docker_registries)
- NOTICE: CREATE TABLE will create implicit sequence "docker_registries_id_seq" for serial column "docker_registries.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_registries_pkey" for table "docker_registries"
- -> 0.0061s
- -- create_table(:docker_image_docker_registries)
- NOTICE: CREATE TABLE will create implicit sequence "docker_image_docker_registries_id_seq" for serial column "docker_image_docker_registries.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_image_docker_registries_pkey" for table "docker_image_docker_registries"
- -> 0.0035s
- -- add_index(:docker_image_docker_registries, [:docker_registry_id, :docker_image_id], {:name=>"by_docker_image_and_registry", :unique=>true})
- -> 0.0028s
- == CreateDockerRegistries: migrated (0.0126s) ================================
- == ChangeMemoryInContainer: migrating ========================================
- -- change_column(:containers, :memory, :string)
- -> 0.0074s
- == ChangeMemoryInContainer: migrated (0.0075s) ===============================
- == ChangeCpusetInContainer: migrating ========================================
- -- change_column(:containers, :cpu_set, :string)
- -> 0.0074s
- == ChangeCpusetInContainer: migrated (0.0076s) ===============================
- == AddTagRepositoryIdIndex: migrating ========================================
- -- add_index(:docker_tags, [:tag, :katello_repository_id], {:name=>:katello_docker_tag_repository_id, :unique=>true})
- -> 0.0041s
- == AddTagRepositoryIdIndex: migrated (0.0042s) ===============================
- == CreateDiscoveryRules: migrating ===========================================
- -- create_table(:discovery_rules)
- NOTICE: CREATE TABLE will create implicit sequence "discovery_rules_id_seq" for serial column "discovery_rules.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "discovery_rules_pkey" for table "discovery_rules"
- -> 0.0064s
- == CreateDiscoveryRules: migrated (0.0065s) ==================================
- == AddDiscoveryRuleToHost: migrating =========================================
- -- add_column(:hosts, :discovery_rule_id, :integer)
- -> 0.0008s
- == AddDiscoveryRuleToHost: migrated (0.0009s) ================================
- == RenameHostsCountColumn: migrating =========================================
- -- rename_column(:puppetclasses, :hosts_count, :total_hosts)
- -> 0.0005s
- == RenameHostsCountColumn: migrated (0.0006s) ================================
- == FixPuppetclassTotalHosts: migrating =======================================
- ** Invoke puppet:fix_total_hosts (first_time)
- ** Invoke environment
- ** Execute puppet:fix_total_hosts
- == FixPuppetclassTotalHosts: migrated (0.0014s) ==============================
- == AddTypeToParameterIndex: migrating ========================================
- -- index_exists?(:parameters, [:reference_id, :name], {:unique=>true})
- -> 0.0019s
- == AddTypeToParameterIndex: migrated (0.0020s) ===============================
- == AddAutoAttachToActivationKeys: migrating ==================================
- -- add_column(:katello_activation_keys, :auto_attach, :boolean)
- -> 0.0008s
- == AddAutoAttachToActivationKeys: migrated (0.0009s) =========================
- == AddUserCredentialsToDockerRegistries: migrating ===========================
- -- add_column(:docker_registries, :username, :string)
- -> 0.0006s
- -- add_column(:docker_registries, :password, :string)
- -> 0.0004s
- == AddUserCredentialsToDockerRegistries: migrated (0.0011s) ==================
- == RemoveAuditUserFk: migrating ==============================================
- -- remove_foreign_key(:audits, :user)
- -> 0.0010s
- == RemoveAuditUserFk: migrated (0.0011s) =====================================
- == RenameSmartProxyAuthRelatedSettings: migrating ============================
- == RenameSmartProxyAuthRelatedSettings: migrated (0.0000s) ===================
- == ContentViewVersionAddMinor: migrating =====================================
- -- add_column(:katello_content_view_versions, :minor, :integer, {:null=>false, :default=>0})
- -> 0.0081s
- -- rename_column(:katello_content_view_versions, :version, :major)
- -> 0.0005s
- == ContentViewVersionAddMinor: migrated (0.0088s) ============================
- == AddDiscoveryIdToSubnet: migrating =========================================
- -- add_column(:subnets, :discovery_id, :integer)
- -> 0.0008s
- == AddDiscoveryIdToSubnet: migrated (0.0009s) ================================
- == MakeTemplatesDefault: migrating ===========================================
- == MakeTemplatesDefault: migrated (0.0229s) ==================================
- == AddTimestampsToRepositoryJoinTables: migrating ============================
- -- change_table(:katello_repository_errata)
- -> 0.0011s
- -- change_table(:katello_repository_docker_images)
- -> 0.0007s
- == AddTimestampsToRepositoryJoinTables: migrated (0.0020s) ===================
- == AddDefaultValueToAutoAttach: migrating ====================================
- -- change_column(:katello_activation_keys, :auto_attach, :boolean, {:default=>true})
- -> 0.0270s
- == AddDefaultValueToAutoAttach: migrated (0.0271s) ===========================
- == DisownForemanTemplates: migrating =========================================
- == DisownForemanTemplates: migrated (0.0043s) ================================
- == RemoveDockerTables: migrating =============================================
- -- change_table(:containers)
- -> 0.0014s
- -- remove_foreign_key(:containers, {:name=>:containers_docker_image_id_fk})
- -> 0.0007s
- -- remove_foreign_key(:containers, {:name=>:containers_docker_tag_id_fk})
- -> 0.0007s
- -- remove_column(:containers, :docker_image_id)
- -> 0.0004s
- -- remove_column(:containers, :docker_tag_id)
- -> 0.0003s
- -- execute("DROP TABLE docker_images CASCADE")
- NOTICE: drop cascades to 2 other objects
- DETAIL: drop cascades to constraint docker_tags_docker_image_id_fk on table docker_tags
- drop cascades to constraint katello_repository_docker_images_docker_image_id_fk on table katello_repository_docker_images
- -> 0.0021s
- -- execute("DROP TABLE docker_tags CASCADE")
- -> 0.0015s
- -- execute("DROP TABLE docker_image_docker_registries CASCADE")
- -> 0.0010s
- == RemoveDockerTables: migrated (0.0133s) ====================================
- == CreateDockerTables: migrating =============================================
- -- create_table(:katello_docker_images)
- NOTICE: CREATE TABLE will create implicit sequence "katello_docker_images_id_seq" for serial column "katello_docker_images.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_docker_images_pkey" for table "katello_docker_images"
- -> 0.0075s
- -- create_table(:katello_docker_tags)
- NOTICE: CREATE TABLE will create implicit sequence "katello_docker_tags_id_seq" for serial column "katello_docker_tags.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_docker_tags_pkey" for table "katello_docker_tags"
- -> 0.0037s
- -- add_index(:katello_docker_images, :uuid, {:unique=>true})
- -> 0.0030s
- -- add_foreign_key(:katello_docker_tags, :katello_docker_images, {:column=>"docker_image_id"})
- -> 0.0013s
- -- add_foreign_key(:katello_docker_tags, :katello_repositories, {:column=>"repository_id"})
- -> 0.0014s
- -- add_index(:katello_docker_tags, [:docker_image_id, :repository_id, :name], {:name=>:docker_tag_docker_image_repo_name, :unique=>true})
- -> 0.0029s
- -- add_foreign_key(:katello_repository_docker_images, :katello_docker_images, {:column=>:docker_image_id})
- -> 0.0014s
- == CreateDockerTables: migrated (0.0219s) ====================================
- == TrackVersionComponents: migrating =========================================
- -- create_table("katello_content_view_version_components")
- NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_version_components_id_seq" for serial column "katello_content_view_version_components.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_version_components_pkey" for table "katello_content_view_version_components"
- -> 0.0046s
- -- add_index(:katello_content_view_version_components, [:component_version_id, :composite_version_id], {:unique=>true, :name=>:katello_cvv_components_cid_cid_unq})
- -> 0.0027s
- -- add_foreign_key("katello_content_view_version_components", "katello_content_view_versions", {:name=>"katello_cvv_components_component_fk", :column=>"component_version_id"})
- -> 0.0014s
- -- add_foreign_key("katello_content_view_version_components", "katello_content_view_versions", {:name=>"katello_cvv_components_composite_fk", :column=>"composite_version_id"})
- -> 0.0012s
- == TrackVersionComponents: migrated (0.0103s) ================================
- == AddComputeAttributesToNics: migrating =====================================
- -- add_column(:nics, :compute_attributes, :text)
- -> 0.0007s
- == AddComputeAttributesToNics: migrated (0.0008s) ============================
- == CreateWizardStates: migrating =============================================
- -- create_table(:docker_container_wizard_states)
- NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_id_seq" for serial column "docker_container_wizard_states.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_pkey" for table "docker_container_wizard_states"
- -> 0.0043s
- -- create_table(:docker_container_wizard_states_preliminaries)
- NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_preliminaries_id_seq" for serial column "docker_container_wizard_states_preliminaries.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_preliminaries_pkey" for table "docker_container_wizard_states_preliminaries"
- -> 0.0037s
- -- create_table(:docker_container_wizard_states_images)
- NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_images_id_seq" for serial column "docker_container_wizard_states_images.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_images_pkey" for table "docker_container_wizard_states_images"
- -> 0.0061s
- -- create_table(:docker_container_wizard_states_configurations)
- NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_configurations_id_seq" for serial column "docker_container_wizard_states_configurations.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_configurations_pkey" for table "docker_container_wizard_states_configurations"
- -> 0.0061s
- -- create_table(:docker_container_wizard_states_environments)
- NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_environments_id_seq" for serial column "docker_container_wizard_states_environments.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_environments_pkey" for table "docker_container_wizard_states_environments"
- -> 0.0048s
- == CreateWizardStates: migrated (0.0254s) ====================================
- == AddHostContentViewEnvironment: migrating ==================================
- -- add_column(:hosts, :content_view_id, :integer, {:null=>true})
- -> 0.0008s
- -- add_column(:hosts, :lifecycle_environment_id, :integer, {:null=>true})
- -> 0.0004s
- -- add_column(:hostgroups, :content_view_id, :integer, {:null=>true})
- -> 0.0004s
- -- add_column(:hostgroups, :lifecycle_environment_id, :integer, {:null=>true})
- -> 0.0004s
- == AddHostContentViewEnvironment: migrated (0.0083s) =========================
- == CreateDiscoveryAttributeSets: migrating ===================================
- -- create_table(:discovery_attribute_sets)
- NOTICE: CREATE TABLE will create implicit sequence "discovery_attribute_sets_id_seq" for serial column "discovery_attribute_sets.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "discovery_attribute_sets_pkey" for table "discovery_attribute_sets"
- -> 0.0047s
- -- add_index(:discovery_attribute_sets, :host_id)
- -> 0.0028s
- -- add_foreign_key("discovery_attribute_sets", "hosts", {:name=>"discovery_attribute_sets_host_id_fk"})
- -> 0.0020s
- == CreateDiscoveryAttributeSets: migrated (0.0097s) ==========================
- == FillDiscoveryAttributeSetsForExistingHosts: migrating =====================
- == FillDiscoveryAttributeSetsForExistingHosts: migrated (0.1384s) ============
- == AddDescriptionToTaxonomies: migrating =====================================
- -- column_exists?(:taxonomies, :description)
- -> 0.0013s
- == AddDescriptionToTaxonomies: migrated (0.0014s) ============================
- == AddCapsuleIdToContainer: migrating ========================================
- -- add_column(:containers, :capsule_id, :integer)
- -> 0.0008s
- -- add_foreign_key(:containers, :smart_proxies, {:column=>"capsule_id"})
- -> 0.0015s
- -- add_column(:docker_container_wizard_states_images, :capsule_id, :integer)
- -> 0.0005s
- == AddCapsuleIdToContainer: migrated (0.0030s) ===============================
- == ActuallyRenameSmartProxyAuthRelatedSettings: migrating ====================
- == ActuallyRenameSmartProxyAuthRelatedSettings: migrated (0.0019s) ===========
- == AddUpstreamNameToRepository: migrating ====================================
- -- add_column(:katello_repositories, :docker_upstream_name, :string)
- -> 0.0009s
- == AddUpstreamNameToRepository: migrated (0.3548s) ===========================
- == UpdatePromoteErrataEmailDescription: migrating ============================
- == UpdatePromoteErrataEmailDescription: migrated (0.0169s) ===================
- == AddKatelloFlagToDockerWizardImage: migrating ==============================
- -- add_column(:docker_container_wizard_states_images, :katello, :boolean)
- -> 0.0007s
- == AddKatelloFlagToDockerWizardImage: migrated (0.0008s) =====================
- == SetPtableLayoutToText: migrating ==========================================
- -- change_column(:ptables, :layout, :text, {:null=>false})
- -> 0.0055s
- == SetPtableLayoutToText: migrated (0.0056s) =================================
- == AddKatelloFlagToContainers: migrating =====================================
- -- add_column(:containers, :katello, :boolean)
- -> 0.0005s
- == AddKatelloFlagToContainers: migrated (0.0007s) ============================
- == MoveDescriptionFieldsToText: migrating ====================================
- -- change_column(:compute_resources, :description, :text)
- -> 0.0056s
- -- change_column(:operatingsystems, :description, :text)
- -> 0.0067s
- -- change_column(:lookup_keys, :description, :text)
- -> 0.0224s
- -- change_column(:mail_notifications, :description, :text)
- -> 0.0077s
- == MoveDescriptionFieldsToText: migrated (0.0428s) ===========================
- == ChangeDefaultSubnetBootMode: migrating ====================================
- -- change_column(:subnets, :boot_mode, :string, {:default=>"DHCP"})
- -> 0.0068s
- == ChangeDefaultSubnetBootMode: migrated (0.0069s) ===========================
- == ChangeDescriptionsToTextFields: migrating =================================
- -- change_column(:katello_content_view_filters, :description, :text)
- -> 0.0082s
- -- change_column(:katello_content_views, :description, :text)
- -> 0.0097s
- == ChangeDescriptionsToTextFields: migrated (0.0181s) ========================
- == RemoveDuplicateTokensFromHosts: migrating =================================
- == RemoveDuplicateTokensFromHosts: migrated (0.0026s) ========================
- == RemoveKatelloFlagFromContainers: migrating ================================
- -- remove_column(:containers, :katello)
- -> 0.0007s
- == RemoveKatelloFlagFromContainers: migrated (0.0008s) =======================
- == AddContentHostIdToSmartProxy: migrating ===================================
- -- add_column(:smart_proxies, :content_host_id, :integer)
- -> 0.0006s
- -- add_foreign_key(:smart_proxies, :katello_systems, {:column=>"content_host_id"})
- -> 0.0015s
- == AddContentHostIdToSmartProxy: migrated (0.0062s) ==========================
- == AddIndexToLogsSourceId: migrating =========================================
- -- add_index(:logs, :source_id)
- -> 0.0042s
- == AddIndexToLogsSourceId: migrated (0.0043s) ================================
- == CopyUnmanagedHostsToInterfaces: migrating =================================
- -- Migrating Unmanaged Host interfaces to standalone Interfaces
- == CopyUnmanagedHostsToInterfaces: migrated (0.0025s) ========================
- == AddUsergroupSyncToAuthSources: migrating ==================================
- -- add_column(:auth_sources, :usergroup_sync, :boolean, {:null=>false, :default=>true})
- -> 0.0060s
- == AddUsergroupSyncToAuthSources: migrated (0.0061s) =========================
- ** Invoke db:_dump (first_time)
- ** Execute db:_dump
- ** Invoke db:schema:dump (first_time)
- ** Invoke environment
- ** Invoke db:load_config
- ** Execute db:schema:dump
- ** Invoke fix_db_cache (first_time)
- ** Invoke environment
- ** Execute fix_db_cache
- Recreating cache
Advertisement
Add Comment
Please, Sign In to add comment