Guest User

Untitled

a guest
Jun 22nd, 2015
1,170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 195.08 KB | None | 0 0
  1. [root@lts-mgmt01 foreman]# foreman-rake db:migrate --trace
  2. ** Invoke db:migrate (first_time)
  3. ** Invoke environment (first_time)
  4. ** Execute environment
  5. foreman_bootdisk: skipping engine hook (PGError: ERROR: relation "template_kinds" does not exist
  6. LINE 4: WHERE a.attrelid = '"template_kinds"'::regclass
  7. ^
  8. : SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  9. FROM pg_attribute a LEFT JOIN pg_attrdef d
  10. ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  11. WHERE a.attrelid = '"template_kinds"'::regclass
  12. AND a.attnum > 0 AND NOT a.attisdropped
  13. ORDER BY a.attnum
  14. )
  15. ** Invoke db:load_config (first_time)
  16. ** Execute db:load_config
  17. ** Execute db:migrate
  18. == CreateHosts: migrating ====================================================
  19. -- create_table(:hosts)
  20. NOTICE: CREATE TABLE will create implicit sequence "hosts_id_seq" for serial column "hosts.id"
  21. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "hosts_pkey" for table "hosts"
  22. -> 0.0218s
  23. -- add_index(:hosts, :source_file_id, {:integer=>true})
  24. -> 0.0072s
  25. -- add_index(:hosts, :name)
  26. -> 0.0073s
  27. -- create_table(:fact_names)
  28. NOTICE: CREATE TABLE will create implicit sequence "fact_names_id_seq" for serial column "fact_names.id"
  29. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "fact_names_pkey" for table "fact_names"
  30. -> 0.0074s
  31. -- add_index(:fact_names, :name)
  32. -> 0.0076s
  33. -- create_table(:fact_values)
  34. NOTICE: CREATE TABLE will create implicit sequence "fact_values_id_seq" for serial column "fact_values.id"
  35. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "fact_values_pkey" for table "fact_values"
  36. -> 0.0156s
  37. -- add_index(:fact_values, :fact_name_id, {:integer=>true})
  38. -> 0.0074s
  39. -- add_index(:fact_values, :host_id, {:integer=>true})
  40. -> 0.0074s
  41. -- add_column(:hosts, :mac, :string, {:limit=>17, :default=>""})
  42. -> 0.0311s
  43. -- add_column(:hosts, :sp_mac, :string, {:limit=>17, :default=>""})
  44. -> 0.0370s
  45. -- add_column(:hosts, :sp_ip, :string, {:limit=>15, :default=>""})
  46. -> 0.0340s
  47. -- add_column(:hosts, :sp_name, :string, {:default=>""})
  48. -> 0.0455s
  49. -- add_column(:hosts, :root_pass, :string, {:limit=>64})
  50. -> 0.0005s
  51. -- add_column(:hosts, :serial, :string, {:limit=>12})
  52. -> 0.0004s
  53. -- add_column(:hosts, :puppetmaster, :string)
  54. -> 0.0003s
  55. -- add_column(:hosts, :puppet_status, :integer, {:null=>false, :default=>0})
  56. -> 0.1302s
  57. -- add_column(:hosts, :domain_id, :integer)
  58. -> 0.0005s
  59. -- add_column(:hosts, :architecture_id, :integer)
  60. -> 0.0004s
  61. -- add_column(:hosts, :operatingsystem_id, :integer)
  62. -> 0.0003s
  63. -- add_column(:hosts, :environment_id, :integer)
  64. -> 0.0005s
  65. -- add_column(:hosts, :subnet_id, :integer)
  66. -> 0.0003s
  67. -- add_column(:hosts, :sp_subnet_id, :integer)
  68. -> 0.0003s
  69. -- add_column(:hosts, :ptable_id, :integer)
  70. -> 0.0003s
  71. -- add_column(:hosts, :medium_id, :integer)
  72. -> 0.0003s
  73. -- add_column(:hosts, :build, :boolean, {:default=>true})
  74. -> 0.0118s
  75. -- add_column(:hosts, :comment, :text)
  76. -> 0.0005s
  77. -- add_column(:hosts, :disk, :text)
  78. -> 0.0003s
  79. -- add_column(:hosts, :installed_at, :datetime)
  80. -> 0.0003s
  81. == CreateHosts: migrated (0.3789s) ===========================================
  82.  
  83. == AddAuditsTable: migrating =================================================
  84. -- create_table(:audits, {:force=>true})
  85. NOTICE: CREATE TABLE will create implicit sequence "audits_id_seq" for serial column "audits.id"
  86. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "audits_pkey" for table "audits"
  87. -> 0.0082s
  88. -- add_index(:audits, [:auditable_id, :auditable_type], {:name=>"auditable_index"})
  89. -> 0.0036s
  90. -- add_index(:audits, [:user_id, :user_type], {:name=>"user_index"})
  91. -> 0.0038s
  92. -- add_index(:audits, :created_at)
  93. -> 0.0039s
  94. -- add_index(:audits, [:auditable_parent_id, :auditable_parent_type], {:name=>"auditable_parent_index"})
  95. -> 0.0047s
  96. == AddAuditsTable: migrated (0.0247s) ========================================
  97.  
  98. == CreateArchitectures: migrating ============================================
  99. -- create_table(:architectures)
  100. NOTICE: CREATE TABLE will create implicit sequence "architectures_id_seq" for serial column "architectures.id"
  101. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "architectures_pkey" for table "architectures"
  102. -> 0.0047s
  103. -- create_table(:architectures_operatingsystems, {:id=>false})
  104. -> 0.0007s
  105. == CreateArchitectures: migrated (0.0057s) ===================================
  106.  
  107. == CreateMedia: migrating ====================================================
  108. -- create_table(:media)
  109. NOTICE: CREATE TABLE will create implicit sequence "media_id_seq" for serial column "media.id"
  110. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "media_pkey" for table "media"
  111. -> 0.0052s
  112. == CreateMedia: migrated (0.0054s) ===========================================
  113.  
  114. == CreateDomains: migrating ==================================================
  115. -- create_table(:domains)
  116. NOTICE: CREATE TABLE will create implicit sequence "domains_id_seq" for serial column "domains.id"
  117. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "domains_pkey" for table "domains"
  118. -> 0.0073s
  119. == CreateDomains: migrated (0.0074s) =========================================
  120.  
  121. == CreateSubnets: migrating ==================================================
  122. -- create_table(:subnets)
  123. NOTICE: CREATE TABLE will create implicit sequence "subnets_id_seq" for serial column "subnets.id"
  124. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "subnets_pkey" for table "subnets"
  125. -> 0.0104s
  126. == CreateSubnets: migrated (0.0106s) =========================================
  127.  
  128. == CreateOperatingsystems: migrating =========================================
  129. -- create_table(:operatingsystems)
  130. NOTICE: CREATE TABLE will create implicit sequence "operatingsystems_id_seq" for serial column "operatingsystems.id"
  131. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "operatingsystems_pkey" for table "operatingsystems"
  132. -> 0.0050s
  133. == CreateOperatingsystems: migrated (0.0052s) ================================
  134.  
  135. == CreateModels: migrating ===================================================
  136. -- create_table(:models)
  137. NOTICE: CREATE TABLE will create implicit sequence "models_id_seq" for serial column "models.id"
  138. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "models_pkey" for table "models"
  139. -> 0.0075s
  140. -- add_column(:hosts, :model_id, :integer)
  141. -> 0.0009s
  142. == CreateModels: migrated (0.0088s) ==========================================
  143.  
  144. == CreateEnvironments: migrating =============================================
  145. -- create_table(:environments)
  146. NOTICE: CREATE TABLE will create implicit sequence "environments_id_seq" for serial column "environments.id"
  147. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "environments_pkey" for table "environments"
  148. -> 0.0041s
  149. -- create_table(:environments_puppetclasses, {:id=>false})
  150. -> 0.0006s
  151. == CreateEnvironments: migrated (0.0048s) ====================================
  152.  
  153. == CreateReports: migrating ==================================================
  154. -- create_table(:reports)
  155. NOTICE: CREATE TABLE will create implicit sequence "reports_id_seq" for serial column "reports.id"
  156. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "reports_pkey" for table "reports"
  157. -> 0.0066s
  158. == CreateReports: migrated (0.0067s) =========================================
  159.  
  160. == CreatePtables: migrating ==================================================
  161. -- create_table(:ptables)
  162. NOTICE: CREATE TABLE will create implicit sequence "ptables_id_seq" for serial column "ptables.id"
  163. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ptables_pkey" for table "ptables"
  164. -> 0.0074s
  165. -- create_table(:operatingsystems_ptables, {:id=>false})
  166. -> 0.0009s
  167. == CreatePtables: migrated (0.0085s) =========================================
  168.  
  169. == CreatePuppetclasses: migrating ============================================
  170. -- create_table(:puppetclasses)
  171. NOTICE: CREATE TABLE will create implicit sequence "puppetclasses_id_seq" for serial column "puppetclasses.id"
  172. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "puppetclasses_pkey" for table "puppetclasses"
  173. -> 0.0069s
  174. -- create_table(:hosts_puppetclasses, {:id=>false})
  175. -> 0.0008s
  176. -- create_table(:operatingsystems_puppetclasses, {:id=>false})
  177. -> 0.0009s
  178. == CreatePuppetclasses: migrated (0.0089s) ===================================
  179.  
  180. == CreateParameters: migrating ===============================================
  181. -- create_table(:parameters)
  182. NOTICE: CREATE TABLE will create implicit sequence "parameters_id_seq" for serial column "parameters.id"
  183. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameters_pkey" for table "parameters"
  184. -> 0.0068s
  185. == CreateParameters: migrated (0.0069s) ======================================
  186.  
  187. == CreateAuthSources: migrating ==============================================
  188. -- create_table(:auth_sources)
  189. NOTICE: CREATE TABLE will create implicit sequence "auth_sources_id_seq" for serial column "auth_sources.id"
  190. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "auth_sources_pkey" for table "auth_sources"
  191. -> 0.0075s
  192. == CreateAuthSources: migrated (0.0076s) =====================================
  193.  
  194. == CreateHostgroups: migrating ===============================================
  195. -- create_table(:hostgroups)
  196. NOTICE: CREATE TABLE will create implicit sequence "hostgroups_id_seq" for serial column "hostgroups.id"
  197. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "hostgroups_pkey" for table "hostgroups"
  198. -> 0.0042s
  199. -- create_table(:hostgroups_puppetclasses, {:id=>false})
  200. -> 0.0007s
  201. -- add_column(:hosts, :hostgroup_id, :integer)
  202. -> 0.0004s
  203. -- add_column(:parameters, :hostgroup_id, :integer)
  204. -> 0.0004s
  205. == CreateHostgroups: migrated (0.0060s) ======================================
  206.  
  207. == AddTypeToParameter: migrating =============================================
  208. -- add_column(:parameters, :type, :string)
  209. -> 0.0009s
  210. == AddTypeToParameter: migrated (0.0010s) ====================================
  211.  
  212. == AddDomainToParameter: migrating ===========================================
  213. -- add_column(:parameters, :domain_id, :integer)
  214. -> 0.0007s
  215. == AddDomainToParameter: migrated (0.0008s) ==================================
  216.  
  217. == ChangeReportFieldTypeToText: migrating ====================================
  218. == ChangeReportFieldTypeToText: migrated (0.0002s) ===========================
  219.  
  220. == ChangeHostBuildDefaultToFalse: migrating ==================================
  221. -- change_column(:hosts, :build, :boolean, {:default=>false})
  222. -> 0.0134s
  223. == ChangeHostBuildDefaultToFalse: migrated (0.0195s) =========================
  224.  
  225. == AddIndexToHost: migrating =================================================
  226. -- add_index("hosts", "last_report")
  227. -> 0.0057s
  228. -- add_index("hosts", "installed_at")
  229. -> 0.0065s
  230. -- add_index("hosts", "puppet_status")
  231. -> 0.0062s
  232. -- add_index("hosts", :domain_id, {:name=>"host_domain_id_ix"})
  233. -> 0.0057s
  234. -- add_index("hosts", :architecture_id, {:name=>"host_arch_id_ix"})
  235. -> 0.0063s
  236. -- add_index("hosts", :operatingsystem_id, {:name=>"host_os_id_ix"})
  237. -> 0.0072s
  238. -- add_index("hosts", :environment_id, {:name=>"host_env_id_ix"})
  239. -> 0.0072s
  240. -- add_index("hosts", :medium_id, {:name=>"host_medium_id_ix"})
  241. -> 0.0071s
  242. -- add_index("hosts", :hostgroup_id, {:name=>"host_group_id_ix"})
  243. -> 0.0061s
  244. == AddIndexToHost: migrated (0.0590s) ========================================
  245.  
  246. == AddIndexToParameters: migrating ===========================================
  247. -- add_index(:parameters, [:host_id, :type])
  248. -> 0.0144s
  249. -- add_index(:parameters, [:hostgroup_id, :type])
  250. -> 0.0058s
  251. -- add_index(:parameters, [:domain_id, :type])
  252. -> 0.0049s
  253. -- add_index(:parameters, :type)
  254. -> 0.0043s
  255. == AddIndexToParameters: migrated (0.0299s) ==================================
  256.  
  257. == AddIndexToReports: migrating ==============================================
  258. -- add_index(:reports, [:reported_at, :host_id])
  259. -> 0.0041s
  260. == AddIndexToReports: migrated (0.0042s) =====================================
  261.  
  262. == CreateUsers: migrating ====================================================
  263. -- create_table(:users)
  264. NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id"
  265. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
  266. -> 0.0071s
  267. == CreateUsers: migrated (0.0072s) ===========================================
  268.  
  269. == CreateSessions: migrating =================================================
  270. -- create_table(:sessions)
  271. NOTICE: CREATE TABLE will create implicit sequence "sessions_id_seq" for serial column "sessions.id"
  272. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sessions_pkey" for table "sessions"
  273. -> 0.0070s
  274. -- add_index(:sessions, :session_id)
  275. -> 0.0035s
  276. -- add_index(:sessions, :updated_at)
  277. -> 0.0038s
  278. == CreateSessions: migrated (0.0146s) ========================================
  279.  
  280. == AddStatusToReport: migrating ==============================================
  281. -- add_column(:reports, :status, :integer)
  282. -> 0.0007s
  283. -- add_index(:reports, :status)
  284. -> 0.0040s
  285. -- add_index(:reports, :host_id)
  286. -> 0.0041s
  287. -- add_index(:reports, :reported_at)
  288. -> 0.0043s
  289. == AddStatusToReport: migrated (0.0134s) =====================================
  290.  
  291. == CalcExistingReports: migrating ============================================
  292. == CalcExistingReports: migrated (0.0039s) ===================================
  293.  
  294. == CreateLookupKeys: migrating ===============================================
  295. -- create_table(:lookup_keys)
  296. NOTICE: CREATE TABLE will create implicit sequence "lookup_keys_id_seq" for serial column "lookup_keys.id"
  297. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lookup_keys_pkey" for table "lookup_keys"
  298. -> 0.0043s
  299. -- add_index(:lookup_keys, :key)
  300. -> 0.0037s
  301. == CreateLookupKeys: migrated (0.0083s) ======================================
  302.  
  303. == CreateLookupValues: migrating =============================================
  304. -- create_table(:lookup_values)
  305. NOTICE: CREATE TABLE will create implicit sequence "lookup_values_id_seq" for serial column "lookup_values.id"
  306. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lookup_values_pkey" for table "lookup_values"
  307. -> 0.0073s
  308. -- add_index(:lookup_values, :priority)
  309. -> 0.0036s
  310. == CreateLookupValues: migrated (0.0111s) ====================================
  311.  
  312. == ChangeMysqlReportsColumn: migrating =======================================
  313. == ChangeMysqlReportsColumn: migrated (0.0001s) ==============================
  314.  
  315. == AddFamilyToOs: migrating ==================================================
  316. -- add_column(:operatingsystems, :family_id, :integer)
  317. -> 0.0007s
  318. == AddFamilyToOs: migrated (0.0054s) =========================================
  319.  
  320. == UpdateFactNamesAndValuesToBin: migrating ==================================
  321. == UpdateFactNamesAndValuesToBin: migrated (0.0002s) =========================
  322.  
  323. == AddReleasenameToOs: migrating =============================================
  324. -- add_column(:operatingsystems, :release_name, :string, {:limit=>64})
  325. -> 0.0007s
  326. == AddReleasenameToOs: migrated (0.0062s) ====================================
  327.  
  328. == CreateUsergroups: migrating ===============================================
  329. -- create_table(:usergroups)
  330. NOTICE: CREATE TABLE will create implicit sequence "usergroups_id_seq" for serial column "usergroups.id"
  331. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usergroups_pkey" for table "usergroups"
  332. -> 0.0047s
  333. -- create_table(:usergroup_members)
  334. NOTICE: CREATE TABLE will create implicit sequence "usergroup_members_id_seq" for serial column "usergroup_members.id"
  335. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usergroup_members_pkey" for table "usergroup_members"
  336. -> 0.0043s
  337. == CreateUsergroups: migrated (0.0092s) ======================================
  338.  
  339. == AddOwnerToHosts: migrating ================================================
  340. -- add_column(:hosts, :owner_id, :integer)
  341. -> 0.0010s
  342. -- add_column(:hosts, :owner_type, :string)
  343. -> 0.0004s
  344. == AddOwnerToHosts: migrated (0.0600s) =======================================
  345.  
  346. == AddUbuntuCustomLvmPtable: migrating =======================================
  347. == AddUbuntuCustomLvmPtable: migrated (0.0000s) ==============================
  348.  
  349. == CreateMediaOperatingsystemsAndMigrateData: migrating ======================
  350. -- create_table(:media_operatingsystems, {:id=>false})
  351. -> 0.0012s
  352. -- remove_column(:media, :operatingsystem_id)
  353. -> 0.0005s
  354. == CreateMediaOperatingsystemsAndMigrateData: migrated (0.0061s) =============
  355.  
  356. == MigrateInstallationMediumUri: migrating ===================================
  357. == MigrateInstallationMediumUri: migrated (0.0029s) ==========================
  358.  
  359. == SimplifyParameters: migrating =============================================
  360. -- index_exists?(:parameters, :host_id)
  361. -> 0.0027s
  362. -- index_exists?(:parameters, :hostgroup_id)
  363. -> 0.0019s
  364. -- index_exists?(:parameters, :domain_id)
  365. -> 0.0020s
  366. -- column_exists?(:parameters, :host_id)
  367. -> 0.0007s
  368. -- rename_column(:parameters, :host_id, :reference_id)
  369. -> 0.0006s
  370. -- index_exists?(:parameters, :reference_id)
  371. -> 0.0021s
  372. -- Everything migrated ok so we remove the old columns
  373. -- column_exists?(:parameters, :hostgroup_id)
  374. -> 0.0007s
  375. -- remove_column(:parameters, :hostgroup_id)
  376. -> 0.0005s
  377. -- column_exists?(:parameters, :domain_id)
  378. -> 0.0007s
  379. -- remove_column(:parameters, :domain_id)
  380. -> 0.0005s
  381. == SimplifyParameters: migrated (0.0310s) ====================================
  382.  
  383. == UpdateOsMinor: migrating ==================================================
  384. -- change_column(:operatingsystems, :minor, :string, {:limit=>16, :default=>"", :null=>false})
  385. -> 0.0042s
  386. == UpdateOsMinor: migrated (0.0061s) =========================================
  387.  
  388. == ChangeFamilyInOs: migrating ===============================================
  389. -- add_column(:operatingsystems, :type, :string, {:limit=>16})
  390. -> 0.0006s
  391. -- add_index(:operatingsystems, :type)
  392. -> 0.0035s
  393. -- remove_column(:operatingsystems, :family_id)
  394. -> 0.0004s
  395. == ChangeFamilyInOs: migrated (0.0093s) ======================================
  396.  
  397. == CreateNotices: migrating ==================================================
  398. -- create_table(:notices)
  399. NOTICE: CREATE TABLE will create implicit sequence "notices_id_seq" for serial column "notices.id"
  400. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "notices_pkey" for table "notices"
  401. -> 0.0071s
  402. -- create_table(:user_notices, {:id=>false})
  403. -> 0.0008s
  404. == CreateNotices: migrated (0.0081s) =========================================
  405.  
  406. == AddInternalAuth: migrating ================================================
  407. -- add_column(:users, :password_hash, :string, {:limit=>128})
  408. -> 0.0009s
  409. -- add_column(:users, :password_salt, :string, {:limit=>128})
  410. -> 0.0006s
  411. == AddInternalAuth: migrated (0.0018s) =======================================
  412.  
  413. == CreateRoles: migrating ====================================================
  414. -- add_column(:users, :role_id, :integer)
  415. -> 0.0008s
  416. -- create_table("roles", {:force=>true})
  417. NOTICE: CREATE TABLE will create implicit sequence "roles_id_seq" for serial column "roles.id"
  418. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "roles_pkey" for table "roles"
  419. -> 0.0095s
  420. -- create_table(:user_roles)
  421. NOTICE: CREATE TABLE will create implicit sequence "user_roles_id_seq" for serial column "user_roles.id"
  422. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_roles_pkey" for table "user_roles"
  423. -> 0.0055s
  424. == CreateRoles: migrated (0.0162s) ===========================================
  425.  
  426. == AddUserDomainsAndHostgroups: migrating ====================================
  427. -- create_table(:user_domains, {:id=>false})
  428. -> 0.0011s
  429. -- create_table(:user_hostgroups, {:id=>false})
  430. -> 0.0006s
  431. == AddUserDomainsAndHostgroups: migrated (0.0021s) ===========================
  432.  
  433. == CreateUserFacts: migrating ================================================
  434. -- create_table(:user_facts)
  435. NOTICE: CREATE TABLE will create implicit sequence "user_facts_id_seq" for serial column "user_facts.id"
  436. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_facts_pkey" for table "user_facts"
  437. -> 0.0046s
  438. == CreateUserFacts: migrated (0.0047s) =======================================
  439.  
  440. == AddEnabledToHosts: migrating ==============================================
  441. -- add_column(:hosts, :enabled, :boolean, {:default=>true})
  442. -> 0.0308s
  443. == AddEnabledToHosts: migrated (0.0310s) =====================================
  444.  
  445. == AddMyBooleansToUser: migrating ============================================
  446. -- add_column(:users, :domains_andor, :string, {:limit=>3, :default=>"or"})
  447. -> 0.0070s
  448. -- add_column(:users, :hostgroups_andor, :string, {:limit=>3, :default=>"or"})
  449. -> 0.0069s
  450. -- add_column(:users, :facts_andor, :string, {:limit=>3, :default=>"or"})
  451. -> 0.0072s
  452. == AddMyBooleansToUser: migrated (0.0214s) ===================================
  453.  
  454. == CreateMessages: migrating =================================================
  455. -- create_table(:messages)
  456. NOTICE: CREATE TABLE will create implicit sequence "messages_id_seq" for serial column "messages.id"
  457. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages"
  458. -> 0.0204s
  459. -- add_index(:messages, :value)
  460. -> 0.0050s
  461. == CreateMessages: migrated (0.0260s) ========================================
  462.  
  463. == CreateSources: migrating ==================================================
  464. -- create_table(:sources)
  465. NOTICE: CREATE TABLE will create implicit sequence "sources_id_seq" for serial column "sources.id"
  466. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sources_pkey" for table "sources"
  467. -> 0.0075s
  468. -- add_index(:sources, :value)
  469. -> 0.0035s
  470. == CreateSources: migrated (0.0113s) =========================================
  471.  
  472. == CreateLogs: migrating =====================================================
  473. -- create_table(:logs)
  474. NOTICE: CREATE TABLE will create implicit sequence "logs_id_seq" for serial column "logs.id"
  475. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "logs_pkey" for table "logs"
  476. -> 0.0044s
  477. -- add_index(:logs, :report_id)
  478. -> 0.0037s
  479. -- add_index(:logs, :message_id)
  480. -> 0.0038s
  481. -- add_index(:logs, :level_id)
  482. -> 0.0039s
  483. == CreateLogs: migrated (0.0161s) ============================================
  484.  
  485. == AddMetricsToReport: migrating =============================================
  486. -- add_column(:reports, :metrics, :text)
  487. -> 0.0008s
  488. == AddMetricsToReport: migrated (0.0009s) ====================================
  489.  
  490. == ConvertReports: migrating =================================================
  491. -- About to convert all of the 0 reports log field into a more DB optimized way... this might take a while.....
  492. -- remove_column(:reports, :log)
  493. -> 0.0005s
  494. == ConvertReports: migrated (0.0029s) ========================================
  495.  
  496. == AddOwnedFilterToUser: migrating ===========================================
  497. -- add_column(:users, :filter_on_owner, :boolean)
  498. -> 0.0006s
  499. == AddOwnedFilterToUser: migrated (0.0006s) ==================================
  500.  
  501. == CorrectMedia: migrating ===================================================
  502. -- table_exists?(:medias)
  503. -> 0.0006s
  504. == CorrectMedia: migrated (0.0008s) ==========================================
  505.  
  506. == CreateConfigTemplates: migrating ==========================================
  507. -- create_table(:config_templates)
  508. NOTICE: CREATE TABLE will create implicit sequence "config_templates_id_seq" for serial column "config_templates.id"
  509. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "config_templates_pkey" for table "config_templates"
  510. -> 0.0071s
  511. == CreateConfigTemplates: migrated (0.0072s) =================================
  512.  
  513. == CreateTemplateCombinations: migrating =====================================
  514. -- create_table(:template_combinations)
  515. NOTICE: CREATE TABLE will create implicit sequence "template_combinations_id_seq" for serial column "template_combinations.id"
  516. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "template_combinations_pkey" for table "template_combinations"
  517. -> 0.0045s
  518. == CreateTemplateCombinations: migrated (0.0047s) ============================
  519.  
  520. == CreateOperatingsystemsConfigTemplates: migrating ==========================
  521. -- create_table(:config_templates_operatingsystems, {:id=>false})
  522. -> 0.0010s
  523. == CreateOperatingsystemsConfigTemplates: migrated (0.0011s) =================
  524.  
  525. == CreateTemplateKinds: migrating ============================================
  526. -- create_table(:template_kinds)
  527. NOTICE: CREATE TABLE will create implicit sequence "template_kinds_id_seq" for serial column "template_kinds.id"
  528. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "template_kinds_pkey" for table "template_kinds"
  529. -> 0.0042s
  530. == CreateTemplateKinds: migrated (0.0043s) ===================================
  531.  
  532. == CreateOsDefaultTemplates: migrating =======================================
  533. -- create_table(:os_default_templates)
  534. NOTICE: CREATE TABLE will create implicit sequence "os_default_templates_id_seq" for serial column "os_default_templates.id"
  535. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "os_default_templates_pkey" for table "os_default_templates"
  536. -> 0.0039s
  537. == CreateOsDefaultTemplates: migrated (0.0040s) ==============================
  538.  
  539. == AddDefaultTemplates: migrating ============================================
  540. == AddDefaultTemplates: migrated (0.0000s) ===================================
  541.  
  542. == AddSubSystemsToSubnet: migrating ==========================================
  543. -- add_column(:subnets, :dhcp_id, :integer)
  544. -> 0.0008s
  545. -- add_column(:subnets, :tftp_id, :integer)
  546. -> 0.0003s
  547. -- rename_column(:subnets, :number, :network)
  548. -> 0.0004s
  549. == AddSubSystemsToSubnet: migrated (0.0017s) =================================
  550.  
  551. == CreateProxies: migrating ==================================================
  552. -- create_table(:smart_proxies)
  553. NOTICE: CREATE TABLE will create implicit sequence "smart_proxies_id_seq" for serial column "smart_proxies.id"
  554. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "smart_proxies_pkey" for table "smart_proxies"
  555. -> 0.0074s
  556. == CreateProxies: migrated (0.0075s) =========================================
  557.  
  558. == AddProxyToDomain: migrating ===============================================
  559. -- add_column(:domains, :dns_id, :integer)
  560. -> 0.0006s
  561. -- remove_column(:domains, :dnsserver)
  562. -> 0.0003s
  563. -- remove_column(:domains, :gateway)
  564. -> 0.0004s
  565. == AddProxyToDomain: migrated (0.0016s) ======================================
  566.  
  567. == AddGrubbyTemplate: migrating ==============================================
  568. == AddGrubbyTemplate: migrated (0.0000s) =====================================
  569.  
  570. == AddHostGroupDefaults: migrating ===========================================
  571. -- add_column(:hostgroups, :environment_id, :integer)
  572. -> 0.0006s
  573. -- add_column(:hostgroups, :operatingsystem_id, :integer)
  574. -> 0.0004s
  575. -- add_column(:hostgroups, :architecture_id, :integer)
  576. -> 0.0004s
  577. -- add_column(:hostgroups, :medium_id, :integer)
  578. -> 0.0003s
  579. -- add_column(:hostgroups, :ptable_id, :integer)
  580. -> 0.0003s
  581. -- add_column(:hostgroups, :root_pass, :string)
  582. -> 0.0029s
  583. -- add_column(:hostgroups, :puppetmaster, :string)
  584. -> 0.0004s
  585. == AddHostGroupDefaults: migrated (0.0057s) ==================================
  586.  
  587. == AddDefaultPxeMenuTemplate: migrating ======================================
  588. == AddDefaultPxeMenuTemplate: migrated (0.0000s) =============================
  589.  
  590. == CreateProxyFeatures: migrating ============================================
  591. -- create_table(:features)
  592. NOTICE: CREATE TABLE will create implicit sequence "features_id_seq" for serial column "features.id"
  593. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "features_pkey" for table "features"
  594. -> 0.0045s
  595. -- create_table(:features_smart_proxies, {:id=>false})
  596. -> 0.0009s
  597. == CreateProxyFeatures: migrated (0.0055s) ===================================
  598.  
  599. == ChangePuppetmasterColumn: migrating =======================================
  600. -- rename_column(:hosts, :puppetmaster, :puppetmaster_name)
  601. -> 0.0006s
  602. -- add_column(:hosts, :puppetproxy_id, :integer)
  603. -> 0.0004s
  604. -- rename_column(:hostgroups, :puppetmaster, :puppetmaster_name)
  605. -> 0.0003s
  606. -- add_column(:hostgroups, :puppetproxy_id, :integer)
  607. -> 0.0005s
  608. == ChangePuppetmasterColumn: migrated (0.0020s) ==============================
  609.  
  610. == AddManagedToHosts: migrating ==============================================
  611. -- add_column(:hosts, :managed, :boolean)
  612. -> 0.0008s
  613. == AddManagedToHosts: migrated (0.0045s) =====================================
  614.  
  615. == RevertFaceNamesAndValuesToTextRecords: migrating ==========================
  616. == RevertFaceNamesAndValuesToTextRecords: migrated (0.0001s) =================
  617.  
  618. == AddPriorityToParameter: migrating =========================================
  619. -- add_column(:parameters, :priority, :integer)
  620. -> 0.0007s
  621. == AddPriorityToParameter: migrated (0.0039s) ================================
  622.  
  623. == AddMediaPathToMedium: migrating ===========================================
  624. -- add_column(:media, :media_path, :string, {:limit=>128})
  625. -> 0.0007s
  626. -- add_column(:media, :config_path, :string, {:limit=>128})
  627. -> 0.0003s
  628. -- add_column(:media, :image_path, :string, {:limit=>128})
  629. -> 0.0029s
  630. == AddMediaPathToMedium: migrated (0.0042s) ==================================
  631.  
  632. == AddImageToHost: migrating =================================================
  633. -- add_column(:hosts, :use_image, :boolean)
  634. -> 0.0007s
  635. -- add_column(:hosts, :image_file, :string, {:limit=>128})
  636. -> 0.0003s
  637. -- add_column(:hostgroups, :use_image, :boolean)
  638. -> 0.0004s
  639. -- add_column(:hostgroups, :image_file, :string, {:limit=>128})
  640. -> 0.0004s
  641. == AddImageToHost: migrated (0.0021s) ========================================
  642.  
  643. == RemoveUnusedFieldsFromPuppetClasses: migrating ============================
  644. -- remove_column(:puppetclasses, :nameindicator)
  645. -> 0.0005s
  646. -- remove_column(:puppetclasses, :operatingsystem_id)
  647. -> 0.0003s
  648. == RemoveUnusedFieldsFromPuppetClasses: migrated (0.0010s) ===================
  649.  
  650. == AddTableBookmarks: migrating ==============================================
  651. -- create_table(:bookmarks, {:force=>true})
  652. NOTICE: CREATE TABLE will create implicit sequence "bookmarks_id_seq" for serial column "bookmarks.id"
  653. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "bookmarks_pkey" for table "bookmarks"
  654. -> 0.0092s
  655. -- add_index(:bookmarks, :name)
  656. -> 0.0040s
  657. -- add_index(:bookmarks, :controller)
  658. -> 0.0038s
  659. -- add_index(:bookmarks, [:owner_id, :owner_type])
  660. -> 0.0042s
  661. == AddTableBookmarks: migrated (0.0216s) =====================================
  662.  
  663. == AddSolarisTemplates: migrating ============================================
  664. == AddSolarisTemplates: migrated (0.0000s) ===================================
  665.  
  666. == AddSolarisDisks: migrating ================================================
  667. == AddSolarisDisks: migrated (0.0000s) =======================================
  668.  
  669. == AddLookUpKeyIdToPuppetClass: migrating ====================================
  670. -- add_column(:lookup_keys, :puppetclass_id, :integer)
  671. -> 0.0006s
  672. -- add_index(:lookup_keys, :puppetclass_id)
  673. -> 0.0035s
  674. -- add_column(:lookup_keys, :default_value, :string)
  675. -> 0.0028s
  676. -- add_column(:lookup_keys, :path, :string)
  677. -> 0.0003s
  678. -- add_index(:lookup_keys, :path)
  679. -> 0.0039s
  680. -- add_column(:lookup_keys, :description, :string)
  681. -> 0.0004s
  682. -- add_column(:lookup_keys, :validator_type, :string)
  683. -> 0.0003s
  684. -- add_column(:lookup_keys, :validator_rule, :string)
  685. -> 0.0003s
  686. -- rename_column(:lookup_values, :priority, :match)
  687. -> 0.0003s
  688. -- add_index(:lookup_values, :match)
  689. -> 0.0038s
  690. == AddLookUpKeyIdToPuppetClass: migrated (0.0168s) ===========================
  691.  
  692. == AddSparcInfoToModel: migrating ============================================
  693. -- add_column(:models, :vendor_class, :string, {:limit=>32})
  694. -> 0.0008s
  695. -- add_column(:models, :hardware_model, :string, {:limit=>16})
  696. -> 0.0004s
  697. == AddSparcInfoToModel: migrated (0.0015s) ===================================
  698.  
  699. == AddAncestryToHostgroup: migrating =========================================
  700. -- add_column(:hostgroups, :ancestry, :string)
  701. -> 0.0005s
  702. -- add_index(:hostgroups, :ancestry)
  703. -> 0.0042s
  704. == AddAncestryToHostgroup: migrated (0.0048s) ================================
  705.  
  706. == CreateSettings: migrating =================================================
  707. -- create_table(:settings)
  708. NOTICE: CREATE TABLE will create implicit sequence "settings_id_seq" for serial column "settings.id"
  709. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "settings_pkey" for table "settings"
  710. -> 0.0116s
  711. -- add_index(:settings, :name, {:unique=>true})
  712. -> 0.0042s
  713. == CreateSettings: migrated (0.0160s) ========================================
  714.  
  715. == UpdateAuditsTable: migrating ==============================================
  716. == UpdateAuditsTable: migrated (0.0026s) =====================================
  717.  
  718. == CreateHostClass: migrating ================================================
  719. -- rename_table(:hosts_puppetclasses, :host_classes)
  720. -> 0.0035s
  721. -- add_column(:host_classes, :id, :primary_key)
  722. NOTICE: ALTER TABLE will create implicit sequence "host_classes_id_seq" for serial column "host_classes.id"
  723. NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "host_classes_pkey" for table "host_classes"
  724. -> 0.0044s
  725. == CreateHostClass: migrated (0.0081s) =======================================
  726.  
  727. == AddSuseTemplates: migrating ===============================================
  728. == AddSuseTemplates: migrated (0.0000s) ======================================
  729.  
  730. == AddVmDefaultsToHostgroup: migrating =======================================
  731. -- add_column(:hostgroups, :vm_defaults, :text)
  732. -> 0.0008s
  733. == AddVmDefaultsToHostgroup: migrated (0.0009s) ==============================
  734.  
  735. == AddSubnetAndDomainToHostGroups: migrating =================================
  736. -- column_exists?(:hostgroups, :subnet_id)
  737. -> 0.0010s
  738. -- add_column(:hostgroups, :subnet_id, :integer)
  739. -> 0.0006s
  740. -- column_exists?(:hostgroups, :domain_id)
  741. -> 0.0009s
  742. -- add_column(:hostgroups, :domain_id, :integer)
  743. -> 0.0003s
  744. == AddSubnetAndDomainToHostGroups: migrated (0.0032s) ========================
  745.  
  746. == RenameChangesToAuditedChanges: migrating ==================================
  747. -- rename_column(:audits, :changes, :audited_changes)
  748. -> 0.1051s
  749. == RenameChangesToAuditedChanges: migrated (0.1052s) =========================
  750.  
  751. == AddRemoteAddressToAudits: migrating =======================================
  752. -- add_column(:audits, :remote_address, :string)
  753. -> 0.0008s
  754. == AddRemoteAddressToAudits: migrated (0.0009s) ==============================
  755.  
  756. == RenameParentToAssociation: migrating ======================================
  757. -- rename_column(:audits, :auditable_parent_id, :association_id)
  758. -> 0.0006s
  759. -- rename_column(:audits, :auditable_parent_type, :association_type)
  760. -> 0.0004s
  761. == RenameParentToAssociation: migrated (0.0012s) =============================
  762.  
  763. == AddGatewayAndDnsToSubnets: migrating ======================================
  764. -- add_column(:subnets, :gateway, :string)
  765. -> 0.0007s
  766. -- add_column(:subnets, :dns_primary, :string)
  767. -> 0.0004s
  768. -- add_column(:subnets, :dns_secondary, :string)
  769. -> 0.0004s
  770. == AddGatewayAndDnsToSubnets: migrated (0.0017s) =============================
  771.  
  772. == EnsureAllHostnamesAreLowercase: migrating =================================
  773. -- execute("UPDATE hosts SET name=LOWER(name)")
  774. -> 0.0005s
  775. == EnsureAllHostnamesAreLowercase: migrated (0.0006s) ========================
  776.  
  777. == AddFromAndToRangesToSubnets: migrating ====================================
  778. -- add_column(:subnets, :from, :string)
  779. -> 0.0006s
  780. -- add_column(:subnets, :to, :string)
  781. -> 0.0003s
  782. -- remove_column(:subnets, :ranges)
  783. -> 0.0005s
  784. == AddFromAndToRangesToSubnets: migrated (0.0016s) ===========================
  785.  
  786. == CreateSubnetDomain: migrating =============================================
  787. -- create_table(:subnet_domains)
  788. NOTICE: CREATE TABLE will create implicit sequence "subnet_domains_id_seq" for serial column "subnet_domains.id"
  789. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "subnet_domains_pkey" for table "subnet_domains"
  790. -> 0.0059s
  791. -- remove_column(:subnets, :domain_id)
  792. -> 0.0005s
  793. == CreateSubnetDomain: migrated (0.0097s) ====================================
  794.  
  795. == CreateComputeResources: migrating =========================================
  796. -- create_table(:compute_resources)
  797. NOTICE: CREATE TABLE will create implicit sequence "compute_resources_id_seq" for serial column "compute_resources.id"
  798. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "compute_resources_pkey" for table "compute_resources"
  799. -> 0.0075s
  800. == CreateComputeResources: migrated (0.0076s) ================================
  801.  
  802. == AddUuidAndComputeIdToHost: migrating ======================================
  803. -- add_column(:hosts, :uuid, :string)
  804. -> 0.0007s
  805. -- add_column(:hosts, :compute_resource_id, :integer)
  806. -> 0.0004s
  807. == AddUuidAndComputeIdToHost: migrated (0.0013s) =============================
  808.  
  809. == AddWindowsTemplates: migrating ============================================
  810. == AddWindowsTemplates: migrated (0.0000s) ===================================
  811.  
  812. == CreateNics: migrating =====================================================
  813. -- create_table(:nics)
  814. NOTICE: CREATE TABLE will create implicit sequence "nics_id_seq" for serial column "nics.id"
  815. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nics_pkey" for table "nics"
  816. -> 0.0075s
  817. -- add_index(:nics, [:type], {:name=>"index_by_type"})
  818. -> 0.0038s
  819. -- add_index(:nics, [:host_id], {:name=>"index_by_host"})
  820. -> 0.0038s
  821. -- add_index(:nics, [:type, :id], {:name=>"index_by_type_and_id"})
  822. -> 0.0040s
  823. -- remove_columns(:hosts, :sp_mac, :sp_ip, :sp_name, :sp_subnet_id)
  824. -> 0.0015s
  825. == CreateNics: migrated (0.0226s) ============================================
  826.  
  827. == AddPuppetMasterProxyToHostAndHostGroup: migrating =========================
  828. -- rename_column(:hosts, :puppetproxy_id, :puppet_ca_proxy_id)
  829. -> 0.0007s
  830. -- add_column(:hosts, :puppet_proxy_id, :integer)
  831. -> 0.0005s
  832. -- rename_column(:hostgroups, :puppetproxy_id, :puppet_ca_proxy_id)
  833. -> 0.0003s
  834. -- add_column(:hostgroups, :puppet_proxy_id, :integer)
  835. -> 0.0003s
  836. -- remove_column(:hosts, :puppetmaster_name)
  837. -> 0.0005s
  838. -- remove_column(:hostgroups, :puppetmaster_name)
  839. -> 0.0003s
  840. == AddPuppetMasterProxyToHostAndHostGroup: migrated (0.0086s) ================
  841.  
  842. == UpdateReportFieldToLargeInt: migrating ====================================
  843. -- change_column(:reports, :status, :bigint)
  844. -> 0.0227s
  845. -- change_column(:hosts, :puppet_status, :bigint)
  846. -> 0.0637s
  847. == UpdateReportFieldToLargeInt: migrated (0.0867s) ===========================
  848.  
  849. == CreateImages: migrating ===================================================
  850. -- create_table(:images)
  851. NOTICE: CREATE TABLE will create implicit sequence "images_id_seq" for serial column "images.id"
  852. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "images_pkey" for table "images"
  853. -> 0.0105s
  854. == CreateImages: migrated (0.0106s) ==========================================
  855.  
  856. == AddCertNameToHost: migrating ==============================================
  857. -- add_column(:hosts, :certname, :string)
  858. -> 0.0008s
  859. -- add_index("hosts", :certname)
  860. -> 0.0081s
  861. == AddCertNameToHost: migrated (0.0090s) =====================================
  862.  
  863. == CreateKeyPairs: migrating =================================================
  864. -- create_table(:key_pairs)
  865. NOTICE: CREATE TABLE will create implicit sequence "key_pairs_id_seq" for serial column "key_pairs.id"
  866. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "key_pairs_pkey" for table "key_pairs"
  867. -> 0.0076s
  868. == CreateKeyPairs: migrated (0.0077s) ========================================
  869.  
  870. == AddDnsIdToSubnet: migrating ===============================================
  871. -- add_column(:subnets, :dns_id, :integer)
  872. -> 0.0006s
  873. == AddDnsIdToSubnet: migrated (0.0007s) ======================================
  874.  
  875. == AddImageIdToHost: migrating ===============================================
  876. -- add_column(:hosts, :image_id, :integer)
  877. -> 0.0006s
  878. == AddImageIdToHost: migrated (0.0007s) ======================================
  879.  
  880. == AddUserComputeResources: migrating ========================================
  881. -- create_table(:user_compute_resources, {:id=>false})
  882. -> 0.0014s
  883. == AddUserComputeResources: migrated (0.0016s) ===============================
  884.  
  885. == AddComputeResourcesBooleanToUser: migrating ===============================
  886. -- add_column(:users, :compute_resources_andor, :string, {:limit=>3, :default=>"or"})
  887. -> 0.0127s
  888. == AddComputeResourcesBooleanToUser: migrated (0.0128s) ======================
  889.  
  890. == AddEpelSnippets: migrating ================================================
  891. == AddEpelSnippets: migrated (0.0000s) =======================================
  892.  
  893. == ConvertParamsToText: migrating ============================================
  894. -- change_column("parameters", :value, :text)
  895. -> 0.0303s
  896. -- change_column("lookup_values", :value, :text)
  897. -> 0.0323s
  898. == ConvertParamsToText: migrated (0.0628s) ===================================
  899.  
  900. == ChangeBookmarkColumnToText: migrating =====================================
  901. -- change_column("bookmarks", :query, :text)
  902. -> 0.0258s
  903. == ChangeBookmarkColumnToText: migrated (0.0260s) ============================
  904.  
  905. == RenameAssociationToAssociated: migrating ==================================
  906. -- index_exists?(:audits, [:association_id, :association_type], {:name=>"association_index"})
  907. -> 0.0027s
  908. -- column_exists?(:audits, :association_id)
  909. -> 0.0008s
  910. -- rename_column(:audits, :association_id, :associated_id)
  911. -> 0.0006s
  912. -- column_exists?(:audits, :association_type)
  913. -> 0.0007s
  914. -- rename_column(:audits, :association_type, :associated_type)
  915. -> 0.0003s
  916. -- index_exists?(:audits, [:association_id, :association_type], {:name=>"association_index"})
  917. -> 0.0020s
  918. -- add_index(:audits, [:associated_id, :associated_type], {:name=>"associated_index"})
  919. -> 0.0078s
  920. == RenameAssociationToAssociated: migrated (0.0153s) =========================
  921.  
  922. == FixAuditableType: migrating ===============================================
  923. -- execute("UPDATE audits SET auditable_type='Host' WHERE auditable_type='Puppet::Rails::Host'")
  924. -> 0.0007s
  925. == FixAuditableType: migrated (0.0008s) ======================================
  926.  
  927. == FixAssociatedType: migrating ==============================================
  928. -- execute("UPDATE audits SET associated_type='Host' WHERE associated_type='Puppet::Rails::Host'")
  929. -> 0.0006s
  930. == FixAssociatedType: migrated (0.0007s) =====================================
  931.  
  932. == CreateTaxonomies: migrating ===============================================
  933. -- create_table(:taxonomies)
  934. NOTICE: CREATE TABLE will create implicit sequence "taxonomies_id_seq" for serial column "taxonomies.id"
  935. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxonomies_pkey" for table "taxonomies"
  936. -> 0.0115s
  937. == CreateTaxonomies: migrated (0.0117s) ======================================
  938.  
  939. == AddOkHostsBookMark: migrating =============================================
  940. == AddOkHostsBookMark: migrated (0.0000s) ====================================
  941.  
  942. == AddAuditableNameAndAssociatedNameToAudit: migrating =======================
  943. -- column_exists?(:audits, :auditable_name)
  944. -> 0.0010s
  945. -- add_column(:audits, :auditable_name, :string)
  946. -> 0.0006s
  947. -- column_exists?(:audits, :associated_name)
  948. -> 0.0008s
  949. -- add_column(:audits, :associated_name, :string)
  950. -> 0.0003s
  951. -- index_exists?(:audits, :id)
  952. -> 0.0026s
  953. -- add_index(:audits, :id)
  954. -> 0.0052s
  955. -- About to review all audits, this may take a while...
  956. == AddAuditableNameAndAssociatedNameToAudit: migrated (0.0195s) ==============
  957.  
  958. == AddOsFamilyToMedia: migrating =============================================
  959. -- add_column(:media, :os_family, :string)
  960. -> 0.0006s
  961. == AddOsFamilyToMedia: migrated (0.0028s) ====================================
  962.  
  963. == AddOsFamilyToPtable: migrating ============================================
  964. -- column_exists?(:ptables, :os_family)
  965. -> 0.0007s
  966. -- add_column(:ptables, :os_family, :string)
  967. -> 0.0007s
  968. -- column_exists?(:ptables, :operatingsystem_id)
  969. -> 0.0006s
  970. -- remove_column(:ptables, :operatingsystem_id)
  971. -> 0.0003s
  972. == AddOsFamilyToPtable: migrated (0.1377s) ===================================
  973.  
  974. == AddAttributesToComputeResources: migrating ================================
  975. -- column_exists?(:compute_resources, :attrs)
  976. -> 0.0007s
  977. -- add_column(:compute_resources, :attrs, :text)
  978. -> 0.0005s
  979. == AddAttributesToComputeResources: migrated (0.0013s) =======================
  980.  
  981. == AddSomeIndexes: migrating =================================================
  982. -- add_index(:environments_puppetclasses, :puppetclass_id)
  983. -> 0.0030s
  984. -- add_index(:environments_puppetclasses, :environment_id)
  985. -> 0.0102s
  986. -- add_index(:puppetclasses, :name)
  987. -> 0.0057s
  988. -- add_index(:hostgroups_puppetclasses, :puppetclass_id)
  989. -> 0.0073s
  990. -- add_index(:hostgroups_puppetclasses, :hostgroup_id)
  991. -> 0.0083s
  992. == AddSomeIndexes: migrated (0.0349s) ========================================
  993.  
  994. == CreateEnvironmentClasses: migrating =======================================
  995. -- rename_table(:environments_puppetclasses, :environment_classes)
  996. -> 0.0029s
  997. -- add_column(:environment_classes, :id, :primary_key)
  998. NOTICE: ALTER TABLE will create implicit sequence "environment_classes_id_seq" for serial column "environment_classes.id"
  999. NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "environment_classes_pkey" for table "environment_classes"
  1000. -> 0.0169s
  1001. -- add_column(:environment_classes, :lookup_key_id, :integer)
  1002. -> 0.0005s
  1003. == CreateEnvironmentClasses: migrated (0.0205s) ==============================
  1004.  
  1005. == AddLookupKeysOverrideAndRequired: migrating ===============================
  1006. -- add_column(:lookup_keys, :is_param, :boolean, {:default=>false})
  1007. -> 0.0224s
  1008. -- add_column(:lookup_keys, :key_type, :string, {:default=>nil})
  1009. -> 0.0313s
  1010. -- add_column(:lookup_keys, :override, :boolean, {:default=>false})
  1011. -> 0.0250s
  1012. -- add_column(:lookup_keys, :required, :boolean, {:default=>false})
  1013. -> 0.0254s
  1014. == AddLookupKeysOverrideAndRequired: migrated (0.1048s) ======================
  1015.  
  1016. == AddLookupValuesCountToLookupKeys: migrating ===============================
  1017. -- add_column(:lookup_keys, :lookup_values_count, :integer, {:default=>0})
  1018. -> 0.0238s
  1019. == AddLookupValuesCountToLookupKeys: migrated (0.0240s) ======================
  1020.  
  1021. == CacheLookupValuesCount: migrating =========================================
  1022. -- execute("update lookup_keys set lookup_values_count=(select count(*) from lookup_values where lookup_key_id=lookup_keys.id)")
  1023. -> 0.0009s
  1024. == CacheLookupValuesCount: migrated (0.0010s) ================================
  1025.  
  1026. == AddIamRoleToImages: migrating =============================================
  1027. -- add_column(:images, :iam_role, :string)
  1028. -> 0.0009s
  1029. == AddIamRoleToImages: migrated (0.0012s) ====================================
  1030.  
  1031. == CreateTokens: migrating ===================================================
  1032. -- create_table(:tokens)
  1033. NOTICE: CREATE TABLE will create implicit sequence "tokens_id_seq" for serial column "tokens.id"
  1034. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tokens_pkey" for table "tokens"
  1035. -> 0.0085s
  1036. -- add_index(:tokens, :value)
  1037. -> 0.0073s
  1038. -- add_index(:tokens, :host_id)
  1039. -> 0.0086s
  1040. == CreateTokens: migrated (0.0247s) ==========================================
  1041.  
  1042. == AddBmcFeatureToProxy: migrating ===========================================
  1043. == AddBmcFeatureToProxy: migrated (0.0000s) ==================================
  1044.  
  1045. == AddTaxonomyIdsToHosts: migrating ==========================================
  1046. -- add_column(:hosts, :organization_id, :integer)
  1047. -> 0.0008s
  1048. -- add_column(:hosts, :location_id, :integer)
  1049. -> 0.0004s
  1050. == AddTaxonomyIdsToHosts: migrated (0.0013s) =================================
  1051.  
  1052. == ChangeDomainCharacterCount: migrating =====================================
  1053. -- change_column(:domains, :fullname, :string, {:limit=>254})
  1054. -> 0.0114s
  1055. == ChangeDomainCharacterCount: migrated (0.0116s) ============================
  1056.  
  1057. == CreateTrends: migrating ===================================================
  1058. -- create_table(:trends)
  1059. NOTICE: CREATE TABLE will create implicit sequence "trends_id_seq" for serial column "trends.id"
  1060. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trends_pkey" for table "trends"
  1061. -> 0.0067s
  1062. -- add_index(:trends, :type)
  1063. -> 0.0033s
  1064. -- add_index(:trends, [:trendable_type, :trendable_id])
  1065. -> 0.0030s
  1066. -- add_index(:trends, :fact_value)
  1067. -> 0.0068s
  1068. == CreateTrends: migrated (0.0203s) ==========================================
  1069.  
  1070. == CreateTrendCounters: migrating ============================================
  1071. -- create_table(:trend_counters)
  1072. NOTICE: CREATE TABLE will create implicit sequence "trend_counters_id_seq" for serial column "trend_counters.id"
  1073. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trend_counters_pkey" for table "trend_counters"
  1074. -> 0.0038s
  1075. -- add_index(:trend_counters, :trend_id)
  1076. -> 0.0026s
  1077. == CreateTrendCounters: migrated (0.0066s) ===================================
  1078.  
  1079. == UpdateMediaPathLimit: migrating ===========================================
  1080. -- change_column(:media, :path, :string, {:limit=>255})
  1081. -> 0.0065s
  1082. == UpdateMediaPathLimit: migrated (0.0066s) ==================================
  1083.  
  1084. == CreateHostgroupClasses: migrating =========================================
  1085. -- rename_table(:hostgroups_puppetclasses, :hostgroup_classes)
  1086. -> 0.0029s
  1087. -- add_column(:hostgroup_classes, :id, :primary_key)
  1088. NOTICE: ALTER TABLE will create implicit sequence "hostgroup_classes_id_seq" for serial column "hostgroup_classes.id"
  1089. NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "hostgroup_classes_pkey" for table "hostgroup_classes"
  1090. -> 0.0072s
  1091. == CreateHostgroupClasses: migrated (0.0103s) ================================
  1092.  
  1093. == AddLocalbootTemplate: migrating ===========================================
  1094. == AddLocalbootTemplate: migrated (0.0000s) ==================================
  1095.  
  1096. == RenameReplyAdressSetting: migrating =======================================
  1097. -- execute("UPDATE settings SET name='email_reply_address' WHERE name='email_replay_adress'")
  1098. -> 0.0006s
  1099. == RenameReplyAdressSetting: migrated (0.0007s) ==============================
  1100.  
  1101. == AddLocationsOrganizations: migrating ======================================
  1102. -- create_table(:locations_organizations, {:id=>false})
  1103. -> 0.0010s
  1104. == AddLocationsOrganizations: migrated (0.0011s) =============================
  1105.  
  1106. == MigrateHypervisorsToComputeResources: migrating ===========================
  1107. == MigrateHypervisorsToComputeResources: migrated (0.0011s) ==================
  1108.  
  1109. == CreateTaxableTaxonomies: migrating ========================================
  1110. -- create_table(:taxable_taxonomies)
  1111. NOTICE: CREATE TABLE will create implicit sequence "taxable_taxonomies_id_seq" for serial column "taxable_taxonomies.id"
  1112. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxable_taxonomies_pkey" for table "taxable_taxonomies"
  1113. -> 0.0038s
  1114. -- add_index(:taxable_taxonomies, [:taxable_id, :taxable_type])
  1115. -> 0.0027s
  1116. -- add_index(:taxable_taxonomies, [:taxable_id, :taxable_type, :taxonomy_id], {:name=>"taxable_index"})
  1117. -> 0.0029s
  1118. -- add_index(:taxable_taxonomies, :taxonomy_id)
  1119. -> 0.0032s
  1120. == CreateTaxableTaxonomies: migrated (0.0129s) ===============================
  1121.  
  1122. == AddMyTaxonomyToUser: migrating ============================================
  1123. -- add_column(:users, :organizations_andor, :string, {:limit=>3, :default=>"or"})
  1124. -> 0.0057s
  1125. -- add_column(:users, :locations_andor, :string, {:limit=>3, :default=>"or"})
  1126. -> 0.0053s
  1127. == AddMyTaxonomyToUser: migrated (0.0112s) ===================================
  1128.  
  1129. == AddSubscribeToAllHostgroupsToUsers: migrating =============================
  1130. -- column_exists?(:users, :subscribe_to_all_hostgroups)
  1131. -> 0.0013s
  1132. -- add_column(:users, :subscribe_to_all_hostgroups, :boolean)
  1133. -> 0.0006s
  1134. == AddSubscribeToAllHostgroupsToUsers: migrated (0.0021s) ====================
  1135.  
  1136. == ChangeSmartVariableLength: migrating ======================================
  1137. -- change_column(:lookup_keys, :default_value, :text)
  1138. -> 0.0255s
  1139. == ChangeSmartVariableLength: migrated (0.0257s) =============================
  1140.  
  1141. == RemoveReplayAddressSetting: migrating =====================================
  1142. -- execute("DELETE FROM settings WHERE name='email_replay_address'")
  1143. -> 0.0004s
  1144. == RemoveReplayAddressSetting: migrated (0.0005s) ============================
  1145.  
  1146. == AddIgnoreTypesToTaxonomy: migrating =======================================
  1147. -- add_column(:taxonomies, :ignore_types, :text)
  1148. -> 0.0010s
  1149. == AddIgnoreTypesToTaxonomy: migrated (0.0011s) ==============================
  1150.  
  1151. == AddDigestToMessages: migrating ============================================
  1152. -- index_exists?(:messages, :value)
  1153. -> 0.0013s
  1154. -- remove_index(:messages, :value)
  1155. -> 0.0013s
  1156. -- add_column(:messages, :digest, :string)
  1157. -> 0.0004s
  1158. -- add_index(:messages, :digest)
  1159. -> 0.0033s
  1160. == AddDigestToMessages: migrated (0.0214s) ===================================
  1161.  
  1162. == AddStiToHosts: migrating ==================================================
  1163. -- add_column(:hosts, :type, :string)
  1164. -> 0.0010s
  1165. -- execute("UPDATE hosts set type='Host::Managed'")
  1166. -> 0.0007s
  1167. -- add_index(:hosts, :type)
  1168. -> 0.0065s
  1169. == AddStiToHosts: migrated (0.0084s) =========================================
  1170.  
  1171. == AddDigestToSources: migrating =============================================
  1172. -- index_exists?(:sources, :value)
  1173. -> 0.0016s
  1174. -- remove_index(:sources, :value)
  1175. -> 0.0014s
  1176. -- add_column(:sources, :digest, :string)
  1177. -> 0.0006s
  1178. -- add_index(:sources, :digest)
  1179. -> 0.0035s
  1180. == AddDigestToSources: migrated (0.0229s) ====================================
  1181.  
  1182. == RemoveDuplicateSnippets: migrating ========================================
  1183. == RemoveDuplicateSnippets: migrated (0.1683s) ===============================
  1184.  
  1185. == AddLabelToHostGroup: migrating ============================================
  1186. -- add_column(:hostgroups, :label, :string)
  1187. -> 0.0011s
  1188. -- execute("UPDATE hostgroups set label = name WHERE ancestry IS NULL")
  1189. -> 0.0003s
  1190. == AddLabelToHostGroup: migrated (0.0043s) ===================================
  1191.  
  1192. == AddStiToSettings: migrating ===============================================
  1193. -- execute("UPDATE settings set category='Setting::Auth' where category='Auth'")
  1194. -> 0.0003s
  1195. -- execute("UPDATE settings set category='Setting::General' where category='General'")
  1196. -> 0.0003s
  1197. -- execute("UPDATE settings set category='Setting::Puppet' where category='Puppet'")
  1198. -> 0.0002s
  1199. -- execute("UPDATE settings set category='Setting::Provisioning' where category='Provisioning'")
  1200. -> 0.0002s
  1201. -- add_index(:settings, :category)
  1202. -> 0.0036s
  1203. == AddStiToSettings: migrated (0.0048s) ======================================
  1204.  
  1205. == FixStiHostAuditableType: migrating ========================================
  1206. -- execute("UPDATE audits SET auditable_type='Host' WHERE auditable_type='Host::Base'")
  1207. -> 0.0004s
  1208. == FixStiHostAuditableType: migrated (0.0005s) ===============================
  1209.  
  1210. == AddIdToUserHostgroup: migrating ===========================================
  1211. -- add_column(:user_hostgroups, :id, :primary_key)
  1212. NOTICE: ALTER TABLE will create implicit sequence "user_hostgroups_id_seq" for serial column "user_hostgroups.id"
  1213. NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "user_hostgroups_pkey" for table "user_hostgroups"
  1214. -> 0.0044s
  1215. == AddIdToUserHostgroup: migrated (0.0045s) ==================================
  1216.  
  1217. == AddLocaleToUsers: migrating ===============================================
  1218. -- add_column(:users, :locale, :string, {:limit=>5, :null=>true})
  1219. -> 0.0011s
  1220. == AddLocaleToUsers: migrated (0.0013s) ======================================
  1221.  
  1222. == RemoveDuplicateFactNames: migrating =======================================
  1223. == RemoveDuplicateFactNames: migrated (0.0195s) ==============================
  1224.  
  1225. == AddUniqueConstraintToFactName: migrating ==================================
  1226. -- remove_index(:fact_names, {:column=>:name})
  1227. -> 0.0019s
  1228. -- add_index(:fact_names, :name, {:unique=>true})
  1229. -> 0.0055s
  1230. == AddUniqueConstraintToFactName: migrated (0.0077s) =========================
  1231.  
  1232. == AddUniqueConstraintsToFactValues: migrating ===============================
  1233. -- add_index(:fact_values, [:fact_name_id, :host_id], {:unique=>true})
  1234. -> 0.0064s
  1235. == AddUniqueConstraintsToFactValues: migrated (0.0066s) ======================
  1236.  
  1237. == ChangeColumnLengths: migrating ============================================
  1238. -- change_column(:media, :name, :string, {:null=>false, :default=>"", :limit=>255})
  1239. -> 0.0076s
  1240. -- change_column(:media, :media_path, :string, {:limit=>255})
  1241. -> 0.0056s
  1242. -- change_column(:media, :config_path, :string, {:limit=>255})
  1243. -> 0.0056s
  1244. -- change_column(:media, :image_path, :string, {:limit=>255})
  1245. -> 0.0054s
  1246. -- change_column(:architectures, :name, :string, {:default=>"x86_64", :null=>false, :limit=>255})
  1247. -> 0.0045s
  1248. -- change_column(:auth_sources, :type, :string, {:null=>false, :default=>"", :limit=>255})
  1249. -> 0.0067s
  1250. -- change_column(:auth_sources, :name, :string, {:null=>false, :default=>"", :limit=>255})
  1251. -> 0.0072s
  1252. -- change_column(:auth_sources, :host, :string, {:limit=>255})
  1253. -> 0.0058s
  1254. -- change_column(:auth_sources, :account_password, :string, {:limit=>255})
  1255. -> 0.0059s
  1256. -- change_column(:auth_sources, :attr_login, :string, {:limit=>255})
  1257. -> 0.0063s
  1258. -- change_column(:auth_sources, :attr_firstname, :string, {:limit=>255})
  1259. -> 0.0061s
  1260. -- change_column(:auth_sources, :attr_lastname, :string, {:limit=>255})
  1261. -> 0.0055s
  1262. -- change_column(:auth_sources, :attr_mail, :string, {:limit=>255})
  1263. -> 0.0056s
  1264. -- change_column(:domains, :fullname, :string, {:limit=>255})
  1265. -> 0.0056s
  1266. -- change_column(:features, :name, :string, {:limit=>255})
  1267. -> 0.0036s
  1268. -- change_column(:hosts, :mac, :string, {:default=>"", :limit=>255})
  1269. -> 0.0399s
  1270. -- change_column(:hosts, :root_pass, :string, {:limit=>255})
  1271. -> 0.0284s
  1272. -- change_column(:hosts, :serial, :string, {:limit=>255})
  1273. -> 0.0282s
  1274. -- change_column(:models, :name, :string, {:null=>false, :limit=>255})
  1275. -> 0.0061s
  1276. -- change_column(:models, :vendor_class, :string, {:limit=>255})
  1277. -> 0.0054s
  1278. -- change_column(:models, :hardware_model, :string, {:limit=>255})
  1279. -> 0.0055s
  1280. -- change_column(:operatingsystems, :name, :string, {:limit=>255})
  1281. -> 0.0044s
  1282. -- change_column(:operatingsystems, :release_name, :string, {:limit=>255})
  1283. -> 0.0091s
  1284. -- change_column(:operatingsystems, :type, :string, {:limit=>255})
  1285. -> 0.0077s
  1286. -- change_column(:ptables, :name, :string, {:null=>false, :limit=>255})
  1287. -> 0.1120s
  1288. -- change_column(:roles, :name, :string, {:limit=>255})
  1289. -> 0.0177s
  1290. == ChangeColumnLengths: migrated (0.3544s) ===================================
  1291.  
  1292. == AddTemplatesToFeatures: migrating =========================================
  1293. == AddTemplatesToFeatures: migrated (0.1537s) ================================
  1294.  
  1295. == RemoveEnvironmentFromHost: migrating ======================================
  1296. -- remove_column(:hosts, :environment)
  1297. -> 0.0012s
  1298. == RemoveEnvironmentFromHost: migrated (0.0013s) =============================
  1299.  
  1300. == AddPublicToKeyPairs: migrating ============================================
  1301. -- add_column(:key_pairs, :public, :text)
  1302. -> 0.0012s
  1303. == AddPublicToKeyPairs: migrated (0.0014s) ===================================
  1304.  
  1305. == ChangeComputeResourcePasswordToText: migrating ============================
  1306. -- change_column(:compute_resources, :password, :text)
  1307. -> 0.0069s
  1308. -- You need to run rake security:generate_encryption_key to generate an ENCRYPTION_KEY.
  1309. -- Then, you may run rake db:compute_resources:encrypt to encrypt the passwords for Compute Resources.
  1310. -- Conversely, you may run rake db:compute_resources:decrypt to decrypt the passwords for Compute Resources.
  1311. == ChangeComputeResourcePasswordToText: migrated (0.0071s) ===================
  1312.  
  1313. == AddLdapFilterToAuthSources: migrating =====================================
  1314. -- add_column(:auth_sources, :ldap_filter, :string, {:limit=>255, :null=>true})
  1315. -> 0.0009s
  1316. == AddLdapFilterToAuthSources: migrated (0.0011s) ============================
  1317.  
  1318. == DeleteOrphanedRecords: migrating ==========================================
  1319. -- execute("DELETE FROM architectures_operatingsystems WHERE architecture_id NOT IN (SELECT id FROM architectures) OR operatingsystem_id NOT IN (SELECT id FROM operatingsystems)")
  1320. -> 0.0008s
  1321. -- 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)")
  1322. -> 0.0005s
  1323. -- 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)")
  1324. -> 0.0007s
  1325. -- 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)")
  1326. -> 0.0003s
  1327. -- execute("DELETE FROM media_operatingsystems WHERE medium_id NOT IN (SELECT id FROM media) OR operatingsystem_id NOT IN (SELECT id FROM operatingsystems)")
  1328. -> 0.0007s
  1329. -- execute("DELETE FROM operatingsystems_ptables WHERE ptable_id NOT IN (SELECT id FROM ptables) OR operatingsystem_id NOT IN (SELECT id FROM operatingsystems)")
  1330. -> 0.0006s
  1331. -- execute("DELETE FROM operatingsystems_puppetclasses WHERE puppetclass_id NOT IN (SELECT id FROM puppetclasses) OR operatingsystem_id NOT IN (SELECT id FROM operatingsystems)")
  1332. -> 0.0006s
  1333. -- execute("DELETE FROM subnet_domains WHERE domain_id NOT IN (SELECT id FROM domains) OR subnet_id NOT IN (SELECT id FROM subnets)")
  1334. -> 0.0008s
  1335. -- 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)")
  1336. -> 0.0008s
  1337. -- execute("DELETE FROM user_domains WHERE domain_id NOT IN (SELECT id FROM domains) OR user_id NOT IN (SELECT id FROM users)")
  1338. -> 0.0005s
  1339. -- 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)")
  1340. -> 0.0007s
  1341. -- execute("DELETE FROM user_hostgroups WHERE hostgroup_id NOT IN (SELECT id FROM hostgroups) OR user_id NOT IN (SELECT id FROM users)")
  1342. -> 0.0008s
  1343. -- execute("DELETE FROM user_roles WHERE role_id NOT IN (SELECT id FROM roles) OR user_id NOT IN (SELECT id FROM users)")
  1344. -> 0.0006s
  1345. -- 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)")
  1346. -> 0.0006s
  1347. == DeleteOrphanedRecords: migrated (0.9994s) =================================
  1348.  
  1349. == AddKeys: migrating ========================================================
  1350. -- execute("SET CONSTRAINTS ALL DEFERRED;")
  1351. -> 0.0002s
  1352. -- add_foreign_key("architectures_operatingsystems", "architectures", {:name=>"architectures_operatingsystems_architecture_id_fk"})
  1353. -> 0.0020s
  1354. -- add_foreign_key("architectures_operatingsystems", "operatingsystems", {:name=>"architectures_operatingsystems_operatingsystem_id_fk"})
  1355. -> 0.0012s
  1356. -- add_foreign_key("audits", "users", {:name=>"audits_user_id_fk"})
  1357. -> 0.0014s
  1358. -- add_foreign_key("config_templates_operatingsystems", "config_templates", {:name=>"config_templates_operatingsystems_config_template_id_fk"})
  1359. -> 0.0012s
  1360. -- add_foreign_key("config_templates_operatingsystems", "operatingsystems", {:name=>"config_templates_operatingsystems_operatingsystem_id_fk"})
  1361. -> 0.0011s
  1362. -- add_foreign_key("config_templates", "template_kinds", {:name=>"config_templates_template_kind_id_fk"})
  1363. -> 0.0012s
  1364. -- add_foreign_key("domains", "smart_proxies", {:name=>"domains_dns_id_fk", :column=>"dns_id"})
  1365. -> 0.0009s
  1366. -- add_foreign_key("environment_classes", "environments", {:name=>"environment_classes_environment_id_fk"})
  1367. -> 0.0012s
  1368. -- add_foreign_key("environment_classes", "lookup_keys", {:name=>"environment_classes_lookup_key_id_fk"})
  1369. -> 0.0013s
  1370. -- add_foreign_key("environment_classes", "puppetclasses", {:name=>"environment_classes_puppetclass_id_fk"})
  1371. -> 0.0012s
  1372. -- add_foreign_key("fact_values", "fact_names", {:name=>"fact_values_fact_name_id_fk"})
  1373. -> 0.0011s
  1374. -- add_foreign_key("fact_values", "hosts", {:name=>"fact_values_host_id_fk"})
  1375. -> 0.0013s
  1376. -- add_foreign_key("features_smart_proxies", "features", {:name=>"features_smart_proxies_feature_id_fk"})
  1377. -> 0.0011s
  1378. -- add_foreign_key("features_smart_proxies", "smart_proxies", {:name=>"features_smart_proxies_smart_proxy_id_fk"})
  1379. -> 0.0011s
  1380. -- add_foreign_key("host_classes", "hosts", {:name=>"host_classes_host_id_fk"})
  1381. -> 0.0015s
  1382. -- add_foreign_key("host_classes", "puppetclasses", {:name=>"host_classes_puppetclass_id_fk"})
  1383. -> 0.0013s
  1384. -- add_foreign_key("hostgroup_classes", "hostgroups", {:name=>"hostgroup_classes_hostgroup_id_fk"})
  1385. -> 0.0012s
  1386. -- add_foreign_key("hostgroup_classes", "puppetclasses", {:name=>"hostgroup_classes_puppetclass_id_fk"})
  1387. -> 0.0011s
  1388. -- add_foreign_key("hostgroups", "architectures", {:name=>"hostgroups_architecture_id_fk"})
  1389. -> 0.0012s
  1390. -- add_foreign_key("hostgroups", "domains", {:name=>"hostgroups_domain_id_fk"})
  1391. -> 0.0013s
  1392. -- add_foreign_key("hostgroups", "environments", {:name=>"hostgroups_environment_id_fk"})
  1393. -> 0.0012s
  1394. -- add_foreign_key("hostgroups", "media", {:name=>"hostgroups_medium_id_fk"})
  1395. -> 0.0013s
  1396. -- add_foreign_key("hostgroups", "operatingsystems", {:name=>"hostgroups_operatingsystem_id_fk"})
  1397. -> 0.0015s
  1398. -- add_foreign_key("hostgroups", "ptables", {:name=>"hostgroups_ptable_id_fk"})
  1399. -> 0.0013s
  1400. -- add_foreign_key("hostgroups", "smart_proxies", {:name=>"hostgroups_puppet_ca_proxy_id_fk", :column=>"puppet_ca_proxy_id"})
  1401. -> 0.0012s
  1402. -- add_foreign_key("hostgroups", "smart_proxies", {:name=>"hostgroups_puppet_proxy_id_fk", :column=>"puppet_proxy_id"})
  1403. -> 0.0011s
  1404. -- add_foreign_key("hostgroups", "subnets", {:name=>"hostgroups_subnet_id_fk"})
  1405. -> 0.0013s
  1406. -- add_foreign_key("hosts", "architectures", {:name=>"hosts_architecture_id_fk"})
  1407. -> 0.0016s
  1408. -- add_foreign_key("hosts", "compute_resources", {:name=>"hosts_compute_resource_id_fk"})
  1409. -> 0.0013s
  1410. -- add_foreign_key("hosts", "domains", {:name=>"hosts_domain_id_fk"})
  1411. -> 0.0014s
  1412. -- add_foreign_key("hosts", "environments", {:name=>"hosts_environment_id_fk"})
  1413. -> 0.0014s
  1414. -- add_foreign_key("hosts", "hostgroups", {:name=>"hosts_hostgroup_id_fk"})
  1415. -> 0.0014s
  1416. -- add_foreign_key("hosts", "images", {:name=>"hosts_image_id_fk"})
  1417. -> 0.0014s
  1418. -- add_foreign_key("hosts", "media", {:name=>"hosts_medium_id_fk"})
  1419. -> 0.0014s
  1420. -- add_foreign_key("hosts", "models", {:name=>"hosts_model_id_fk"})
  1421. -> 0.0015s
  1422. -- add_foreign_key("hosts", "operatingsystems", {:name=>"hosts_operatingsystem_id_fk"})
  1423. -> 0.0013s
  1424. -- add_foreign_key("hosts", "ptables", {:name=>"hosts_ptable_id_fk"})
  1425. -> 0.0014s
  1426. -- add_foreign_key("hosts", "smart_proxies", {:name=>"hosts_puppet_ca_proxy_id_fk", :column=>"puppet_ca_proxy_id"})
  1427. -> 0.0013s
  1428. -- add_foreign_key("hosts", "smart_proxies", {:name=>"hosts_puppet_proxy_id_fk", :column=>"puppet_proxy_id"})
  1429. -> 0.0011s
  1430. -- add_foreign_key("hosts", "subnets", {:name=>"hosts_subnet_id_fk"})
  1431. -> 0.0014s
  1432. -- add_foreign_key("hosts", "taxonomies", {:name=>"hosts_location_id_fk", :column=>"location_id"})
  1433. -> 0.0013s
  1434. -- add_foreign_key("hosts", "taxonomies", {:name=>"hosts_organization_id_fk", :column=>"organization_id"})
  1435. -> 0.0014s
  1436. -- add_foreign_key("images", "architectures", {:name=>"images_architecture_id_fk"})
  1437. -> 0.0016s
  1438. -- add_foreign_key("images", "compute_resources", {:name=>"images_compute_resource_id_fk"})
  1439. -> 0.0012s
  1440. -- add_foreign_key("images", "operatingsystems", {:name=>"images_operatingsystem_id_fk"})
  1441. -> 0.0014s
  1442. -- add_foreign_key("key_pairs", "compute_resources", {:name=>"key_pairs_compute_resource_id_fk"})
  1443. -> 0.0014s
  1444. -- add_foreign_key("lookup_keys", "puppetclasses", {:name=>"lookup_keys_puppetclass_id_fk"})
  1445. -> 0.0013s
  1446. -- add_foreign_key("lookup_values", "lookup_keys", {:name=>"lookup_values_lookup_key_id_fk"})
  1447. -> 0.0012s
  1448. -- add_foreign_key("media_operatingsystems", "media", {:name=>"media_operatingsystems_medium_id_fk"})
  1449. -> 0.0012s
  1450. -- add_foreign_key("media_operatingsystems", "operatingsystems", {:name=>"media_operatingsystems_operatingsystem_id_fk"})
  1451. -> 0.0012s
  1452. -- add_foreign_key("nics", "domains", {:name=>"nics_domain_id_fk"})
  1453. -> 0.0013s
  1454. -- add_foreign_key("nics", "hosts", {:name=>"nics_host_id_fk"})
  1455. -> 0.0016s
  1456. -- add_foreign_key("nics", "subnets", {:name=>"nics_subnet_id_fk"})
  1457. -> 0.0013s
  1458. -- add_foreign_key("operatingsystems_ptables", "operatingsystems", {:name=>"operatingsystems_ptables_operatingsystem_id_fk"})
  1459. -> 0.0012s
  1460. -- add_foreign_key("operatingsystems_ptables", "ptables", {:name=>"operatingsystems_ptables_ptable_id_fk"})
  1461. -> 0.0012s
  1462. -- add_foreign_key("operatingsystems_puppetclasses", "operatingsystems", {:name=>"operatingsystems_puppetclasses_operatingsystem_id_fk"})
  1463. -> 0.0012s
  1464. -- add_foreign_key("operatingsystems_puppetclasses", "puppetclasses", {:name=>"operatingsystems_puppetclasses_puppetclass_id_fk"})
  1465. -> 0.0013s
  1466. -- add_foreign_key("os_default_templates", "config_templates", {:name=>"os_default_templates_config_template_id_fk"})
  1467. -> 0.0013s
  1468. -- add_foreign_key("os_default_templates", "operatingsystems", {:name=>"os_default_templates_operatingsystem_id_fk"})
  1469. -> 0.1178s
  1470. -- add_foreign_key("os_default_templates", "template_kinds", {:name=>"os_default_templates_template_kind_id_fk"})
  1471. -> 0.0016s
  1472. -- add_foreign_key("reports", "hosts", {:name=>"reports_host_id_fk"})
  1473. -> 0.0017s
  1474. -- add_foreign_key("subnet_domains", "domains", {:name=>"subnet_domains_domain_id_fk"})
  1475. -> 0.0015s
  1476. -- add_foreign_key("subnet_domains", "subnets", {:name=>"subnet_domains_subnet_id_fk"})
  1477. -> 0.0015s
  1478. -- add_foreign_key("subnets", "smart_proxies", {:name=>"subnets_dhcp_id_fk", :column=>"dhcp_id"})
  1479. -> 0.0013s
  1480. -- add_foreign_key("subnets", "smart_proxies", {:name=>"subnets_dns_id_fk", :column=>"dns_id"})
  1481. -> 0.0014s
  1482. -- add_foreign_key("subnets", "smart_proxies", {:name=>"subnets_tftp_id_fk", :column=>"tftp_id"})
  1483. -> 0.0011s
  1484. -- add_foreign_key("taxable_taxonomies", "taxonomies", {:name=>"taxable_taxonomies_taxonomy_id_fk"})
  1485. -> 0.0015s
  1486. -- add_foreign_key("template_combinations", "config_templates", {:name=>"template_combinations_config_template_id_fk"})
  1487. -> 0.0013s
  1488. -- add_foreign_key("template_combinations", "environments", {:name=>"template_combinations_environment_id_fk"})
  1489. -> 0.0013s
  1490. -- add_foreign_key("template_combinations", "hostgroups", {:name=>"template_combinations_hostgroup_id_fk"})
  1491. -> 0.0013s
  1492. -- add_foreign_key("tokens", "hosts", {:name=>"tokens_host_id_fk"})
  1493. -> 0.0015s
  1494. -- add_foreign_key("trend_counters", "trends", {:name=>"trend_counters_trend_id_fk"})
  1495. -> 0.0013s
  1496. -- add_foreign_key("user_compute_resources", "compute_resources", {:name=>"user_compute_resources_compute_resource_id_fk"})
  1497. -> 0.0012s
  1498. -- add_foreign_key("user_compute_resources", "users", {:name=>"user_compute_resources_user_id_fk"})
  1499. -> 0.0013s
  1500. -- add_foreign_key("user_domains", "domains", {:name=>"user_domains_domain_id_fk"})
  1501. -> 0.0013s
  1502. -- add_foreign_key("user_domains", "users", {:name=>"user_domains_user_id_fk"})
  1503. -> 0.0012s
  1504. -- add_foreign_key("user_facts", "fact_names", {:name=>"user_facts_fact_name_id_fk"})
  1505. -> 0.0013s
  1506. -- add_foreign_key("user_facts", "users", {:name=>"user_facts_user_id_fk"})
  1507. -> 0.0013s
  1508. -- add_foreign_key("user_hostgroups", "hostgroups", {:name=>"user_hostgroups_hostgroup_id_fk"})
  1509. -> 0.0012s
  1510. -- add_foreign_key("user_hostgroups", "users", {:name=>"user_hostgroups_user_id_fk"})
  1511. -> 0.0014s
  1512. -- add_foreign_key("user_notices", "notices", {:name=>"user_notices_notice_id_fk"})
  1513. -> 0.0014s
  1514. -- add_foreign_key("user_notices", "users", {:name=>"user_notices_user_id_fk"})
  1515. -> 0.0013s
  1516. -- add_foreign_key("user_roles", "roles", {:name=>"user_roles_role_id_fk"})
  1517. -> 0.0012s
  1518. -- add_foreign_key("user_roles", "users", {:name=>"user_roles_user_id_fk"})
  1519. -> 0.0013s
  1520. -- add_foreign_key("usergroup_members", "usergroups", {:name=>"usergroup_members_usergroup_id_fk"})
  1521. -> 0.0015s
  1522. -- add_foreign_key("users", "auth_sources", {:name=>"users_auth_source_id_fk"})
  1523. -> 0.0019s
  1524. == AddKeys: migrated (0.2360s) ===============================================
  1525.  
  1526. == CreateHostBootdiskTemplate: migrating =====================================
  1527. == CreateHostBootdiskTemplate: migrated (0.0000s) ============================
  1528.  
  1529. == EditHostBootdiskTemplateMultinic: migrating ===============================
  1530. == EditHostBootdiskTemplateMultinic: migrated (0.0000s) ======================
  1531.  
  1532. == CreateKickstartBootdiskTemplate: migrating ================================
  1533. == CreateKickstartBootdiskTemplate: migrated (0.0000s) =======================
  1534.  
  1535. == CreateGenericHostBootdiskTemplate: migrating ==============================
  1536. == CreateGenericHostBootdiskTemplate: migrated (0.0000s) =====================
  1537.  
  1538. == RemoveUnusedRoleFields: migrating =========================================
  1539. -- remove_column(:users, :role_id)
  1540. -> 0.0006s
  1541. -- remove_column(:user_roles, :inherited_from)
  1542. -> 0.0004s
  1543. == RemoveUnusedRoleFields: migrated (0.0011s) ================================
  1544.  
  1545. == FixAuditableType2: migrating ==============================================
  1546. == FixAuditableType2: migrated (0.0021s) =====================================
  1547.  
  1548. == AddComposeFlagAndShortNameToFactName: migrating ===========================
  1549. -- add_column(:fact_names, :compose, :boolean, {:default=>false, :null=>false})
  1550. -> 0.0052s
  1551. -- add_column(:fact_names, :short_name, :string)
  1552. -> 0.0024s
  1553. == AddComposeFlagAndShortNameToFactName: migrated (0.0077s) ==================
  1554.  
  1555. == KatelloTables: migrating ==================================================
  1556. -- create_table("katello_activation_keys", {:force=>true})
  1557. NOTICE: CREATE TABLE will create implicit sequence "katello_activation_keys_id_seq" for serial column "katello_activation_keys.id"
  1558. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_activation_keys_pkey" for table "katello_activation_keys"
  1559. -> 0.0076s
  1560. -- add_index("katello_activation_keys", ["content_view_id"], {:name=>"index_activation_keys_on_content_view_id"})
  1561. -> 0.0031s
  1562. -- add_index("katello_activation_keys", ["environment_id"], {:name=>"index_activation_keys_on_environment_id"})
  1563. -> 0.0031s
  1564. -- add_index("katello_activation_keys", ["name", "organization_id"], {:name=>"index_activation_keys_on_name_and_organization_id", :unique=>true})
  1565. -> 0.0032s
  1566. -- add_index("katello_activation_keys", ["organization_id"], {:name=>"index_activation_keys_on_organization_id"})
  1567. -> 0.0042s
  1568. -- add_index("katello_activation_keys", ["user_id"], {:name=>"index_activation_keys_on_user_id"})
  1569. -> 0.0038s
  1570. -- create_table("katello_changeset_content_views", {:force=>true})
  1571. NOTICE: CREATE TABLE will create implicit sequence "katello_changeset_content_views_id_seq" for serial column "katello_changeset_content_views.id"
  1572. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_changeset_content_views_pkey" for table "katello_changeset_content_views"
  1573. -> 0.0037s
  1574. -- create_table("katello_changeset_users", {:force=>true})
  1575. NOTICE: CREATE TABLE will create implicit sequence "katello_changeset_users_id_seq" for serial column "katello_changeset_users.id"
  1576. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_changeset_users_pkey" for table "katello_changeset_users"
  1577. -> 0.0039s
  1578. -- add_index("katello_changeset_users", ["changeset_id"], {:name=>"index_changeset_users_on_changeset_id"})
  1579. -> 0.0028s
  1580. -- add_index("katello_changeset_users", ["user_id"], {:name=>"index_changeset_users_on_user_id"})
  1581. -> 0.0028s
  1582. -- create_table("katello_changesets", {:force=>true})
  1583. NOTICE: CREATE TABLE will create implicit sequence "katello_changesets_id_seq" for serial column "katello_changesets.id"
  1584. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_changesets_pkey" for table "katello_changesets"
  1585. -> 0.0062s
  1586. -- add_index("katello_changesets", ["environment_id"], {:name=>"index_changesets_on_environment_id"})
  1587. -> 0.0028s
  1588. -- add_index("katello_changesets", ["name", "environment_id"], {:name=>"index_changesets_on_name_and_environment_id", :unique=>true})
  1589. -> 0.0028s
  1590. -- add_index("katello_changesets", ["task_status_id"], {:name=>"index_changesets_on_task_status_id"})
  1591. -> 0.0031s
  1592. -- create_table("katello_component_content_views", {:force=>true})
  1593. NOTICE: CREATE TABLE will create implicit sequence "katello_component_content_views_id_seq" for serial column "katello_component_content_views.id"
  1594. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_component_content_views_pkey" for table "katello_component_content_views"
  1595. -> 0.0037s
  1596. -- add_index("katello_component_content_views", ["content_view_definition_id", "content_view_id"], {:name=>"component_content_views_index"})
  1597. -> 0.0026s
  1598. -- create_table("katello_content_view_definition_bases", {:force=>true})
  1599. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_definition_bases_id_seq" for serial column "katello_content_view_definition_bases.id"
  1600. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_definition_bases_pkey" for table "katello_content_view_definition_bases"
  1601. -> 0.0057s
  1602. -- add_index("katello_content_view_definition_bases", ["name", "organization_id"], {:name=>"index_content_view_definitions_on_name_and_organization_id"})
  1603. -> 0.0026s
  1604. -- create_table("katello_content_view_definition_products", {:force=>true})
  1605. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_definition_products_id_seq" for serial column "katello_content_view_definition_products.id"
  1606. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_definition_products_pkey" for table "katello_content_view_definition_products"
  1607. -> 0.0036s
  1608. -- add_index("katello_content_view_definition_products", ["content_view_definition_id", "product_id"], {:name=>"content_view_def_product_index"})
  1609. -> 0.0026s
  1610. -- create_table("katello_content_view_definition_repositories", {:force=>true})
  1611. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_definition_repositories_id_seq" for serial column "katello_content_view_definition_repositories.id"
  1612. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_definition_repositories_pkey" for table "katello_content_view_definition_repositories"
  1613. -> 0.0037s
  1614. -- add_index("katello_content_view_definition_repositories", ["content_view_definition_id", "repository_id"], {:name=>"cvd_repo_index"})
  1615. -> 0.0029s
  1616. -- create_table("katello_content_view_environments", {:force=>true})
  1617. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_environments_id_seq" for serial column "katello_content_view_environments.id"
  1618. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_environments_pkey" for table "katello_content_view_environments"
  1619. -> 0.0058s
  1620. -- add_index("katello_content_view_environments", ["content_view_id"], {:name=>"index_content_view_environments_on_content_view_id"})
  1621. -> 0.0026s
  1622. -- add_index("katello_content_view_environments", ["cp_id"], {:name=>"index_cve_cp_id", :unique=>true})
  1623. -> 0.0027s
  1624. -- add_index("katello_content_view_environments", ["environment_id", "content_view_id"], {:name=>"index_cve_eid_cv_id", :unique=>true})
  1625. -> 0.0031s
  1626. -- add_index("katello_content_view_environments", ["environment_id"], {:name=>"index_content_view_environments_on_environment_id"})
  1627. -> 0.0033s
  1628. -- create_table("katello_content_view_version_environments", {:force=>true})
  1629. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_version_environments_id_seq" for serial column "katello_content_view_version_environments.id"
  1630. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_version_environments_pkey" for table "katello_content_view_version_environments"
  1631. -> 0.0038s
  1632. -- add_index("katello_content_view_version_environments", ["content_view_version_id", "environment_id"], {:name=>"cvv_env_index", :unique=>true})
  1633. -> 0.0031s
  1634. -- create_table("katello_content_view_versions", {:force=>true})
  1635. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_versions_id_seq" for serial column "katello_content_view_versions.id"
  1636. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_versions_pkey" for table "katello_content_view_versions"
  1637. -> 0.0047s
  1638. -- add_index("katello_content_view_versions", ["id", "content_view_id"], {:name=>"cvv_cv_index"})
  1639. -> 0.0035s
  1640. -- create_table("katello_content_views", {:force=>true})
  1641. NOTICE: CREATE TABLE will create implicit sequence "katello_content_views_id_seq" for serial column "katello_content_views.id"
  1642. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_views_pkey" for table "katello_content_views"
  1643. -> 0.0062s
  1644. -- add_index("katello_content_views", ["content_view_definition_id"], {:name=>"index_content_views_on_content_view_definition_id"})
  1645. -> 0.0027s
  1646. -- add_index("katello_content_views", ["name", "organization_id"], {:name=>"index_content_views_on_name_and_organization_id"})
  1647. -> 0.0136s
  1648. -- add_index("katello_content_views", ["organization_id", "label"], {:name=>"index_content_views_on_organization_id_and_label", :unique=>true})
  1649. -> 0.0033s
  1650. -- add_index("katello_content_views", ["organization_id"], {:name=>"index_content_views_on_organization_id"})
  1651. -> 0.0033s
  1652. -- create_table("katello_custom_info", {:force=>true})
  1653. NOTICE: CREATE TABLE will create implicit sequence "katello_custom_info_id_seq" for serial column "katello_custom_info.id"
  1654. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_custom_info_pkey" for table "katello_custom_info"
  1655. -> 0.0059s
  1656. -- add_index("katello_custom_info", ["informable_type", "informable_id", "keyname"], {:name=>"index_custom_info_on_type_id_keyname"})
  1657. -> 0.0030s
  1658. -- create_table("delayed_jobs", {:force=>true})
  1659. NOTICE: CREATE TABLE will create implicit sequence "delayed_jobs_id_seq" for serial column "delayed_jobs.id"
  1660. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "delayed_jobs_pkey" for table "delayed_jobs"
  1661. -> 0.0058s
  1662. -- add_index("delayed_jobs", ["priority", "run_at"], {:name=>"delayed_jobs_priority"})
  1663. -> 0.0027s
  1664. -- create_table("katello_distributors", {:force=>true})
  1665. NOTICE: CREATE TABLE will create implicit sequence "katello_distributors_id_seq" for serial column "katello_distributors.id"
  1666. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_distributors_pkey" for table "katello_distributors"
  1667. -> 0.0059s
  1668. -- add_index("katello_distributors", ["content_view_id"], {:name=>"index_distributors_on_content_view_id"})
  1669. -> 0.0029s
  1670. -- add_index("katello_distributors", ["environment_id"], {:name=>"index_distributors_on_environment_id"})
  1671. -> 0.0030s
  1672. -- create_table("katello_environment_priors", {:id=>false, :force=>true})
  1673. -> 0.0010s
  1674. -- add_index("katello_environment_priors", ["environment_id"], {:name=>"index_environment_priors_on_environment_id"})
  1675. -> 0.0026s
  1676. -- add_index("katello_environment_priors", ["prior_id"], {:name=>"index_environment_priors_on_prior_id"})
  1677. -> 0.0028s
  1678. -- create_table("katello_environments", {:force=>true})
  1679. NOTICE: CREATE TABLE will create implicit sequence "katello_environments_id_seq" for serial column "katello_environments.id"
  1680. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_environments_pkey" for table "katello_environments"
  1681. -> 0.0061s
  1682. -- add_index("katello_environments", ["label", "organization_id"], {:name=>"index_environments_on_label_and_organization_id", :unique=>true})
  1683. -> 0.0040s
  1684. -- add_index("katello_environments", ["name", "organization_id"], {:name=>"index_environments_on_name_and_organization_id", :unique=>true})
  1685. -> 0.0030s
  1686. -- add_index("katello_environments", ["organization_id"], {:name=>"index_environments_on_organization_id"})
  1687. -> 0.0031s
  1688. -- create_table("katello_filter_rules", {:force=>true})
  1689. NOTICE: CREATE TABLE will create implicit sequence "katello_filter_rules_id_seq" for serial column "katello_filter_rules.id"
  1690. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_filter_rules_pkey" for table "katello_filter_rules"
  1691. -> 0.0058s
  1692. -- add_index("katello_filter_rules", ["filter_id"], {:name=>"index_filter_rules_on_filter_id"})
  1693. -> 0.0031s
  1694. -- create_table("katello_filters", {:force=>true})
  1695. NOTICE: CREATE TABLE will create implicit sequence "katello_filters_id_seq" for serial column "katello_filters.id"
  1696. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_filters_pkey" for table "katello_filters"
  1697. -> 0.0036s
  1698. -- add_index("katello_filters", ["content_view_definition_id"], {:name=>"index_filters_on_content_view_definition_id"})
  1699. -> 0.0026s
  1700. -- add_index("katello_filters", ["name", "content_view_definition_id"], {:name=>"index_filters_on_name_and_content_view_definition_id", :unique=>true})
  1701. -> 0.0029s
  1702. -- create_table("katello_filters_products", {:id=>false, :force=>true})
  1703. -> 0.0010s
  1704. -- add_index("katello_filters_products", ["filter_id", "product_id"], {:name=>"index_filters_products_on_filter_id_and_product_id", :unique=>true})
  1705. -> 0.0026s
  1706. -- add_index("katello_filters_products", ["filter_id"], {:name=>"index_filters_products_on_filter_id"})
  1707. -> 0.0030s
  1708. -- add_index("katello_filters_products", ["product_id"], {:name=>"index_filters_products_on_product_id"})
  1709. -> 0.0030s
  1710. -- create_table("katello_filters_repositories", {:id=>false, :force=>true})
  1711. -> 0.0009s
  1712. -- add_index("katello_filters_repositories", ["filter_id", "repository_id"], {:name=>"index_filters_repositories_on_filter_id_and_repository_id", :unique=>true})
  1713. -> 0.0027s
  1714. -- add_index("katello_filters_repositories", ["filter_id"], {:name=>"index_filters_repositories_on_filter_id"})
  1715. -> 0.0028s
  1716. -- add_index("katello_filters_repositories", ["repository_id"], {:name=>"index_filters_repositories_on_repository_id"})
  1717. -> 0.0029s
  1718. -- create_table("katello_gpg_keys", {:force=>true})
  1719. NOTICE: CREATE TABLE will create implicit sequence "katello_gpg_keys_id_seq" for serial column "katello_gpg_keys.id"
  1720. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_gpg_keys_pkey" for table "katello_gpg_keys"
  1721. -> 0.0061s
  1722. -- add_index("katello_gpg_keys", ["organization_id", "name"], {:name=>"index_gpg_keys_on_organization_id_and_name", :unique=>true})
  1723. -> 0.0034s
  1724. -- create_table("katello_help_tips", {:force=>true})
  1725. NOTICE: CREATE TABLE will create implicit sequence "katello_help_tips_id_seq" for serial column "katello_help_tips.id"
  1726. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_help_tips_pkey" for table "katello_help_tips"
  1727. -> 0.0044s
  1728. -- add_index("katello_help_tips", ["user_id"], {:name=>"index_help_tips_on_user_id"})
  1729. -> 0.0032s
  1730. -- create_table("katello_job_tasks", {:force=>true})
  1731. NOTICE: CREATE TABLE will create implicit sequence "katello_job_tasks_id_seq" for serial column "katello_job_tasks.id"
  1732. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_job_tasks_pkey" for table "katello_job_tasks"
  1733. -> 0.0045s
  1734. -- add_index("katello_job_tasks", ["job_id"], {:name=>"index_job_tasks_on_job_id"})
  1735. -> 0.0026s
  1736. -- add_index("katello_job_tasks", ["task_status_id"], {:name=>"index_job_tasks_on_task_status_id"})
  1737. -> 0.0029s
  1738. -- create_table("katello_jobs", {:force=>true})
  1739. NOTICE: CREATE TABLE will create implicit sequence "katello_jobs_id_seq" for serial column "katello_jobs.id"
  1740. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_jobs_pkey" for table "katello_jobs"
  1741. -> 0.0058s
  1742. -- add_index("katello_jobs", ["job_owner_id"], {:name=>"index_jobs_on_job_owner_id"})
  1743. -> 0.0026s
  1744. -- add_index("katello_jobs", ["pulp_id"], {:name=>"index_jobs_on_pulp_id"})
  1745. -> 0.0028s
  1746. -- create_table("katello_key_pools", {:force=>true})
  1747. NOTICE: CREATE TABLE will create implicit sequence "katello_key_pools_id_seq" for serial column "katello_key_pools.id"
  1748. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_key_pools_pkey" for table "katello_key_pools"
  1749. -> 0.0037s
  1750. -- add_index("katello_key_pools", ["activation_key_id"], {:name=>"index_key_pools_on_activation_key_id"})
  1751. -> 0.0025s
  1752. -- add_index("katello_key_pools", ["pool_id"], {:name=>"index_key_pools_on_pool_id"})
  1753. -> 0.0028s
  1754. -- create_table("katello_key_system_groups", {:force=>true})
  1755. NOTICE: CREATE TABLE will create implicit sequence "katello_key_system_groups_id_seq" for serial column "katello_key_system_groups.id"
  1756. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_key_system_groups_pkey" for table "katello_key_system_groups"
  1757. -> 0.0037s
  1758. -- add_index("katello_key_system_groups", ["activation_key_id"], {:name=>"index_key_system_groups_on_activation_key_id"})
  1759. -> 0.0025s
  1760. -- add_index("katello_key_system_groups", ["system_group_id"], {:name=>"index_key_system_groups_on_system_group_id"})
  1761. -> 0.0027s
  1762. -- create_table("katello_marketing_engineering_products", {:force=>true})
  1763. NOTICE: CREATE TABLE will create implicit sequence "katello_marketing_engineering_products_id_seq" for serial column "katello_marketing_engineering_products.id"
  1764. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_marketing_engineering_products_pkey" for table "katello_marketing_engineering_products"
  1765. -> 0.0037s
  1766. -- add_index("katello_marketing_engineering_products", ["engineering_product_id"], {:name=>"index_marketing_engineering_products_on_engineering_product_id"})
  1767. -> 0.0027s
  1768. -- add_index("katello_marketing_engineering_products", ["marketing_product_id"], {:name=>"index_marketing_engineering_products_on_marketing_product_id"})
  1769. -> 0.0030s
  1770. -- create_table("katello_notices", {:force=>true})
  1771. NOTICE: CREATE TABLE will create implicit sequence "katello_notices_id_seq" for serial column "katello_notices.id"
  1772. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_notices_pkey" for table "katello_notices"
  1773. -> 0.0206s
  1774. -- add_index("katello_notices", ["organization_id"], {:name=>"index_notices_on_organization_id"})
  1775. -> 0.0029s
  1776. -- create_table("katello_pools", {:force=>true})
  1777. NOTICE: CREATE TABLE will create implicit sequence "katello_pools_id_seq" for serial column "katello_pools.id"
  1778. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_pools_pkey" for table "katello_pools"
  1779. -> 0.0039s
  1780. -- add_index("katello_pools", ["cp_id"], {:name=>"index_pools_on_cp_id"})
  1781. -> 0.0027s
  1782. -- create_table("katello_products", {:force=>true})
  1783. NOTICE: CREATE TABLE will create implicit sequence "katello_products_id_seq" for serial column "katello_products.id"
  1784. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_products_pkey" for table "katello_products"
  1785. -> 0.0062s
  1786. -- add_index("katello_products", ["cp_id"], {:name=>"index_products_on_cp_id"})
  1787. -> 0.0029s
  1788. -- add_index("katello_products", ["gpg_key_id"], {:name=>"index_products_on_gpg_key_id"})
  1789. -> 0.0028s
  1790. -- add_index("katello_products", ["provider_id"], {:name=>"index_products_on_provider_id"})
  1791. -> 0.0033s
  1792. -- add_index("katello_products", ["sync_plan_id"], {:name=>"index_products_on_sync_plan_id"})
  1793. -> 0.0033s
  1794. -- create_table("katello_providers", {:force=>true})
  1795. NOTICE: CREATE TABLE will create implicit sequence "katello_providers_id_seq" for serial column "katello_providers.id"
  1796. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_providers_pkey" for table "katello_providers"
  1797. -> 0.0062s
  1798. -- add_index("katello_providers", ["name", "organization_id"], {:name=>"index_providers_on_name_and_organization_id", :unique=>true})
  1799. -> 0.0028s
  1800. -- add_index("katello_providers", ["organization_id"], {:name=>"index_providers_on_organization_id"})
  1801. -> 0.0027s
  1802. -- add_index("katello_providers", ["task_status_id"], {:name=>"index_providers_on_task_status_id"})
  1803. -> 0.0031s
  1804. -- create_table("katello_repositories", {:force=>true})
  1805. NOTICE: CREATE TABLE will create implicit sequence "katello_repositories_id_seq" for serial column "katello_repositories.id"
  1806. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_repositories_pkey" for table "katello_repositories"
  1807. -> 0.0070s
  1808. -- add_index("katello_repositories", ["content_view_version_id"], {:name=>"index_repositories_on_content_view_version_id"})
  1809. -> 0.0027s
  1810. -- add_index("katello_repositories", ["cp_label"], {:name=>"index_repositories_on_cp_label"})
  1811. -> 0.0028s
  1812. -- add_index("katello_repositories", ["environment_id"], {:name=>"index_repositories_on_environment_id"})
  1813. -> 0.0030s
  1814. -- add_index("katello_repositories", ["gpg_key_id"], {:name=>"index_repositories_on_gpg_key_id"})
  1815. -> 0.0032s
  1816. -- add_index("katello_repositories", ["library_instance_id"], {:name=>"index_repositories_on_library_instance_id"})
  1817. -> 0.0036s
  1818. -- add_index("katello_repositories", ["product_id"], {:name=>"index_repositories_on_product_id"})
  1819. -> 0.0129s
  1820. -- add_index("katello_repositories", ["pulp_id"], {:name=>"index_repositories_on_pulp_id"})
  1821. -> 0.0078s
  1822. -- create_table("katello_search_favorites", {:force=>true})
  1823. NOTICE: CREATE TABLE will create implicit sequence "katello_search_favorites_id_seq" for serial column "katello_search_favorites.id"
  1824. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_search_favorites_pkey" for table "katello_search_favorites"
  1825. -> 0.0059s
  1826. -- add_index("katello_search_favorites", ["user_id"], {:name=>"index_search_favorites_on_user_id"})
  1827. -> 0.0026s
  1828. -- create_table("katello_search_histories", {:force=>true})
  1829. NOTICE: CREATE TABLE will create implicit sequence "katello_search_histories_id_seq" for serial column "katello_search_histories.id"
  1830. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_search_histories_pkey" for table "katello_search_histories"
  1831. -> 0.0057s
  1832. -- add_index("katello_search_histories", ["user_id"], {:name=>"index_search_histories_on_user_id"})
  1833. -> 0.0025s
  1834. -- create_table("katello_sync_plans", {:force=>true})
  1835. NOTICE: CREATE TABLE will create implicit sequence "katello_sync_plans_id_seq" for serial column "katello_sync_plans.id"
  1836. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_sync_plans_pkey" for table "katello_sync_plans"
  1837. -> 0.0057s
  1838. -- add_index("katello_sync_plans", ["name", "organization_id"], {:name=>"index_sync_plans_on_name_and_organization_id", :unique=>true})
  1839. -> 0.0025s
  1840. -- add_index("katello_sync_plans", ["organization_id"], {:name=>"index_sync_plans_on_organization_id"})
  1841. -> 0.0027s
  1842. -- create_table("katello_system_activation_keys", {:force=>true})
  1843. NOTICE: CREATE TABLE will create implicit sequence "katello_system_activation_keys_id_seq" for serial column "katello_system_activation_keys.id"
  1844. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_activation_keys_pkey" for table "katello_system_activation_keys"
  1845. -> 0.0038s
  1846. -- add_index("katello_system_activation_keys", ["activation_key_id"], {:name=>"index_system_activation_keys_on_activation_key_id"})
  1847. -> 0.0024s
  1848. -- add_index("katello_system_activation_keys", ["system_id"], {:name=>"index_system_activation_keys_on_system_id"})
  1849. -> 0.0027s
  1850. -- create_table("katello_system_groups", {:force=>true})
  1851. NOTICE: CREATE TABLE will create implicit sequence "katello_system_groups_id_seq" for serial column "katello_system_groups.id"
  1852. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_groups_pkey" for table "katello_system_groups"
  1853. -> 0.0060s
  1854. -- add_index("katello_system_groups", ["name", "organization_id"], {:name=>"index_system_groups_on_name_and_organization_id", :unique=>true})
  1855. -> 0.0029s
  1856. -- add_index("katello_system_groups", ["organization_id"], {:name=>"index_system_groups_on_organization_id"})
  1857. -> 0.0030s
  1858. -- create_table("katello_system_system_groups", {:force=>true})
  1859. NOTICE: CREATE TABLE will create implicit sequence "katello_system_system_groups_id_seq" for serial column "katello_system_system_groups.id"
  1860. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_system_groups_pkey" for table "katello_system_system_groups"
  1861. -> 0.0078s
  1862. -- add_index("katello_system_system_groups", ["system_group_id"], {:name=>"index_system_system_groups_on_system_group_id"})
  1863. -> 0.0028s
  1864. -- add_index("katello_system_system_groups", ["system_id"], {:name=>"index_system_system_groups_on_system_id"})
  1865. -> 0.0028s
  1866. -- create_table("katello_systems", {:force=>true})
  1867. NOTICE: CREATE TABLE will create implicit sequence "katello_systems_id_seq" for serial column "katello_systems.id"
  1868. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_systems_pkey" for table "katello_systems"
  1869. -> 0.0060s
  1870. -- add_index("katello_systems", ["content_view_id"], {:name=>"index_systems_on_content_view_id"})
  1871. -> 0.0027s
  1872. -- add_index("katello_systems", ["environment_id"], {:name=>"index_systems_on_environment_id"})
  1873. -> 0.0028s
  1874. -- create_table("katello_task_statuses", {:force=>true})
  1875. NOTICE: CREATE TABLE will create implicit sequence "katello_task_statuses_id_seq" for serial column "katello_task_statuses.id"
  1876. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_task_statuses_pkey" for table "katello_task_statuses"
  1877. -> 0.0061s
  1878. -- add_index("katello_task_statuses", ["organization_id"], {:name=>"index_task_statuses_on_organization_id"})
  1879. -> 0.0029s
  1880. -- add_index("katello_task_statuses", ["task_owner_id"], {:name=>"index_task_statuses_on_task_owner_id"})
  1881. -> 0.0030s
  1882. -- add_index("katello_task_statuses", ["user_id"], {:name=>"index_task_statuses_on_user_id"})
  1883. -> 0.0031s
  1884. -- add_index("katello_task_statuses", ["uuid"], {:name=>"index_task_statuses_on_uuid"})
  1885. -> 0.0034s
  1886. -- create_table("katello_user_notices", {:force=>true})
  1887. NOTICE: CREATE TABLE will create implicit sequence "katello_user_notices_id_seq" for serial column "katello_user_notices.id"
  1888. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_user_notices_pkey" for table "katello_user_notices"
  1889. -> 0.0199s
  1890. -- add_index("katello_user_notices", ["notice_id"], {:name=>"index_user_notices_on_notice_id"})
  1891. -> 0.0030s
  1892. -- add_index("katello_user_notices", ["user_id"], {:name=>"index_user_notices_on_user_id"})
  1893. -> 0.0030s
  1894. == KatelloTables: migrated (0.5316s) =========================================
  1895.  
  1896. == AddUsersFields: migrating =================================================
  1897. -- add_column(:users, :helptips_enabled, :boolean, {:default=>true})
  1898. -> 0.0064s
  1899. -- add_column(:users, :hidden, :boolean, {:default=>false, :null=>false})
  1900. -> 0.0055s
  1901. -- add_column(:users, :page_size, :integer, {:default=>25, :null=>false})
  1902. -> 0.0060s
  1903. -- add_column(:users, :disabled, :boolean, {:default=>false})
  1904. -> 0.0055s
  1905. -- add_column(:users, :preferences, :text)
  1906. -> 0.0003s
  1907. -- add_column(:users, :remote_id, :string)
  1908. -> 0.0004s
  1909. == AddUsersFields: migrated (0.0247s) ========================================
  1910.  
  1911. == AddForeignKeysEngine: migrating ===========================================
  1912. -- add_foreign_key("katello_activation_keys", "katello_content_views", {:column=>"content_view_id", :name=>"activation_keys_content_view_id_fk"})
  1913. -> 0.0018s
  1914. -- add_foreign_key("katello_activation_keys", "katello_environments", {:column=>"environment_id", :name=>"activation_keys_environment_id_fk"})
  1915. -> 0.0012s
  1916. -- add_foreign_key("katello_activation_keys", "users", {:column=>"user_id", :name=>"activation_keys_user_id_fk"})
  1917. -> 0.0013s
  1918. -- 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"})
  1919. -> 0.0013s
  1920. -- add_foreign_key("katello_component_content_views", "katello_content_views", {:name=>"component_content_views_content_view_id_fk", :column=>"content_view_id"})
  1921. -> 0.0010s
  1922. -- add_foreign_key("katello_content_view_definition_bases", "katello_content_view_definition_bases", {:name=>"content_view_definition_bases_source_id_fk", :column=>"source_id"})
  1923. -> 0.0010s
  1924. -- 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"})
  1925. -> 0.0011s
  1926. -- add_foreign_key("katello_content_view_definition_products", "katello_products", {:name=>"content_view_definition_products_product_id_fk", :column=>"product_id"})
  1927. -> 0.0012s
  1928. -- 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"})
  1929. -> 0.0011s
  1930. -- add_foreign_key("katello_content_view_definition_repositories", "katello_repositories", {:name=>"content_view_definition_repositories_repository_id_fk", :column=>"repository_id"})
  1931. -> 0.0014s
  1932. -- add_foreign_key("katello_content_view_environments", "katello_content_views", {:name=>"content_view_environments_content_view_id_fk", :column=>"content_view_id"})
  1933. -> 0.0012s
  1934. -- add_foreign_key("katello_content_view_environments", "katello_environments", {:name=>"content_view_environments_environment_id_fk", :column=>"environment_id"})
  1935. -> 0.0010s
  1936. -- 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"})
  1937. -> 0.0014s
  1938. -- add_foreign_key("katello_content_view_version_environments", "katello_environments", {:name=>"content_view_version_environments_environment_id_fk", :column=>"environment_id"})
  1939. -> 0.0011s
  1940. -- 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"})
  1941. -> 0.0012s
  1942. -- add_foreign_key("katello_content_view_versions", "katello_content_view_definition_bases", {:name=>"content_view_versions_definition_archive_id_fk", :column=>"definition_archive_id"})
  1943. -> 0.0011s
  1944. -- add_foreign_key("katello_content_view_versions", "katello_content_views", {:name=>"content_view_versions_content_view_id_fk", :column=>"content_view_id"})
  1945. -> 0.0011s
  1946. -- add_foreign_key("katello_content_views", "katello_content_view_definition_bases", {:name=>"content_views_content_view_definition_id_fk", :column=>"content_view_definition_id"})
  1947. -> 0.0011s
  1948. -- add_foreign_key("katello_distributors", "katello_content_views", {:name=>"distributors_content_view_id_fk", :column=>"content_view_id"})
  1949. -> 0.0012s
  1950. -- add_foreign_key("katello_distributors", "katello_environments", {:name=>"distributors_environment_id_fk", :column=>"environment_id"})
  1951. -> 0.0011s
  1952. -- add_foreign_key("katello_environment_priors", "katello_environments", {:name=>"environment_priors_environment_id_fk", :column=>"environment_id"})
  1953. -> 0.0011s
  1954. -- add_foreign_key("katello_environment_priors", "katello_environments", {:name=>"environment_priors_prior_id_fk", :column=>"prior_id"})
  1955. -> 0.0012s
  1956. -- add_foreign_key("katello_filter_rules", "katello_filters", {:name=>"filters_rules_filter_id_fk", :column=>"filter_id"})
  1957. -> 0.0012s
  1958. -- add_foreign_key("katello_filters", "katello_content_view_definition_bases", {:name=>"filters_content_view_definition_id_fk", :column=>"content_view_definition_id"})
  1959. -> 0.0010s
  1960. -- add_foreign_key("katello_filters_products", "katello_filters", {:name=>"filters_product_filter_id_fk", :column=>"filter_id"})
  1961. -> 0.0011s
  1962. -- add_foreign_key("katello_filters_products", "katello_products", {:name=>"filters_product_product_id_fk", :column=>"product_id"})
  1963. -> 0.0011s
  1964. -- add_foreign_key("katello_filters_repositories", "katello_filters", {:name=>"filters_repositories_filter_id_fk", :column=>"filter_id"})
  1965. -> 0.0010s
  1966. -- add_foreign_key("katello_filters_repositories", "katello_repositories", {:name=>"filters_repositories_repository_id_fk", :column=>"repository_id"})
  1967. -> 0.0020s
  1968. -- add_foreign_key("katello_help_tips", "users", {:name=>"help_tips_user_id_fk", :column=>"user_id"})
  1969. -> 0.0013s
  1970. -- add_foreign_key("katello_job_tasks", "katello_jobs", {:name=>"job_tasks_job_id_fk", :column=>"job_id"})
  1971. -> 0.0012s
  1972. -- add_foreign_key("katello_job_tasks", "katello_task_statuses", {:name=>"job_tasks_task_status_id_fk", :column=>"task_status_id"})
  1973. -> 0.0013s
  1974. -- add_foreign_key("katello_key_pools", "katello_activation_keys", {:name=>"key_pools_activation_key_id_fk", :column=>"activation_key_id"})
  1975. -> 0.0013s
  1976. -- add_foreign_key("katello_key_pools", "katello_pools", {:name=>"key_pools_pool_id_fk", :column=>"pool_id"})
  1977. -> 0.0011s
  1978. -- add_foreign_key("katello_key_system_groups", "katello_activation_keys", {:name=>"key_system_groups_activation_key_id_fk", :column=>"activation_key_id"})
  1979. -> 0.0013s
  1980. -- add_foreign_key("katello_key_system_groups", "katello_system_groups", {:name=>"key_system_groups_system_group_id_fk", :column=>"system_group_id"})
  1981. -> 0.0011s
  1982. -- add_foreign_key("katello_marketing_engineering_products", "katello_products", {:name=>"marketing_engineering_products_engineering_product_id_fk", :column=>"engineering_product_id"})
  1983. -> 0.0012s
  1984. -- add_foreign_key("katello_marketing_engineering_products", "katello_products", {:name=>"marketing_engineering_products_marketing_product_id_fk", :column=>"marketing_product_id"})
  1985. -> 0.0011s
  1986. -- add_foreign_key("katello_products", "katello_gpg_keys", {:name=>"products_gpg_key_id_fk", :column=>"gpg_key_id"})
  1987. -> 0.0012s
  1988. -- add_foreign_key("katello_products", "katello_providers", {:name=>"products_provider_id_fk", :column=>"provider_id"})
  1989. -> 0.0012s
  1990. -- add_foreign_key("katello_products", "katello_sync_plans", {:name=>"products_sync_plan_id_fk", :column=>"sync_plan_id"})
  1991. -> 0.0012s
  1992. -- add_foreign_key("katello_providers", "katello_task_statuses", {:name=>"providers_discovery_task_id_fk", :column=>"discovery_task_id"})
  1993. -> 0.0011s
  1994. -- add_foreign_key("katello_providers", "katello_task_statuses", {:name=>"providers_task_status_id_fk", :column=>"task_status_id"})
  1995. -> 0.0012s
  1996. -- add_foreign_key("katello_repositories", "katello_content_view_versions", {:name=>"repositories_content_view_version_id_fk", :column=>"content_view_version_id"})
  1997. -> 0.0012s
  1998. -- add_foreign_key("katello_repositories", "katello_gpg_keys", {:name=>"repositories_gpg_key_id_fk", :column=>"gpg_key_id"})
  1999. -> 0.0013s
  2000. -- add_foreign_key("katello_repositories", "katello_repositories", {:name=>"repositories_library_instance_id_fk", :column=>"library_instance_id"})
  2001. -> 0.0011s
  2002. -- add_foreign_key("katello_search_favorites", "users", {:name=>"search_favorites_user_id_fk", :column=>"user_id"})
  2003. -> 0.0013s
  2004. -- add_foreign_key("katello_search_histories", "users", {:name=>"search_histories_user_id_fk", :column=>"user_id"})
  2005. -> 0.0012s
  2006. -- add_foreign_key("katello_system_activation_keys", "katello_activation_keys", {:name=>"system_activation_keys_activation_key_id_fk", :column=>"activation_key_id"})
  2007. -> 0.0012s
  2008. -- add_foreign_key("katello_system_activation_keys", "katello_systems", {:name=>"system_activation_keys_system_id_fk", :column=>"system_id"})
  2009. -> 0.0012s
  2010. -- add_foreign_key("katello_system_system_groups", "katello_system_groups", {:name=>"system_system_groups_system_group_id_fk", :column=>"system_group_id"})
  2011. -> 0.0013s
  2012. -- add_foreign_key("katello_system_system_groups", "katello_systems", {:name=>"system_system_groups_system_id_fk", :column=>"system_id"})
  2013. -> 0.0011s
  2014. -- add_foreign_key("katello_systems", "katello_content_views", {:name=>"systems_content_view_id_fk", :column=>"content_view_id"})
  2015. -> 0.0012s
  2016. -- add_foreign_key("katello_systems", "katello_environments", {:name=>"systems_environment_id_fk", :column=>"environment_id"})
  2017. -> 0.0012s
  2018. -- add_foreign_key("katello_task_statuses", "users", {:name=>"task_statuses_user_id_fk", :column=>"user_id"})
  2019. -> 0.0012s
  2020. -- add_foreign_key("katello_user_notices", "katello_notices", {:name=>"user_notices_notice_id_fk", :column=>"notice_id"})
  2021. -> 0.0013s
  2022. -- add_foreign_key("katello_user_notices", "users", {:name=>"user_notices_user_id_fk", :column=>"user_id"})
  2023. -> 0.0011s
  2024. == AddForeignKeysEngine: migrated (0.0711s) ==================================
  2025.  
  2026. == AllowNullValuesOnFactValue: migrating =====================================
  2027. -- change_column(:fact_values, :value, :text, {:null=>true})
  2028. -> 0.0121s
  2029. == AllowNullValuesOnFactValue: migrated (0.0122s) ============================
  2030.  
  2031. == EditHostBootdiskTemplateDnsSecondary: migrating ===========================
  2032. == EditHostBootdiskTemplateDnsSecondary: migrated (0.0000s) ==================
  2033.  
  2034. == AddTypeToFactName: migrating ==============================================
  2035. -- add_column(:fact_names, :type, :string, {:default=>"FactName"})
  2036. -> 0.0077s
  2037. == AddTypeToFactName: migrated (0.0080s) =====================================
  2038.  
  2039. == ChangeNameIndexOnFactName: migrating ======================================
  2040. -- remove_index(:fact_names, {:column=>:name, :unique=>true})
  2041. -> 0.0022s
  2042. -- add_index(:fact_names, [:name, :type], {:unique=>true})
  2043. -> 0.0028s
  2044. == ChangeNameIndexOnFactName: migrated (0.0054s) =============================
  2045.  
  2046. == UpdateForemanUrl: migrating ===============================================
  2047. == UpdateForemanUrl: migrated (0.0044s) ======================================
  2048.  
  2049. == AddAncestryToFactNames: migrating =========================================
  2050. -- add_column(:fact_names, :ancestry, :string)
  2051. -> 0.0007s
  2052. -- add_index(:fact_names, :ancestry)
  2053. -> 0.0035s
  2054. == AddAncestryToFactNames: migrated (0.0045s) ================================
  2055.  
  2056. == ExtendUserRole: migrating =================================================
  2057. -- foreign_keys("user_roles")
  2058. -> 0.1195s
  2059. -- remove_foreign_key("user_roles", {:name=>"user_roles_user_id_fk"})
  2060. -> 0.0013s
  2061. -- add_column(:user_roles, :owner_type, :string, {:default=>"User", :null=>false})
  2062. -> 0.0034s
  2063. -- rename_column(:user_roles, :user_id, :owner_id)
  2064. -> 0.0003s
  2065. -- add_index(:user_roles, :owner_type)
  2066. -> 0.0029s
  2067. -- add_index(:user_roles, :owner_id)
  2068. -> 0.0030s
  2069. -- add_index(:user_roles, [:owner_id, :owner_type])
  2070. -> 0.0035s
  2071. -- change_column(:user_roles, :owner_id, :integer, {:null=>false})
  2072. -> 0.0087s
  2073. == ExtendUserRole: migrated (0.1434s) ========================================
  2074.  
  2075. == CreateCachedUserRoles: migrating ==========================================
  2076. -- create_table(:cached_user_roles)
  2077. NOTICE: CREATE TABLE will create implicit sequence "cached_user_roles_id_seq" for serial column "cached_user_roles.id"
  2078. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cached_user_roles_pkey" for table "cached_user_roles"
  2079. -> 0.0046s
  2080. -- add_index(:cached_user_roles, :user_id)
  2081. -> 0.0031s
  2082. -- add_index(:cached_user_roles, :role_id)
  2083. -> 0.0028s
  2084. -- add_index(:cached_user_roles, :user_role_id)
  2085. -> 0.0031s
  2086. == CreateCachedUserRoles: migrated (0.0139s) =================================
  2087.  
  2088. == AddOrganizationFields: migrating ==========================================
  2089. -- column_exists?(:taxonomies, :description)
  2090. -> 0.0010s
  2091. -- add_column(:taxonomies, :description, :text)
  2092. -> 0.0006s
  2093. -- add_column(:taxonomies, :label, :string)
  2094. -> 0.0004s
  2095. -- add_column(:taxonomies, :deletion_task_id, :integer)
  2096. -> 0.0003s
  2097. -- add_column(:taxonomies, :default_info, :text)
  2098. -> 0.0003s
  2099. -- add_column(:taxonomies, :apply_info_task_id, :integer)
  2100. -> 0.0004s
  2101. -- add_column(:taxonomies, :owner_auto_attach_all_systems_task_id, :integer)
  2102. -> 0.0003s
  2103. -- add_index(:taxonomies, [:deletion_task_id], {:name=>"index_organizations_on_task_id"})
  2104. -> 0.0032s
  2105. -- add_index(:taxonomies, [:label], {:name=>"index_organizations_on_cp_key", :unique=>true})
  2106. -> 0.0031s
  2107. == AddOrganizationFields: migrated (0.0103s) =================================
  2108.  
  2109. == CalculateCacheForUserRole: migrating ======================================
  2110. == CalculateCacheForUserRole: migrated (0.0042s) =============================
  2111.  
  2112. == AddPxegrubLocalbootTemplate: migrating ====================================
  2113. == AddPxegrubLocalbootTemplate: migrated (0.0000s) ===========================
  2114.  
  2115. == CreateCachedUsergroupMembers: migrating ===================================
  2116. -- create_table(:cached_usergroup_members)
  2117. NOTICE: CREATE TABLE will create implicit sequence "cached_usergroup_members_id_seq" for serial column "cached_usergroup_members.id"
  2118. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cached_usergroup_members_pkey" for table "cached_usergroup_members"
  2119. -> 0.0048s
  2120. -- add_index(:cached_usergroup_members, :user_id)
  2121. -> 0.0029s
  2122. -- add_index(:cached_usergroup_members, :usergroup_id)
  2123. -> 0.0028s
  2124. == CreateCachedUsergroupMembers: migrated (0.1333s) ==========================
  2125.  
  2126. == CreateRealms: migrating ===================================================
  2127. -- create_table(:realms)
  2128. NOTICE: CREATE TABLE will create implicit sequence "realms_id_seq" for serial column "realms.id"
  2129. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "realms_pkey" for table "realms"
  2130. -> 0.0076s
  2131. -- add_index(:realms, :name, {:unique=>true})
  2132. -> 0.0035s
  2133. -- column_exists?(:hosts, :otp)
  2134. -> 0.0018s
  2135. -- add_column(:hosts, :otp, :string)
  2136. -> 0.0008s
  2137. -- column_exists?(:hosts, :realm_id)
  2138. -> 0.0012s
  2139. -- add_column(:hosts, :realm_id, :integer)
  2140. -> 0.0004s
  2141. -- column_exists?(:hostgroups, :realm_id)
  2142. -> 0.0008s
  2143. -- add_column(:hostgroups, :realm_id, :integer)
  2144. -> 0.0004s
  2145. -- add_foreign_key(:realms, :smart_proxies, {:name=>"realms_realm_proxy_id_fk", :column=>"realm_proxy_id"})
  2146. -> 0.0013s
  2147. -- add_foreign_key(:hosts, :realms, {:name=>"hosts_realms_id_fk"})
  2148. -> 0.0018s
  2149. -- add_foreign_key(:hostgroups, :realms, {:name=>"hostgroups_realms_id_fk"})
  2150. -> 0.0014s
  2151. == CreateRealms: migrated (0.0218s) ==========================================
  2152.  
  2153. == RenameSeededTemplates: migrating ==========================================
  2154. == RenameSeededTemplates: migrated (0.0235s) =================================
  2155.  
  2156. == AddAdminFlagToUsergroup: migrating ========================================
  2157. -- add_column(:usergroups, :admin, :boolean, {:null=>false, :default=>false})
  2158. -> 0.0037s
  2159. == AddAdminFlagToUsergroup: migrated (0.0039s) ===============================
  2160.  
  2161. == CreatePermissions: migrating ==============================================
  2162. -- create_table(:permissions)
  2163. NOTICE: CREATE TABLE will create implicit sequence "permissions_id_seq" for serial column "permissions.id"
  2164. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "permissions_pkey" for table "permissions"
  2165. -> 0.0063s
  2166. -- add_index(:permissions, [:name, :resource_type])
  2167. -> 0.0029s
  2168. == CreatePermissions: migrated (0.0094s) =====================================
  2169.  
  2170. == CreateFilters: migrating ==================================================
  2171. -- create_table(:filters)
  2172. NOTICE: CREATE TABLE will create implicit sequence "filters_id_seq" for serial column "filters.id"
  2173. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "filters_pkey" for table "filters"
  2174. -> 0.0063s
  2175. == CreateFilters: migrated (0.0064s) =========================================
  2176.  
  2177. == CreateFilterings: migrating ===============================================
  2178. -- create_table(:filterings)
  2179. NOTICE: CREATE TABLE will create implicit sequence "filterings_id_seq" for serial column "filterings.id"
  2180. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "filterings_pkey" for table "filterings"
  2181. -> 0.0161s
  2182. -- add_index(:filterings, :filter_id)
  2183. -> 0.0032s
  2184. -- add_index(:filterings, :permission_id)
  2185. -> 0.0029s
  2186. == CreateFilterings: migrated (0.0223s) ======================================
  2187.  
  2188. == AddDescriptionToOperatingsystem: migrating ================================
  2189. -- add_column(:operatingsystems, :description, :string)
  2190. -> 0.0009s
  2191. == AddDescriptionToOperatingsystem: migrated (0.0010s) =======================
  2192.  
  2193. == CreateForemanTasks: migrating =============================================
  2194. -- create_table(:foreman_tasks_tasks, {:id=>false})
  2195. -> 0.0037s
  2196. == CreateForemanTasks: migrated (0.0039s) ====================================
  2197.  
  2198. == CreateForemanTasksLocks: migrating ========================================
  2199. -- create_table(:foreman_tasks_locks)
  2200. NOTICE: CREATE TABLE will create implicit sequence "foreman_tasks_locks_id_seq" for serial column "foreman_tasks_locks.id"
  2201. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foreman_tasks_locks_pkey" for table "foreman_tasks_locks"
  2202. -> 0.0062s
  2203. -- add_index(:foreman_tasks_locks, [:resource_type, :resource_id])
  2204. -> 0.0031s
  2205. == CreateForemanTasksLocks: migrated (0.0096s) ===============================
  2206.  
  2207. == AddLdapAvatarSupport: migrating ===========================================
  2208. -- add_column(:auth_sources, :attr_photo, :string)
  2209. -> 0.0008s
  2210. -- add_column(:users, :avatar_hash, :string, {:limit=>128})
  2211. -> 0.0005s
  2212. == AddLdapAvatarSupport: migrated (0.0015s) ==================================
  2213.  
  2214. == AddQuantityToKatelloKeyPools: migrating ===================================
  2215. -- add_column(:katello_key_pools, :quantity, :integer)
  2216. -> 0.0007s
  2217. == AddQuantityToKatelloKeyPools: migrated (0.0008s) ==========================
  2218.  
  2219. == AddCpIdToKatelloActivationKeys: migrating =================================
  2220. -- add_column(:katello_activation_keys, :cp_id, :string)
  2221. -> 0.0007s
  2222. -- add_column(:katello_activation_keys, :label, :string)
  2223. -> 0.0003s
  2224. -- add_index(:katello_activation_keys, :cp_id)
  2225. -> 0.0045s
  2226. -- add_index(:katello_activation_keys, :label, {:name=>"index_activation_keys_on_label", :unique=>true})
  2227. -> 0.0046s
  2228. == AddCpIdToKatelloActivationKeys: migrated (0.0105s) ========================
  2229.  
  2230. == DropKatelloKeyPoolsTable: migrating =======================================
  2231. -- drop_table(:katello_key_pools)
  2232. -> 0.0020s
  2233. == DropKatelloKeyPoolsTable: migrated (0.0021s) ==============================
  2234.  
  2235. == AddUserdataFlagToImages: migrating ========================================
  2236. -- add_column(:images, :user_data, :boolean, {:default=>false})
  2237. -> 0.0059s
  2238. == AddUserdataFlagToImages: migrated (0.0060s) ===============================
  2239.  
  2240. == CreateComputeProfiles: migrating ==========================================
  2241. -- create_table(:compute_profiles)
  2242. NOTICE: CREATE TABLE will create implicit sequence "compute_profiles_id_seq" for serial column "compute_profiles.id"
  2243. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "compute_profiles_pkey" for table "compute_profiles"
  2244. -> 0.0042s
  2245. == CreateComputeProfiles: migrated (0.0043s) =================================
  2246.  
  2247. == CreateComputeAttributes: migrating ========================================
  2248. -- create_table(:compute_attributes)
  2249. NOTICE: CREATE TABLE will create implicit sequence "compute_attributes_id_seq" for serial column "compute_attributes.id"
  2250. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "compute_attributes_pkey" for table "compute_attributes"
  2251. -> 0.0064s
  2252. -- add_index(:compute_attributes, :compute_profile_id)
  2253. -> 0.0030s
  2254. -- add_index(:compute_attributes, :compute_resource_id)
  2255. -> 0.0028s
  2256. -- add_foreign_key("compute_attributes", "compute_resources", {:name=>"compute_attributes_compute_resource_id_fk"})
  2257. -> 0.0015s
  2258. -- add_foreign_key("compute_attributes", "compute_profiles", {:name=>"compute_attributes_compute_profile_id_fk"})
  2259. -> 0.0012s
  2260. == CreateComputeAttributes: migrated (0.0154s) ===============================
  2261.  
  2262. == AddComputeProfileToHostgroup: migrating ===================================
  2263. -- add_column(:hostgroups, :compute_profile_id, :integer)
  2264. -> 0.0010s
  2265. -- add_column(:hosts, :compute_profile_id, :integer)
  2266. -> 0.0004s
  2267. -- add_index(:hostgroups, :compute_profile_id)
  2268. -> 0.0037s
  2269. -- add_index(:hosts, :compute_profile_id)
  2270. -> 0.0067s
  2271. -- add_foreign_key("hostgroups", "compute_profiles", {:name=>"hostgroups_compute_profile_id_fk"})
  2272. -> 0.0017s
  2273. -- add_foreign_key("hosts", "compute_profiles", {:name=>"hosts_compute_profile_id_fk"})
  2274. -> 0.0014s
  2275. == AddComputeProfileToHostgroup: migrated (0.0154s) ==========================
  2276.  
  2277. == UpdateEnvironmentsAddKatelloId: migrating =================================
  2278. -- add_column(:environments, :katello_id, :string)
  2279. -> 0.0032s
  2280. -- add_index(:environments, :katello_id)
  2281. -> 0.0031s
  2282. == UpdateEnvironmentsAddKatelloId: migrated (0.0065s) ========================
  2283.  
  2284. == AddForeignKeysToFiltersAndFilterings: migrating ===========================
  2285. -- add_foreign_key("filters", "roles", {:name=>"filters_roles_id_fk"})
  2286. -> 0.0018s
  2287. -- add_foreign_key("filterings", "filters", {:name=>"filterings_filters_id_fk"})
  2288. -> 0.0014s
  2289. -- add_foreign_key("filterings", "permissions", {:name=>"filterings_permissions_id_fk"})
  2290. -> 0.0014s
  2291. == AddForeignKeysToFiltersAndFilterings: migrated (0.0049s) ==================
  2292.  
  2293. == AddPasswordToImages: migrating ============================================
  2294. -- add_column(:images, :password, :string)
  2295. -> 0.0008s
  2296. == AddPasswordToImages: migrated (0.0009s) ===================================
  2297.  
  2298. == RefactorContentViews: migrating ===========================================
  2299. -- remove_foreign_key("katello_component_content_views", {:name=>"component_content_views_content_view_definition_id_fk"})
  2300. -> 0.0009s
  2301. -- remove_foreign_key("katello_content_view_definition_bases", {:name=>"content_view_definition_bases_source_id_fk"})
  2302. -> 0.0006s
  2303. -- remove_foreign_key("katello_content_view_definition_products", {:name=>"content_view_definition_products_content_view_definition_id_fk"})
  2304. -> 0.0006s
  2305. -- remove_foreign_key("katello_content_view_definition_products", {:name=>"content_view_definition_products_product_id_fk"})
  2306. -> 0.0006s
  2307. -- remove_foreign_key("katello_content_view_definition_repositories", {:name=>"CV_definition_repositories_CV_definition_id_fk"})
  2308. -> 0.0006s
  2309. -- remove_foreign_key("katello_content_view_versions", {:name=>"content_view_versions_content_view_definition_archive_id_fk"})
  2310. -> 0.0006s
  2311. -- remove_foreign_key("katello_content_view_versions", {:name=>"content_view_versions_definition_archive_id_fk"})
  2312. -> 0.0006s
  2313. -- remove_foreign_key("katello_content_views", {:name=>"content_views_content_view_definition_id_fk"})
  2314. -> 0.0006s
  2315. -- remove_foreign_key("katello_filters", {:name=>"filters_content_view_definition_id_fk"})
  2316. -> 0.0006s
  2317. -- remove_foreign_key("katello_filters_products", {:name=>"filters_product_filter_id_fk"})
  2318. -> 0.0006s
  2319. -- remove_foreign_key("katello_filters_products", {:name=>"filters_product_product_id_fk"})
  2320. -> 0.0006s
  2321. -- remove_foreign_key("katello_filter_rules", {:name=>"filters_rules_filter_id_fk"})
  2322. -> 0.0006s
  2323. -- drop_table(:katello_content_view_definition_bases)
  2324. -> 0.0014s
  2325. -- drop_table(:katello_content_view_definition_products)
  2326. -> 0.0009s
  2327. -- drop_table(:katello_filters_products)
  2328. -> 0.0008s
  2329. -- drop_table(:katello_filter_rules)
  2330. -> 0.0012s
  2331. -- drop_table(:katello_content_view_version_environments)
  2332. -> 0.0015s
  2333. -- add_column(:katello_content_views, :composite, :boolean)
  2334. -> 0.0005s
  2335. -- add_column(:katello_content_view_environments, :content_view_version_id, :integer)
  2336. -> 0.0004s
  2337. -- remove_column(:katello_content_views, :content_view_definition_id)
  2338. -> 0.0005s
  2339. -- rename_column(:katello_component_content_views, :content_view_definition_id, :content_view_version_id)
  2340. -> 0.0004s
  2341. -- rename_table(:katello_component_content_views, :katello_content_view_components)
  2342. -> 0.0024s
  2343. -- rename_table(:katello_content_view_definition_repositories, :katello_content_view_repositories)
  2344. -> 0.0022s
  2345. -- rename_column(:katello_content_view_repositories, :content_view_definition_id, :content_view_id)
  2346. -> 0.0004s
  2347. -- rename_table(:katello_filters, :katello_content_view_filters)
  2348. -> 0.0023s
  2349. -- rename_table(:katello_filters_repositories, :katello_content_view_filters_repositories)
  2350. -> 0.0027s
  2351. -- rename_column(:katello_content_view_filters_repositories, :filter_id, :content_view_filter_id)
  2352. -> 0.0005s
  2353. -- rename_column(:katello_content_view_filters, :content_view_definition_id, :content_view_id)
  2354. -> 0.0004s
  2355. -- add_column(:katello_content_view_filters, :type, :string)
  2356. -> 0.0029s
  2357. -- add_column(:katello_content_view_filters, :inclusion, :boolean, {:default=>false, :null=>false})
  2358. -> 0.0084s
  2359. == RefactorContentViews: migrated (0.0395s) ==================================
  2360.  
  2361. == AddDefaultOrganizationIdToUsers: migrating ================================
  2362. -- add_column(:users, :default_organization_id, :integer)
  2363. -> 0.0011s
  2364. == AddDefaultOrganizationIdToUsers: migrated (0.0012s) =======================
  2365.  
  2366. == AddDefaultLocationIdToUsers: migrating ====================================
  2367. -- add_column(:users, :default_location_id, :integer)
  2368. -> 0.0008s
  2369. == AddDefaultLocationIdToUsers: migrated (0.0009s) ===========================
  2370.  
  2371. == AddAncestryToTaxonomies: migrating ========================================
  2372. -- add_column(:taxonomies, :ancestry, :string)
  2373. -> 0.0007s
  2374. -- add_index(:taxonomies, :ancestry)
  2375. -> 0.0043s
  2376. == AddAncestryToTaxonomies: migrated (0.0059s) ===============================
  2377.  
  2378. == CreateContentViewPuppetModules: migrating =================================
  2379. -- create_table(:katello_content_view_puppet_modules)
  2380. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_puppet_modules_id_seq" for serial column "katello_content_view_puppet_modules.id"
  2381. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_puppet_modules_pkey" for table "katello_content_view_puppet_modules"
  2382. -> 0.0067s
  2383. -- add_index(:katello_content_view_puppet_modules, :content_view_id)
  2384. -> 0.0036s
  2385. -- add_index(:katello_content_view_puppet_modules, [:name, :content_view_id], {:unique=>true, :name=>:katello_cv_puppet_modules_name})
  2386. -> 0.0038s
  2387. -- add_index(:katello_content_view_puppet_modules, [:name, :author, :content_view_id], {:unique=>true, :name=>:katello_cv_puppet_modules_name_author})
  2388. -> 0.0046s
  2389. -- add_index(:katello_content_view_puppet_modules, [:uuid, :content_view_id], {:unique=>true, :name=>:katello_cv_puppet_modules_uuid})
  2390. -> 0.0044s
  2391. == CreateContentViewPuppetModules: migrated (0.0239s) ========================
  2392.  
  2393. == CreateContentViewPackageFilterRules: migrating ============================
  2394. -- create_table(:katello_content_view_package_filter_rules)
  2395. 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"
  2396. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_package_filter_rules_pkey" for table "katello_content_view_package_filter_rules"
  2397. -> 0.0071s
  2398. == CreateContentViewPackageFilterRules: migrated (0.0073s) ===================
  2399.  
  2400. == CreateContentViewPackageGroupFilterRules: migrating =======================
  2401. -- create_table(:katello_content_view_package_group_filter_rules)
  2402. 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"
  2403. 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"
  2404. -> 0.0043s
  2405. == CreateContentViewPackageGroupFilterRules: migrated (0.0044s) ==============
  2406.  
  2407. == CreateContentViewErratumFilterRules: migrating ============================
  2408. -- create_table(:katello_content_view_erratum_filter_rules)
  2409. 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"
  2410. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_erratum_filter_rules_pkey" for table "katello_content_view_erratum_filter_rules"
  2411. -> 0.0068s
  2412. == CreateContentViewErratumFilterRules: migrated (0.0069s) ===================
  2413.  
  2414. == RemoveChangeset: migrating ================================================
  2415. -- drop_table("katello_changeset_content_views")
  2416. -> 0.0012s
  2417. -- drop_table("katello_changeset_users")
  2418. -> 0.0011s
  2419. -- drop_table("katello_changesets")
  2420. -> 0.0016s
  2421. == RemoveChangeset: migrated (0.0042s) =======================================
  2422.  
  2423. == CreateContentViewHistory: migrating =======================================
  2424. -- create_table("katello_content_view_histories")
  2425. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_histories_id_seq" for serial column "katello_content_view_histories.id"
  2426. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_histories_pkey" for table "katello_content_view_histories"
  2427. -> 0.0070s
  2428. -- add_index("katello_content_view_histories", ["katello_content_view_version_id"], {:name=>"index_cvh_cvvid"})
  2429. -> 0.0036s
  2430. -- add_index("katello_content_view_histories", ["katello_environment_id"], {:name=>"index_cvh_environment_id"})
  2431. -> 0.0044s
  2432. -- add_foreign_key("katello_content_view_histories", "katello_environments", {:name=>"content_view_histories_cvh_environment_id", :column=>"katello_environment_id"})
  2433. -> 0.0020s
  2434. -- add_foreign_key("katello_content_view_histories", "katello_content_view_versions", {:name=>"content_view_histories_cvh_cvv_id", :column=>"katello_content_view_version_id"})
  2435. -> 0.0015s
  2436. == CreateContentViewHistory: migrated (0.0189s) ==============================
  2437.  
  2438. == ChangeLabelToTitle: migrating =============================================
  2439. -- rename_column(:hostgroups, :label, :title)
  2440. -> 0.0007s
  2441. -- add_column(:taxonomies, :title, :string)
  2442. -> 0.0004s
  2443. -- execute("UPDATE taxonomies set title = name WHERE ancestry IS NULL")
  2444. -> 0.0005s
  2445. == ChangeLabelToTitle: migrated (0.0046s) ====================================
  2446.  
  2447. == MigratePermissions: migrating =============================================
  2448. -- Skipping migration of permissions, since old permissions are not present
  2449. == MigratePermissions: migrated (0.1687s) ====================================
  2450.  
  2451. == AddTaxonomySearchesToFilter: migrating ====================================
  2452. -- add_column(:filters, :taxonomy_search, :text)
  2453. -> 0.0008s
  2454. == AddTaxonomySearchesToFilter: migrated (0.0371s) ===========================
  2455.  
  2456. == RemoveProviderDiscovery: migrating ========================================
  2457. -- remove_column(:katello_providers, :discovery_url)
  2458. -> 0.0006s
  2459. -- remove_column(:katello_providers, :discovery_task_id)
  2460. -> 0.0007s
  2461. -- remove_column(:katello_providers, :discovered_repos)
  2462. -> 0.0003s
  2463. == RemoveProviderDiscovery: migrated (0.0018s) ===============================
  2464.  
  2465. == AddProvisionMethodToHosts: migrating ======================================
  2466. -- add_column(:hosts, :provision_method, :string)
  2467. -> 0.0012s
  2468. == AddProvisionMethodToHosts: migrated (0.0030s) =============================
  2469.  
  2470. == AllowNullForRepositoryContentId: migrating ================================
  2471. -- change_column(:katello_repositories, :content_id, :string, {:null=>true})
  2472. -> 0.0505s
  2473. == AllowNullForRepositoryContentId: migrated (0.0506s) =======================
  2474.  
  2475. == CreateContentViewPuppetEnvironments: migrating ============================
  2476. -- create_table(:katello_content_view_puppet_environments)
  2477. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_puppet_environments_id_seq" for serial column "katello_content_view_puppet_environments.id"
  2478. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_puppet_environments_pkey" for table "katello_content_view_puppet_environments"
  2479. -> 0.0170s
  2480. -- add_index(:katello_content_view_puppet_environments, [:content_view_version_id], {:name=>:index_cvpe_on_content_view_version_id})
  2481. -> 0.0077s
  2482. -- add_index(:katello_content_view_puppet_environments, [:environment_id], {:name=>:index_cvpe_on_environment_id})
  2483. -> 0.0076s
  2484. -- add_index(:katello_content_view_puppet_environments, [:pulp_id], {:name=>:index_cvpe_on_pulp_id})
  2485. -> 0.0089s
  2486. == CreateContentViewPuppetEnvironments: migrated (0.0418s) ===================
  2487.  
  2488. == RepositoryAddChecksumType: migrating ======================================
  2489. -- add_column(:katello_repositories, :checksum_type, :string, {:null=>true})
  2490. -> 0.0008s
  2491. == RepositoryAddChecksumType: migrated (0.0009s) =============================
  2492.  
  2493. == AddCounterCaches: migrating ===============================================
  2494. -- add_column(:architectures, :hosts_count, :integer, {:default=>0})
  2495. -> 0.0237s
  2496. -- add_column(:architectures, :hostgroups_count, :integer, {:default=>0})
  2497. -> 0.0078s
  2498. -- add_column(:domains, :hosts_count, :integer, {:default=>0})
  2499. -> 0.0083s
  2500. -- add_column(:domains, :hostgroups_count, :integer, {:default=>0})
  2501. -> 0.0133s
  2502. -- add_column(:environments, :hosts_count, :integer, {:default=>0})
  2503. -> 0.0152s
  2504. -- add_column(:environments, :hostgroups_count, :integer, {:default=>0})
  2505. -> 0.0114s
  2506. -- add_column(:models, :hosts_count, :integer, {:default=>0})
  2507. -> 0.0105s
  2508. -- add_column(:operatingsystems, :hosts_count, :integer, {:default=>0})
  2509. -> 0.0116s
  2510. -- add_column(:operatingsystems, :hostgroups_count, :integer, {:default=>0})
  2511. -> 0.0166s
  2512. -- add_column(:puppetclasses, :hosts_count, :integer, {:default=>0})
  2513. -> 0.0073s
  2514. -- add_column(:puppetclasses, :hostgroups_count, :integer, {:default=>0})
  2515. -> 0.0086s
  2516. -- add_column(:puppetclasses, :lookup_keys_count, :integer, {:default=>0})
  2517. -> 0.0063s
  2518. == AddCounterCaches: migrated (0.1657s) ======================================
  2519.  
  2520. == FixPuppetclassCounters: migrating =========================================
  2521. -- rename_column(:puppetclasses, :lookup_keys_count, :global_class_params_count)
  2522. -> 0.0010s
  2523. -- add_column(:puppetclasses, :lookup_keys_count, :integer, {:default=>0})
  2524. -> 0.0084s
  2525. == FixPuppetclassCounters: migrated (0.0112s) ================================
  2526.  
  2527. == DropCdnImportSuccessColumn: migrating =====================================
  2528. -- remove_column(:katello_products, :cdn_import_success)
  2529. -> 0.0009s
  2530. == DropCdnImportSuccessColumn: migrated (0.0010s) ============================
  2531.  
  2532. == ChangeHostManagedDefaultToFalse: migrating ================================
  2533. -- change_column(:hosts, :managed, :boolean, {:null=>false, :default=>false})
  2534. -> 0.0655s
  2535. == ChangeHostManagedDefaultToFalse: migrated (0.0672s) =======================
  2536.  
  2537. == AddServerTypeToAuthSource: migrating ======================================
  2538. -- add_column(:auth_sources, :server_type, :string, {:default=>"posix"})
  2539. -> 0.0138s
  2540. == AddServerTypeToAuthSource: migrated (0.0140s) =============================
  2541.  
  2542. == AddGroupsBaseToAuthSource: migrating ======================================
  2543. -- add_column(:auth_sources, :groups_base, :string)
  2544. -> 0.0008s
  2545. == AddGroupsBaseToAuthSource: migrated (0.0009s) =============================
  2546.  
  2547. == RemoveForemanTasksProgress: migrating =====================================
  2548. -- remove_column(:foreman_tasks_tasks, :progress)
  2549. -> 0.0005s
  2550. == RemoveForemanTasksProgress: migrated (0.0005s) ============================
  2551.  
  2552. == AddLowerloginToUsers: migrating ===========================================
  2553. -- add_column(:users, :lower_login, :string)
  2554. -> 0.0007s
  2555. -- add_index(:users, :lower_login, {:unique=>true})
  2556. -> 0.0041s
  2557. == AddLowerloginToUsers: migrated (0.0093s) ==================================
  2558.  
  2559. == CreateContentViewForeignKeys: migrating ===================================
  2560. -- add_foreign_key(:katello_content_view_environments, :katello_content_view_versions, {:name=>"katello_content_view_environments_version_fk", :column=>"content_view_version_id"})
  2561. -> 0.0025s
  2562. -- add_foreign_key(:katello_content_view_components, :katello_content_view_versions, {:name=>"katello_content_view_components_version_fk", :column=>"content_view_version_id"})
  2563. -> 0.0015s
  2564. -- add_foreign_key(:katello_content_view_components, :katello_content_views, {:name=>"katello_content_view_components_view_fk", :column=>"content_view_id"})
  2565. -> 0.0012s
  2566. -- add_foreign_key(:katello_content_view_repositories, :katello_content_views, {:name=>"katello_content_view_repostories_content_view_fk", :column=>"content_view_id"})
  2567. -> 0.0014s
  2568. -- add_foreign_key(:katello_content_view_repositories, :katello_repositories, {:name=>"katello_content_view_repositories_repository_view_fk", :column=>"repository_id"})
  2569. -> 0.0017s
  2570. -- 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"})
  2571. -> 0.0022s
  2572. -- add_foreign_key(:katello_content_view_filters_repositories, :katello_repositories, {:name=>"katello_content_view_filters_repositories_repository_fk", :column=>"repository_id"})
  2573. -> 0.0019s
  2574. -- add_foreign_key(:katello_content_view_filters, :katello_content_views, {:name=>"katello_content_view_filters_view_fk", :column=>"content_view_id"})
  2575. -> 0.0019s
  2576. -- add_foreign_key(:katello_content_view_puppet_modules, :katello_content_views, {:name=>"katello_content_view_puppet_modules_view_fk", :column=>"content_view_id"})
  2577. -> 0.0023s
  2578. -- 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"})
  2579. -> 0.0020s
  2580. -- 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"})
  2581. -> 0.0019s
  2582. -- 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"})
  2583. -> 0.0020s
  2584. -- 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"})
  2585. -> 0.0022s
  2586. -- add_foreign_key(:katello_content_view_puppet_environments, :katello_environments, {:name=>"katello_content_view_puppet_environments_environment_fk", :column=>"environment_id"})
  2587. -> 0.0021s
  2588. -- add_foreign_key(:katello_content_views, :taxonomies, {:name=>"katello_content_views_organization_fk", :column=>"organization_id"})
  2589. -> 0.0019s
  2590. == CreateContentViewForeignKeys: migrated (0.0303s) ==========================
  2591.  
  2592. == DropRepositoriesEnabledColumn: migrating ==================================
  2593. -- remove_column(:katello_repositories, :enabled)
  2594. -> 0.0011s
  2595. == DropRepositoriesEnabledColumn: migrated (0.0013s) =========================
  2596.  
  2597. == CreateConfigGroups: migrating =============================================
  2598. -- create_table(:config_groups)
  2599. NOTICE: CREATE TABLE will create implicit sequence "config_groups_id_seq" for serial column "config_groups.id"
  2600. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "config_groups_pkey" for table "config_groups"
  2601. -> 0.0079s
  2602. == CreateConfigGroups: migrated (0.0081s) ====================================
  2603.  
  2604. == CreateConfigGroupClasses: migrating =======================================
  2605. -- create_table(:config_group_classes)
  2606. NOTICE: CREATE TABLE will create implicit sequence "config_group_classes_id_seq" for serial column "config_group_classes.id"
  2607. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "config_group_classes_pkey" for table "config_group_classes"
  2608. -> 0.0072s
  2609. == CreateConfigGroupClasses: migrated (0.0073s) ==============================
  2610.  
  2611. == CreateHostConfigGroups: migrating =========================================
  2612. -- create_table(:host_config_groups)
  2613. NOTICE: CREATE TABLE will create implicit sequence "host_config_groups_id_seq" for serial column "host_config_groups.id"
  2614. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "host_config_groups_pkey" for table "host_config_groups"
  2615. -> 0.0065s
  2616. == CreateHostConfigGroups: migrated (0.0066s) ================================
  2617.  
  2618. == CreateExternalUsergroups: migrating =======================================
  2619. -- create_table(:external_usergroups)
  2620. NOTICE: CREATE TABLE will create implicit sequence "external_usergroups_id_seq" for serial column "external_usergroups.id"
  2621. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "external_usergroups_pkey" for table "external_usergroups"
  2622. -> 0.0041s
  2623. -- add_index(:external_usergroups, :usergroup_id)
  2624. -> 0.0047s
  2625. -- add_foreign_key("external_usergroups", "usergroups", {:name=>"external_usergroups_usergroup_id_fk"})
  2626. -> 0.0022s
  2627. -- add_foreign_key("external_usergroups", "auth_sources", {:name=>"external_usergroups_auth_source_id_fk"})
  2628. -> 0.0014s
  2629. == CreateExternalUsergroups: migrated (0.0128s) ==============================
  2630.  
  2631. == RemoveSubscribeToAllHostgroupsFromUsers: migrating ========================
  2632. -- column_exists?(:users, :subscribe_to_all_hostgroups)
  2633. -> 0.0027s
  2634. -- remove_column(:users, :subscribe_to_all_hostgroups)
  2635. -> 0.0008s
  2636. == RemoveSubscribeToAllHostgroupsFromUsers: migrated (0.0037s) ===============
  2637.  
  2638. == UpdateContentViewDescriptionType: migrating ===============================
  2639. -- change_column(:katello_content_views, :description, :string, {:limit=>255})
  2640. -> 0.0110s
  2641. == UpdateContentViewDescriptionType: migrated (0.0112s) ======================
  2642.  
  2643. == AddCountersToConfigGroups: migrating ======================================
  2644. -- add_column(:config_groups, :hosts_count, :integer)
  2645. -> 0.0009s
  2646. -- add_column(:config_groups, :hostgroups_count, :integer)
  2647. -> 0.0003s
  2648. -- add_column(:config_groups, :config_group_classes_count, :integer)
  2649. -> 0.0005s
  2650. == AddCountersToConfigGroups: migrated (0.0018s) =============================
  2651.  
  2652. == AllowNullContentViewToActivationKey: migrating ============================
  2653. -- change_column(:katello_activation_keys, :environment_id, :integer, {:null=>true})
  2654. -> 0.0188s
  2655. == AllowNullContentViewToActivationKey: migrated (0.0190s) ===================
  2656.  
  2657. == AddConfigGroupCounterDefaults: migrating ==================================
  2658. -- change_column(:config_groups, :hosts_count, :integer, {:default=>0})
  2659. -> 0.0040s
  2660. -- change_column(:config_groups, :hostgroups_count, :integer, {:default=>0})
  2661. -> 0.0030s
  2662. -- change_column(:config_groups, :config_group_classes_count, :integer, {:default=>0})
  2663. -> 0.0032s
  2664. == AddConfigGroupCounterDefaults: migrated (0.1723s) =========================
  2665.  
  2666. == CleanupUsersProperties: migrating =========================================
  2667. -- column_exists?(:users, :domains_andor)
  2668. -> 0.0015s
  2669. -- remove_column(:users, :domains_andor)
  2670. -> 0.0008s
  2671. -- column_exists?(:users, :hostgroups_andor)
  2672. -> 0.0010s
  2673. -- remove_column(:users, :hostgroups_andor)
  2674. -> 0.0005s
  2675. -- column_exists?(:users, :facts_andor)
  2676. -> 0.0009s
  2677. -- remove_column(:users, :facts_andor)
  2678. -> 0.0005s
  2679. -- column_exists?(:users, :compute_resources_andor)
  2680. -> 0.0009s
  2681. -- remove_column(:users, :compute_resources_andor)
  2682. -> 0.0005s
  2683. -- column_exists?(:users, :organizations_andor)
  2684. -> 0.0010s
  2685. -- remove_column(:users, :organizations_andor)
  2686. -> 0.0005s
  2687. -- column_exists?(:users, :locations_andor)
  2688. -> 0.0009s
  2689. -- remove_column(:users, :locations_andor)
  2690. -> 0.0005s
  2691. -- column_exists?(:users, :filter_on_owner)
  2692. -> 0.0009s
  2693. -- remove_column(:users, :filter_on_owner)
  2694. -> 0.0003s
  2695. == CleanupUsersProperties: migrated (0.0114s) ================================
  2696.  
  2697. == RemoveUserJoinTables: migrating ===========================================
  2698. -- table_exists?(:user_compute_resources)
  2699. -> 0.0005s
  2700. -- remove_foreign_key("user_compute_resources", "users")
  2701. -> 0.0010s
  2702. -- remove_foreign_key("user_compute_resources", "compute_resources")
  2703. -> 0.0007s
  2704. -- drop_table(:user_compute_resources)
  2705. -> 0.0005s
  2706. -- table_exists?(:user_notices)
  2707. -> 0.0003s
  2708. -- remove_foreign_key("user_notices", "notices")
  2709. -> 0.0008s
  2710. -- remove_foreign_key("user_notices", "users")
  2711. -> 0.0008s
  2712. -- drop_table(:user_notices)
  2713. -> 0.0003s
  2714. -- table_exists?(:user_facts)
  2715. -> 0.0003s
  2716. -- remove_foreign_key("user_facts", "fact_names")
  2717. -> 0.0008s
  2718. -- remove_foreign_key("user_facts", "users")
  2719. -> 0.0007s
  2720. -- drop_table(:user_facts)
  2721. -> 0.0010s
  2722. -- table_exists?(:user_hostgroups)
  2723. -> 0.0003s
  2724. -- remove_foreign_key("user_hostgroups", "hostgroups")
  2725. -> 0.0008s
  2726. -- remove_foreign_key("user_hostgroups", "users")
  2727. -> 0.0007s
  2728. -- drop_table(:user_hostgroups)
  2729. -> 0.0008s
  2730. -- table_exists?(:user_domains)
  2731. -> 0.0003s
  2732. -- remove_foreign_key("user_domains", "domains")
  2733. -> 0.0008s
  2734. -- remove_foreign_key("user_domains", "users")
  2735. -> 0.0008s
  2736. -- drop_table(:user_domains)
  2737. -> 0.0003s
  2738. -- table_exists?(:notices)
  2739. -> 0.0003s
  2740. -- drop_table(:notices)
  2741. -> 0.0012s
  2742. == RemoveUserJoinTables: migrated (0.0150s) ==================================
  2743.  
  2744. == AddNextVersionToKatelloContentViews: migrating ============================
  2745. -- add_column(:katello_content_views, :next_version, :int, {:null=>false, :default=>1})
  2746. -> 0.0108s
  2747. == AddNextVersionToKatelloContentViews: migrated (0.3522s) ===================
  2748.  
  2749. == UpdateProductsAddOrganization: migrating ==================================
  2750. -- add_column(:katello_products, :organization_id, :integer, {:null=>true})
  2751. -> 0.0010s
  2752. -- change_column(:katello_products, :organization_id, :integer, {:null=>false})
  2753. -> 0.0129s
  2754. -- add_index(:katello_products, :organization_id)
  2755. -> 0.0048s
  2756. == UpdateProductsAddOrganization: migrated (0.0239s) =========================
  2757.  
  2758. == AddAnonymousProvidersToOrgs: migrating ====================================
  2759. == AddAnonymousProvidersToOrgs: migrated (0.0020s) ===========================
  2760.  
  2761. == AddHostIdToSystem: migrating ==============================================
  2762. -- add_column(:katello_systems, :host_id, :integer)
  2763. -> 0.0008s
  2764. -- add_index(:katello_systems, :host_id)
  2765. -> 0.0039s
  2766. -- add_foreign_key("katello_systems", "hosts", {:name=>"katello_systems_host_id", :column=>"host_id"})
  2767. -> 0.0019s
  2768. == AddHostIdToSystem: migrated (0.0068s) =====================================
  2769.  
  2770. == AddReleaseVersionToActivationKeys: migrating ==============================
  2771. -- add_column(:katello_activation_keys, :release_version, :string)
  2772. -> 0.0006s
  2773. == AddReleaseVersionToActivationKeys: migrated (0.0007s) =====================
  2774.  
  2775. == RenameSystemGroupsToHostCollections: migrating ============================
  2776. -- rename_index(:katello_key_system_groups, "katello_key_system_groups_pkey", "katello_key_host_collections_pkey")
  2777. -> 0.0005s
  2778. -- rename_index(:katello_key_system_groups, "index_key_system_groups_on_activation_key_id", "index_key_host_collections_on_activation_key_id")
  2779. -> 0.0003s
  2780. -- rename_index(:katello_key_system_groups, "index_key_system_groups_on_system_group_id", "index_key_host_collections_on_host_collection_id")
  2781. -> 0.0004s
  2782. -- rename_column(:katello_key_system_groups, :system_group_id, :host_collection_id)
  2783. -> 0.0004s
  2784. -- rename_table(:katello_key_system_groups, :katello_key_host_collections)
  2785. -> 0.0023s
  2786. -- rename_index(:katello_system_groups, "katello_system_groups_pkey", "katello_host_collections_pkey")
  2787. -> 0.0003s
  2788. -- rename_index(:katello_system_groups, "index_system_groups_on_name_and_organization_id", "index_host_collections_on_name_and_organization_id")
  2789. -> 0.0003s
  2790. -- rename_index(:katello_system_groups, "index_system_groups_on_organization_id", "index_host_collections_on_organization_id")
  2791. -> 0.0004s
  2792. -- rename_column(:katello_system_groups, :max_systems, :max_content_hosts)
  2793. -> 0.0003s
  2794. -- rename_table(:katello_system_groups, :katello_host_collections)
  2795. -> 0.0021s
  2796. -- rename_index(:katello_system_system_groups, "katello_system_system_groups_pkey", "katello_system_host_collections_pkey")
  2797. -> 0.0004s
  2798. -- rename_index(:katello_system_system_groups, "index_system_system_groups_on_system_group_id", "index_system_host_collections_on_host_collection_id")
  2799. -> 0.0003s
  2800. -- rename_index(:katello_system_system_groups, "index_system_system_groups_on_system_id", "index_system_host_collections_on_system_id")
  2801. -> 0.0004s
  2802. -- rename_column(:katello_system_system_groups, :system_group_id, :host_collection_id)
  2803. -> 0.0004s
  2804. -- rename_table(:katello_system_system_groups, :katello_system_host_collections)
  2805. -> 0.0021s
  2806. == RenameSystemGroupsToHostCollections: migrated (0.0117s) ===================
  2807.  
  2808. == UpdateHostCollectionsForeignKeys: migrating ===============================
  2809. -- remove_foreign_key("katello_key_host_collections", {:name=>"key_system_groups_activation_key_id_fk"})
  2810. -> 0.0008s
  2811. -- remove_foreign_key("katello_key_host_collections", {:name=>"key_system_groups_system_group_id_fk"})
  2812. -> 0.0007s
  2813. -- remove_foreign_key("katello_system_host_collections", {:name=>"system_system_groups_system_group_id_fk"})
  2814. -> 0.0006s
  2815. -- remove_foreign_key("katello_system_host_collections", {:name=>"system_system_groups_system_id_fk"})
  2816. -> 0.0007s
  2817. -- add_foreign_key("katello_key_host_collections", "katello_activation_keys", {:name=>"key_host_collections_activation_key_id_fk", :column=>"activation_key_id"})
  2818. -> 0.0017s
  2819. -- add_foreign_key("katello_key_host_collections", "katello_host_collections", {:name=>"key_host_collections_host_collection_id_fk", :column=>"host_collection_id"})
  2820. -> 0.0013s
  2821. -- add_foreign_key("katello_system_host_collections", "katello_host_collections", {:name=>"system_host_collections_host_collection_id_fk", :column=>"host_collection_id"})
  2822. -> 0.0012s
  2823. -- add_foreign_key("katello_system_host_collections", "katello_systems", {:name=>"system_host_collections_system_id_fk", :column=>"system_id"})
  2824. -> 0.0012s
  2825. == UpdateHostCollectionsForeignKeys: migrated (0.0089s) ======================
  2826.  
  2827. == CreateCapsuleLifecycleEnvironments: migrating =============================
  2828. -- create_table(:katello_capsule_lifecycle_environments)
  2829. NOTICE: CREATE TABLE will create implicit sequence "katello_capsule_lifecycle_environments_id_seq" for serial column "katello_capsule_lifecycle_environments.id"
  2830. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_capsule_lifecycle_environments_pkey" for table "katello_capsule_lifecycle_environments"
  2831. -> 0.0039s
  2832. -- add_index(:katello_capsule_lifecycle_environments, [:capsule_id], {:name=>:index_cle_on_capsule_id})
  2833. -> 0.0026s
  2834. -- add_index(:katello_capsule_lifecycle_environments, [:lifecycle_environment_id], {:name=>:index_cle_on_lifecycle_environment_id})
  2835. -> 0.0028s
  2836. == CreateCapsuleLifecycleEnvironments: migrated (0.0096s) ====================
  2837.  
  2838. == AddHiddenValueToParameter: migrating ======================================
  2839. -- add_column(:parameters, :hidden_value, :boolean, {:default=>false})
  2840. -> 0.0091s
  2841. == AddHiddenValueToParameter: migrated (0.0092s) =============================
  2842.  
  2843. == ChangeTemplatekindToBootdisk: migrating ===================================
  2844. == ChangeTemplatekindToBootdisk: migrated (0.0143s) ==========================
  2845.  
  2846. == PackageFilterAddOriginalPackages: migrating ===============================
  2847. -- add_column(:katello_content_view_filters, :original_packages, :boolean, {:default=>false, :null=>false})
  2848. -> 0.0299s
  2849. == PackageFilterAddOriginalPackages: migrated (0.0301s) ======================
  2850.  
  2851. == AddPulpProxyToHost: migrating =============================================
  2852. -- add_column(:hosts, :content_source_id, :integer)
  2853. -> 0.0010s
  2854. -- add_column(:hostgroups, :content_source_id, :integer)
  2855. -> 0.0005s
  2856. -- add_index(:hosts, :content_source_id)
  2857. -> 0.0110s
  2858. -- add_index(:hostgroups, :content_source_id)
  2859. -> 0.0064s
  2860. -- add_foreign_key(:hosts, :smart_proxies, {:name=>"hosts_content_source_id_fk", :column=>"content_source_id"})
  2861. -> 0.0016s
  2862. -- add_foreign_key(:hostgroups, :smart_proxies, {:name=>"hostgroups_content_source_id_fk", :column=>"content_source_id"})
  2863. -> 0.0012s
  2864. == AddPulpProxyToHost: migrated (0.0222s) ====================================
  2865.  
  2866. == ContentViewPuppetEnvironmentId: migrating =================================
  2867. -- add_column(:katello_content_view_puppet_environments, :puppet_environment_id, :integer, {:null=>true})
  2868. -> 0.0008s
  2869. -- add_foreign_key("katello_content_view_puppet_environments", "environments", {:name=>"katello_cvpe_pe_id", :column=>"puppet_environment_id"})
  2870. -> 0.0013s
  2871. == ContentViewPuppetEnvironmentId: migrated (0.0062s) ========================
  2872.  
  2873. == AddUuidToContentViewPackageGroupFilterRule: migrating =====================
  2874. -- add_column(:katello_content_view_package_group_filter_rules, :uuid, :string)
  2875. -> 0.0071s
  2876. == AddUuidToContentViewPackageGroupFilterRule: migrated (0.0072s) ============
  2877.  
  2878. == AddDescriptionToContentViewFilterRules: migrating =========================
  2879. -- add_column(:katello_content_view_filters, :description, :string)
  2880. -> 0.0007s
  2881. == AddDescriptionToContentViewFilterRules: migrated (0.0008s) ================
  2882.  
  2883. == DropTaxonomiesOwnerAutoAttachAllSystemsTaskIdColumn: migrating ============
  2884. -- remove_column(:taxonomies, :owner_auto_attach_all_systems_task_id)
  2885. -> 0.0006s
  2886. == DropTaxonomiesOwnerAutoAttachAllSystemsTaskIdColumn: migrated (0.0007s) ===
  2887.  
  2888. == FixIntegerSettings: migrating =============================================
  2889. == FixIntegerSettings: migrated (0.0012s) ====================================
  2890.  
  2891. == AddForeignKeysForOrganizations: migrating =================================
  2892. -- add_foreign_key(:katello_task_statuses, :taxonomies, {:name=>"katello_task_statuses_organization_fk", :column=>"organization_id"})
  2893. -> 0.0020s
  2894. -- add_foreign_key(:katello_sync_plans, :taxonomies, {:name=>"katello_sync_plans_organization_fk", :column=>"organization_id"})
  2895. -> 0.0012s
  2896. -- add_foreign_key(:katello_providers, :taxonomies, {:name=>"katello_providers_organization_fk", :column=>"organization_id"})
  2897. -> 0.0013s
  2898. -- add_foreign_key(:katello_gpg_keys, :taxonomies, {:name=>"katello_gpg_keys_organization_fk", :column=>"organization_id"})
  2899. -> 0.0011s
  2900. -- add_foreign_key(:katello_products, :taxonomies, {:name=>"katello_products_organization_fk", :column=>"organization_id"})
  2901. -> 0.0012s
  2902. -- add_foreign_key(:katello_activation_keys, :taxonomies, {:name=>"katello_activation_keys_organization_fk", :column=>"organization_id"})
  2903. -> 0.0012s
  2904. -- add_foreign_key(:katello_notices, :taxonomies, {:name=>"katello_notices_organization_fk", :column=>"organization_id"})
  2905. -> 0.0011s
  2906. -- add_foreign_key(:katello_host_collections, :taxonomies, {:name=>"katello_host_collections_organization_fk", :column=>"organization_id"})
  2907. -> 0.0015s
  2908. -- add_foreign_key(:katello_environments, :taxonomies, {:name=>"katello_environments_organization_fk", :column=>"organization_id"})
  2909. -> 0.0012s
  2910. == AddForeignKeysForOrganizations: migrated (0.0126s) ========================
  2911.  
  2912. == RemoveLabelFromActivationKey: migrating ===================================
  2913. -- remove_column(:katello_activation_keys, :label)
  2914. -> 0.0008s
  2915. == RemoveLabelFromActivationKey: migrated (0.0009s) ==========================
  2916.  
  2917. == AddMissingForeignKeys: migrating ==========================================
  2918. -- add_foreign_key(:katello_capsule_lifecycle_environments, :smart_proxies, {:name=>"katello_capsule_lifecycle_environments_capsule_fk", :column=>"capsule_id"})
  2919. -> 0.0017s
  2920. -- add_foreign_key(:katello_capsule_lifecycle_environments, :katello_environments, {:name=>"katello_capsule_lifecycle_environments_environment_fk", :column=>"lifecycle_environment_id"})
  2921. -> 0.0013s
  2922. -- add_foreign_key(:katello_repositories, :katello_environments, {:name=>"katello_repositories_environment_fk", :column=>"environment_id"})
  2923. -> 0.0012s
  2924. -- add_foreign_key(:katello_repositories, :katello_products, {:name=>"katello_repositories_product_fk", :column=>"product_id"})
  2925. -> 0.0013s
  2926. == AddMissingForeignKeys: migrated (0.0059s) =================================
  2927.  
  2928. == AddUnlimitedToActivationKeys: migrating ===================================
  2929. -- add_column(:katello_activation_keys, :unlimited_content_hosts, :boolean, {:default=>true})
  2930. -> 0.0420s
  2931. -- rename_column(:katello_activation_keys, :usage_limit, :max_content_hosts)
  2932. -> 0.0005s
  2933. -- change_column_default(:katello_activation_keys, :max_content_hosts, nil)
  2934. -> 0.0006s
  2935. -- update("UPDATE katello_activation_keys\n SET unlimited_content_hosts = true, max_content_hosts = null\n WHERE max_content_hosts = -1")
  2936. -> 0.0006s
  2937. -> 0 rows
  2938. -- update("UPDATE katello_activation_keys\n SET unlimited_content_hosts = false\n WHERE max_content_hosts > 0")
  2939. -> 0.0003s
  2940. -> 0 rows
  2941. == AddUnlimitedToActivationKeys: migrated (0.0443s) ==========================
  2942.  
  2943. == AddUnlimitedToHostCollection: migrating ===================================
  2944. -- add_column(:katello_host_collections, :unlimited_content_hosts, :boolean, {:default=>true})
  2945. -> 0.0221s
  2946. -- change_column(:katello_host_collections, :max_content_hosts, :integer, {:null=>true, :default=>nil})
  2947. -> 0.0269s
  2948. -- update("UPDATE katello_host_collections\n SET unlimited_content_hosts = true, max_content_hosts = null\n WHERE max_content_hosts = -1")
  2949. -> 0.0005s
  2950. -> 0 rows
  2951. -- update("UPDATE katello_host_collections\n SET unlimited_content_hosts = false\n WHERE max_content_hosts > 0")
  2952. -> 0.0003s
  2953. -> 0 rows
  2954. == AddUnlimitedToHostCollection: migrated (0.0504s) ==========================
  2955.  
  2956. == AddBootModeToSubnet: migrating ============================================
  2957. -- add_column(:subnets, :boot_mode, :string, {:default=>"Static", :null=>false})
  2958. -> 0.0112s
  2959. == AddBootModeToSubnet: migrated (0.0152s) ===================================
  2960.  
  2961. == AddLockedAndDefaultAndVendorToConfigTemplate: migrating ===================
  2962. -- add_column(:config_templates, :locked, :boolean, {:default=>false})
  2963. -> 0.0127s
  2964. -- add_column(:config_templates, :default, :boolean, {:default=>false})
  2965. -> 0.0148s
  2966. -- add_column(:config_templates, :vendor, :string)
  2967. -> 0.0005s
  2968. == AddLockedAndDefaultAndVendorToConfigTemplate: migrated (0.0283s) ==========
  2969.  
  2970. == RemoveArchitectureDefault: migrating ======================================
  2971. -- change_column(:architectures, :name, :string, {:default=>nil})
  2972. -> 0.0054s
  2973. == RemoveArchitectureDefault: migrated (0.0055s) =============================
  2974.  
  2975. == LocationAddKatelloDefault: migrating ======================================
  2976. -- add_column(:taxonomies, :katello_default, :boolean, {:null=>false, :default=>true})
  2977. -> 0.0306s
  2978. == LocationAddKatelloDefault: migrated (0.0307s) =============================
  2979.  
  2980. == RemoveDeletionTaskIdFromTaxonomies: migrating =============================
  2981. -- remove_column(:taxonomies, :deletion_task_id)
  2982. -> 0.0012s
  2983. == RemoveDeletionTaskIdFromTaxonomies: migrated (0.0012s) ====================
  2984.  
  2985. == ExtractNicAttributes: migrating ===========================================
  2986. -- add_column(:nics, :provider, :string)
  2987. -> 0.0007s
  2988. -- add_column(:nics, :username, :string)
  2989. -> 0.0004s
  2990. -- add_column(:nics, :password, :string)
  2991. -> 0.0004s
  2992. -- Extracting serialized attributes
  2993. == ExtractNicAttributes: migrated (0.0033s) ==================================
  2994.  
  2995. == AddAttributesToNicBase: migrating =========================================
  2996. -- add_column(:nics, :virtual, :boolean, {:default=>false, :null=>false})
  2997. -> 0.0113s
  2998. -- add_column(:nics, :link, :boolean, {:default=>true, :null=>false})
  2999. -> 0.0104s
  3000. -- add_column(:nics, :identifier, :string)
  3001. -> 0.0004s
  3002. -- add_column(:nics, :tag, :string, {:default=>"", :null=>false})
  3003. -> 0.0099s
  3004. -- add_column(:nics, :physical_device, :string, {:default=>"", :null=>false})
  3005. -> 0.0105s
  3006. == AddAttributesToNicBase: migrated (0.0429s) ================================
  3007.  
  3008. == AddManagedToNics: migrating ===============================================
  3009. -- add_column(:nics, :managed, :boolean, {:default=>true})
  3010. -> 0.0125s
  3011. == AddManagedToNics: migrated (0.0126s) ======================================
  3012.  
  3013. == ChangeAuditableNameColumnToText: migrating ================================
  3014. -- change_column(:audits, :auditable_name, :text)
  3015. -> 0.0156s
  3016. == ChangeAuditableNameColumnToText: migrated (0.0157s) =======================
  3017.  
  3018. == RepoRenameFeedToUrl: migrating ============================================
  3019. -- rename_column(:katello_repositories, :feed, :url)
  3020. -> 0.0007s
  3021. == RepoRenameFeedToUrl: migrated (0.0008s) ===================================
  3022.  
  3023. == AddPrimaryInterfaceToHosts: migrating =====================================
  3024. -- add_column(:hosts, :primary_interface, :string)
  3025. -> 0.0007s
  3026. == AddPrimaryInterfaceToHosts: migrated (0.0009s) ============================
  3027.  
  3028. == AddIpSuggestionToSubnets: migrating =======================================
  3029. -- add_column(:subnets, :ipam, :boolean, {:default=>true})
  3030. -> 0.0067s
  3031. == AddIpSuggestionToSubnets: migrated (0.0068s) ==============================
  3032.  
  3033. == AddUniqueIndexToParameter: migrating ======================================
  3034. -- add_index(:parameters, [:type, :reference_id, :name], {:unique=>true})
  3035. -> 0.0045s
  3036. == AddUniqueIndexToParameter: migrated (0.0046s) =============================
  3037.  
  3038. == RemoveHiddenColumnFromUser: migrating =====================================
  3039. -- remove_column(:users, :hidden)
  3040. -> 0.0008s
  3041. == RemoveHiddenColumnFromUser: migrated (0.0009s) ============================
  3042.  
  3043. == RemoveDelayedJobs: migrating ==============================================
  3044. -- drop_table("delayed_jobs")
  3045. -> 0.0016s
  3046. == RemoveDelayedJobs: migrated (0.0017s) =====================================
  3047.  
  3048. == AddParentTaskId: migrating ================================================
  3049. -- add_column(:foreman_tasks_tasks, :parent_task_id, :string, {:index=>true})
  3050. -> 0.0007s
  3051. == AddParentTaskId: migrated (0.0008s) =======================================
  3052.  
  3053. == AddSyncPlanEnabledToSyncPlan: migrating ===================================
  3054. -- add_column(:katello_sync_plans, :enabled, :boolean, {:default=>true, :null=>false})
  3055. -> 0.0092s
  3056. == AddSyncPlanEnabledToSyncPlan: migrated (0.0093s) ==========================
  3057.  
  3058. == AddMergeOverridesAndAvoidDuplicatesToLookupKey: migrating =================
  3059. -- add_column(:lookup_keys, :merge_overrides, :boolean)
  3060. -> 0.0008s
  3061. -- add_column(:lookup_keys, :avoid_duplicates, :boolean)
  3062. -> 0.0004s
  3063. == AddMergeOverridesAndAvoidDuplicatesToLookupKey: migrated (0.0013s) ========
  3064.  
  3065. == FixCounters: migrating ====================================================
  3066. ** Invoke fix_cached_counters (first_time)
  3067. ** Invoke environment
  3068. ** Execute fix_cached_counters
  3069. Correcting cached counters: (this may take a few minutes)
  3070. Architecture corrected
  3071. Environment corrected
  3072. Operatingsystem corrected
  3073. Domain corrected
  3074. Realm corrected
  3075. Puppetclass corrected
  3076. Model corrected
  3077. ConfigGroup corrected
  3078. LookupKey corrected
  3079. == FixCounters: migrated (0.1594s) ===========================================
  3080.  
  3081. == ConvertIpamToString: migrating ============================================
  3082. -- add_column(:subnets, :ipam_tmp, :string, {:default=>"DHCP", :null=>false})
  3083. -> 0.0063s
  3084. -- remove_column(:subnets, :ipam)
  3085. -> 0.0006s
  3086. -- rename_column(:subnets, :ipam_tmp, :ipam)
  3087. -> 0.0004s
  3088. == ConvertIpamToString: migrated (0.0114s) ===================================
  3089.  
  3090. == RemoveSignoSetting: migrating =============================================
  3091. == RemoveSignoSetting: migrated (0.0008s) ====================================
  3092.  
  3093. == ChangeNilAdminUsersToFalse: migrating =====================================
  3094. -- change_column(:users, :admin, :boolean, {:null=>false, :default=>false})
  3095. -> 0.0079s
  3096. == ChangeNilAdminUsersToFalse: migrated (0.0100s) ============================
  3097.  
  3098. == AddBondAttributesToNicBase: migrating =====================================
  3099. -- add_column(:nics, :mode, :string, {:null=>false, :default=>"balance-rr"})
  3100. -> 0.0099s
  3101. -- add_column(:nics, :attached_devices, :string, {:default=>"", :null=>false})
  3102. -> 0.0104s
  3103. -- add_column(:nics, :bond_options, :string, {:default=>"", :null=>false})
  3104. -> 0.0119s
  3105. -- rename_column(:nics, :physical_device, :attached_to)
  3106. -> 0.0003s
  3107. == AddBondAttributesToNicBase: migrated (0.0329s) ============================
  3108.  
  3109. == MoveHostNicsToInterfaces: migrating =======================================
  3110. -- add_column(:nics, :primary, :boolean, {:default=>false})
  3111. -> 0.0106s
  3112. -- add_column(:nics, :provision, :boolean, {:default=>false})
  3113. -> 0.0504s
  3114. -- Migrating Host interfaces to standalone Interfaces
  3115. -- remove_column(:hosts, :ip)
  3116. -> 0.0004s
  3117. -- remove_column(:hosts, :mac)
  3118. -> 0.0005s
  3119. -- remove_column(:hosts, :primary_interface)
  3120. -> 0.0004s
  3121. -- remove_foreign_key(:hosts, {:name=>"hosts_subnet_id_fk"})
  3122. -> 0.0008s
  3123. -- remove_column(:hosts, :subnet_id)
  3124. -> 0.0003s
  3125. -- remove_foreign_key(:hosts, {:name=>"hosts_domain_id_fk"})
  3126. -> 0.0007s
  3127. -- remove_column(:hosts, :domain_id)
  3128. -> 0.0006s
  3129. == MoveHostNicsToInterfaces: migrated (0.0673s) ==============================
  3130.  
  3131. == AddPasswordHashToOperatingsystem: migrating ===============================
  3132. -- add_column(:operatingsystems, :password_hash, :string, {:default=>"MD5"})
  3133. -> 0.0074s
  3134. == AddPasswordHashToOperatingsystem: migrated (0.0075s) ======================
  3135.  
  3136. == AddGrubPasswordToHosts: migrating =========================================
  3137. -- add_column(:hosts, :grub_pass, :string, {:default=>""})
  3138. -> 0.0267s
  3139. == AddGrubPasswordToHosts: migrated (0.0268s) ================================
  3140.  
  3141. == AddGrubPasswordToHostgroup: migrating =====================================
  3142. -- add_column(:hostgroups, :grub_pass, :string, {:default=>""})
  3143. -> 0.0111s
  3144. == AddGrubPasswordToHostgroup: migrated (0.0112s) ============================
  3145.  
  3146. == AddShouldUsePuppetDefaultToLookupValueAndKey: migrating ===================
  3147. -- add_column(:lookup_values, :use_puppet_default, :boolean, {:default=>false})
  3148. -> 0.0085s
  3149. -- add_column(:lookup_keys, :use_puppet_default, :boolean)
  3150. -> 0.0004s
  3151. == AddShouldUsePuppetDefaultToLookupValueAndKey: migrated (0.0091s) ==========
  3152.  
  3153. == AddTitleToOs: migrating ===================================================
  3154. -- add_column(:operatingsystems, :title, :string)
  3155. -> 0.0006s
  3156. == AddTitleToOs: migrated (0.0030s) ==========================================
  3157.  
  3158. == AddDescriptionToContentViewVersions: migrating ============================
  3159. -- add_column(:katello_content_view_versions, :description, :text)
  3160. -> 0.0029s
  3161. == AddDescriptionToContentViewVersions: migrated (0.0030s) ===================
  3162.  
  3163. == CreateMailNotifications: migrating ========================================
  3164. -- create_table(:mail_notifications)
  3165. NOTICE: CREATE TABLE will create implicit sequence "mail_notifications_id_seq" for serial column "mail_notifications.id"
  3166. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "mail_notifications_pkey" for table "mail_notifications"
  3167. -> 0.0061s
  3168. == CreateMailNotifications: migrated (0.0062s) ===============================
  3169.  
  3170. == CreateUserMailNotifications: migrating ====================================
  3171. -- create_table(:user_mail_notifications)
  3172. NOTICE: CREATE TABLE will create implicit sequence "user_mail_notifications_id_seq" for serial column "user_mail_notifications.id"
  3173. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_mail_notifications_pkey" for table "user_mail_notifications"
  3174. -> 0.0042s
  3175. -- add_foreign_key(:user_mail_notifications, :users, {:name=>"user_mail_notifications_user_id_fk"})
  3176. -> 0.0015s
  3177. -- add_foreign_key(:user_mail_notifications, :mail_notifications, {:name=>"user_mail_notifications_mail_notification_id_fk"})
  3178. -> 0.0014s
  3179. == CreateUserMailNotifications: migrated (0.0073s) ===========================
  3180.  
  3181. == AddErrata: migrating ======================================================
  3182. -- create_table("katello_errata")
  3183. NOTICE: CREATE TABLE will create implicit sequence "katello_errata_id_seq" for serial column "katello_errata.id"
  3184. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_errata_pkey" for table "katello_errata"
  3185. -> 0.0059s
  3186. -- add_index(:katello_errata, :uuid, {:unique=>true})
  3187. -> 0.0029s
  3188. -- create_table("katello_erratum_packages")
  3189. NOTICE: CREATE TABLE will create implicit sequence "katello_erratum_packages_id_seq" for serial column "katello_erratum_packages.id"
  3190. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_erratum_packages_pkey" for table "katello_erratum_packages"
  3191. -> 0.0053s
  3192. -- add_index(:katello_erratum_packages, [:erratum_id, :nvrea, :name, :filename], {:unique=>true, :name=>"katello_erratum_packages_eid_nvrea_n_f"})
  3193. -> 0.0027s
  3194. -- add_foreign_key("katello_erratum_packages", "katello_errata", {:name=>"katello_erratum_packages_errata_id_fk", :column=>"erratum_id"})
  3195. -> 0.0013s
  3196. -- create_table("katello_erratum_cves")
  3197. NOTICE: CREATE TABLE will create implicit sequence "katello_erratum_cves_id_seq" for serial column "katello_erratum_cves.id"
  3198. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_erratum_cves_pkey" for table "katello_erratum_cves"
  3199. -> 0.0070s
  3200. -- add_index(:katello_erratum_cves, [:erratum_id, :cve_id, :href], {:unique=>true})
  3201. -> 0.0028s
  3202. -- add_foreign_key("katello_erratum_cves", "katello_errata", {:name=>"katello_erratum_cves_errata_id_fk", :column=>"erratum_id"})
  3203. -> 0.0012s
  3204. -- create_table("katello_erratum_bugzillas")
  3205. NOTICE: CREATE TABLE will create implicit sequence "katello_erratum_bugzillas_id_seq" for serial column "katello_erratum_bugzillas.id"
  3206. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_erratum_bugzillas_pkey" for table "katello_erratum_bugzillas"
  3207. -> 0.0058s
  3208. -- add_index(:katello_erratum_bugzillas, [:erratum_id, :bug_id, :href], {:unique=>true, :name=>"katello_erratum_bz_eid_bid_href"})
  3209. -> 0.0027s
  3210. -- add_foreign_key("katello_erratum_bugzillas", "katello_errata", {:name=>"katello_erratum_bugzillas_errata_id_fk", :column=>"erratum_id"})
  3211. -> 0.0014s
  3212. -- create_table("katello_repository_errata")
  3213. NOTICE: CREATE TABLE will create implicit sequence "katello_repository_errata_id_seq" for serial column "katello_repository_errata.id"
  3214. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_repository_errata_pkey" for table "katello_repository_errata"
  3215. -> 0.0037s
  3216. -- add_index(:katello_repository_errata, [:erratum_id, :repository_id], {:unique=>true})
  3217. -> 0.0026s
  3218. -- add_foreign_key("katello_repository_errata", "katello_errata", {:name=>"katello_repository_errata_errata_id_fk", :column=>"erratum_id"})
  3219. -> 0.0013s
  3220. -- add_foreign_key("katello_repository_errata", "katello_repositories", {:name=>"katello_repository_errata_repo_id_fk", :column=>"repository_id"})
  3221. -> 0.0013s
  3222. -- create_table("katello_system_errata")
  3223. NOTICE: CREATE TABLE will create implicit sequence "katello_system_errata_id_seq" for serial column "katello_system_errata.id"
  3224. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_errata_pkey" for table "katello_system_errata"
  3225. -> 0.0037s
  3226. -- add_index(:katello_system_errata, [:erratum_id, :system_id], {:unique=>true, :name=>:katello_system_errata_eid_sid})
  3227. -> 0.0027s
  3228. -- add_foreign_key("katello_system_errata", "katello_errata", {:name=>"katello_system_errata_errata_id", :column=>"erratum_id"})
  3229. -> 0.0013s
  3230. -- add_foreign_key("katello_system_errata", "katello_systems", {:name=>"katello_system_errata_system_id", :column=>"system_id"})
  3231. -> 0.0012s
  3232. == AddErrata: migrated (0.0583s) =============================================
  3233.  
  3234. == AddEmailToComputeResource: migrating ======================================
  3235. -- add_column(:compute_resources, :email, :string)
  3236. -> 0.0007s
  3237. == AddEmailToComputeResource: migrated (0.0008s) =============================
  3238.  
  3239. == AddMailEnabledToUser: migrating ===========================================
  3240. -- add_column(:users, :mail_enabled, :boolean, {:default=>true})
  3241. -> 0.0082s
  3242. == AddMailEnabledToUser: migrated (0.0084s) ==================================
  3243.  
  3244. == AddSystemRepository: migrating ============================================
  3245. -- create_table("katello_system_repositories")
  3246. NOTICE: CREATE TABLE will create implicit sequence "katello_system_repositories_id_seq" for serial column "katello_system_repositories.id"
  3247. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_system_repositories_pkey" for table "katello_system_repositories"
  3248. -> 0.0040s
  3249. -- add_index(:katello_system_repositories, [:system_id, :repository_id], {:unique=>true, :name=>:katello_system_repositories_sid_rid})
  3250. -> 0.0029s
  3251. -- add_foreign_key("katello_system_repositories", "katello_systems", {:name=>"katello_system_repositories_system_id_fk", :column=>"system_id"})
  3252. -> 0.0014s
  3253. -- add_foreign_key("katello_system_repositories", "katello_repositories", {:name=>"katello_system_repositories_repo_id_fk", :column=>"repository_id"})
  3254. -> 0.0014s
  3255. == AddSystemRepository: migrated (0.0100s) ===================================
  3256.  
  3257. == AddDockerContainerRegistryUrlToProviders: migrating =======================
  3258. -- add_column(:katello_providers, :docker_registry_url, :string)
  3259. -> 0.0007s
  3260. == AddDockerContainerRegistryUrlToProviders: migrated (0.1681s) ==============
  3261.  
  3262. == CreateContainers: migrating ===============================================
  3263. -- create_table(:containers)
  3264. NOTICE: CREATE TABLE will create implicit sequence "containers_id_seq" for serial column "containers.id"
  3265. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "containers_pkey" for table "containers"
  3266. -> 0.0089s
  3267. == CreateContainers: migrated (0.0090s) ======================================
  3268.  
  3269. == AddComputeResourceIdToContainer: migrating ================================
  3270. -- add_column(:containers, :compute_resource_id, :integer)
  3271. -> 0.0007s
  3272. == AddComputeResourceIdToContainer: migrated (0.0010s) =======================
  3273.  
  3274. == AddTagToContainer: migrating ==============================================
  3275. -- add_column(:containers, :tag, :string)
  3276. -> 0.0010s
  3277. == AddTagToContainer: migrated (0.0011s) =====================================
  3278.  
  3279. == AddAttributesToContainer: migrating =======================================
  3280. -- add_column(:containers, :entrypoint, :string)
  3281. -> 0.0010s
  3282. -- add_column(:containers, :cpu_set, :integer)
  3283. -> 0.0006s
  3284. -- add_column(:containers, :cpu_shares, :float)
  3285. -> 0.0006s
  3286. -- add_column(:containers, :memory, :integer)
  3287. -> 0.0006s
  3288. -- add_column(:containers, :tty, :boolean)
  3289. -> 0.0006s
  3290. -- add_column(:containers, :attach_stdin, :boolean, {:default=>true})
  3291. -> 0.0071s
  3292. -- add_column(:containers, :attach_stdout, :boolean, {:default=>true})
  3293. -> 0.0073s
  3294. -- add_column(:containers, :attach_stderr, :boolean, {:default=>true})
  3295. -> 0.0063s
  3296. == AddAttributesToContainer: migrated (0.0249s) ==============================
  3297.  
  3298. == CreateDockerImages: migrating =============================================
  3299. -- create_table(:docker_images)
  3300. NOTICE: CREATE TABLE will create implicit sequence "docker_images_id_seq" for serial column "docker_images.id"
  3301. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_images_pkey" for table "docker_images"
  3302. -> 0.0053s
  3303. -- create_table(:docker_tags)
  3304. NOTICE: CREATE TABLE will create implicit sequence "docker_tags_id_seq" for serial column "docker_tags.id"
  3305. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_tags_pkey" for table "docker_tags"
  3306. -> 0.0038s
  3307. -- add_foreign_key(:docker_tags, :docker_images, {:column=>:docker_image_id})
  3308. -> 0.0013s
  3309. -- remove_column(:containers, :image)
  3310. -> 0.0004s
  3311. -- remove_column(:containers, :tag)
  3312. -> 0.0004s
  3313. -- add_column(:containers, :docker_image_id, :integer)
  3314. -> 0.0005s
  3315. -- add_column(:containers, :docker_tag_id, :integer)
  3316. -> 0.0003s
  3317. -- add_foreign_key(:containers, :docker_images, {:column=>:docker_image_id})
  3318. -> 0.0012s
  3319. -- add_foreign_key(:containers, :docker_tags, {:column=>:docker_tag_id})
  3320. -> 0.0012s
  3321. == CreateDockerImages: migrated (0.0149s) ====================================
  3322.  
  3323. == AddSubscriptionTypeToMailNotifications: migrating =========================
  3324. -- add_column(:mail_notifications, :subscription_type, :string)
  3325. -> 0.0010s
  3326. == AddSubscriptionTypeToMailNotifications: migrated (0.0011s) ================
  3327.  
  3328. == RemoveFailedReportSetting: migrating ======================================
  3329. == RemoveFailedReportSetting: migrated (0.0007s) =============================
  3330.  
  3331. == AddDockerImageFields: migrating ===========================================
  3332. -- add_column(:docker_images, :katello_uuid, :string)
  3333. -> 0.0027s
  3334. -- add_column(:docker_images, :katello_repository_id, :integer)
  3335. -> 0.0003s
  3336. -- add_column(:docker_tags, :katello_repository_id, :integer)
  3337. -> 0.0004s
  3338. -- create_table(:katello_repository_docker_images)
  3339. NOTICE: CREATE TABLE will create implicit sequence "katello_repository_docker_images_id_seq" for serial column "katello_repository_docker_images.id"
  3340. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_repository_docker_images_pkey" for table "katello_repository_docker_images"
  3341. -> 0.0034s
  3342. -- add_index(:docker_images, :katello_uuid, {:unique=>true})
  3343. -> 0.0028s
  3344. -- add_index(:katello_repository_docker_images, [:docker_image_id, :repository_id], {:name=>:katello_repo_docker_imgs_image_repo_id, :unique=>true})
  3345. -> 0.0028s
  3346. -- add_index(:docker_tags, [:docker_image_id, :katello_repository_id, :tag], {:name=>:katello_repo_docker_tags_image_repo_id, :unique=>true})
  3347. -> 0.0026s
  3348. -- add_foreign_key(:katello_repository_docker_images, :docker_images, {:column=>:docker_image_id})
  3349. -> 0.0013s
  3350. -- add_foreign_key(:katello_repository_docker_images, :katello_repositories, {:column=>:repository_id})
  3351. -> 0.0013s
  3352. -- add_foreign_key(:docker_tags, :katello_repositories, {:column=>:katello_repository_id})
  3353. -> 0.0013s
  3354. == AddDockerImageFields: migrated (0.0196s) ==================================
  3355.  
  3356. == AddUuidToContainers: migrating ============================================
  3357. -- add_column(:containers, :uuid, :string)
  3358. -> 0.0007s
  3359. -- add_index(:containers, [:uuid, :compute_resource_id])
  3360. -> 0.0034s
  3361. == AddUuidToContainers: migrated (0.0043s) ===================================
  3362.  
  3363. == RenameSubnetNameToUnique: migrating =======================================
  3364. == RenameSubnetNameToUnique: migrated (0.0013s) ==============================
  3365.  
  3366. == AddTimezoneToUser: migrating ==============================================
  3367. -- add_column(:users, :timezone, :string)
  3368. -> 0.0008s
  3369. == AddTimezoneToUser: migrated (0.0009s) =====================================
  3370.  
  3371. == CreateDockerRegistries: migrating =========================================
  3372. -- create_table(:docker_registries)
  3373. NOTICE: CREATE TABLE will create implicit sequence "docker_registries_id_seq" for serial column "docker_registries.id"
  3374. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_registries_pkey" for table "docker_registries"
  3375. -> 0.0061s
  3376. -- create_table(:docker_image_docker_registries)
  3377. NOTICE: CREATE TABLE will create implicit sequence "docker_image_docker_registries_id_seq" for serial column "docker_image_docker_registries.id"
  3378. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_image_docker_registries_pkey" for table "docker_image_docker_registries"
  3379. -> 0.0035s
  3380. -- add_index(:docker_image_docker_registries, [:docker_registry_id, :docker_image_id], {:name=>"by_docker_image_and_registry", :unique=>true})
  3381. -> 0.0028s
  3382. == CreateDockerRegistries: migrated (0.0126s) ================================
  3383.  
  3384. == ChangeMemoryInContainer: migrating ========================================
  3385. -- change_column(:containers, :memory, :string)
  3386. -> 0.0074s
  3387. == ChangeMemoryInContainer: migrated (0.0075s) ===============================
  3388.  
  3389. == ChangeCpusetInContainer: migrating ========================================
  3390. -- change_column(:containers, :cpu_set, :string)
  3391. -> 0.0074s
  3392. == ChangeCpusetInContainer: migrated (0.0076s) ===============================
  3393.  
  3394. == AddTagRepositoryIdIndex: migrating ========================================
  3395. -- add_index(:docker_tags, [:tag, :katello_repository_id], {:name=>:katello_docker_tag_repository_id, :unique=>true})
  3396. -> 0.0041s
  3397. == AddTagRepositoryIdIndex: migrated (0.0042s) ===============================
  3398.  
  3399. == CreateDiscoveryRules: migrating ===========================================
  3400. -- create_table(:discovery_rules)
  3401. NOTICE: CREATE TABLE will create implicit sequence "discovery_rules_id_seq" for serial column "discovery_rules.id"
  3402. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "discovery_rules_pkey" for table "discovery_rules"
  3403. -> 0.0064s
  3404. == CreateDiscoveryRules: migrated (0.0065s) ==================================
  3405.  
  3406. == AddDiscoveryRuleToHost: migrating =========================================
  3407. -- add_column(:hosts, :discovery_rule_id, :integer)
  3408. -> 0.0008s
  3409. == AddDiscoveryRuleToHost: migrated (0.0009s) ================================
  3410.  
  3411. == RenameHostsCountColumn: migrating =========================================
  3412. -- rename_column(:puppetclasses, :hosts_count, :total_hosts)
  3413. -> 0.0005s
  3414. == RenameHostsCountColumn: migrated (0.0006s) ================================
  3415.  
  3416. == FixPuppetclassTotalHosts: migrating =======================================
  3417. ** Invoke puppet:fix_total_hosts (first_time)
  3418. ** Invoke environment
  3419. ** Execute puppet:fix_total_hosts
  3420. == FixPuppetclassTotalHosts: migrated (0.0014s) ==============================
  3421.  
  3422. == AddTypeToParameterIndex: migrating ========================================
  3423. -- index_exists?(:parameters, [:reference_id, :name], {:unique=>true})
  3424. -> 0.0019s
  3425. == AddTypeToParameterIndex: migrated (0.0020s) ===============================
  3426.  
  3427. == AddAutoAttachToActivationKeys: migrating ==================================
  3428. -- add_column(:katello_activation_keys, :auto_attach, :boolean)
  3429. -> 0.0008s
  3430. == AddAutoAttachToActivationKeys: migrated (0.0009s) =========================
  3431.  
  3432. == AddUserCredentialsToDockerRegistries: migrating ===========================
  3433. -- add_column(:docker_registries, :username, :string)
  3434. -> 0.0006s
  3435. -- add_column(:docker_registries, :password, :string)
  3436. -> 0.0004s
  3437. == AddUserCredentialsToDockerRegistries: migrated (0.0011s) ==================
  3438.  
  3439. == RemoveAuditUserFk: migrating ==============================================
  3440. -- remove_foreign_key(:audits, :user)
  3441. -> 0.0010s
  3442. == RemoveAuditUserFk: migrated (0.0011s) =====================================
  3443.  
  3444. == RenameSmartProxyAuthRelatedSettings: migrating ============================
  3445. == RenameSmartProxyAuthRelatedSettings: migrated (0.0000s) ===================
  3446.  
  3447. == ContentViewVersionAddMinor: migrating =====================================
  3448. -- add_column(:katello_content_view_versions, :minor, :integer, {:null=>false, :default=>0})
  3449. -> 0.0081s
  3450. -- rename_column(:katello_content_view_versions, :version, :major)
  3451. -> 0.0005s
  3452. == ContentViewVersionAddMinor: migrated (0.0088s) ============================
  3453.  
  3454. == AddDiscoveryIdToSubnet: migrating =========================================
  3455. -- add_column(:subnets, :discovery_id, :integer)
  3456. -> 0.0008s
  3457. == AddDiscoveryIdToSubnet: migrated (0.0009s) ================================
  3458.  
  3459. == MakeTemplatesDefault: migrating ===========================================
  3460. == MakeTemplatesDefault: migrated (0.0229s) ==================================
  3461.  
  3462. == AddTimestampsToRepositoryJoinTables: migrating ============================
  3463. -- change_table(:katello_repository_errata)
  3464. -> 0.0011s
  3465. -- change_table(:katello_repository_docker_images)
  3466. -> 0.0007s
  3467. == AddTimestampsToRepositoryJoinTables: migrated (0.0020s) ===================
  3468.  
  3469. == AddDefaultValueToAutoAttach: migrating ====================================
  3470. -- change_column(:katello_activation_keys, :auto_attach, :boolean, {:default=>true})
  3471. -> 0.0270s
  3472. == AddDefaultValueToAutoAttach: migrated (0.0271s) ===========================
  3473.  
  3474. == DisownForemanTemplates: migrating =========================================
  3475. == DisownForemanTemplates: migrated (0.0043s) ================================
  3476.  
  3477. == RemoveDockerTables: migrating =============================================
  3478. -- change_table(:containers)
  3479. -> 0.0014s
  3480. -- remove_foreign_key(:containers, {:name=>:containers_docker_image_id_fk})
  3481. -> 0.0007s
  3482. -- remove_foreign_key(:containers, {:name=>:containers_docker_tag_id_fk})
  3483. -> 0.0007s
  3484. -- remove_column(:containers, :docker_image_id)
  3485. -> 0.0004s
  3486. -- remove_column(:containers, :docker_tag_id)
  3487. -> 0.0003s
  3488. -- execute("DROP TABLE docker_images CASCADE")
  3489. NOTICE: drop cascades to 2 other objects
  3490. DETAIL: drop cascades to constraint docker_tags_docker_image_id_fk on table docker_tags
  3491. drop cascades to constraint katello_repository_docker_images_docker_image_id_fk on table katello_repository_docker_images
  3492. -> 0.0021s
  3493. -- execute("DROP TABLE docker_tags CASCADE")
  3494. -> 0.0015s
  3495. -- execute("DROP TABLE docker_image_docker_registries CASCADE")
  3496. -> 0.0010s
  3497. == RemoveDockerTables: migrated (0.0133s) ====================================
  3498.  
  3499. == CreateDockerTables: migrating =============================================
  3500. -- create_table(:katello_docker_images)
  3501. NOTICE: CREATE TABLE will create implicit sequence "katello_docker_images_id_seq" for serial column "katello_docker_images.id"
  3502. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_docker_images_pkey" for table "katello_docker_images"
  3503. -> 0.0075s
  3504. -- create_table(:katello_docker_tags)
  3505. NOTICE: CREATE TABLE will create implicit sequence "katello_docker_tags_id_seq" for serial column "katello_docker_tags.id"
  3506. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_docker_tags_pkey" for table "katello_docker_tags"
  3507. -> 0.0037s
  3508. -- add_index(:katello_docker_images, :uuid, {:unique=>true})
  3509. -> 0.0030s
  3510. -- add_foreign_key(:katello_docker_tags, :katello_docker_images, {:column=>"docker_image_id"})
  3511. -> 0.0013s
  3512. -- add_foreign_key(:katello_docker_tags, :katello_repositories, {:column=>"repository_id"})
  3513. -> 0.0014s
  3514. -- add_index(:katello_docker_tags, [:docker_image_id, :repository_id, :name], {:name=>:docker_tag_docker_image_repo_name, :unique=>true})
  3515. -> 0.0029s
  3516. -- add_foreign_key(:katello_repository_docker_images, :katello_docker_images, {:column=>:docker_image_id})
  3517. -> 0.0014s
  3518. == CreateDockerTables: migrated (0.0219s) ====================================
  3519.  
  3520. == TrackVersionComponents: migrating =========================================
  3521. -- create_table("katello_content_view_version_components")
  3522. NOTICE: CREATE TABLE will create implicit sequence "katello_content_view_version_components_id_seq" for serial column "katello_content_view_version_components.id"
  3523. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "katello_content_view_version_components_pkey" for table "katello_content_view_version_components"
  3524. -> 0.0046s
  3525. -- add_index(:katello_content_view_version_components, [:component_version_id, :composite_version_id], {:unique=>true, :name=>:katello_cvv_components_cid_cid_unq})
  3526. -> 0.0027s
  3527. -- add_foreign_key("katello_content_view_version_components", "katello_content_view_versions", {:name=>"katello_cvv_components_component_fk", :column=>"component_version_id"})
  3528. -> 0.0014s
  3529. -- add_foreign_key("katello_content_view_version_components", "katello_content_view_versions", {:name=>"katello_cvv_components_composite_fk", :column=>"composite_version_id"})
  3530. -> 0.0012s
  3531. == TrackVersionComponents: migrated (0.0103s) ================================
  3532.  
  3533. == AddComputeAttributesToNics: migrating =====================================
  3534. -- add_column(:nics, :compute_attributes, :text)
  3535. -> 0.0007s
  3536. == AddComputeAttributesToNics: migrated (0.0008s) ============================
  3537.  
  3538. == CreateWizardStates: migrating =============================================
  3539. -- create_table(:docker_container_wizard_states)
  3540. NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_id_seq" for serial column "docker_container_wizard_states.id"
  3541. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_pkey" for table "docker_container_wizard_states"
  3542. -> 0.0043s
  3543. -- create_table(:docker_container_wizard_states_preliminaries)
  3544. NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_preliminaries_id_seq" for serial column "docker_container_wizard_states_preliminaries.id"
  3545. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_preliminaries_pkey" for table "docker_container_wizard_states_preliminaries"
  3546. -> 0.0037s
  3547. -- create_table(:docker_container_wizard_states_images)
  3548. NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_images_id_seq" for serial column "docker_container_wizard_states_images.id"
  3549. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_images_pkey" for table "docker_container_wizard_states_images"
  3550. -> 0.0061s
  3551. -- create_table(:docker_container_wizard_states_configurations)
  3552. NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_configurations_id_seq" for serial column "docker_container_wizard_states_configurations.id"
  3553. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_configurations_pkey" for table "docker_container_wizard_states_configurations"
  3554. -> 0.0061s
  3555. -- create_table(:docker_container_wizard_states_environments)
  3556. NOTICE: CREATE TABLE will create implicit sequence "docker_container_wizard_states_environments_id_seq" for serial column "docker_container_wizard_states_environments.id"
  3557. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docker_container_wizard_states_environments_pkey" for table "docker_container_wizard_states_environments"
  3558. -> 0.0048s
  3559. == CreateWizardStates: migrated (0.0254s) ====================================
  3560.  
  3561. == AddHostContentViewEnvironment: migrating ==================================
  3562. -- add_column(:hosts, :content_view_id, :integer, {:null=>true})
  3563. -> 0.0008s
  3564. -- add_column(:hosts, :lifecycle_environment_id, :integer, {:null=>true})
  3565. -> 0.0004s
  3566. -- add_column(:hostgroups, :content_view_id, :integer, {:null=>true})
  3567. -> 0.0004s
  3568. -- add_column(:hostgroups, :lifecycle_environment_id, :integer, {:null=>true})
  3569. -> 0.0004s
  3570. == AddHostContentViewEnvironment: migrated (0.0083s) =========================
  3571.  
  3572. == CreateDiscoveryAttributeSets: migrating ===================================
  3573. -- create_table(:discovery_attribute_sets)
  3574. NOTICE: CREATE TABLE will create implicit sequence "discovery_attribute_sets_id_seq" for serial column "discovery_attribute_sets.id"
  3575. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "discovery_attribute_sets_pkey" for table "discovery_attribute_sets"
  3576. -> 0.0047s
  3577. -- add_index(:discovery_attribute_sets, :host_id)
  3578. -> 0.0028s
  3579. -- add_foreign_key("discovery_attribute_sets", "hosts", {:name=>"discovery_attribute_sets_host_id_fk"})
  3580. -> 0.0020s
  3581. == CreateDiscoveryAttributeSets: migrated (0.0097s) ==========================
  3582.  
  3583. == FillDiscoveryAttributeSetsForExistingHosts: migrating =====================
  3584. == FillDiscoveryAttributeSetsForExistingHosts: migrated (0.1384s) ============
  3585.  
  3586. == AddDescriptionToTaxonomies: migrating =====================================
  3587. -- column_exists?(:taxonomies, :description)
  3588. -> 0.0013s
  3589. == AddDescriptionToTaxonomies: migrated (0.0014s) ============================
  3590.  
  3591. == AddCapsuleIdToContainer: migrating ========================================
  3592. -- add_column(:containers, :capsule_id, :integer)
  3593. -> 0.0008s
  3594. -- add_foreign_key(:containers, :smart_proxies, {:column=>"capsule_id"})
  3595. -> 0.0015s
  3596. -- add_column(:docker_container_wizard_states_images, :capsule_id, :integer)
  3597. -> 0.0005s
  3598. == AddCapsuleIdToContainer: migrated (0.0030s) ===============================
  3599.  
  3600. == ActuallyRenameSmartProxyAuthRelatedSettings: migrating ====================
  3601. == ActuallyRenameSmartProxyAuthRelatedSettings: migrated (0.0019s) ===========
  3602.  
  3603. == AddUpstreamNameToRepository: migrating ====================================
  3604. -- add_column(:katello_repositories, :docker_upstream_name, :string)
  3605. -> 0.0009s
  3606. == AddUpstreamNameToRepository: migrated (0.3548s) ===========================
  3607.  
  3608. == UpdatePromoteErrataEmailDescription: migrating ============================
  3609. == UpdatePromoteErrataEmailDescription: migrated (0.0169s) ===================
  3610.  
  3611. == AddKatelloFlagToDockerWizardImage: migrating ==============================
  3612. -- add_column(:docker_container_wizard_states_images, :katello, :boolean)
  3613. -> 0.0007s
  3614. == AddKatelloFlagToDockerWizardImage: migrated (0.0008s) =====================
  3615.  
  3616. == SetPtableLayoutToText: migrating ==========================================
  3617. -- change_column(:ptables, :layout, :text, {:null=>false})
  3618. -> 0.0055s
  3619. == SetPtableLayoutToText: migrated (0.0056s) =================================
  3620.  
  3621. == AddKatelloFlagToContainers: migrating =====================================
  3622. -- add_column(:containers, :katello, :boolean)
  3623. -> 0.0005s
  3624. == AddKatelloFlagToContainers: migrated (0.0007s) ============================
  3625.  
  3626. == MoveDescriptionFieldsToText: migrating ====================================
  3627. -- change_column(:compute_resources, :description, :text)
  3628. -> 0.0056s
  3629. -- change_column(:operatingsystems, :description, :text)
  3630. -> 0.0067s
  3631. -- change_column(:lookup_keys, :description, :text)
  3632. -> 0.0224s
  3633. -- change_column(:mail_notifications, :description, :text)
  3634. -> 0.0077s
  3635. == MoveDescriptionFieldsToText: migrated (0.0428s) ===========================
  3636.  
  3637. == ChangeDefaultSubnetBootMode: migrating ====================================
  3638. -- change_column(:subnets, :boot_mode, :string, {:default=>"DHCP"})
  3639. -> 0.0068s
  3640. == ChangeDefaultSubnetBootMode: migrated (0.0069s) ===========================
  3641.  
  3642. == ChangeDescriptionsToTextFields: migrating =================================
  3643. -- change_column(:katello_content_view_filters, :description, :text)
  3644. -> 0.0082s
  3645. -- change_column(:katello_content_views, :description, :text)
  3646. -> 0.0097s
  3647. == ChangeDescriptionsToTextFields: migrated (0.0181s) ========================
  3648.  
  3649. == RemoveDuplicateTokensFromHosts: migrating =================================
  3650. == RemoveDuplicateTokensFromHosts: migrated (0.0026s) ========================
  3651.  
  3652. == RemoveKatelloFlagFromContainers: migrating ================================
  3653. -- remove_column(:containers, :katello)
  3654. -> 0.0007s
  3655. == RemoveKatelloFlagFromContainers: migrated (0.0008s) =======================
  3656.  
  3657. == AddContentHostIdToSmartProxy: migrating ===================================
  3658. -- add_column(:smart_proxies, :content_host_id, :integer)
  3659. -> 0.0006s
  3660. -- add_foreign_key(:smart_proxies, :katello_systems, {:column=>"content_host_id"})
  3661. -> 0.0015s
  3662. == AddContentHostIdToSmartProxy: migrated (0.0062s) ==========================
  3663.  
  3664. == AddIndexToLogsSourceId: migrating =========================================
  3665. -- add_index(:logs, :source_id)
  3666. -> 0.0042s
  3667. == AddIndexToLogsSourceId: migrated (0.0043s) ================================
  3668.  
  3669. == CopyUnmanagedHostsToInterfaces: migrating =================================
  3670. -- Migrating Unmanaged Host interfaces to standalone Interfaces
  3671. == CopyUnmanagedHostsToInterfaces: migrated (0.0025s) ========================
  3672.  
  3673. == AddUsergroupSyncToAuthSources: migrating ==================================
  3674. -- add_column(:auth_sources, :usergroup_sync, :boolean, {:null=>false, :default=>true})
  3675. -> 0.0060s
  3676. == AddUsergroupSyncToAuthSources: migrated (0.0061s) =========================
  3677.  
  3678. ** Invoke db:_dump (first_time)
  3679. ** Execute db:_dump
  3680. ** Invoke db:schema:dump (first_time)
  3681. ** Invoke environment
  3682. ** Invoke db:load_config
  3683. ** Execute db:schema:dump
  3684. ** Invoke fix_db_cache (first_time)
  3685. ** Invoke environment
  3686. ** Execute fix_db_cache
  3687. Recreating cache
Advertisement
Add Comment
Please, Sign In to add comment