Bug 745542

The thing is it does not work when there are NONE connection to the postgresql server.

If you run it and katello or katello-jobs are running (there are connection), the db:drop task fails and the database is not dropped. Therefore it works. But once connections are closed, db is dropped and migrate fails (because user is dropped as well).

6ee681fc05d13ad48ea596353585dae592630f1e

I ran this katello-reset-db script on latest build of katello. 

katello-0.1.155-1.el6.noarch

haven't faced any exception. Please see the logs below.

[root@dhcp201-197 ~]# /usr/share/katello/script/katello-reset-dbs 


***********************************************************
THIS SCRIPT WILL ERASE KATELLO / CANDLEPIN / PULP DATABASES
***********************************************************


All data from all systems will be erased completely!


This script only works with PostgreSQL database.


It is strongly recommended to back up databases:
 # mongodump --db pulp_database --out - > pulp_database.json
 # pg_dump -c candlepin > candlepin_db.sql
 # pg_dump -c katello > katello_db.sql


Are you sure you want to proceed (yes/no)? yes
Erasing all data...
Stopping Katello instance
Stopping server on 0.0.0.0:5000 ... 
Sending QUIT signal to process 1781 ... 
>> Exiting!
Stopping server on 0.0.0.0:5001 ... 
Sending QUIT signal to process 1795 ... 
>> Exiting!
Stopping Katello jobs instance
Stopping katello-jobs: 
Stopping Pulp instance
Stopping httpd:                                            [  OK  ]
Stopping Qpid AMQP daemon:                                 [  OK  ]
Stopping mongod:                                           [  OK  ]
Stopping Candlepin instance
Stopping tomcat6:                                          [  OK  ]
Dropping Pulp database
Starting mongod:                                           [  OK  ]
Initializing Pulp database
database migration to version 31 complete
Initializing Candlepin database
Dropping candlepin database
Creating candlepin database
Loading candlepin schema
** Skipping configuration file setup
Certificates are already present.
Waiting for tomcat to restart...
Candlepin has been configured.
Starting Pulp instance
Starting Qpid AMQP daemon:                                 [  OK  ]
Starting httpd:                                            [  OK  ]
Starting Candlepin instance
Initializing Katello database
** Invoke setup (first_time)
** Invoke check_db_config (first_time)
** Invoke db:load_config (first_time)
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:load_config
** Execute check_db_config
** Invoke clear_search_indices (first_time)
** Execute clear_search_indices
Search Indices cleared.
** Invoke db:migrate:reset (first_time)
** Invoke db:drop (first_time)
** Invoke db:load_config 
** Execute db:drop
** Invoke db:create (first_time)
** Invoke db:load_config 
** Execute db:create
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
==  CreateOrganizations: migrating ============================================
-- create_table(:organizations)
NOTICE:  CREATE TABLE will create implicit sequence "organizations_id_seq" for serial column "organizations.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "organizations_pkey" for table "organizations"
   -> 0.0736s
==  CreateOrganizations: migrated (0.0739s) ===================================

==  CreateEnvironments: migrating =============================================
-- create_table(:environments)
NOTICE:  CREATE TABLE will create implicit sequence "environments_id_seq" for serial column "environments.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "environments_pkey" for table "environments"
   -> 0.0945s
==  CreateEnvironments: migrated (0.0946s) ====================================

==  AddEnvironmentPriors: migrating ===========================================
-- create_table(:environment_priors, {:id=>false})
   -> 0.0009s
==  AddEnvironmentPriors: migrated (0.0010s) ==================================

==  CreateProducts: migrating =================================================
-- create_table(:products)
NOTICE:  CREATE TABLE will create implicit sequence "products_id_seq" for serial column "products.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "products_pkey" for table "products"
   -> 0.0701s
==  CreateProducts: migrated (0.0702s) ========================================

==  EnvironmentsProducts: migrating ===========================================
-- create_table(:environment_products)
NOTICE:  CREATE TABLE will create implicit sequence "environment_products_id_seq" for serial column "environment_products.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "environment_products_pkey" for table "environment_products"
   -> 0.0370s
