Actions
Bug #1736
closeddb:migrate does generate errors
Description
Hi,
As already discussed on #theforeman, there is an issue with db:migrate on MYSQL.
I tested on my production DB, and on an empty DB, same problem.
On the production DB:
[root@lpr-mgmt01 foreman]# RAILS_ENV=production bundle exec rake db:migrate /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:10: warning: already initialized constant ENC_NONE /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:11: warning: already initialized constant ENC_EUC /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:12: warning: already initialized constant ENC_SJIS /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:13: warning: already initialized constant ENC_UTF8 == AddSubnetAndDomainToHostGroups: migrating ================================= -- add_column(:hostgroups, :subnet_id, :integer) rake aborted! An error has occurred, all later migrations canceled: Mysql::Error: Duplicate column name 'subnet_id': ALTER TABLE `hostgroups` ADD `subnet_id` int(11) Tasks: TOP => db:migrate (See full trace by running task with --trace) [root@lpr-mgmt01 foreman]# RAILS_ENV=production bundle exec rake db:migrate:status /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:10: warning: already initialized constant ENC_NONE /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:11: warning: already initialized constant ENC_EUC /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:12: warning: already initialized constant ENC_SJIS /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:13: warning: already initialized constant ENC_UTF8 database: puppet Status Migration ID Migration Name -------------------------------------------------- up 20101018120621 Create logs up 20091219132839 Create lookup values up 20100914092104 Add my booleans to user up 20120110113051 Create subnet domain up 20120506143325 Create images up 20100625155400 Create notices up 20090907045751 Add domain to parameter up 20110712070522 Create host class up 20120127141602 Add windows templates up 20100325142616 Update fact names and values to bin up 20111124095054 Add remote address to audits up 20100523141204 Create media operatingsystems and migrate data up 20100822072954 Create user facts up 20101202104444 Add proxy to domain up 20090905155444 Add type to parameter up 20090715143858 Create architectures up 20120529113900 Add user compute resources up 20110404150043 Add media path to medium up 20110407091150 Add image to host up 20090729132209 Create reports up 20110420150600 Add solaris templates up 20090920064156 Add index to parameters up 20100524080302 Migrate installation medium uri up 20110301154453 Add managed to hosts up 20101122132041 Create operatingsystems config templates up 20100414125652 Add releasename to os up 20111124095053 Rename changes to audited changes up 20100701081235 Add user domains and hostgroups up 20100629093200 Create roles down 20120624081510 Add auditable name and associated name to audit up 20090720134126 Create operatingsystems down 20120613082125 Rename association to associated up 20120509131302 Add cert name to host up 20090802062223 Create puppetclasses up 20101103150254 Add owned filter to user up 20090714132448 Create hosts up 20090730152224 Create ptables down 20120705130038 Add attributes to compute resources up 20110412103238 Remove unused fields from puppet classes up 20101130100315 Create proxies up 20090920065522 Add index to reports up 20090718064254 Create subnets up 20120122131037 Create compute resources up 20120607074318 Convert params to text up 20101125153351 Add default templates up 20110327123639 Add priority to parameter up 20110725142054 Add suse templates up 20110616080444 Add look up key id to puppet class up 20090905150131 Create hostgroups up 20100525094200 Simplify parameters up 20120521142924 Add dns id to subnet up 20110619130336 Add ancestry to hostgroup up 20100419151910 Add owner to hosts up 20090718060746 Create domains up 20100823181036 Add enabled to hosts up 20090920043521 Add index to host up 20101213085232 Add grubby template up 20101121080425 Create config templates up 20110213104226 Create proxy features up 20090722141107 Create environments up 20101121135521 Create template combinations up 20100616114400 Change family in os up 20091214045923 Calc existing reports up 20091012135004 Create users up 20090722140138 Create models up 20110617190131 Add sparc info to model up 20110128130239 Add default pxe menu template down 20120624094034 Add os family to ptable up 20100601221000 Update os minor up 20120510113417 Create key pairs up 20100310080727 Add family to os up 20100115021803 Change mysql reports column up 20110628115422 Create settings up 20110801090318 Add vm defaults to hostgroup up 20120102071633 Add from and to ranges to subnets up 20120604114049 Add epel snippets up 20110712064120 Update audits table up 20100628123400 Add internal auth up 20101123153303 Create os default templates up 20120523065531 Add image id to host up 20120126113850 Add uuid and compute id to host up 20091219132338 Create lookup keys down 20120624093958 Add os family to media up 20120529115814 Add compute resources boolean to user up 20120502105518 Update report field to large int up 20111227095806 Ensure all hostnames are lowercase up 20101123152150 Create template kinds up 20090916053824 Change host build default to false up 20101019183859 Convert reports up 20101019122857 Add metrics to report up 20090804130144 Create parameters up 20101018120603 Create sources up 20091016031017 Create sessions down 20120620124659 Fix associated type up 20110417102947 Add table bookmarks up 20090820130541 Create auth sources down 20120620124658 Fix auditable type up 20090714132449 Add audits table up 20111124095055 Rename parent to association up 20110216101848 Change puppetmaster column up 20101018120548 Create messages up 20100523114430 Add ubuntu custom lvm ptable up 20120612070100 Change bookmark column to text up 20090915030726 Change report field type to text up 20120313081913 Add puppet master proxy to host and host group up 20101130093613 Add sub systems to subnet up 20090717025820 Create media up 20110106132600 Create hypervisors up 20110117162722 Add host group defaults up 20100416124600 Create usergroups up 20110613141800 Add solaris disks up 20111205231500 Add gateway and dns to subnets up 20091022054108 Add status to report up 20110321070954 Revert face names and values to text records up 20101118130026 Correct media down 20120623002052 Add ok hosts book mark down 20110803114134 Add subnet and domain to host groups @ On an empty new DB (needs to run db:migrate twice to have errors): @ [root@lpr-mgmt01 foreman]# RAILS_ENV=production bundle exec rake db:migrate /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:10: warning: already initialized constant ENC_NONE /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:11: warning: already initialized constant ENC_EUC /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:12: warning: already initialized constant ENC_SJIS /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:13: warning: already initialized constant ENC_UTF8 == CreateHosts: migrating ==================================================== == AddCreatedAtToAllTables: migrating ======================================== -- add_column("inventory_facts", :created_at, :datetime) -> 0.0364s -- add_column("schema_migrations", :created_at, :datetime) -> 0.0269s == AddCreatedAtToAllTables: migrated (0.0735s) =============================== == RemoveDuplicatedIndexOnAllTables: migrating =============================== == RemoveDuplicatedIndexOnAllTables: migrated (0.0075s) ====================== == AddEnvironmentToHost: migrating =========================================== == AddEnvironmentToHost: migrated (0.0009s) ================================== == AddInventoryServiceTables: migrating ====================================== == AddInventoryServiceTables: migrated (0.0010s) ============================= -- add_column(:hosts, :mac, :string, {:default=>"", :limit=>17}) -> 0.0482s -- add_column(:hosts, :sp_mac, :string, {:default=>"", :limit=>17}) -> 0.0341s -- add_column(:hosts, :sp_ip, :string, {:default=>"", :limit=>15}) -> 0.0451s -- add_column(:hosts, :sp_name, :string, {:default=>""}) -> 0.0454s -- add_column(:hosts, :root_pass, :string, {:limit=>64}) -> 0.0546s -- add_column(:hosts, :serial, :string, {:limit=>12}) -> 0.0473s -- add_column(:hosts, :puppetmaster, :string) -> 0.0319s -- add_column(:hosts, :puppet_status, :integer, {:null=>false, :default=>0}) -> 0.0719s -- add_column(:hosts, :domain_id, :integer) -> 0.0402s -- add_column(:hosts, :architecture_id, :integer) -> 0.0337s -- add_column(:hosts, :operatingsystem_id, :integer) -> 0.0359s -- add_column(:hosts, :environment_id, :integer) -> 0.0390s -- add_column(:hosts, :subnet_id, :integer) -> 0.0504s -- add_column(:hosts, :sp_subnet_id, :integer) -> 0.0681s -- add_column(:hosts, :ptable_id, :integer) -> 0.0444s -- add_column(:hosts, :medium_id, :integer) -> 0.0792s -- add_column(:hosts, :build, :boolean, {:default=>true}) -> 0.1775s -- add_column(:hosts, :comment, :text) -> 0.0358s -- add_column(:hosts, :disk, :text) -> 0.0586s -- add_column(:hosts, :installed_at, :datetime) -> 0.0402s == CreateHosts: migrated (2.4030s) =========================================== == AddAuditsTable: migrating ================================================= -- create_table(:audits, {:force=>true}) -> 0.0256s -- add_index(:audits, [:auditable_id, :auditable_type], {:name=>"auditable_index"}) -> 0.0820s -- add_index(:audits, [:user_id, :user_type], {:name=>"user_index"}) -> 0.0367s -- add_index(:audits, :created_at) -> 0.0410s -- add_index(:audits, [:auditable_parent_id, :auditable_parent_type], {:name=>"auditable_parent_index"}) -> 0.0499s == AddAuditsTable: migrated (0.2356s) ======================================== == CreateArchitectures: migrating ============================================ -- create_table(:architectures) -> 0.0318s -- create_table(:architectures_operatingsystems, {:id=>false}) -> 0.0199s == CreateArchitectures: migrated (0.0519s) =================================== == CreateMedia: migrating ==================================================== -- create_table(:media) -> 0.0214s == CreateMedia: migrated (0.0480s) =========================================== == CreateDomains: migrating ================================================== -- create_table(:domains) -> 0.0320s == CreateDomains: migrated (0.0321s) ========================================= == CreateSubnets: migrating ================================================== -- create_table(:subnets) -> 0.0210s == CreateSubnets: migrated (0.0211s) ========================================= == CreateOperatingsystems: migrating ========================================= -- create_table(:operatingsystems) -> 0.0300s == CreateOperatingsystems: migrated (0.0300s) ================================ == CreateModels: migrating =================================================== -- create_table(:models) -> 0.0218s -- add_column(:hosts, :model_id, :integer) -> 0.0366s == CreateModels: migrated (0.0586s) ========================================== == CreateEnvironments: migrating ============================================= -- create_table(:environments) -> 0.0188s -- create_table(:environments_puppetclasses, {:id=>false}) -> 0.0246s == CreateEnvironments: migrated (0.0435s) ==================================== == CreateReports: migrating ================================================== -- create_table(:reports) -> 0.0221s == CreateReports: migrated (0.0222s) ========================================= == CreatePtables: migrating ================================================== -- create_table(:ptables) -> 0.0498s -- create_table(:operatingsystems_ptables, {:id=>false}) -> 0.0319s == CreatePtables: migrated (0.0979s) ========================================= == CreatePuppetclasses: migrating ============================================ -- create_table(:puppetclasses) -> 0.0226s -- create_table(:hosts_puppetclasses, {:id=>false}) -> 0.0189s -- create_table(:operatingsystems_puppetclasses, {:id=>false}) -> 0.0356s == CreatePuppetclasses: migrated (0.0773s) =================================== == CreateParameters: migrating =============================================== -- create_table(:parameters) -> 0.0287s == CreateParameters: migrated (0.0288s) ====================================== == CreateAuthSources: migrating ============================================== -- create_table(:auth_sources) -> 0.0412s == CreateAuthSources: migrated (0.0413s) ===================================== == CreateHostgroups: migrating =============================================== -- create_table(:hostgroups) -> 0.0186s -- create_table(:hostgroups_puppetclasses, {:id=>false}) -> 0.0176s -- add_column(:hosts, :hostgroup_id, :integer) -> 0.0390s -- add_column(:parameters, :hostgroup_id, :integer) -> 0.0282s == CreateHostgroups: migrated (0.1037s) ====================================== == AddTypeToParameter: migrating ============================================= -- add_column(:parameters, :type, :string) -> 0.0282s == AddTypeToParameter: migrated (0.0283s) ==================================== == AddDomainToParameter: migrating =========================================== -- add_column(:parameters, :domain_id, :integer) -> 0.0518s == AddDomainToParameter: migrated (0.0519s) ================================== == ChangeReportFieldTypeToText: migrating ==================================== -- execute("ALTER TABLE reports MODIFY log text;") -> 0.0372s == ChangeReportFieldTypeToText: migrated (0.0374s) =========================== == ChangeHostBuildDefaultToFalse: migrating ================================== -- change_column(:hosts, :build, :boolean, {:default=>false}) -> 0.0359s == ChangeHostBuildDefaultToFalse: migrated (0.0415s) ========================= == AddIndexToHost: migrating ================================================= -- add_index("hosts", "last_report") -> 0.0421s -- add_index("hosts", "installed_at") -> 0.0485s -- add_index("hosts", "puppet_status") -> 0.0912s -- add_index("hosts", :domain_id, {:name=>"host_domain_id_ix"}) -> 0.0566s -- add_index("hosts", :architecture_id, {:name=>"host_arch_id_ix"}) -> 0.0503s -- add_index("hosts", :operatingsystem_id, {:name=>"host_os_id_ix"}) -> 0.0784s -- add_index("hosts", :environment_id, {:name=>"host_env_id_ix"}) -> 0.0939s -- add_index("hosts", :medium_id, {:name=>"host_medium_id_ix"}) -> 0.0630s -- add_index("hosts", :hostgroup_id, {:name=>"host_group_id_ix"}) -> 0.0648s == AddIndexToHost: migrated (0.5896s) ======================================== == AddIndexToParameters: migrating =========================================== -- add_index(:parameters, [:host_id, :type]) -> 0.0344s -- add_index(:parameters, [:hostgroup_id, :type]) -> 0.0395s -- add_index(:parameters, [:domain_id, :type]) -> 0.0387s -- add_index(:parameters, :type) -> 0.0640s == AddIndexToParameters: migrated (0.1770s) ================================== == AddIndexToReports: migrating ============================================== -- add_index(:reports, [:reported_at, :host_id]) -> 0.0380s == AddIndexToReports: migrated (0.0381s) ===================================== == CreateUsers: migrating ==================================================== -- create_table(:users) -> 0.0189s == CreateUsers: migrated (0.0190s) =========================================== == CreateSessions: migrating ================================================= -- create_table(:sessions) -> 0.0174s -- add_index(:sessions, :session_id) -> 0.0402s -- add_index(:sessions, :updated_at) -> 0.0702s == CreateSessions: migrated (0.1280s) ======================================== == AddStatusToReport: migrating ============================================== -- add_column(:reports, :status, :integer) -> 0.0360s -- add_index(:reports, :status) -> 0.0377s -- add_index(:reports, :host_id) -> 0.0561s -- add_index(:reports, :reported_at) -> 0.0397s == AddStatusToReport: migrated (0.1698s) ===================================== == CalcExistingReports: migrating ============================================ == CalcExistingReports: migrated (0.0020s) =================================== == CreateLookupKeys: migrating =============================================== -- create_table(:lookup_keys) -> 0.0161s -- add_index(:lookup_keys, :key) -> 0.0434s == CreateLookupKeys: migrated (0.0596s) ====================================== == CreateLookupValues: migrating ============================================= -- create_table(:lookup_values) -> 0.0188s -- add_index(:lookup_values, :priority) -> 0.0274s == CreateLookupValues: migrated (0.0464s) ==================================== == ChangeMysqlReportsColumn: migrating ======================================= -- execute("ALTER TABLE reports MODIFY log mediumtext;") -> 0.0814s == ChangeMysqlReportsColumn: migrated (0.0816s) ============================== == AddFamilyToOs: migrating ================================================== -- add_column(:operatingsystems, :family_id, :integer) -> 0.0512s == AddFamilyToOs: migrated (0.0528s) ========================================= == UpdateFactNamesAndValuesToBin: migrating ================================== -- execute("ALTER TABLE fact_names MODIFY name varchar(255) COLLATE utf8_bin NOT NULL") -> 0.0378s -- execute("ALTER TABLE fact_values MODIFY value varchar(255) COLLATE utf8_bin NOT NULL") -> 0.0474s == UpdateFactNamesAndValuesToBin: migrated (0.0854s) ========================= == AddReleasenameToOs: migrating ============================================= -- add_column(:operatingsystems, :release_name, :string, {:limit=>64}) -> 0.0354s == AddReleasenameToOs: migrated (0.0424s) ==================================== == CreateUsergroups: migrating =============================================== -- create_table(:usergroups) -> 0.0171s -- create_table(:usergroup_members) -> 0.0229s == CreateUsergroups: migrated (0.0401s) ====================================== == AddOwnerToHosts: migrating ================================================ -- add_column(:hosts, :owner_id, :integer) -> 0.1006s -- add_column(:hosts, :owner_type, :string) -> 0.0751s == AddOwnerToHosts: migrated (0.2099s) ======================================= == AddUbuntuCustomLvmPtable: migrating ======================================= == AddUbuntuCustomLvmPtable: migrated (0.0213s) ============================== == CreateMediaOperatingsystemsAndMigrateData: migrating ====================== -- create_table(:media_operatingsystems, {:id=>false}) -> 0.0178s -- remove_column(:media, :operatingsystem_id) -> 0.0303s == CreateMediaOperatingsystemsAndMigrateData: migrated (0.0525s) ============= == MigrateInstallationMediumUri: migrating =================================== == MigrateInstallationMediumUri: migrated (0.0898s) ========================== == SimplifyParameters: migrating ============================================= -- remove_index(:parameters, [:host_id, :type]) -> 0.0385s -- remove_index(:parameters, [:hostgroup_id, :type]) -> 0.0589s -- remove_index(:parameters, [:domain_id, :type]) -> 0.0292s -- rename_column(:parameters, :host_id, :reference_id) -> 0.0441s -- add_index(:parameters, [:reference_id, :type]) -> 0.0395s -- Everything migrated ok so we remove the old columns -- remove_column(:parameters, :hostgroup_id) -> 0.0510s -- remove_column(:parameters, :domain_id) -> 0.0288s == SimplifyParameters: migrated (0.3003s) ==================================== == UpdateOsMinor: migrating ================================================== -- change_column(:operatingsystems, :minor, :string, {:null=>false, :default=>"", :limit=>16}) -> 0.0244s == UpdateOsMinor: migrated (0.0274s) ========================================= == ChangeFamilyInOs: migrating =============================================== -- add_column(:operatingsystems, :type, :string, {:limit=>16}) -> 0.0248s -- add_index(:operatingsystems, :type) -> 0.0274s -- remove_column(:operatingsystems, :family_id) -> 0.0304s == ChangeFamilyInOs: migrated (0.0842s) ====================================== == CreateNotices: migrating ================================================== -- create_table(:notices) -> 0.0232s -- create_table(:user_notices, {:id=>false}) -> 0.0156s == CreateNotices: migrated (0.0389s) ========================================= == AddInternalAuth: migrating ================================================ -- add_column(:users, :password_hash, :string, {:limit=>128}) -> 0.0447s -- add_column(:users, :password_salt, :string, {:limit=>128}) -> 0.0228s -- **************************************************************************************** -- The newly created internal account named admin has been allocated a password of 'changeme' -- Set this to something else in the settings/users page -- **************************************************************************************** == AddInternalAuth: migrated (0.1215s) ======================================= == CreateRoles: migrating ==================================================== -- add_column(:users, :role_id, :integer) -> 0.0497s -- create_table("roles", {:force=>true}) -> 0.0201s -- create_table(:user_roles) -> 0.0190s == CreateRoles: migrated (0.0891s) =========================================== == AddUserDomainsAndHostgroups: migrating ==================================== -- create_table(:user_domains, {:id=>false}) -> 0.0167s -- create_table(:user_hostgroups, {:id=>false}) -> 0.0143s == AddUserDomainsAndHostgroups: migrated (0.0311s) =========================== == CreateUserFacts: migrating ================================================ -- create_table(:user_facts) -> 0.0241s == CreateUserFacts: migrated (0.0242s) ======================================= == AddEnabledToHosts: migrating ============================================== -- add_column(:hosts, :enabled, :boolean, {:default=>true}) -> 0.0734s == AddEnabledToHosts: migrated (0.0735s) ===================================== == AddMyBooleansToUser: migrating ============================================ -- add_column(:users, :domains_andor, :string, {:default=>"or", :limit=>3}) -> 0.0834s -- add_column(:users, :hostgroups_andor, :string, {:default=>"or", :limit=>3}) -> 0.0359s -- add_column(:users, :facts_andor, :string, {:default=>"or", :limit=>3}) -> 0.0343s == AddMyBooleansToUser: migrated (0.1538s) =================================== == CreateMessages: migrating ================================================= -- create_table(:messages) -> 0.0253s -- execute("ALTER TABLE messages ENGINE = MYISAM") -> 0.0335s -- execute("ALTER TABLE messages ADD FULLTEXT (value)") -> 0.1502s == CreateMessages: migrated (0.2093s) ======================================== == CreateSources: migrating ================================================== -- create_table(:sources) -> 0.0199s -- execute("ALTER TABLE sources ENGINE = MYISAM") -> 0.0104s -- execute("ALTER TABLE sources ADD FULLTEXT (value)") -> 0.0049s == CreateSources: migrated (0.0355s) ========================================= == CreateLogs: migrating ===================================================== -- create_table(:logs) -> 0.0191s -- add_index(:logs, :report_id) -> 0.0299s -- add_index(:logs, :message_id) -> 0.0335s -- add_index(:logs, :level_id) -> 0.0390s == CreateLogs: migrated (0.1219s) ============================================ == AddMetricsToReport: migrating ============================================= -- add_column(:reports, :metrics, :text) -> 0.0530s == AddMetricsToReport: migrated (0.0531s) ==================================== == 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.0572s == ConvertReports: migrated (0.0610s) ======================================== == AddOwnedFilterToUser: migrating =========================================== -- add_column(:users, :filter_on_owner, :boolean) -> 0.0426s == AddOwnedFilterToUser: migrated (0.0427s) ================================== == CorrectMedia: migrating =================================================== -- table_exists?(:medias) -> 0.0018s == CorrectMedia: migrated (0.0019s) ========================================== == CreateConfigTemplates: migrating ========================================== -- create_table(:config_templates) -> 0.0384s == CreateConfigTemplates: migrated (0.0385s) ================================= == CreateTemplateCombinations: migrating ===================================== -- create_table(:template_combinations) -> 0.0236s == CreateTemplateCombinations: migrated (0.0237s) ============================ == CreateOperatingsystemsConfigTemplates: migrating ========================== -- create_table(:config_templates_operatingsystems, {:id=>false}) -> 0.0231s == CreateOperatingsystemsConfigTemplates: migrated (0.0232s) ================= == CreateTemplateKinds: migrating ============================================ -- create_table(:template_kinds) -> 0.0243s == CreateTemplateKinds: migrated (0.0738s) =================================== == CreateOsDefaultTemplates: migrating ======================================= -- create_table(:os_default_templates) -> 0.0175s == CreateOsDefaultTemplates: migrated (0.0176s) ============================== == AddDefaultTemplates: migrating ============================================ == AddDefaultTemplates: migrated (0.2295s) =================================== == AddSubSystemsToSubnet: migrating ========================================== -- add_column(:subnets, :dhcp_id, :integer) -> 0.0305s -- add_column(:subnets, :tftp_id, :integer) -> 0.1517s -- rename_column(:subnets, :number, :network) -> 0.0542s == AddSubSystemsToSubnet: migrated (0.2367s) ================================= == CreateProxies: migrating ================================================== -- create_table(:smart_proxies) -> 0.0177s == CreateProxies: migrated (0.0178s) ========================================= == AddProxyToDomain: migrating =============================================== -- add_column(:domains, :dns_id, :integer) -> 0.0741s -- remove_column(:domains, :dnsserver) -> 0.0353s -- remove_column(:domains, :gateway) -> 0.0234s == AddProxyToDomain: migrated (0.1332s) ====================================== == AddGrubbyTemplate: migrating ============================================== == AddGrubbyTemplate: migrated (0.0162s) ===================================== == CreateHypervisors: migrating ============================================== -- create_table(:hypervisors) -> 0.0159s == CreateHypervisors: migrated (0.0161s) ===================================== == AddHostGroupDefaults: migrating =========================================== -- add_column(:hostgroups, :environment_id, :integer) -> 0.0427s -- add_column(:hostgroups, :operatingsystem_id, :integer) -> 0.0226s -- add_column(:hostgroups, :architecture_id, :integer) -> 0.0218s -- add_column(:hostgroups, :medium_id, :integer) -> 0.0241s -- add_column(:hostgroups, :ptable_id, :integer) -> 0.0243s -- add_column(:hostgroups, :root_pass, :string) -> 0.0325s -- add_column(:hostgroups, :puppetmaster, :string) -> 0.0235s == AddHostGroupDefaults: migrated (0.1922s) ================================== == AddDefaultPxeMenuTemplate: migrating ====================================== == AddDefaultPxeMenuTemplate: migrated (0.0167s) ============================= == CreateProxyFeatures: migrating ============================================ -- create_table(:features) -> 0.0195s -- create_table(:features_smart_proxies, {:id=>false}) -> 0.0202s == CreateProxyFeatures: migrated (0.0779s) =================================== == ChangePuppetmasterColumn: migrating ======================================= -- rename_column(:hosts, :puppetmaster, :puppetmaster_name) -> 0.1137s -- add_column(:hosts, :puppetproxy_id, :integer) -> 0.0722s -- rename_column(:hostgroups, :puppetmaster, :puppetmaster_name) -> 0.0385s -- add_column(:hostgroups, :puppetproxy_id, :integer) -> 0.0252s == ChangePuppetmasterColumn: migrated (0.2501s) ============================== == AddManagedToHosts: migrating ============================================== -- add_column(:hosts, :managed, :boolean) -> 0.0730s == AddManagedToHosts: migrated (0.0742s) ===================================== == RevertFaceNamesAndValuesToTextRecords: migrating ========================== -- execute("ALTER TABLE fact_values MODIFY value text COLLATE utf8_bin NOT NULL;") -> 0.0455s == RevertFaceNamesAndValuesToTextRecords: migrated (0.0458s) ================= == AddPriorityToParameter: migrating ========================================= -- add_column(:parameters, :priority, :integer) -> 0.0422s == AddPriorityToParameter: migrated (0.0455s) ================================ == AddMediaPathToMedium: migrating =========================================== -- add_column(:media, :media_path, :string, {:limit=>128}) -> 0.0621s -- add_column(:media, :config_path, :string, {:limit=>128}) -> 0.0262s -- add_column(:media, :image_path, :string, {:limit=>128}) -> 0.0570s == AddMediaPathToMedium: migrated (0.1457s) ================================== == AddImageToHost: migrating ================================================= -- add_column(:hosts, :use_image, :boolean) -> 0.0704s -- add_column(:hosts, :image_file, :string, {:limit=>128}) -> 0.0734s -- add_column(:hostgroups, :use_image, :boolean) -> 0.0477s -- add_column(:hostgroups, :image_file, :string, {:limit=>128}) -> 0.0314s == AddImageToHost: migrated (0.2234s) ======================================== == RemoveUnusedFieldsFromPuppetClasses: migrating ============================ -- remove_column(:puppetclasses, :nameindicator) -> 0.0307s -- remove_column(:puppetclasses, :operatingsystem_id) -> 0.0258s == RemoveUnusedFieldsFromPuppetClasses: migrated (0.0567s) =================== == AddTableBookmarks: migrating ============================================== -- create_table(:bookmarks, {:force=>true}) -> 0.0190s -- add_index(:bookmarks, :name) -> 0.0385s -- add_index(:bookmarks, :controller) -> 0.0319s -- add_index(:bookmarks, [:owner_id, :owner_type]) -> 0.0403s == AddTableBookmarks: migrated (0.1717s) ===================================== == AddSolarisTemplates: migrating ============================================ == AddSolarisTemplates: migrated (0.0722s) =================================== == AddSolarisDisks: migrating ================================================ == AddSolarisDisks: migrated (0.0396s) ======================================= == AddLookUpKeyIdToPuppetClass: migrating ==================================== -- add_column(:lookup_keys, :puppetclass_id, :integer) -> 0.0331s -- add_index(:lookup_keys, :puppetclass_id) -> 0.0330s -- add_column(:lookup_keys, :default_value, :string) -> 0.0364s -- add_column(:lookup_keys, :path, :string) -> 0.0321s -- add_index(:lookup_keys, :path) -> 0.0399s -- add_column(:lookup_keys, :description, :string) -> 0.0569s -- add_column(:lookup_keys, :validator_type, :string) -> 0.0556s -- add_column(:lookup_keys, :validator_rule, :string) -> 0.0399s -- rename_column(:lookup_values, :priority, :match) -> 0.0296s -- add_index(:lookup_values, :match) -> 0.0308s == AddLookUpKeyIdToPuppetClass: migrated (0.3879s) =========================== == AddSparcInfoToModel: migrating ============================================ -- add_column(:models, :vendor_class, :string, {:limit=>32}) -> 0.0427s -- add_column(:models, :hardware_model, :string, {:limit=>16}) -> 0.0244s == AddSparcInfoToModel: migrated (0.0673s) =================================== == AddAncestryToHostgroup: migrating ========================================= -- add_column(:hostgroups, :ancestry, :string) -> 0.0312s -- add_index(:hostgroups, :ancestry) -> 0.0341s == AddAncestryToHostgroup: migrated (0.0654s) ================================ == CreateSettings: migrating ================================================= -- create_table(:settings) -> 0.0255s -- add_index(:settings, :name, {:unique=>true}) -> 0.0747s == CreateSettings: migrated (0.1004s) ======================================== == UpdateAuditsTable: migrating ============================================== == UpdateAuditsTable: migrated (0.0019s) ===================================== == CreateHostClass: migrating ================================================ -- rename_table(:hosts_puppetclasses, :host_classes) -> 0.0049s -- add_column(:host_classes, :id, :primary_key) -> 0.0474s == CreateHostClass: migrated (0.0524s) ======================================= == AddSuseTemplates: migrating =============================================== == AddSuseTemplates: migrated (0.1497s) ====================================== == AddVmDefaultsToHostgroup: migrating ======================================= -- add_column(:hostgroups, :vm_defaults, :text) -> 0.0357s == AddVmDefaultsToHostgroup: migrated (0.0357s) ============================== == AddSubnetAndDomainToHostGroups: migrating ================================= -- add_column(:hostgroups, :subnet_id, :integer) -> 0.0338s -- add_column(:hostgroups, :domain_id, :integer) -> 0.0402s == AddSubnetAndDomainToHostGroups: migrated (0.0742s) ======================== == RenameChangesToAuditedChanges: migrating ================================== -- rename_column(:audits, :changes, :audited_changes) -> 0.0430s == RenameChangesToAuditedChanges: migrated (0.0431s) ========================= == AddRemoteAddressToAudits: migrating ======================================= -- add_column(:audits, :remote_address, :string) -> 0.0611s == AddRemoteAddressToAudits: migrated (0.0613s) ============================== == RenameParentToAssociation: migrating ====================================== -- rename_column(:audits, :auditable_parent_id, :association_id) -> 0.0543s -- rename_column(:audits, :auditable_parent_type, :association_type) -> 0.0659s == RenameParentToAssociation: migrated (0.1203s) ============================= == AddGatewayAndDnsToSubnets: migrating ====================================== -- add_column(:subnets, :gateway, :string) -> 0.0338s -- add_column(:subnets, :dns_primary, :string) -> 0.0324s -- add_column(:subnets, :dns_secondary, :string) -> 0.0290s == AddGatewayAndDnsToSubnets: migrated (0.0954s) ============================= == EnsureAllHostnamesAreLowercase: migrating ================================= -- execute("UPDATE hosts SET name=LOWER(name)") -> 0.0006s == EnsureAllHostnamesAreLowercase: migrated (0.0007s) ======================== == AddFromAndToRangesToSubnets: migrating ==================================== -- add_column(:subnets, :from, :string) -> 0.0404s -- add_column(:subnets, :to, :string) -> 0.0287s -- remove_column(:subnets, :ranges) -> 0.0218s == AddFromAndToRangesToSubnets: migrated (0.0911s) =========================== == CreateSubnetDomain: migrating ============================================= -- create_table(:subnet_domains) -> 0.0211s -- remove_column(:subnets, :domain_id) -> 0.0363s == CreateSubnetDomain: migrated (0.0772s) ==================================== == CreateComputeResources: migrating ========================================= -- create_table(:compute_resources) -> 0.0173s == CreateComputeResources: migrated (0.0174s) ================================ == AddUuidAndComputeIdToHost: migrating ====================================== -- add_column(:hosts, :uuid, :string) -> 0.1011s -- add_column(:hosts, :compute_resource_id, :integer) -> 0.0729s == AddUuidAndComputeIdToHost: migrated (0.1742s) ============================= == AddWindowsTemplates: migrating ============================================ == AddWindowsTemplates: migrated (0.0642s) =================================== == AddPuppetMasterProxyToHostAndHostGroup: migrating ========================= -- rename_column(:hosts, :puppetproxy_id, :puppet_ca_proxy_id) -> 0.0825s -- add_column(:hosts, :puppet_proxy_id, :integer) -> 0.0931s -- rename_column(:hostgroups, :puppetproxy_id, :puppet_ca_proxy_id) -> 0.0310s -- add_column(:hostgroups, :puppet_proxy_id, :integer) -> 0.0321s -- remove_column(:hosts, :puppetmaster_name) -> 0.0687s -- remove_column(:hostgroups, :puppetmaster_name) -> 0.0298s == AddPuppetMasterProxyToHostAndHostGroup: migrated (0.3790s) ================ == UpdateReportFieldToLargeInt: migrating ==================================== -- change_column(:reports, :status, :bigint) -> 0.0439s -- change_column(:hosts, :puppet_status, :bigint) -> 0.1435s == UpdateReportFieldToLargeInt: migrated (0.1876s) =========================== == CreateImages: migrating =================================================== -- create_table(:images) -> 0.0197s == CreateImages: migrated (0.0198s) ========================================== == AddCertNameToHost: migrating ============================================== -- add_column(:hosts, :certname, :string) -> 0.0701s -- add_index("hosts", :certname) -> 0.0732s == AddCertNameToHost: migrated (0.1434s) ===================================== == CreateKeyPairs: migrating ================================================= -- create_table(:key_pairs) -> 0.0278s == CreateKeyPairs: migrated (0.0279s) ======================================== == AddDnsIdToSubnet: migrating =============================================== -- add_column(:subnets, :dns_id, :integer) -> 0.0287s == AddDnsIdToSubnet: migrated (0.0288s) ====================================== == AddImageIdToHost: migrating =============================================== -- add_column(:hosts, :image_id, :integer) -> 0.1118s == AddImageIdToHost: migrated (0.1119s) ====================================== == AddUserComputeResources: migrating ======================================== -- create_table(:user_compute_resources, {:id=>false}) -> 0.0203s == AddUserComputeResources: migrated (0.0204s) =============================== == AddComputeResourcesBooleanToUser: migrating =============================== -- add_column(:users, :compute_resources_andor, :string, {:default=>"or", :limit=>3}) -> 0.0444s == AddComputeResourcesBooleanToUser: migrated (0.0445s) ====================== == AddEpelSnippets: migrating ================================================ == AddEpelSnippets: migrated (0.0154s) ======================================= == ConvertParamsToText: migrating ============================================ -- change_column("parameters", :value, :text, {:limit=>false}) -> 0.0397s -- change_column("lookup_values", :value, :text, {:limit=>false}) -> 0.0347s == ConvertParamsToText: migrated (0.0746s) =================================== == ChangeBookmarkColumnToText: migrating ===================================== -- change_column("bookmarks", :query, :text, {:limit=>false}) -> 0.0658s == ChangeBookmarkColumnToText: migrated (0.0660s) ============================ == RenameAssociationToAssociated: migrating ================================== -- index_exists?(:audits, [:association_id, :association_type], {:name=>"association_index"}) -> 0.0009s -- rename_column(:audits, :association_id, :associated_id) -> 0.0540s -- rename_column(:audits, :association_type, :associated_type) -> 0.0638s -- add_index(:audits, [:associated_id, :associated_type], {:name=>"associated_index"}) -> 0.0487s == RenameAssociationToAssociated: migrated (0.1677s) ========================= == FixAuditableType: migrating =============================================== -- execute("UPDATE audits SET auditable_type='Host' WHERE auditable_type='Puppet::Rails::Host'") -> 0.0006s == FixAuditableType: migrated (0.0006s) ====================================== == FixAssociatedType: migrating ============================================== -- execute("UPDATE audits SET associated_type='Host' WHERE associated_type='Puppet::Rails::Host'") -> 0.0005s == FixAssociatedType: migrated (0.0006s) ===================================== == AddOkHostsBookMark: migrating ============================================= == AddOkHostsBookMark: migrated (0.0169s) ==================================== == AddAuditableNameAndAssociatedNameToAudit: migrating ======================= -- column_exists?(:audits, :auditable_name) -> 0.0015s -- add_column(:audits, :auditable_name, :string) -> 0.0631s -- column_exists?(:audits, :associated_name) -> 0.0028s -- add_column(:audits, :associated_name, :string) -> 0.0784s -- index_exists?(:audits, :id) -> 0.0010s -- add_index(:audits, :id) -> 0.0580s -- About to review all audits, this may take a while... == AddAuditableNameAndAssociatedNameToAudit: migrated (0.2093s) ============== == AddOsFamilyToMedia: migrating ============================================= -- add_column(:media, :os_family, :string) -> 0.0330s == AddOsFamilyToMedia: migrated (0.0461s) ==================================== == AddOsFamilyToPtable: migrating ============================================ -- add_column(:ptables, :os_family, :string) -> 0.0338s -- remove_column(:ptables, :operatingsystem_id) -> 0.0274s == AddOsFamilyToPtable: migrated (0.0798s) =================================== == AddAttributesToComputeResources: migrating ================================ -- add_column(:compute_resources, :attrs, :text) -> 0.0360s == AddAttributesToComputeResources: migrated (0.0361s) ======================= [root@lpr-mgmt01 foreman]# RAILS_ENV=production bundle exec rake db:migrate /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:10: warning: already initialized constant ENC_NONE /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:11: warning: already initialized constant ENC_EUC /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:12: warning: already initialized constant ENC_SJIS /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:13: warning: already initialized constant ENC_UTF8 == AddAttributesToComputeResources: migrating ================================ -- add_column(:compute_resources, :attrs, :text) rake aborted! An error has occurred, all later migrations canceled: Mysql::Error: Duplicate column name 'attrs': ALTER TABLE `compute_resources` ADD `attrs` text Tasks: TOP => db:migrate (See full trace by running task with --trace) [root@lpr-mgmt01 foreman]# RAILS_ENV=production bundle exec rake db:migrate:status /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:10: warning: already initialized constant ENC_NONE /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:11: warning: already initialized constant ENC_EUC /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:12: warning: already initialized constant ENC_SJIS /usr/lib/ruby/gems/1.8/gems/ruby_parser-2.3.1/lib/ruby_parser_extras.rb:13: warning: already initialized constant ENC_UTF8 database: foreman Status Migration ID Migration Name -------------------------------------------------- up 20101018120621 Create logs up 20091219132839 Create lookup values up 20100914092104 Add my booleans to user up 20120110113051 Create subnet domain up 20120506143325 Create images up 20100625155400 Create notices up 20090907045751 Add domain to parameter up 20110712070522 Create host class up 20120127141602 Add windows templates up 20100325142616 Update fact names and values to bin up 20111124095054 Add remote address to audits up 20100523141204 Create media operatingsystems and migrate data up 20100822072954 Create user facts up 20101202104444 Add proxy to domain up 20090905155444 Add type to parameter up 20090715143858 Create architectures up 20120529113900 Add user compute resources up 20110404150043 Add media path to medium up 20110407091150 Add image to host up 20090729132209 Create reports up 20110420150600 Add solaris templates up 20090920064156 Add index to parameters up 20100524080302 Migrate installation medium uri up 20110301154453 Add managed to hosts up 20101122132041 Create operatingsystems config templates up 20100414125652 Add releasename to os up 20111124095053 Rename changes to audited changes up 20100701081235 Add user domains and hostgroups up 20100629093200 Create roles up 20120624081510 Add auditable name and associated name to audit up 20090720134126 Create operatingsystems up 20120613082125 Rename association to associated up 20120509131302 Add cert name to host up 20090802062223 Create puppetclasses up 20101103150254 Add owned filter to user up 20090714132448 Create hosts up 20090730152224 Create ptables down 20120705130038 Add attributes to compute resources up 20110412103238 Remove unused fields from puppet classes up 20101130100315 Create proxies up 20090920065522 Add index to reports up 20090718064254 Create subnets up 20120122131037 Create compute resources up 20120607074318 Convert params to text up 20101125153351 Add default templates up 20110327123639 Add priority to parameter up 20110725142054 Add suse templates up 20110616080444 Add look up key id to puppet class up 20090905150131 Create hostgroups up 20100525094200 Simplify parameters up 20120521142924 Add dns id to subnet up 20110619130336 Add ancestry to hostgroup up 20100419151910 Add owner to hosts up 20090718060746 Create domains up 20100823181036 Add enabled to hosts up 20090920043521 Add index to host up 20101213085232 Add grubby template up 20101121080425 Create config templates up 20110213104226 Create proxy features up 20090722141107 Create environments up 20101121135521 Create template combinations up 20100616114400 Change family in os up 20091214045923 Calc existing reports up 20091012135004 Create users up 20090722140138 Create models up 20110617190131 Add sparc info to model up 20110128130239 Add default pxe menu template up 20120624094034 Add os family to ptable up 20100601221000 Update os minor up 20120510113417 Create key pairs up 20100310080727 Add family to os up 20100115021803 Change mysql reports column up 20110628115422 Create settings up 20110801090318 Add vm defaults to hostgroup up 20120102071633 Add from and to ranges to subnets up 20120604114049 Add epel snippets up 20110712064120 Update audits table up 20100628123400 Add internal auth up 20101123153303 Create os default templates up 20120523065531 Add image id to host up 20120126113850 Add uuid and compute id to host up 20091219132338 Create lookup keys up 20120624093958 Add os family to media up 20120529115814 Add compute resources boolean to user up 20120502105518 Update report field to large int up 20111227095806 Ensure all hostnames are lowercase up 20101123152150 Create template kinds up 20090916053824 Change host build default to false up 20101019183859 Convert reports up 20101019122857 Add metrics to report up 20090804130144 Create parameters up 20101018120603 Create sources up 20091016031017 Create sessions up 20120620124659 Fix associated type up 20110417102947 Add table bookmarks up 20090820130541 Create auth sources up 20120620124658 Fix auditable type up 20090714132449 Add audits table up 20111124095055 Rename parent to association up 20110216101848 Change puppetmaster column up 20101018120548 Create messages up 20100523114430 Add ubuntu custom lvm ptable up 20120612070100 Change bookmark column to text up 20090915030726 Change report field type to text up 20120313081913 Add puppet master proxy to host and host group up 20101130093613 Add sub systems to subnet up 20090717025820 Create media up 20110106132600 Create hypervisors up 20110117162722 Add host group defaults up 20100416124600 Create usergroups up 20110613141800 Add solaris disks up 20111205231500 Add gateway and dns to subnets up 20091022054108 Add status to report up 20110321070954 Revert face names and values to text records up 20101118130026 Correct media up 20120623002052 Add ok hosts book mark up 20110803114134 Add subnet and domain to host groups up 1 *** NO FILE *** up 2 *** NO FILE *** up 3 *** NO FILE *** up 4 *** NO FILE *** @
Updated by Ohad Levy over 12 years ago
- Status changed from New to Closed
- % Done changed from 0 to 100
Applied in changeset 456a1b0423bdd0fc60fa572f94b4da41f268b11e.
Actions