API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 5th, 2013
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 57.38 KB | None | 0 0
raw download clone embed print report
  1. [root@zzzap foreman]# rake db:migrate
  2. Warning: fuzzy message was used.
  3. : msgid 'User'
  4. Warning: fuzzy message was used.
  5. : msgid 'Users'
  6. == CreateHosts: migrating ====================================================
  7. NOTICE: CREATE TABLE will create implicit sequence "resources_id_seq" for serial column "resources.id"
  8. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "resources_pkey" for table "resources"
  9. NOTICE: CREATE TABLE will create implicit sequence "source_files_id_seq" for serial column "source_files.id"
  10. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "source_files_pkey" for table "source_files"
  11. NOTICE: CREATE TABLE will create implicit sequence "resource_tags_id_seq" for serial column "resource_tags.id"
  12. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "resource_tags_pkey" for table "resource_tags"
  13. NOTICE: CREATE TABLE will create implicit sequence "puppet_tags_id_seq" for serial column "puppet_tags.id"
  14. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "puppet_tags_pkey" for table "puppet_tags"
  15. NOTICE: CREATE TABLE will create implicit sequence "hosts_id_seq" for serial column "hosts.id"
  16. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "hosts_pkey" for table "hosts"
  17. NOTICE: CREATE TABLE will create implicit sequence "fact_names_id_seq" for serial column "fact_names.id"
  18. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "fact_names_pkey" for table "fact_names"
  19. NOTICE: CREATE TABLE will create implicit sequence "fact_values_id_seq" for serial column "fact_values.id"
  20. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "fact_values_pkey" for table "fact_values"
  21. NOTICE: CREATE TABLE will create implicit sequence "param_values_id_seq" for serial column "param_values.id"
  22. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "param_values_pkey" for table "param_values"
  23. NOTICE: CREATE TABLE will create implicit sequence "param_names_id_seq" for serial column "param_names.id"
  24. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "param_names_pkey" for table "param_names"
  25. NOTICE: CREATE TABLE will create implicit sequence "inventory_nodes_id_seq" for serial column "inventory_nodes.id"
  26. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "inventory_nodes_pkey" for table "inventory_nodes"
  27. NOTICE: CREATE TABLE will create implicit sequence "inventory_facts_id_seq" for serial column "inventory_facts.id"
  28. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "inventory_facts_pkey" for table "inventory_facts"
  29. == AddCreatedAtToAllTables: migrating ========================================
  30. -- add_column("schema_migrations", :created_at, :datetime)
  31. -> 0.0010s
  32. -- add_column("inventory_facts", :created_at, :datetime)
  33. -> 0.0009s
  34. == AddCreatedAtToAllTables: migrated (0.0173s) ===============================
  35.  
  36. == RemoveDuplicatedIndexOnAllTables: migrating ===============================
  37. == RemoveDuplicatedIndexOnAllTables: migrated (0.0259s) ======================
  38.  
  39. == AddEnvironmentToHost: migrating ===========================================
  40. == AddEnvironmentToHost: migrated (0.0013s) ==================================
  41.  
  42. == AddInventoryServiceTables: migrating ======================================
  43. == AddInventoryServiceTables: migrated (0.0020s) =============================
  44.  
  45. -- add_column(:hosts, :mac, :string, {:limit=>17, :default=>""})
  46. -> 0.1024s
  47. -- add_column(:hosts, :sp_mac, :string, {:limit=>17, :default=>""})
  48. -> 0.1174s
  49. -- add_column(:hosts, :sp_ip, :string, {:limit=>15, :default=>""})
  50. -> 0.1257s
  51. -- add_column(:hosts, :sp_name, :string, {:default=>""})
  52. -> 0.0924s
  53. -- add_column(:hosts, :root_pass, :string, {:limit=>64})
  54. -> 0.0008s
  55. -- add_column(:hosts, :serial, :string, {:limit=>12})
  56. -> 0.0008s
  57. -- add_column(:hosts, :puppetmaster, :string)
  58. -> 0.0008s
  59. -- add_column(:hosts, :puppet_status, :integer, {:null=>false, :default=>0})
  60. -> 0.1316s
  61. -- add_column(:hosts, :domain_id, :integer)
  62. -> 0.0009s
  63. -- add_column(:hosts, :architecture_id, :integer)
  64. -> 0.0007s
  65. -- add_column(:hosts, :operatingsystem_id, :integer)
  66. -> 0.0008s
  67. -- add_column(:hosts, :environment_id, :integer)
  68. -> 0.0008s
  69. -- add_column(:hosts, :subnet_id, :integer)
  70. -> 0.0008s
  71. -- add_column(:hosts, :sp_subnet_id, :integer)
  72. -> 0.0008s
  73. -- add_column(:hosts, :ptable_id, :integer)
  74. -> 0.0007s
  75. -- add_column(:hosts, :medium_id, :integer)
  76. -> 0.0008s
  77. -- add_column(:hosts, :build, :boolean, {:default=>true})
  78. -> 0.1018s
  79. -- add_column(:hosts, :comment, :text)
  80. -> 0.0008s
  81. -- add_column(:hosts, :disk, :text)
  82. -> 0.0007s
  83. -- add_column(:hosts, :installed_at, :datetime)
  84. -> 0.0007s
  85. == CreateHosts: migrated (2.0359s) ===========================================
  86.  
  87. == AddAuditsTable: migrating =================================================
  88. -- create_table(:audits, {:force=>true})
  89. NOTICE: CREATE TABLE will create implicit sequence "audits_id_seq" for serial column "audits.id"
  90. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "audits_pkey" for table "audits"
  91. -> 0.0851s
  92. -- add_index(:audits, [:auditable_id, :auditable_type], {:name=>"auditable_index"})
  93. -> 0.0249s
  94. -- add_index(:audits, [:user_id, :user_type], {:name=>"user_index"})
  95. -> 0.0251s
  96. -- add_index(:audits, :created_at)
  97. -> 0.0335s
  98. -- add_index(:audits, [:auditable_parent_id, :auditable_parent_type], {:name=>"auditable_parent_index"})
  99. -> 0.0251s
  100. == AddAuditsTable: migrated (0.1943s) ========================================
  101.  
  102. == CreateArchitectures: migrating ============================================
  103. -- create_table(:architectures)
  104. NOTICE: CREATE TABLE will create implicit sequence "architectures_id_seq" for serial column "architectures.id"
  105. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "architectures_pkey" for table "architectures"
  106. -> 0.0352s
  107. -- create_table(:architectures_operatingsystems, {:id=>false})
  108. -> 0.0012s
  109. == CreateArchitectures: migrated (0.0366s) ===================================
  110.  
  111. == CreateMedia: migrating ====================================================
  112. -- create_table(:media)
  113. NOTICE: CREATE TABLE will create implicit sequence "media_id_seq" for serial column "media.id"
  114. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "media_pkey" for table "media"
  115. -> 0.0368s
  116. == CreateMedia: migrated (0.0654s) ===========================================
  117.  
  118. == CreateDomains: migrating ==================================================
  119. -- create_table(:domains)
  120. NOTICE: CREATE TABLE will create implicit sequence "domains_id_seq" for serial column "domains.id"
  121. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "domains_pkey" for table "domains"
  122. -> 0.0535s
  123. == CreateDomains: migrated (0.0537s) =========================================
  124.  
  125. == CreateSubnets: migrating ==================================================
  126. -- create_table(:subnets)
  127. NOTICE: CREATE TABLE will create implicit sequence "subnets_id_seq" for serial column "subnets.id"
  128. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "subnets_pkey" for table "subnets"
  129. -> 0.0711s
  130. == CreateSubnets: migrated (0.0712s) =========================================
  131.  
  132. == CreateOperatingsystems: migrating =========================================
  133. -- create_table(:operatingsystems)
  134. NOTICE: CREATE TABLE will create implicit sequence "operatingsystems_id_seq" for serial column "operatingsystems.id"
  135. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "operatingsystems_pkey" for table "operatingsystems"
  136. -> 0.0382s
  137. == CreateOperatingsystems: migrated (0.0383s) ================================
  138.  
  139. == CreateModels: migrating ===================================================
  140. -- create_table(:models)
  141. NOTICE: CREATE TABLE will create implicit sequence "models_id_seq" for serial column "models.id"
  142. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "models_pkey" for table "models"
  143. -> 0.0551s
  144. -- add_column(:hosts, :model_id, :integer)
  145. -> 0.0012s
  146. == CreateModels: migrated (0.0565s) ==========================================
  147.  
  148. == CreateEnvironments: migrating =============================================
  149. -- create_table(:environments)
  150. NOTICE: CREATE TABLE will create implicit sequence "environments_id_seq" for serial column "environments.id"
  151. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "environments_pkey" for table "environments"
  152. -> 0.0301s
  153. -- create_table(:environments_puppetclasses, {:id=>false})
  154. -> 0.0013s
  155. == CreateEnvironments: migrated (0.0316s) ====================================
  156.  
  157. == CreateReports: migrating ==================================================
  158. -- create_table(:reports)
  159. NOTICE: CREATE TABLE will create implicit sequence "reports_id_seq" for serial column "reports.id"
  160. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "reports_pkey" for table "reports"
  161. -> 0.0640s
  162. == CreateReports: migrated (0.0642s) =========================================
  163.  
  164. == CreatePtables: migrating ==================================================
  165. -- create_table(:ptables)
  166. NOTICE: CREATE TABLE will create implicit sequence "ptables_id_seq" for serial column "ptables.id"
  167. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ptables_pkey" for table "ptables"
  168. -> 0.0583s
  169. -- create_table(:operatingsystems_ptables, {:id=>false})
  170. -> 0.0011s
  171. == CreatePtables: migrated (0.0865s) =========================================
  172.  
  173. == CreatePuppetclasses: migrating ============================================
  174. -- create_table(:puppetclasses)
  175. NOTICE: CREATE TABLE will create implicit sequence "puppetclasses_id_seq" for serial column "puppetclasses.id"
  176. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "puppetclasses_pkey" for table "puppetclasses"
  177. -> 0.0560s
  178. -- create_table(:hosts_puppetclasses, {:id=>false})
  179. -> 0.0012s
  180. -- create_table(:operatingsystems_puppetclasses, {:id=>false})
  181. -> 0.0013s
  182. == CreatePuppetclasses: migrated (0.0589s) ===================================
  183.  
  184. == CreateParameters: migrating ===============================================
  185. -- create_table(:parameters)
  186. NOTICE: CREATE TABLE will create implicit sequence "parameters_id_seq" for serial column "parameters.id"
  187. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "parameters_pkey" for table "parameters"
  188. -> 0.0648s
  189. == CreateParameters: migrated (0.0649s) ======================================
  190.  
  191. == CreateAuthSources: migrating ==============================================
  192. -- create_table(:auth_sources)
  193. NOTICE: CREATE TABLE will create implicit sequence "auth_sources_id_seq" for serial column "auth_sources.id"
  194. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "auth_sources_pkey" for table "auth_sources"
  195. -> 0.0651s
  196. == CreateAuthSources: migrated (0.0653s) =====================================
  197.  
  198. == CreateHostgroups: migrating ===============================================
  199. -- create_table(:hostgroups)
  200. NOTICE: CREATE TABLE will create implicit sequence "hostgroups_id_seq" for serial column "hostgroups.id"
  201. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "hostgroups_pkey" for table "hostgroups"
  202. -> 0.0319s
  203. -- create_table(:hostgroups_puppetclasses, {:id=>false})
  204. -> 0.0012s
  205. -- add_column(:hosts, :hostgroup_id, :integer)
  206. -> 0.0011s
  207. -- add_column(:parameters, :hostgroup_id, :integer)
  208. -> 0.0008s
  209. == CreateHostgroups: migrated (0.0356s) ======================================
  210.  
  211. == AddTypeToParameter: migrating =============================================
  212. -- add_column(:parameters, :type, :string)
  213. -> 0.0010s
  214. == AddTypeToParameter: migrated (0.0011s) ====================================
  215.  
  216. == AddDomainToParameter: migrating ===========================================
  217. -- add_column(:parameters, :domain_id, :integer)
  218. -> 0.0009s
  219. == AddDomainToParameter: migrated (0.0011s) ==================================
  220.  
  221. == ChangeReportFieldTypeToText: migrating ====================================
  222. == ChangeReportFieldTypeToText: migrated (0.0002s) ===========================
  223.  
  224. == ChangeHostBuildDefaultToFalse: migrating ==================================
  225. -- change_column(:hosts, :build, :boolean, {:default=>false})
  226. -> 0.1260s
  227. == ChangeHostBuildDefaultToFalse: migrated (0.1326s) =========================
  228.  
  229. == AddIndexToHost: migrating =================================================
  230. -- add_index("hosts", "last_report")
  231. -> 0.0307s
  232. -- add_index("hosts", "installed_at")
  233. -> 0.0250s
  234. -- add_index("hosts", "puppet_status")
  235. -> 0.0251s
  236. -- add_index("hosts", :domain_id, {:name=>"host_domain_id_ix"})
  237. -> 0.0251s
  238. -- add_index("hosts", :architecture_id, {:name=>"host_arch_id_ix"})
  239. -> 0.1168s
  240. -- add_index("hosts", :operatingsystem_id, {:name=>"host_os_id_ix"})
  241. -> 0.0418s
  242. -- add_index("hosts", :environment_id, {:name=>"host_env_id_ix"})
  243. -> 0.0334s
  244. -- add_index("hosts", :medium_id, {:name=>"host_medium_id_ix"})
  245. -> 0.0334s
  246. -- add_index("hosts", :hostgroup_id, {:name=>"host_group_id_ix"})
  247. -> 0.0501s
  248. == AddIndexToHost: migrated (0.3824s) ========================================
  249.  
  250. == AddIndexToParameters: migrating ===========================================
  251. -- add_index(:parameters, [:host_id, :type])
  252. -> 0.0355s
  253. -- add_index(:parameters, [:hostgroup_id, :type])
  254. -> 0.0335s
  255. -- add_index(:parameters, [:domain_id, :type])
  256. -> 0.0334s
  257. -- add_index(:parameters, :type)
  258. -> 0.0335s
  259. == AddIndexToParameters: migrated (0.1362s) ==================================
  260.  
  261. == AddIndexToReports: migrating ==============================================
  262. -- add_index(:reports, [:reported_at, :host_id])
  263. -> 0.0284s
  264. == AddIndexToReports: migrated (0.0285s) =====================================
  265.  
  266. == CreateUsers: migrating ====================================================
  267. -- create_table(:users)
  268. NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id"
  269. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
  270. -> 0.0543s
  271. == CreateUsers: migrated (0.0544s) ===========================================
  272.  
  273. == CreateSessions: migrating =================================================
  274. -- create_table(:sessions)
  275. NOTICE: CREATE TABLE will create implicit sequence "sessions_id_seq" for serial column "sessions.id"
  276. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sessions_pkey" for table "sessions"
  277. -> 0.0544s
  278. -- add_index(:sessions, :session_id)
  279. -> 0.0333s
  280. -- add_index(:sessions, :updated_at)
  281. -> 0.0335s
  282. == CreateSessions: migrated (0.1214s) ========================================
  283.  
  284. == AddStatusToReport: migrating ==============================================
  285. -- add_column(:reports, :status, :integer)
  286. -> 0.0009s
  287. -- add_index(:reports, :status)
  288. -> 0.0370s
  289. -- add_index(:reports, :host_id)
  290. -> 0.0334s
  291. -- add_index(:reports, :reported_at)
  292. -> 0.0335s
  293. == AddStatusToReport: migrated (0.1052s) =====================================
  294.  
  295. == CalcExistingReports: migrating ============================================
  296. == CalcExistingReports: migrated (0.0060s) ===================================
  297.  
  298. == CreateLookupKeys: migrating ===============================================
  299. -- create_table(:lookup_keys)
  300. NOTICE: CREATE TABLE will create implicit sequence "lookup_keys_id_seq" for serial column "lookup_keys.id"
  301. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lookup_keys_pkey" for table "lookup_keys"
  302. -> 0.0310s
  303. -- add_index(:lookup_keys, :key)
  304. -> 0.0333s
  305. == CreateLookupKeys: migrated (0.0645s) ======================================
  306.  
  307. == CreateLookupValues: migrating =============================================
  308. -- create_table(:lookup_values)
  309. NOTICE: CREATE TABLE will create implicit sequence "lookup_values_id_seq" for serial column "lookup_values.id"
  310. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "lookup_values_pkey" for table "lookup_values"
  311. -> 0.0561s
  312. -- add_index(:lookup_values, :priority)
  313. -> 0.0249s
  314. == CreateLookupValues: migrated (0.0813s) ====================================
  315.  
  316. == ChangeMysqlReportsColumn: migrating =======================================
  317. == ChangeMysqlReportsColumn: migrated (0.0002s) ==============================
  318.  
  319. == AddFamilyToOs: migrating ==================================================
  320. -- add_column(:operatingsystems, :family_id, :integer)
  321. -> 0.0011s
  322. == AddFamilyToOs: migrated (0.0073s) =========================================
  323.  
  324. == UpdateFactNamesAndValuesToBin: migrating ==================================
  325. == UpdateFactNamesAndValuesToBin: migrated (0.0001s) =========================
  326.  
  327. == AddReleasenameToOs: migrating =============================================
  328. -- add_column(:operatingsystems, :release_name, :string, {:limit=>64})
  329. -> 0.0009s
  330. == AddReleasenameToOs: migrated (0.0096s) ====================================
  331.  
  332. == CreateUsergroups: migrating ===============================================
  333. -- create_table(:usergroups)
  334. NOTICE: CREATE TABLE will create implicit sequence "usergroups_id_seq" for serial column "usergroups.id"
  335. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usergroups_pkey" for table "usergroups"
  336. -> 0.0318s
  337. -- create_table(:usergroup_members)
  338. NOTICE: CREATE TABLE will create implicit sequence "usergroup_members_id_seq" for serial column "usergroup_members.id"
  339. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usergroup_members_pkey" for table "usergroup_members"
  340. -> 0.0250s
  341. == CreateUsergroups: migrated (0.0570s) ======================================
  342.  
  343. == AddOwnerToHosts: migrating ================================================
  344. -- add_column(:hosts, :owner_id, :integer)
  345. -> 0.0010s
  346. -- add_column(:hosts, :owner_type, :string)
  347. -> 0.0007s
  348. -- setting default owner for all hosts
  349. == AddOwnerToHosts: migrated (0.0297s) =======================================
  350.  
  351. == AddUbuntuCustomLvmPtable: migrating =======================================
  352. == AddUbuntuCustomLvmPtable: migrated (0.1616s) ==============================
  353.  
  354. == CreateMediaOperatingsystemsAndMigrateData: migrating ======================
  355. -- create_table(:media_operatingsystems, {:id=>false})
  356. -> 0.0013s
  357. -- remove_column(:media, :operatingsystem_id)
  358. -> 0.0009s
  359. == CreateMediaOperatingsystemsAndMigrateData: migrated (0.0183s) =============
  360.  
  361. == MigrateInstallationMediumUri: migrating ===================================
  362. == MigrateInstallationMediumUri: migrated (0.0881s) ==========================
  363.  
  364. == SimplifyParameters: migrating =============================================
  365. -- index_exists?(:parameters, :host_id)
  366. -> 0.0039s
  367. -- index_exists?(:parameters, :hostgroup_id)
  368. -> 0.0035s
  369. -- index_exists?(:parameters, :domain_id)
  370. -> 0.0035s
  371. -- column_exists?(:parameters, :host_id)
  372. -> 0.0014s
  373. -- rename_column(:parameters, :host_id, :reference_id)
  374. -> 0.0012s
  375. -- index_exists?(:parameters, :reference_id)
  376. -> 0.0036s
  377. -- Everything migrated ok so we remove the old columns
  378. -- column_exists?(:parameters, :hostgroup_id)
  379. -> 0.0010s
  380. -- remove_column(:parameters, :hostgroup_id)
  381. -> 0.0009s
  382. -- column_exists?(:parameters, :domain_id)
  383. -> 0.0010s
  384. -- remove_column(:parameters, :domain_id)
  385. -> 0.0007s
  386. == SimplifyParameters: migrated (0.0363s) ====================================
  387.  
  388. == UpdateOsMinor: migrating ==================================================
  389. -- change_column(:operatingsystems, :minor, :string, {:limit=>16, :default=>"", :null=>false})
  390. -> 0.0375s
  391. == UpdateOsMinor: migrated (0.0400s) =========================================
  392.  
  393. == ChangeFamilyInOs: migrating ===============================================
  394. -- add_column(:operatingsystems, :type, :string, {:limit=>16})
  395. -> 0.0011s
  396. -- add_index(:operatingsystems, :type)
  397. -> 0.0366s
  398. -- remove_column(:operatingsystems, :family_id)
  399. -> 0.0008s
  400. == ChangeFamilyInOs: migrated (0.0441s) ======================================
  401.  
  402. == CreateNotices: migrating ==================================================
  403. -- create_table(:notices)
  404. NOTICE: CREATE TABLE will create implicit sequence "notices_id_seq" for serial column "notices.id"
  405. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "notices_pkey" for table "notices"
  406. -> 0.0564s
  407. -- create_table(:user_notices, {:id=>false})
  408. -> 0.0013s
  409. == CreateNotices: migrated (0.0579s) =========================================
  410.  
  411. == AddInternalAuth: migrating ================================================
  412. -- add_column(:users, :password_hash, :string, {:limit=>128})
  413. -> 0.0009s
  414. -- add_column(:users, :password_salt, :string, {:limit=>128})
  415. -> 0.0008s
  416. -- ****************************************************************************************
  417. -- The newly created internal account named admin has been allocated a password of 'changeme'
  418. -- Set this to something else in the settings/users page
  419. -- ****************************************************************************************
  420. == AddInternalAuth: migrated (0.3326s) =======================================
  421.  
  422. == CreateRoles: migrating ====================================================
  423. -- add_column(:users, :role_id, :integer)
  424. -> 0.0013s
  425. -- create_table("roles", {:force=>true})
  426. NOTICE: CREATE TABLE will create implicit sequence "roles_id_seq" for serial column "roles.id"
  427. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "roles_pkey" for table "roles"
  428. -> 0.0621s
  429. -- create_table(:user_roles)
  430. NOTICE: CREATE TABLE will create implicit sequence "user_roles_id_seq" for serial column "user_roles.id"
  431. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_roles_pkey" for table "user_roles"
  432. -> 0.0252s
  433. == CreateRoles: migrated (0.0888s) ===========================================
  434.  
  435. == AddUserDomainsAndHostgroups: migrating ====================================
  436. -- create_table(:user_domains, {:id=>false})
  437. -> 0.0014s
  438. -- create_table(:user_hostgroups, {:id=>false})
  439. -> 0.0012s
  440. == AddUserDomainsAndHostgroups: migrated (0.0028s) ===========================
  441.  
  442. == CreateUserFacts: migrating ================================================
  443. -- create_table(:user_facts)
  444. NOTICE: CREATE TABLE will create implicit sequence "user_facts_id_seq" for serial column "user_facts.id"
  445. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_facts_pkey" for table "user_facts"
  446. -> 0.0322s
  447. == CreateUserFacts: migrated (0.0323s) =======================================
  448.  
  449. == AddEnabledToHosts: migrating ==============================================
  450. -- add_column(:hosts, :enabled, :boolean, {:default=>true})
  451. -> 0.3525s
  452. == AddEnabledToHosts: migrated (0.3526s) =====================================
  453.  
  454. == AddMyBooleansToUser: migrating ============================================
  455. -- add_column(:users, :domains_andor, :string, {:limit=>3, :default=>"or"})
  456. -> 0.0566s
  457. -- add_column(:users, :hostgroups_andor, :string, {:limit=>3, :default=>"or"})
  458. -> 0.0668s
  459. -- add_column(:users, :facts_andor, :string, {:limit=>3, :default=>"or"})
  460. -> 0.0589s
  461. == AddMyBooleansToUser: migrated (0.1826s) ===================================
  462.  
  463. == CreateMessages: migrating =================================================
  464. -- create_table(:messages)
  465. NOTICE: CREATE TABLE will create implicit sequence "messages_id_seq" for serial column "messages.id"
  466. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages"
  467. -> 0.0585s
  468. -- add_index(:messages, :value)
  469. -> 0.0497s
  470. == CreateMessages: migrated (0.1086s) ========================================
  471.  
  472. == CreateSources: migrating ==================================================
  473. -- create_table(:sources)
  474. NOTICE: CREATE TABLE will create implicit sequence "sources_id_seq" for serial column "sources.id"
  475. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sources_pkey" for table "sources"
  476. -> 0.0541s
  477. -- add_index(:sources, :value)
  478. -> 0.0247s
  479. == CreateSources: migrated (0.0793s) =========================================
  480.  
  481. == CreateLogs: migrating =====================================================
  482. -- create_table(:logs)
  483. NOTICE: CREATE TABLE will create implicit sequence "logs_id_seq" for serial column "logs.id"
  484. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "logs_pkey" for table "logs"
  485. -> 0.0378s
  486. -- add_index(:logs, :report_id)
  487. -> 0.0917s
  488. -- add_index(:logs, :message_id)
  489. -> 0.0251s
  490. -- add_index(:logs, :level_id)
  491. -> 0.0251s
  492. == CreateLogs: migrated (0.1801s) ============================================
  493.  
  494. == AddMetricsToReport: migrating =============================================
  495. -- add_column(:reports, :metrics, :text)
  496. -> 0.0010s
  497. == AddMetricsToReport: migrated (0.0011s) ====================================
  498.  
  499. == ConvertReports: migrating =================================================
  500. -- About to convert all of the 0 reports log field into a more DB optimized way... this might take a while.....
  501. -- remove_column(:reports, :log)
  502. -> 0.0009s
  503. == ConvertReports: migrated (0.0046s) ========================================
  504.  
  505. == AddOwnedFilterToUser: migrating ===========================================
  506. -- add_column(:users, :filter_on_owner, :boolean)
  507. -> 0.0010s
  508. == AddOwnedFilterToUser: migrated (0.0011s) ==================================
  509.  
  510. == CorrectMedia: migrating ===================================================
  511. -- table_exists?(:medias)
  512. -> 0.0010s
  513. == CorrectMedia: migrated (0.0011s) ==========================================
  514.  
  515. == CreateConfigTemplates: migrating ==========================================
  516. -- create_table(:config_templates)
  517. NOTICE: CREATE TABLE will create implicit sequence "config_templates_id_seq" for serial column "config_templates.id"
  518. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "config_templates_pkey" for table "config_templates"
  519. -> 0.0645s
  520. == CreateConfigTemplates: migrated (0.0646s) =================================
  521.  
  522. == CreateTemplateCombinations: migrating =====================================
  523. -- create_table(:template_combinations)
  524. NOTICE: CREATE TABLE will create implicit sequence "template_combinations_id_seq" for serial column "template_combinations.id"
  525. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "template_combinations_pkey" for table "template_combinations"
  526. -> 0.0390s
  527. == CreateTemplateCombinations: migrated (0.0392s) ============================
  528.  
  529. == CreateOperatingsystemsConfigTemplates: migrating ==========================
  530. -- create_table(:config_templates_operatingsystems, {:id=>false})
  531. -> 0.0013s
  532. == CreateOperatingsystemsConfigTemplates: migrated (0.0015s) =================
  533.  
  534. == CreateTemplateKinds: migrating ============================================
  535. -- create_table(:template_kinds)
  536. NOTICE: CREATE TABLE will create implicit sequence "template_kinds_id_seq" for serial column "template_kinds.id"
  537. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "template_kinds_pkey" for table "template_kinds"
  538. -> 0.0398s
  539. == CreateTemplateKinds: migrated (0.0849s) ===================================
  540.  
  541. == CreateOsDefaultTemplates: migrating =======================================
  542. -- create_table(:os_default_templates)
  543. NOTICE: CREATE TABLE will create implicit sequence "os_default_templates_id_seq" for serial column "os_default_templates.id"
  544. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "os_default_templates_pkey" for table "os_default_templates"
  545. -> 0.0881s
  546. == CreateOsDefaultTemplates: migrated (0.0883s) ==============================
  547.  
  548. == AddDefaultTemplates: migrating ============================================
  549. == AddDefaultTemplates: migrated (0.1587s) ===================================
  550.  
  551. == AddSubSystemsToSubnet: migrating ==========================================
  552. -- add_column(:subnets, :dhcp_id, :integer)
  553. -> 0.0014s
  554. -- add_column(:subnets, :tftp_id, :integer)
  555. -> 0.0005s
  556. -- rename_column(:subnets, :number, :network)
  557. -> 0.0006s
  558. == AddSubSystemsToSubnet: migrated (0.0028s) =================================
  559.  
  560. == CreateProxies: migrating ==================================================
  561. -- create_table(:smart_proxies)
  562. NOTICE: CREATE TABLE will create implicit sequence "smart_proxies_id_seq" for serial column "smart_proxies.id"
  563. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "smart_proxies_pkey" for table "smart_proxies"
  564. -> 0.1247s
  565. == CreateProxies: migrated (0.1249s) =========================================
  566.  
  567. == AddProxyToDomain: migrating ===============================================
  568. -- add_column(:domains, :dns_id, :integer)
  569. -> 0.0011s
  570. -- remove_column(:domains, :dnsserver)
  571. -> 0.0008s
  572. -- remove_column(:domains, :gateway)
  573. -> 0.0007s
  574. == AddProxyToDomain: migrated (0.0028s) ======================================
  575.  
  576. == AddGrubbyTemplate: migrating ==============================================
  577. == AddGrubbyTemplate: migrated (0.0265s) =====================================
  578.  
  579. == AddHostGroupDefaults: migrating ===========================================
  580. -- add_column(:hostgroups, :environment_id, :integer)
  581. -> 0.0012s
  582. -- add_column(:hostgroups, :operatingsystem_id, :integer)
  583. -> 0.0007s
  584. -- add_column(:hostgroups, :architecture_id, :integer)
  585. -> 0.0007s
  586. -- add_column(:hostgroups, :medium_id, :integer)
  587. -> 0.0008s
  588. -- add_column(:hostgroups, :ptable_id, :integer)
  589. -> 0.0007s
  590. -- add_column(:hostgroups, :root_pass, :string)
  591. -> 0.0277s
  592. -- add_column(:hostgroups, :puppetmaster, :string)
  593. -> 0.0008s
  594. == AddHostGroupDefaults: migrated (0.0331s) ==================================
  595.  
  596. == AddDefaultPxeMenuTemplate: migrating ======================================
  597. == AddDefaultPxeMenuTemplate: migrated (0.0201s) =============================
  598.  
  599. == CreateProxyFeatures: migrating ============================================
  600. -- create_table(:features)
  601. NOTICE: CREATE TABLE will create implicit sequence "features_id_seq" for serial column "features.id"
  602. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "features_pkey" for table "features"
  603. -> 0.0319s
  604. -- create_table(:features_smart_proxies, {:id=>false})
  605. -> 0.0011s
  606. == CreateProxyFeatures: migrated (0.0508s) ===================================
  607.  
  608. == ChangePuppetmasterColumn: migrating =======================================
  609. -- rename_column(:hosts, :puppetmaster, :puppetmaster_name)
  610. -> 0.0012s
  611. -- add_column(:hosts, :puppetproxy_id, :integer)
  612. -> 0.0009s
  613. -- rename_column(:hostgroups, :puppetmaster, :puppetmaster_name)
  614. -> 0.0009s
  615. -- add_column(:hostgroups, :puppetproxy_id, :integer)
  616. -> 0.0008s
  617. == ChangePuppetmasterColumn: migrated (0.0042s) ==============================
  618.  
  619. == AddManagedToHosts: migrating ==============================================
  620. -- add_column(:hosts, :managed, :boolean)
  621. -> 0.0013s
  622. == AddManagedToHosts: migrated (0.0031s) =====================================
  623.  
  624. == RevertFaceNamesAndValuesToTextRecords: migrating ==========================
  625. == RevertFaceNamesAndValuesToTextRecords: migrated (0.0002s) =================
  626.  
  627. == AddPriorityToParameter: migrating =========================================
  628. -- add_column(:parameters, :priority, :integer)
  629. -> 0.0010s
  630. == AddPriorityToParameter: migrated (0.0052s) ================================
  631.  
  632. == AddMediaPathToMedium: migrating ===========================================
  633. -- add_column(:media, :media_path, :string, {:limit=>128})
  634. -> 0.0010s
  635. -- add_column(:media, :config_path, :string, {:limit=>128})
  636. -> 0.0009s
  637. -- add_column(:media, :image_path, :string, {:limit=>128})
  638. -> 0.0301s
  639. == AddMediaPathToMedium: migrated (0.0324s) ==================================
  640.  
  641. == AddImageToHost: migrating =================================================
  642. -- add_column(:hosts, :use_image, :boolean)
  643. -> 0.0011s
  644. -- add_column(:hosts, :image_file, :string, {:limit=>128})
  645. -> 0.0009s
  646. -- add_column(:hostgroups, :use_image, :boolean)
  647. -> 0.0008s
  648. -- add_column(:hostgroups, :image_file, :string, {:limit=>128})
  649. -> 0.0009s
  650. == AddImageToHost: migrated (0.0042s) ========================================
  651.  
  652. == RemoveUnusedFieldsFromPuppetClasses: migrating ============================
  653. -- remove_column(:puppetclasses, :nameindicator)
  654. -> 0.0010s
  655. -- remove_column(:puppetclasses, :operatingsystem_id)
  656. -> 0.0009s
  657. == RemoveUnusedFieldsFromPuppetClasses: migrated (0.0021s) ===================
  658.  
  659. == AddTableBookmarks: migrating ==============================================
  660. -- create_table(:bookmarks, {:force=>true})
  661. NOTICE: CREATE TABLE will create implicit sequence "bookmarks_id_seq" for serial column "bookmarks.id"
  662. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "bookmarks_pkey" for table "bookmarks"
  663. -> 0.0584s
  664. -- add_index(:bookmarks, :name)
  665. -> 0.0250s
  666. -- add_index(:bookmarks, :controller)
  667. -> 0.0252s
  668. -- add_index(:bookmarks, [:owner_id, :owner_type])
  669. -> 0.0251s
  670. == AddTableBookmarks: migrated (0.1695s) =====================================
  671.  
  672. == AddSolarisTemplates: migrating ============================================
  673. == AddSolarisTemplates: migrated (0.0278s) ===================================
  674.  
  675. == AddSolarisDisks: migrating ================================================
  676. == AddSolarisDisks: migrated (0.0277s) =======================================
  677.  
  678. == AddLookUpKeyIdToPuppetClass: migrating ====================================
  679. -- add_column(:lookup_keys, :puppetclass_id, :integer)
  680. -> 0.0018s
  681. -- add_index(:lookup_keys, :puppetclass_id)
  682. -> 0.0325s
  683. -- add_column(:lookup_keys, :default_value, :string)
  684. -> 0.0254s
  685. -- add_column(:lookup_keys, :path, :string)
  686. -> 0.0008s
  687. -- add_index(:lookup_keys, :path)
  688. -> 0.0491s
  689. -- add_column(:lookup_keys, :description, :string)
  690. -> 0.0008s
  691. -- add_column(:lookup_keys, :validator_type, :string)
  692. -> 0.0008s
  693. -- add_column(:lookup_keys, :validator_rule, :string)
  694. -> 0.0008s
  695. -- rename_column(:lookup_values, :priority, :match)
  696. -> 0.0008s
  697. -- add_index(:lookup_values, :match)
  698. -> 0.0300s
  699. == AddLookUpKeyIdToPuppetClass: migrated (0.1438s) ===========================
  700.  
  701. == AddSparcInfoToModel: migrating ============================================
  702. -- add_column(:models, :vendor_class, :string, {:limit=>32})
  703. -> 0.0010s
  704. -- add_column(:models, :hardware_model, :string, {:limit=>16})
  705. -> 0.0007s
  706. == AddSparcInfoToModel: migrated (0.0020s) ===================================
  707.  
  708. == AddAncestryToHostgroup: migrating =========================================
  709. -- add_column(:hostgroups, :ancestry, :string)
  710. -> 0.0011s
  711. -- add_index(:hostgroups, :ancestry)
  712. -> 0.0341s
  713. == AddAncestryToHostgroup: migrated (0.0354s) ================================
  714.  
  715. == CreateSettings: migrating =================================================
  716. -- create_table(:settings)
  717. NOTICE: CREATE TABLE will create implicit sequence "settings_id_seq" for serial column "settings.id"
  718. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "settings_pkey" for table "settings"
  719. -> 0.0610s
  720. -- add_index(:settings, :name, {:unique=>true})
  721. -> 0.0499s
  722. == CreateSettings: migrated (0.1112s) ========================================
  723.  
  724. == UpdateAuditsTable: migrating ==============================================
  725. == UpdateAuditsTable: migrated (0.0034s) =====================================
  726.  
  727. == CreateHostClass: migrating ================================================
  728. -- rename_table(:hosts_puppetclasses, :host_classes)
  729. -> 0.0062s
  730. -- add_column(:host_classes, :id, :primary_key)
  731. NOTICE: ALTER TABLE will create implicit sequence "host_classes_id_seq" for serial column "host_classes.id"
  732. NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "host_classes_pkey" for table "host_classes"
  733. -> 0.0731s
  734. == CreateHostClass: migrated (0.0795s) =======================================
  735.  
  736. == AddSuseTemplates: migrating ===============================================
  737. -- Failed to migrate PG::Error: ERROR: column "operatingsystem_id" of relation "media" does not exist
  738. LINE 1: INSERT INTO "media" ("created_at", "name", "operatingsystem_...
  739. ^
  740. : INSERT INTO "media" ("created_at", "name", "operatingsystem_id", "path", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"
  741. == AddSuseTemplates: migrated (0.1851s) ======================================
  742.  
  743. rake aborted!
  744. An error has occurred, this and all later migrations canceled:
  745.  
  746. PG::Error: ERROR: current transaction is aborted, commands ignored until end of transaction block
  747. : SELECT attr.attname
  748. FROM pg_attribute attr
  749. INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
  750. WHERE cons.contype = 'p'
  751. AND cons.conrelid = '"schema_migrations"'::regclass
  752.  
  753. Tasks: TOP => db:migrate
  754. (See full trace by running task with --trace)
  755. [root@zzzap foreman]# rake db:migrate
  756. Warning: fuzzy message was used.
  757. : msgid 'User'
  758. Warning: fuzzy message was used.
  759. : msgid 'Users'
  760. == AddSuseTemplates: migrating ===============================================
  761. == AddSuseTemplates: migrated (0.5671s) ======================================
  762.  
  763. == AddVmDefaultsToHostgroup: migrating =======================================
  764. -- add_column(:hostgroups, :vm_defaults, :text)
  765. -> 0.0018s
  766. == AddVmDefaultsToHostgroup: migrated (0.0019s) ==============================
  767.  
  768. == AddSubnetAndDomainToHostGroups: migrating =================================
  769. -- column_exists?(:hostgroups, :subnet_id)
  770. -> 0.0019s
  771. -- add_column(:hostgroups, :subnet_id, :integer)
  772. -> 0.0008s
  773. -- column_exists?(:hostgroups, :domain_id)
  774. -> 0.0017s
  775. -- add_column(:hostgroups, :domain_id, :integer)
  776. -> 0.0008s
  777. == AddSubnetAndDomainToHostGroups: migrated (0.0056s) ========================
  778.  
  779. == RenameChangesToAuditedChanges: migrating ==================================
  780. -- rename_column(:audits, :changes, :audited_changes)
  781. -> 0.0010s
  782. == RenameChangesToAuditedChanges: migrated (0.0011s) =========================
  783.  
  784. == AddRemoteAddressToAudits: migrating =======================================
  785. -- add_column(:audits, :remote_address, :string)
  786. -> 0.0010s
  787. == AddRemoteAddressToAudits: migrated (0.0011s) ==============================
  788.  
  789. == RenameParentToAssociation: migrating ======================================
  790. -- rename_column(:audits, :auditable_parent_id, :association_id)
  791. -> 0.0009s
  792. -- rename_column(:audits, :auditable_parent_type, :association_type)
  793. -> 0.0008s
  794. == RenameParentToAssociation: migrated (0.0019s) =============================
  795.  
  796. == AddGatewayAndDnsToSubnets: migrating ======================================
  797. -- add_column(:subnets, :gateway, :string)
  798. -> 0.0009s
  799. -- add_column(:subnets, :dns_primary, :string)
  800. -> 0.0008s
  801. -- add_column(:subnets, :dns_secondary, :string)
  802. -> 0.0007s
  803. == AddGatewayAndDnsToSubnets: migrated (0.0028s) =============================
  804.  
  805. == EnsureAllHostnamesAreLowercase: migrating =================================
  806. -- execute("UPDATE hosts SET name=LOWER(name)")
  807. -> 0.0016s
  808. == EnsureAllHostnamesAreLowercase: migrated (0.0017s) ========================
  809.  
  810. == AddFromAndToRangesToSubnets: migrating ====================================
  811. -- add_column(:subnets, :from, :string)
  812. -> 0.0009s
  813. -- add_column(:subnets, :to, :string)
  814. -> 0.0007s
  815. -- remove_column(:subnets, :ranges)
  816. -> 0.0008s
  817. == AddFromAndToRangesToSubnets: migrated (0.0026s) ===========================
  818.  
  819. == CreateSubnetDomain: migrating =============================================
  820. -- create_table(:subnet_domains)
  821. NOTICE: CREATE TABLE will create implicit sequence "subnet_domains_id_seq" for serial column "subnet_domains.id"
  822. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "subnet_domains_pkey" for table "subnet_domains"
  823. -> 0.0588s
  824. -- remove_column(:subnets, :domain_id)
  825. -> 0.0007s
  826. == CreateSubnetDomain: migrated (0.0983s) ====================================
  827.  
  828. == CreateComputeResources: migrating =========================================
  829. -- create_table(:compute_resources)
  830. NOTICE: CREATE TABLE will create implicit sequence "compute_resources_id_seq" for serial column "compute_resources.id"
  831. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "compute_resources_pkey" for table "compute_resources"
  832. -> 0.0585s
  833. == CreateComputeResources: migrated (0.0587s) ================================
  834.  
  835. == AddUuidAndComputeIdToHost: migrating ======================================
  836. -- add_column(:hosts, :uuid, :string)
  837. -> 0.0010s
  838. -- add_column(:hosts, :compute_resource_id, :integer)
  839. -> 0.0009s
  840. == AddUuidAndComputeIdToHost: migrated (0.0021s) =============================
  841.  
  842. == AddWindowsTemplates: migrating ============================================
  843. == AddWindowsTemplates: migrated (0.0063s) ===================================
  844.  
  845. == CreateNics: migrating =====================================================
  846. -- create_table(:nics)
  847. NOTICE: CREATE TABLE will create implicit sequence "nics_id_seq" for serial column "nics.id"
  848. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nics_pkey" for table "nics"
  849. -> 0.0571s
  850. -- add_index(:nics, [:type], {:name=>"index_by_type"})
  851. -> 0.0332s
  852. -- add_index(:nics, [:host_id], {:name=>"index_by_host"})
  853. -> 0.0334s
  854. -- add_index(:nics, [:type, :id], {:name=>"index_by_type_and_id"})
  855. -> 0.0335s
  856. -- remove_columns(:hosts, :sp_mac, :sp_ip, :sp_name, :sp_subnet_id)
  857. -> 0.0034s
  858. == CreateNics: migrated (0.4107s) ============================================
  859.  
  860. == AddPuppetMasterProxyToHostAndHostGroup: migrating =========================
  861. -- rename_column(:hosts, :puppetproxy_id, :puppet_ca_proxy_id)
  862. -> 0.0009s
  863. -- add_column(:hosts, :puppet_proxy_id, :integer)
  864. -> 0.0008s
  865. -- rename_column(:hostgroups, :puppetproxy_id, :puppet_ca_proxy_id)
  866. -> 0.0006s
  867. -- add_column(:hostgroups, :puppet_proxy_id, :integer)
  868. -> 0.0007s
  869. -- remove_column(:hosts, :puppetmaster_name)
  870. -> 0.0008s
  871. -- remove_column(:hostgroups, :puppetmaster_name)
  872. -> 0.0008s
  873. == AddPuppetMasterProxyToHostAndHostGroup: migrated (0.0675s) ================
  874.  
  875. == UpdateReportFieldToLargeInt: migrating ====================================
  876. -- change_column(:reports, :status, :bigint)
  877. -> 0.1777s
  878. -- change_column(:hosts, :puppet_status, :bigint)
  879. -> 0.4194s
  880. == UpdateReportFieldToLargeInt: migrated (0.5974s) ===========================
  881.  
  882. == CreateImages: migrating ===================================================
  883. -- create_table(:images)
  884. NOTICE: CREATE TABLE will create implicit sequence "images_id_seq" for serial column "images.id"
  885. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "images_pkey" for table "images"
  886. -> 0.0563s
  887. == CreateImages: migrated (0.0565s) ==========================================
  888.  
  889. == AddCertNameToHost: migrating ==============================================
  890. -- add_column(:hosts, :certname, :string)
  891. -> 0.0012s
  892. -- add_index("hosts", :certname)
  893. -> 0.0341s
  894. == AddCertNameToHost: migrated (0.0354s) =====================================
  895.  
  896. == CreateKeyPairs: migrating =================================================
  897. -- create_table(:key_pairs)
  898. NOTICE: CREATE TABLE will create implicit sequence "key_pairs_id_seq" for serial column "key_pairs.id"
  899. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "key_pairs_pkey" for table "key_pairs"
  900. -> 0.0564s
  901. == CreateKeyPairs: migrated (0.0566s) ========================================
  902.  
  903. == AddDnsIdToSubnet: migrating ===============================================
  904. -- add_column(:subnets, :dns_id, :integer)
  905. -> 0.0010s
  906. == AddDnsIdToSubnet: migrated (0.0011s) ======================================
  907.  
  908. == AddImageIdToHost: migrating ===============================================
  909. -- add_column(:hosts, :image_id, :integer)
  910. -> 0.0010s
  911. == AddImageIdToHost: migrated (0.0011s) ======================================
  912.  
  913. == AddUserComputeResources: migrating ========================================
  914. -- create_table(:user_compute_resources, {:id=>false})
  915. -> 0.0016s
  916. == AddUserComputeResources: migrated (0.0018s) ===============================
  917.  
  918. == AddComputeResourcesBooleanToUser: migrating ===============================
  919. -- add_column(:users, :compute_resources_andor, :string, {:limit=>3, :default=>"or"})
  920. -> 0.0664s
  921. == AddComputeResourcesBooleanToUser: migrated (0.0665s) ======================
  922.  
  923. == AddEpelSnippets: migrating ================================================
  924. == AddEpelSnippets: migrated (0.0203s) =======================================
  925.  
  926. == ConvertParamsToText: migrating ============================================
  927. -- change_column("parameters", :value, :text)
  928. -> 0.1093s
  929. -- change_column("lookup_values", :value, :text)
  930. -> 0.1173s
  931. == ConvertParamsToText: migrated (0.2268s) ===================================
  932.  
  933. == ChangeBookmarkColumnToText: migrating =====================================
  934. -- change_column("bookmarks", :query, :text)
  935. -> 0.1569s
  936. == ChangeBookmarkColumnToText: migrated (0.1570s) ============================
  937.  
  938. == RenameAssociationToAssociated: migrating ==================================
  939. -- index_exists?(:audits, [:association_id, :association_type], {:name=>"association_index"})
  940. -> 0.0039s
  941. -- column_exists?(:audits, :association_id)
  942. -> 0.0018s
  943. -- rename_column(:audits, :association_id, :associated_id)
  944. -> 0.0008s
  945. -- column_exists?(:audits, :association_type)
  946. -> 0.0016s
  947. -- rename_column(:audits, :association_type, :associated_type)
  948. -> 0.0006s
  949. -- index_exists?(:audits, [:association_id, :association_type], {:name=>"association_index"})
  950. -> 0.0035s
  951. -- add_index(:audits, [:associated_id, :associated_type], {:name=>"associated_index"})
  952. -> 0.0282s
  953. == RenameAssociationToAssociated: migrated (0.0411s) =========================
  954.  
  955. == FixAuditableType: migrating ===============================================
  956. -- execute("UPDATE audits SET auditable_type='Host' WHERE auditable_type='Puppet::Rails::Host'")
  957. -> 0.0013s
  958. == FixAuditableType: migrated (0.0014s) ======================================
  959.  
  960. == FixAssociatedType: migrating ==============================================
  961. -- execute("UPDATE audits SET associated_type='Host' WHERE associated_type='Puppet::Rails::Host'")
  962. -> 0.0007s
  963. == FixAssociatedType: migrated (0.0008s) =====================================
  964.  
  965. == CreateTaxonomies: migrating ===============================================
  966. -- create_table(:taxonomies)
  967. NOTICE: CREATE TABLE will create implicit sequence "taxonomies_id_seq" for serial column "taxonomies.id"
  968. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxonomies_pkey" for table "taxonomies"
  969. -> 0.0784s
  970. == CreateTaxonomies: migrated (0.0786s) ======================================
  971.  
  972. == AddOkHostsBookMark: migrating =============================================
  973. == AddOkHostsBookMark: migrated (0.0250s) ====================================
  974.  
  975. == AddAuditableNameAndAssociatedNameToAudit: migrating =======================
  976. -- column_exists?(:audits, :auditable_name)
  977. -> 0.0017s
  978. -- add_column(:audits, :auditable_name, :string)
  979. -> 0.0010s
  980. -- column_exists?(:audits, :associated_name)
  981. -> 0.0015s
  982. -- add_column(:audits, :associated_name, :string)
  983. -> 0.0007s
  984. -- index_exists?(:audits, :id)
  985. -> 0.0043s
  986. -- add_index(:audits, :id)
  987. -> 0.0267s
  988. -- About to review all audits, this may take a while...
  989. == AddAuditableNameAndAssociatedNameToAudit: migrated (0.0514s) ==============
  990.  
  991. == AddOsFamilyToMedia: migrating =============================================
  992. -- add_column(:media, :os_family, :string)
  993. -> 0.0009s
  994. == AddOsFamilyToMedia: migrated (0.0302s) ====================================
  995.  
  996. == AddOsFamilyToPtable: migrating ============================================
  997. -- column_exists?(:ptables, :os_family)
  998. -> 0.0015s
  999. -- add_column(:ptables, :os_family, :string)
  1000. -> 0.0009s
  1001. -- column_exists?(:ptables, :operatingsystem_id)
  1002. -> 0.0011s
  1003. -- remove_column(:ptables, :operatingsystem_id)
  1004. -> 0.0006s
  1005. == AddOsFamilyToPtable: migrated (0.0323s) ===================================
  1006.  
  1007. == AddAttributesToComputeResources: migrating ================================
  1008. -- column_exists?(:compute_resources, :attrs)
  1009. -> 0.0016s
  1010. -- add_column(:compute_resources, :attrs, :text)
  1011. -> 0.0009s
  1012. == AddAttributesToComputeResources: migrated (0.0027s) =======================
  1013.  
  1014. == AddSomeIndexes: migrating =================================================
  1015. -- add_index(:environments_puppetclasses, :puppetclass_id)
  1016. -> 0.0284s
  1017. -- add_index(:environments_puppetclasses, :environment_id)
  1018. -> 0.0251s
  1019. -- add_index(:puppetclasses, :name)
  1020. -> 0.0251s
  1021. -- add_index(:hostgroups_puppetclasses, :puppetclass_id)
  1022. -> 0.0252s
  1023. -- add_index(:hostgroups_puppetclasses, :hostgroup_id)
  1024. -> 0.0334s
  1025. == AddSomeIndexes: migrated (0.1377s) ========================================
  1026.  
  1027. == CreateEnvironmentClasses: migrating =======================================
  1028. -- rename_table(:environments_puppetclasses, :environment_classes)
  1029. -> 0.0056s
  1030. -- add_column(:environment_classes, :id, :primary_key)
  1031. NOTICE: ALTER TABLE will create implicit sequence "environment_classes_id_seq" for serial column "environment_classes.id"
  1032. NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "environment_classes_pkey" for table "environment_classes"
  1033. -> 0.0816s
  1034. -- add_column(:environment_classes, :lookup_key_id, :integer)
  1035. -> 0.0008s
  1036. == CreateEnvironmentClasses: migrated (0.0884s) ==============================
  1037.  
  1038. == AddLookupKeysOverrideAndRequired: migrating ===============================
  1039. -- add_column(:lookup_keys, :is_param, :boolean, {:default=>false})
  1040. -> 0.1461s
  1041. -- add_column(:lookup_keys, :key_type, :string, {:default=>nil})
  1042. -> 0.1271s
  1043. -- add_column(:lookup_keys, :override, :boolean, {:default=>false})
  1044. -> 0.1426s
  1045. -- add_column(:lookup_keys, :required, :boolean, {:default=>false})
  1046. -> 0.1510s
  1047. == AddLookupKeysOverrideAndRequired: migrated (0.5672s) ======================
  1048.  
  1049. == AddLookupValuesCountToLookupKeys: migrating ===============================
  1050. -- add_column(:lookup_keys, :lookup_values_count, :integer, {:default=>0})
  1051. -> 0.1367s
  1052. == AddLookupValuesCountToLookupKeys: migrated (0.1368s) ======================
  1053.  
  1054. == CacheLookupValuesCount: migrating =========================================
  1055. -- execute("update lookup_keys set lookup_values_count=(select count(*) from lookup_values where lookup_key_id=lookup_keys.id)")
  1056. -> 0.0012s
  1057. == CacheLookupValuesCount: migrated (0.0014s) ================================
  1058.  
  1059. == AddIamRoleToImages: migrating =============================================
  1060. -- add_column(:images, :iam_role, :string)
  1061. -> 0.0010s
  1062. == AddIamRoleToImages: migrated (0.0011s) ====================================
  1063.  
  1064. == CreateTokens: migrating ===================================================
  1065. -- create_table(:tokens)
  1066. NOTICE: CREATE TABLE will create implicit sequence "tokens_id_seq" for serial column "tokens.id"
  1067. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tokens_pkey" for table "tokens"
  1068. -> 0.0281s
  1069. -- add_index(:tokens, :value)
  1070. -> 0.0333s
  1071. -- add_index(:tokens, :host_id)
  1072. -> 0.0335s
  1073. == CreateTokens: migrated (0.0952s) ==========================================
  1074.  
  1075. == AddBmcFeatureToProxy: migrating ===========================================
  1076. == AddBmcFeatureToProxy: migrated (0.0224s) ==================================
  1077.  
  1078. == AddTaxonomyIdsToHosts: migrating ==========================================
  1079. -- add_column(:hosts, :organization_id, :integer)
  1080. -> 0.0012s
  1081. -- add_column(:hosts, :location_id, :integer)
  1082. -> 0.0007s
  1083. == AddTaxonomyIdsToHosts: migrated (0.0021s) =================================
  1084.  
  1085. == ChangeDomainCharacterCount: migrating =====================================
  1086. -- change_column(:domains, :fullname, :string, {:limit=>254})
  1087. -> 0.0623s
  1088. == ChangeDomainCharacterCount: migrated (0.0624s) ============================
  1089.  
  1090. == CreateTrends: migrating ===================================================
  1091. -- create_table(:trends)
  1092. NOTICE: CREATE TABLE will create implicit sequence "trends_id_seq" for serial column "trends.id"
  1093. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trends_pkey" for table "trends"
  1094. -> 0.0612s
  1095. -- add_index(:trends, :type)
  1096. -> 0.0249s
  1097. -- add_index(:trends, [:trendable_type, :trendable_id])
  1098. -> 0.0419s
  1099. -- add_index(:trends, :fact_value)
  1100. -> 0.0251s
  1101. == CreateTrends: migrated (0.1535s) ==========================================
  1102.  
  1103. == CreateTrendCounters: migrating ============================================
  1104. -- create_table(:trend_counters)
  1105. NOTICE: CREATE TABLE will create implicit sequence "trend_counters_id_seq" for serial column "trend_counters.id"
  1106. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trend_counters_pkey" for table "trend_counters"
  1107. -> 0.0296s
  1108. -- add_index(:trend_counters, :trend_id)
  1109. -> 0.0250s
  1110. == CreateTrendCounters: migrated (0.0548s) ===================================
  1111.  
  1112. == UpdateMediaPathLimit: migrating ===========================================
  1113. -- change_column(:media, :path, :string, {:limit=>255})
  1114. -> 0.0551s
  1115. == UpdateMediaPathLimit: migrated (0.0553s) ==================================
  1116.  
  1117. == CreateHostgroupClasses: migrating =========================================
  1118. -- rename_table(:hostgroups_puppetclasses, :hostgroup_classes)
  1119. -> 0.0050s
  1120. -- add_column(:hostgroup_classes, :id, :primary_key)
  1121. NOTICE: ALTER TABLE will create implicit sequence "hostgroup_classes_id_seq" for serial column "hostgroup_classes.id"
  1122. NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "hostgroup_classes_pkey" for table "hostgroup_classes"
  1123. -> 0.0819s
  1124. == CreateHostgroupClasses: migrated (0.0873s) ================================
  1125.  
  1126. == AddLocalbootTemplate: migrating ===========================================
  1127. == AddLocalbootTemplate: migrated (0.0196s) ==================================
  1128.  
  1129. == RenameReplyAdressSetting: migrating =======================================
  1130. -- execute("UPDATE settings SET name='email_reply_address' WHERE name='email_replay_adress'")
  1131. -> 0.0009s
  1132. == RenameReplyAdressSetting: migrated (0.0010s) ==============================
  1133.  
  1134. == AddLocationsOrganizations: migrating ======================================
  1135. -- create_table(:locations_organizations, {:id=>false})
  1136. -> 0.0016s
  1137. == AddLocationsOrganizations: migrated (0.0017s) =============================
  1138.  
  1139. == MigrateHypervisorsToComputeResources: migrating ===========================
  1140. == MigrateHypervisorsToComputeResources: migrated (0.0018s) ==================
  1141.  
  1142. == CreateTaxableTaxonomies: migrating ========================================
  1143. -- create_table(:taxable_taxonomies)
  1144. NOTICE: CREATE TABLE will create implicit sequence "taxable_taxonomies_id_seq" for serial column "taxable_taxonomies.id"
  1145. NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxable_taxonomies_pkey" for table "taxable_taxonomies"
  1146. -> 0.0318s
  1147. -- add_index(:taxable_taxonomies, [:taxable_id, :taxable_type])
  1148. -> 0.0249s
  1149. -- add_index(:taxable_taxonomies, [:taxable_id, :taxable_type, :taxonomy_id], {:name=>"taxable_index"})
  1150. -> 0.0251s
  1151. -- add_index(:taxable_taxonomies, :taxonomy_id)
  1152. -> 0.0252s
  1153. == CreateTaxableTaxonomies: migrated (0.1074s) ===============================
  1154.  
  1155. == AddMyTaxonomyToUser: migrating ============================================
  1156. -- add_column(:users, :organizations_andor, :string, {:limit=>3, :default=>"or"})
  1157. -> 0.0740s
  1158. -- add_column(:users, :locations_andor, :string, {:limit=>3, :default=>"or"})
  1159. -> 0.0670s
  1160. == AddMyTaxonomyToUser: migrated (0.1412s) ===================================
  1161.  
  1162. == ChangeSmartVariableLength: migrating ======================================
  1163. -- change_column(:lookup_keys, :default_value, :text)
  1164. -> 0.1567s
  1165. == ChangeSmartVariableLength: migrated (0.1568s) =============================
  1166.  
  1167. == RemoveReplayAddressSetting: migrating =====================================
  1168. -- execute("DELETE FROM settings WHERE name='email_replay_address'")
  1169. -> 0.0006s
  1170. == RemoveReplayAddressSetting: migrated (0.0007s) ============================
  1171.  
  1172. == AddIgnoreTypesToTaxonomy: migrating =======================================
  1173. -- add_column(:taxonomies, :ignore_types, :text)
  1174. -> 0.0010s
  1175. == AddIgnoreTypesToTaxonomy: migrated (0.0012s) ==============================
  1176.  
  1177. == AddDigestToMessages: migrating ============================================
  1178. -- index_exists?(:messages, :value)
  1179. -> 0.0021s
  1180. -- remove_index(:messages, :value)
  1181. -> 0.0027s
  1182. -- add_column(:messages, :digest, :string)
  1183. -> 0.0009s
  1184. -- add_index(:messages, :digest)
  1185. -> 0.0334s
  1186. == AddDigestToMessages: migrated (0.0592s) ===================================
  1187.  
  1188. == AddStiToHosts: migrating ==================================================
  1189. -- add_column(:hosts, :type, :string)
  1190. -> 0.0011s
  1191. -- execute("UPDATE hosts set type='Host::Managed'")
  1192. -> 0.0011s
  1193. -- add_index(:hosts, :type)
  1194. -> 0.0398s
  1195. == AddStiToHosts: migrated (0.0423s) =========================================
  1196.  
  1197. == AddDigestToSources: migrating =============================================
  1198. -- index_exists?(:sources, :value)
  1199. -> 0.0024s
  1200. -- remove_index(:sources, :value)
  1201. -> 0.0025s
  1202. -- add_column(:sources, :digest, :string)
  1203. -> 0.0008s
  1204. -- add_index(:sources, :digest)
  1205. -> 0.0374s
  1206. == AddDigestToSources: migrated (0.0602s) ====================================
  1207.  
  1208. == RemoveDuplicateSnippets: migrating ========================================
  1209. == RemoveDuplicateSnippets: migrated (0.0561s) ===============================
  1210.  
  1211. [root@zzzap foreman]#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!