-- add_index(:environment_products, [:environment_id, :product_id], {:unique=>true})
   -> 0.0335s
==  EnvironmentsProducts: migrated (0.0707s) ==================================

==  CreateProviders: migrating ================================================
-- create_table(:providers)
NOTICE:  CREATE TABLE will create implicit sequence "providers_id_seq" for serial column "providers.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "providers_pkey" for table "providers"
   -> 0.0708s
==  CreateProviders: migrated (0.0709s) =======================================

==  CreateChangesets: migrating ===============================================
-- create_table(:changesets)
NOTICE:  CREATE TABLE will create implicit sequence "changesets_id_seq" for serial column "changesets.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "changesets_pkey" for table "changesets"
   -> 0.0492s
==  CreateChangesets: migrated (0.0493s) ======================================

==  CreateUsers: migrating ====================================================
-- create_table(:users)
NOTICE:  CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
   -> 0.0717s
==  CreateUsers: migrated (0.0718s) ===========================================

==  CreateRoles: migrating ====================================================
-- create_table(:roles)
NOTICE:  CREATE TABLE will create implicit sequence "roles_id_seq" for serial column "roles.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "roles_pkey" for table "roles"
   -> 0.0384s
==  CreateRoles: migrated (0.0385s) ===========================================

==  CreateVerbs: migrating ====================================================
-- create_table(:verbs)
NOTICE:  CREATE TABLE will create implicit sequence "verbs_id_seq" for serial column "verbs.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "verbs_pkey" for table "verbs"
   -> 0.0387s
==  CreateVerbs: migrated (0.0388s) ===========================================

==  CreateResourceTypes: migrating ============================================
-- create_table(:resource_types)
NOTICE:  CREATE TABLE will create implicit sequence "resource_types_id_seq" for serial column "resource_types.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "resource_types_pkey" for table "resource_types"
   -> 0.0306s
==  CreateResourceTypes: migrated (0.0307s) ===================================

==  CreatePermissions: migrating ==============================================
-- create_table(:permissions)
NOTICE:  CREATE TABLE will create implicit sequence "permissions_id_seq" for serial column "permissions.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "permissions_pkey" for table "permissions"
   -> 0.0307s
-- add_index(:permissions, :role_id)
   -> 0.0251s
-- add_index(:permissions, :resource_type_id, {:null=>true})
   -> 0.0253s
-- add_index(:permissions, :organization_id, {:null=>true})
   -> 0.0419s
==  CreatePermissions: migrated (0.1233s) =====================================

==  CreatePermissionVerb: migrating ===========================================
-- create_table(:permissions_verbs, {:id=>false})
   -> 0.0009s
-- add_index(:permissions_verbs, :permission_id)
   -> 0.0306s
-- add_index(:permissions_verbs, :verb_id)
   -> 0.0253s
==  CreatePermissionVerb: migrated (0.0571s) ==================================

==  CreatePermissionTag: migrating ============================================
-- create_table(:permission_tags)
NOTICE:  CREATE TABLE will create implicit sequence "permission_tags_id_seq" for serial column "permission_tags.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "permission_tags_pkey" for table "permission_tags"
   -> 0.0338s
==  CreatePermissionTag: migrated (0.0339s) ===================================

==  CreateRoleUser: migrating =================================================
-- create_table(:roles_users, {:id=>false})
   -> 0.0007s
-- add_index(:roles_users, :role_id)
   -> 0.0330s
-- add_index(:roles_users, :user_id)
   -> 0.0334s
==  CreateRoleUser: migrated (0.0674s) ========================================

==  ChangesetsProducts: migrating =============================================
-- create_table(:changesets_products, {:id=>false})
   -> 0.0008s
==  ChangesetsProducts: migrated (0.0009s) ====================================

