Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

Bug 745542

Summary:	Script katello-reset-dbs does not work
Product:	Red Hat Satellite	Reporter:	Lukas Zapletal <lzap>
Component:	Packaging	Assignee:	Lukas Zapletal <lzap>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Katello QA List <katello-qa-list>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	6.0.0	CC:	sghai
Target Milestone:	Unspecified
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2012-08-22 18:00:44 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	747354

Description Lukas Zapletal 2011-10-12 16:22:15 UTC

Exception is thrown because postgres user is no longer "katello". Need to fix the script.

Comment 1 Lukas Zapletal 2011-10-13 14:16:06 UTC

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).

Comment 2 Lukas Zapletal 2011-10-17 15:00:35 UTC

6ee681fc05d13ad48ea596353585dae592630f1e

Comment 3 Sachin Ghai 2011-12-30 09:14:03 UTC

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 ~]#