==  CreateHelpTips: migrating =================================================
-- create_table(:help_tips)
NOTICE:  CREATE TABLE will create implicit sequence "help_tips_id_seq" for serial column "help_tips.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "help_tips_pkey" for table "help_tips"
   -> 0.0347s
==  CreateHelpTips: migrated (0.0348s) ========================================

==  AddOwnerToRole: migrating =================================================
-- add_column(:users, :own_role_id, :integer)
   -> 0.0004s
==  AddOwnerToRole: migrated (0.0005s) ========================================

==  CreateNotices: migrating ==================================================
-- create_table(:notices)
NOTICE:  CREATE TABLE will create implicit sequence "notices_id_seq" for serial column "notices.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "notices_pkey" for table "notices"
   -> 0.0685s
-- create_table(:user_notices)
NOTICE:  CREATE TABLE will create implicit sequence "user_notices_id_seq" for serial column "user_notices.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "user_notices_pkey" for table "user_notices"
   -> 0.0336s
==  CreateNotices: migrated (0.1022s) =========================================

==  CreateSystems: migrating ==================================================
-- create_table(:systems)
NOTICE:  CREATE TABLE will create implicit sequence "systems_id_seq" for serial column "systems.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "systems_pkey" for table "systems"
   -> 0.0687s
==  CreateSystems: migrated (0.0688s) =========================================

==  ChangesetPackages: migrating ==============================================
-- create_table(:changeset_packages)
NOTICE:  CREATE TABLE will create implicit sequence "changeset_packages_id_seq" for serial column "changeset_packages.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "changeset_packages_pkey" for table "changeset_packages"
   -> 0.1026s
==  ChangesetPackages: migrated (0.1027s) =====================================

==  ChangesetErrata: migrating ================================================
-- create_table(:changeset_errata)
NOTICE:  CREATE TABLE will create implicit sequence "changeset_errata_id_seq" for serial column "changeset_errata.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "changeset_errata_pkey" for table "changeset_errata"
   -> 0.0700s
==  ChangesetErrata: migrated (0.0701s) =======================================

==  CreateSyncPlans: migrating ================================================
-- create_table(:sync_plans)
NOTICE:  CREATE TABLE will create implicit sequence "sync_plans_id_seq" for serial column "sync_plans.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sync_plans_pkey" for table "sync_plans"
   -> 0.0953s
==  CreateSyncPlans: migrated (0.0954s) =======================================

==  AddChangesetPromotionDate: migrating ======================================
-- add_column(:changesets, :promotion_date, :datetime)
   -> 0.0007s
==  AddChangesetPromotionDate: migrated (0.0008s) =============================

==  ChangesetRepos: migrating =================================================
-- create_table(:changesets_repositories, {:id=>false})
   -> 0.0009s
==  ChangesetRepos: migrated (0.0010s) ========================================

==  CreateSearchHistories: migrating ==========================================
-- create_table(:search_histories)
NOTICE:  CREATE TABLE will create implicit sequence "search_histories_id_seq" for serial column "search_histories.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "search_histories_pkey" for table "search_histories"
   -> 0.0713s
==  CreateSearchHistories: migrated (0.0714s) =================================

==  CreateSearchFavorites: migrating ==========================================
-- create_table(:search_favorites)
NOTICE:  CREATE TABLE will create implicit sequence "search_favorites_id_seq" for serial column "search_favorites.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "search_favorites_pkey" for table "search_favorites"
   -> 0.0715s
==  CreateSearchFavorites: migrated (0.0716s) =================================

==  AddChangesetStatus: migrating =============================================
-- add_column(:changesets, :state, :string, {:null=>false, :default=>"new"})
   -> 0.0311s
-- remove_column(:changesets, :published)
   -> 0.0104s
==  AddChangesetStatus: migrated (0.0416s) ====================================

==  AddPlanToProduct: migrating ===============================================
-- add_column(:products, :sync_plan_id, :integer, {:null=>false, :default=>25})
   -> 0.0014s
==  AddPlanToProduct: migrated (0.0015s) ======================================

==  AddUserPageSize: migrating ================================================
-- add_column(:users, :page_size, :integer, {:null=>false, :default=>25})
   -> 0.0014s
==  AddUserPageSize: migrated (0.0015s) =======================================

==  CreateDelayedJobs: migrating ==============================================
-- create_table(:delayed_jobs, {:force=>true})
NOTICE:  CREATE TABLE will create implicit sequence "delayed_jobs_id_seq" for serial column "delayed_jobs.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "delayed_jobs_pkey" for table "delayed_jobs"
   -> 0.0556s
-- add_index(:delayed_jobs, [:priority, :run_at], {:name=>"delayed_jobs_priority"})
   -> 0.0253s
==  CreateDelayedJobs: migrated (0.0810s) =====================================

==  ChangesetUsers: migrating =================================================
-- create_table(:changeset_users)
NOTICE:  CREATE TABLE will create implicit sequence "changeset_users_id_seq" for serial column "changeset_users.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "changeset_users_pkey" for table "changeset_users"
   -> 0.0322s
==  ChangesetUsers: migrated (0.0323s) ========================================

==  ProductsSystemTemplates: migrating ========================================
-- create_table(:products_system_templates, {:id=>false})
   -> 0.0007s
==  ProductsSystemTemplates: migrated (0.0008s) ===============================

==  CreateOrganizationUser: migrating =========================================
-- create_table(:organizations_users, {:id=>false})
   -> 0.0008s
-- add_index(:organizations_users, :organization_id)
   -> 0.0319s
-- add_index(:organizations_users, :user_id)
   -> 0.0334s
==  CreateOrganizationUser: migrated (0.0664s) ================================

==  AddRoleDescription: migrating =============================================
-- add_column(:roles, :description, :string, {:limit=>250})
   -> 0.0330s
==  AddRoleDescription: migrated (0.0331s) ====================================

==  AddUserDisabled: migrating ================================================
-- add_column(:users, :disabled, :boolean, {:default=>false})
   -> 0.0007s
==  AddUserDisabled: migrated (0.0008s) =======================================

==  CreateActivationKeys: migrating ===========================================
-- create_table(:activation_keys)
NOTICE:  CREATE TABLE will create implicit sequence "activation_keys_id_seq" for serial column "activation_keys.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "activation_keys_pkey" for table "activation_keys"
   -> 0.0672s
==  CreateActivationKeys: migrated (0.0674s) ==================================

==  TaskStatus: migrating =====================================================
-- create_table(:task_statuses)
NOTICE:  CREATE TABLE will create implicit sequence "task_statuses_id_seq" for serial column "task_statuses.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "task_statuses_pkey" for table "task_statuses"
   -> 0.0676s
-- add_index(:task_statuses, :uuid)
   -> 0.0335s
==  TaskStatus: migrated (0.1013s) ============================================

==  CreateSubscriptions: migrating ============================================
-- create_table(:subscriptions)
NOTICE:  CREATE TABLE will create implicit sequence "subscriptions_id_seq" for serial column "subscriptions.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "subscriptions_pkey" for table "subscriptions"
   -> 0.0345s
-- create_table(:key_subscriptions)
NOTICE:  CREATE TABLE will create implicit sequence "key_subscriptions_id_seq" for serial column "key_subscriptions.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "key_subscriptions_pkey" for table "key_subscriptions"
   -> 0.0338s
==  CreateSubscriptions: migrated (0.0684s) ===================================

==  AddChangesetTaskId: migrating =============================================
-- change_table(:changesets)
   -> 0.0006s
==  AddChangesetTaskId: migrated (0.0006s) ====================================

==  AddChangesetsDescription: migrating =======================================
-- add_column(:changesets, :description, :string)
   -> 0.0005s
==  AddChangesetsDescription: migrated (0.0006s) ==============================

==  AddChangesetDependency: migrating =========================================
-- create_table(:changeset_dependencies)
NOTICE:  CREATE TABLE will create implicit sequence "changeset_dependencies_id_seq" for serial column "changeset_dependencies.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "changeset_dependencies_pkey" for table "changeset_dependencies"
   -> 0.0687s
==  AddChangesetDependency: migrated (0.0688s) ================================

==  AddSystemTemplateToSystem: migrating ======================================
-- add_column(:systems, :system_template_id, :integer)
   -> 0.0004s
-- add_index(:systems, :system_template_id)
   -> 0.0349s
==  AddSystemTemplateToSystem: migrated (0.0355s) =============================

==  AddUserToActivationKeys: migrating ========================================
-- add_column(:activation_keys, :user_id, :integer)
   -> 0.0004s
-- add_index(:activation_keys, :user_id)
   -> 0.0355s
==  AddUserToActivationKeys: migrated (0.0361s) ===============================

==  CreateSystemActivationKeys: migrating =====================================
-- create_table(:system_activation_keys)
NOTICE:  CREATE TABLE will create implicit sequence "system_activation_keys_id_seq" for serial column "system_activation_keys.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "system_activation_keys_pkey" for table "system_activation_keys"
   -> 0.0361s
-- add_index(:system_activation_keys, :system_id)
   -> 0.0334s
-- add_index(:system_activation_keys, :activation_key_id)
   -> 0.0335s
==  CreateSystemActivationKeys: migrated (0.1034s) ============================

==  ChangesetDistributions: migrating =========================================
-- create_table(:changeset_distributions)
NOTICE:  CREATE TABLE will create implicit sequence "changeset_distributions_id_seq" for serial column "changeset_distributions.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "changeset_distributions_pkey" for table "changeset_distributions"
   -> 0.0705s
==  ChangesetDistributions: migrated (0.0706s) ================================

==  AddDetailsToPermission: migrating =========================================
-- add_column(:permissions, :name, :string, {:default=>""})
   -> 0.0010s
-- add_column(:permissions, :description, :string, {:default=>""})
   -> 0.0367s
==  AddDetailsToPermission: migrated (0.0378s) ================================

==  ChangesetsSystemTemplate: migrating =======================================
-- create_table(:changesets_system_templates, {:id=>false})
   -> 0.0009s
==  ChangesetsSystemTemplate: migrated (0.0010s) ==============================

==  CreateTemplates: migrating ================================================
-- create_table(:system_templates)
NOTICE:  CREATE TABLE will create implicit sequence "system_templates_id_seq" for serial column "system_templates.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "system_templates_pkey" for table "system_templates"
   -> 0.1629s
==  CreateTemplates: migrated (0.1631s) =======================================

==  AddReqeustType: migrating =================================================
-- add_column(:notices, :request_type, :string)
   -> 0.0005s
==  AddReqeustType: migrated (0.0006s) ========================================

==  RenameSubscriptionsPools: migrating =======================================
-- rename_table(:subscriptions, :pools)
   -> 0.0015s
==  RenameSubscriptionsPools: migrated (0.0016s) ==============================

==  RenameKeySubscrptionKeyPool: migrating ====================================
-- rename_table(:key_subscriptions, :key_pools)
   -> 0.0004s
==  RenameKeySubscrptionKeyPool: migrated (0.0005s) ===========================

==  RenameSubscriptionUuid: migrating =========================================
-- rename_column(:pools, :subscription, :cp_id)
   -> 0.0005s
==  RenameSubscriptionUuid: migrated (0.0006s) ================================

==  RenameKeyPoolSubscriptionId: migrating ====================================
-- rename_column(:key_pools, :subscription_id, :pool_id)
   -> 0.0004s
==  RenameKeyPoolSubscriptionId: migrated (0.0005s) ===========================

==  CreateSystemTemplatePackGroups: migrating =================================
-- create_table(:system_template_pack_groups)
NOTICE:  CREATE TABLE will create implicit sequence "system_template_pack_groups_id_seq" for serial column "system_template_pack_groups.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "system_template_pack_groups_pkey" for table "system_template_pack_groups"
   -> 0.0301s
-- add_index(:system_template_pack_groups, :system_template_id)
   -> 0.0357s
==  CreateSystemTemplatePackGroups: migrated (0.0659s) ========================

==  CreateSystemTemplatePgCategories: migrating ===============================
-- create_table(:system_template_pg_categories)
NOTICE:  CREATE TABLE will create implicit sequence "system_template_pg_categories_id_seq" for serial column "system_template_pg_categories.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "system_template_pg_categories_pkey" for table "system_template_pg_categories"
   -> 0.0317s
-- add_index(:system_template_pg_categories, :system_template_id)
   -> 0.0336s
==  CreateSystemTemplatePgCategories: migrated (0.0655s) ======================

==  SystemTemplatePackages: migrating =========================================
-- create_table(:system_template_packages)
NOTICE:  CREATE TABLE will create implicit sequence "system_template_packages_id_seq" for serial column "system_template_packages.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "system_template_packages_pkey" for table "system_template_packages"
   -> 0.0658s
-- add_index(:system_template_packages, :system_template_id)
   -> 0.0334s
==  SystemTemplatePackages: migrated (0.0995s) ================================

==  CreateFilters: migrating ==================================================
-- create_table(:filters)
NOTICE:  CREATE TABLE will create implicit sequence "filters_id_seq" for serial column "filters.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "filters_pkey" for table "filters"
   -> 0.0326s
==  CreateFilters: migrated (0.0327s) =========================================

==  FiltersProducts: migrating ================================================
-- create_table(:filters_products, {:id=>false})
   -> 0.0007s
==  FiltersProducts: migrated (0.0008s) =======================================

==  CreateRepository: migrating ===============================================
-- create_table(:repositories)
NOTICE:  CREATE TABLE will create implicit sequence "repositories_id_seq" for serial column "repositories.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "repositories_pkey" for table "repositories"
   -> 0.5671s
==  CreateRepository: migrated (0.5673s) ======================================

==  AddChangesetsDependencyDependencyOf: migrating ============================
-- add_column(:changeset_dependencies, :dependency_of, :string)
   -> 0.0004s
==  AddChangesetsDependencyDependencyOf: migrated (0.0005s) ===================

==  AddSystemTemplateDistribution: migrating ==================================
-- create_table(:system_template_distributions)
NOTICE:  CREATE TABLE will create implicit sequence "system_template_distributions_id_seq" for serial column "system_template_distributions.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "system_template_distributions_pkey" for table "system_template_distributions"
   -> 0.0587s
-- add_index(:system_template_distributions, :system_template_id)
   -> 0.0584s
==  AddSystemTemplateDistribution: migrated (0.1173s) =========================

==  AddEmailToUser: migrating =================================================
-- add_column(:users, :email, :string)
   -> 0.0005s
==  AddEmailToUser: migrated (0.0006s) ========================================

==  AddPasswordResetToUsers: migrating ========================================
-- add_column(:users, :password_reset_token, :string)
   -> 0.0006s
-- add_column(:users, :password_reset_sent_at, :datetime)
   -> 0.0004s
==  AddPasswordResetToUsers: migrated (0.0011s) ===============================

==  AddRepoDetails: migrating =================================================
-- add_column(:repositories, :release, :string, {:null=>true})
   -> 0.0008s
==  AddRepoDetails: migrated (0.0009s) ========================================

==  FixRepositoryWhitelist: migrating =========================================
-- rename_column(:repositories, :blacklisted, :enabled)
   -> 0.0005s
-- change_column_default(:repositories, :enabled, true)
   -> 0.0006s
==  FixRepositoryWhitelist: migrated (0.0013s) ================================

==  UpdateRepoAddMajorMinor: migrating ========================================
-- add_column(:repositories, :major, :integer)
   -> 0.0005s
-- add_column(:repositories, :minor, :string)
   -> 0.0005s
==  UpdateRepoAddMajorMinor: migrated (0.0011s) ===============================

==  RemoveRepoRelease: migrating ==============================================
-- remove_column(:repositories, :release)
   -> 0.0004s
==  RemoveRepoRelease: migrated (0.0005s) =====================================

==  CreateGpgs: migrating =====================================================
-- create_table(:gpg_keys)
NOTICE:  CREATE TABLE will create implicit sequence "gpg_keys_id_seq" for serial column "gpg_keys.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "gpg_keys_pkey" for table "gpg_keys"
   -> 0.0817s
-- add_index(:gpg_keys, [:organization_id, :name], {:unique=>true})
   -> 0.0337s
==  CreateGpgs: migrated (0.1978s) ============================================

==  AddGpgColumnToRepository: migrating =======================================
-- add_column(:repositories, :gpg_key_id, :integer)
   -> 0.0004s
==  AddGpgColumnToRepository: migrated (0.0006s) ==============================

==  AddDefaultGpgKeyToProduct: migrating ======================================
-- add_column(:products, :gpg_key_id, :integer)
   -> 0.0004s
==  AddDefaultGpgKeyToProduct: migrated (0.0005s) =============================

==  AddSystemTasks: migrating =================================================
-- create_table(:system_tasks)
NOTICE:  CREATE TABLE will create implicit sequence "system_tasks_id_seq" for serial column "system_tasks.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "system_tasks_pkey" for table "system_tasks"
   -> 0.0405s
==  AddSystemTasks: migrated (0.0406s) ========================================

==  AddOrgDeletionTaskId: migrating ===========================================
-- add_column(:organizations, :task_id, :integer, {:default=>nil})
   -> 0.0008s
==  AddOrgDeletionTaskId: migrated (0.0010s) ==================================

==  AddParamsToTaskStatus: migrating ==========================================
-- add_column(:task_statuses, :parameters, :text)
   -> 0.0005s
==  AddParamsToTaskStatus: migrated (0.0006s) =================================

==  AddTaskTypeToTaskStatus: migrating ========================================
-- add_column(:task_statuses, :task_type, :string)
   -> 0.0005s
==  AddTaskTypeToTaskStatus: migrated (0.0006s) ===============================

==  AddingPreferencesToUser: migrating ========================================
-- add_column(:users, :preferences, :text)
   -> 0.0004s
==  AddingPreferencesToUser: migrated (0.0005s) ===============================

==  CreateMarketingEngineeringProducts: migrating =============================
-- create_table(:marketing_engineering_products)
NOTICE:  CREATE TABLE will create implicit sequence "marketing_engineering_products_id_seq" for serial column "marketing_engineering_products.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "marketing_engineering_products_pkey" for table "marketing_engineering_products"
   -> 0.0405s
-- add_index(:marketing_engineering_products, :marketing_product_id)
   -> 0.0418s
-- add_index(:marketing_engineering_products, :engineering_product_id)
   -> 0.0335s
==  CreateMarketingEngineeringProducts: migrated (0.1160s) ====================

==  UpdateProductsAddType: migrating ==========================================
-- add_column(:products, :type, :string)
   -> 0.0005s
==  UpdateProductsAddType: migrated (0.0006s) =================================

** Invoke db:schema:dump (first_time)
** Invoke environment 
** Execute db:schema:dump
** Execute db:migrate:reset
** Invoke db:seed (first_time)
** Invoke db:abort_if_pending_migrations (first_time)
** Invoke environment 
** Execute db:abort_if_pending_migrations
** Execute db:seed
** Execute setup
Database sucessfully recreated in production
Starting Katello instance
Starting katello: Starting server on 0.0.0.0:5000 ... 
Starting server on 0.0.0.0:5001 ... 
                                                           [  OK  ]
Starting Katello jobs instance
Starting katello-jobs:                                     [  OK  ]
DONE. CHECK ALL THE MESSAGES ABOVE!
[root@dhcp201-197 ~]# echo $?
0
[root@dhcp201-197 ~]#