Satellite 6.17 upgrade fails with ERROR: duplicate key value violates unique constraint "index_katello_installed_packages_on_nvrea" 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: Tasks: TOP => db:migrate 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: (See full trace by running task with --trace) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240312133027 ExtendTemplateInvocationEvents: migrating =================== 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- change_table(:template_invocation_events) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0082s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- remove_index(:template_invocation_events, {:name=>:unique_template_invocation_events_index}) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0073s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- remove_column(:template_invocation_events, :sequence_id) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0003s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- change_table(:template_invocation_events) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0150s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240312133027 ExtendTemplateInvocationEvents: migrated (0.0508s) ========== 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240508100434 AddContentIdToKatelloRepository: migrating ================== 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_repositories, :content_id, :string) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0018s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240508100434 AddContentIdToKatelloRepository: migrated (0.0019s) ========= 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240730163043 AddContentViewEnvironmentActivationKey: migrating =========== 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- create_table(:katello_content_view_environment_activation_keys) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0400s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- remove_column(:katello_activation_keys, :content_view_id) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0052s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- remove_column(:katello_activation_keys, :environment_id) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0013s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240730163043 AddContentViewEnvironmentActivationKey: migrated (0.2559s) == 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240806130902 AddMoreDebFields: migrating ================================= 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_debs, :section, :string, {:limit=>255}) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0015s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_debs, :maintainer, :string, {:limit=>255}) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0003s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_debs, :homepage, :string, {:limit=>255}) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0002s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_debs, :installed_size, :string, {:limit=>255}) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0004s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240806130902 AddMoreDebFields: migrated (0.0025s) ======================== 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240903194428 AddPriorityToContentViewEnvironmentActivationKey: migrating = 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_content_view_environment_activation_keys, :priority, :integer, {:default=>0, :null=>false}) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0008s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240903194428 AddPriorityToContentViewEnvironmentActivationKey: migrated (0.0009s) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240924161240 KatelloRecreateEvrConstructs: migrating ===================== 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- extension_enabled?("evr") 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0244s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- execute("DROP EXTENSION evr CASCADE;\n") 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0097s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- execute(" create type evr_array_item as (\n n NUMERIC,\n s TEXT\n);\n\ncreate type evr_t as (\n epoch INT,\n version evr_array_item[],\n release evr_array_item[]\n);\n\nCREATE FUNCTION evr_trigger() RETURNS trigger AS $$\n BEGIN\n NEW.evr = (select ROW(coalesce(NEW.epoch::numeric,0),\n rpmver_array(coalesce(NEW.version,'empty'))::evr_array_item[],\n rpmver_array(coalesce(NEW.release,'empty'))::evr_array_item[])::evr_t);\n RETURN NEW;\n END;\n$$ language 'plpgsql';\n\ncreate or replace FUNCTION empty(t TEXT)\n\tRETURNS BOOLEAN as $$\n\tBEGIN\n\t\treturn t ~ '^[[:space:]]*$';\n\tEND;\n$$ language 'plpgsql';\n\ncreate or replace FUNCTION isalpha(ch CHAR)\n RETURNS BOOLEAN as $$\n BEGIN\n if ascii(ch) between ascii('a') and ascii('z') or\n ascii(ch) between ascii('A') and ascii('Z')\n then\n return TRUE;\n end if;\n return FALSE;\n END;\n$$ language 'plpgsql';\n\ncreate or replace FUNCTION isalphanum(ch CHAR)\n\tRETURNS BOOLEAN as $$\n\tBEGIN\n\t\tif ascii(ch) between ascii('a') and ascii('z') or\n\t\t\tascii(ch) between ascii('A') and ascii('Z') or\n\t\t\tascii(ch) between ascii('0') and ascii('9')\n\t\tthen\n\t\t\treturn TRUE;\n\t\tend if;\n\t\treturn FALSE;\n\tEND;\n$$ language 'plpgsql';\n\ncreate or replace function isdigit(ch CHAR)\n\tRETURNS BOOLEAN as $$\n\tBEGIN\n\t if ascii(ch) between ascii('0') and ascii('9')\n\t then\n\t\treturn TRUE;\n\t end if;\n\t return FALSE;\n\tEND ;\n$$ language 'plpgsql';\n\ncreate or replace FUNCTION rpmver_array (string1 IN VARCHAR)\n\tRETURNS evr_array_item[] as $$\n\tdeclare\n\t\tstr1 VARCHAR := string1;\n\t\tdigits VARCHAR(10) := '0123456789';\n\t\tlc_alpha VARCHAR(27) := 'abcdefghijklmnopqrstuvwxyz';\n\t\tuc_alpha VARCHAR(27) := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';\n\t\talpha VARCHAR(54) := lc_alpha || uc_alpha;\n\t\tone VARCHAR;\n\t\tisnum BOOLEAN;\n\t\tver_array evr_array_item[] := ARRAY[]::evr_array_item[];\n\tBEGIN\n\t\tif str1 is NULL\n\t\tthen\n\t\t\tRAISE EXCEPTION 'VALUE_ERROR.';\n\t\tend if;\n\n\t\tone := str1;\n\t\t<>\n\t\twhile one <> ''\n\t\tloop\n\t\t\tdeclare\n\t\t\t\tsegm1 VARCHAR;\n\t\t\t\tsegm1_n NUMERIC := 0;\n\t\t\tbegin\n\t\t\t\t-- Throw out all non-alphanum characters\n\t\t\t\twhile one <> '' and not isalphanum(one)\n\t\t\t\tloop\n\t\t\t\t\tone := substr(one, 2);\n\t\t\t\tend loop;\n\t\t\t\tstr1 := one;\n\t\t\t\tif str1 <> '' and isdigit(str1)\n\t\t\t\tthen\n\t\t\t\t\tstr1 := ltrim(str1, digits);\n\t\t\t\t\tisnum := true;\n\t\t\t\telse\n\t\t\t\t\tstr1 := ltrim(str1, alpha);\n\t\t\t\t\tisnum := false;\n\t\t\t\tend if;\n\t\t\t\tif str1 <> ''\n\t\t\t\tthen segm1 := substr(one, 1, length(one) - length(str1));\n\t\t\t\telse segm1 := one;\n\t\t\t\tend if;\n\n\t\t\t\tif segm1 = '' then return ver_array; end if; /* arbitrary */\n\t\t\t\tif isnum\n\t\t\t\tthen\n\t\t\t\t\tsegm1 := ltrim(segm1, '0');\n\t\t\t\t\tif segm1 <> '' then segm1_n := segm1::numeric; end if;\n\t\t\t\t\tsegm1 := NULL;\n\t\t\t\telse\n\t\t\t\tend if;\n\t\t\t\tver_array := array_append(ver_array, (segm1_n, segm1)::evr_array_item);\n\t\t\t\tone := str1;\n\t\t\tend;\n\t\tend loop segment_loop;\n\n\t\treturn ver_array;\n\tEND ;\n$$ language 'plpgsql';\n\n") 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0065s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_rpms, :evr, :evr_t) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0005s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_installed_packages, :evr, :evr_t) 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0003s 2025-05-15 14:16:12 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- execute(" update katello_rpms SET evr = (ROW(coalesce(epoch::numeric,0),\n rpmver_array(coalesce(version,'empty'))::evr_array_item[],\n rpmver_array(coalesce(release,'empty'))::evr_array_item[])::evr_t);\n\n update katello_installed_packages SET evr = (ROW(coalesce(epoch::numeric,0),\n rpmver_array(coalesce(version,'empty'))::evr_array_item[],\n rpmver_array(coalesce(release,'empty'))::evr_array_item[])::evr_t);\n") 2025-05-15 14:16:12 [ERROR ] [configure] '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0] 2025-05-15 14:16:12 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: change from 'notrun' to ['0'] failed: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0] 2025-05-15 14:16:12 [DEBUG ] [configure] Exec[foreman-rake-db:migrate](provider=posix): Executing check '/usr/sbin/foreman-rake db:abort_if_pending_migrations' 2025-05-15 14:16:12 [DEBUG ] [configure] Executing with uid=foreman: '/usr/sbin/foreman-rake db:abort_if_pending_migrations' 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: Run `bin/rails db:migrate` to update your database then try again. 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: You have 14 pending migrations: 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20240924161240 KatelloRecreateEvrConstructs 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241007200316 AddFieldsToKatelloDockerManifestList 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241007212705 AddBootcFactsToContentFacet 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241022121706 AddSyncDependenciesOption 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241025151105 RemovePulp3MigratedHrefsFromContentTables 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241030181402 CreateKatelloFlatpakTables 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241101144625 RemoveSystemPurposeAddons 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241107002541 AddRegistryURLToKatelloFlatpakRemotes 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241112145802 AddManifestEntityToContentFacets 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241120213713 AddAllowOtherTypesToContentViewErratumFilterRules 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241126150849 RemoveRemoteExecutionWorkersPoolSize 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241206183052 AddContentTypeToContainerManifestsAndLists 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241217190624 AddUniqueIndexToRuleIdAndHostIdInInsightsHits 2025-05-15 14:16:32 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/unless: 20241220184900 ChangeSyncInsightsRecommendationsToTrue 2025-05-15 14:16:32 [DEBUG ] [configure] Exec[foreman-rake-db:migrate](provider=posix): Executing '/usr/sbin/foreman-rake db:migrate' 2025-05-15 14:16:32 [DEBUG ] [configure] Executing with uid=foreman: '/usr/sbin/foreman-rake db:migrate' 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: rake aborted! 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: StandardError: An error has occurred, this and all later migrations canceled: 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_katello_installed_packages_on_nvrea" 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: DETAIL: Key (nvrea)=(gcc-objc++-4.8.5-39.el7.x86_64) already exists. 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: /usr/share/gems/gems/activerecord-7.0.8.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:48:in `exec' 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: /usr/share/gems/gems/activerecord-7.0.8.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:48:in `block (2 levels) in execute' ---- 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: Tasks: TOP => db:migrate 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: (See full trace by running task with --trace) 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: == 20240924161240 KatelloRecreateEvrConstructs: migrating ===================== 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- extension_enabled?("evr") 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0020s 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- execute("DROP EXTENSION evr CASCADE;\n") 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0022s 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- execute(" create type evr_array_item as (\n n NUMERIC,\n s TEXT\n);\n\ncreate type evr_t as (\n epoch INT,\n version evr_array_item[],\n release evr_array_item[]\n);\n\nCREATE FUNCTION evr_trigger() RETURNS trigger AS $$\n BEGIN\n NEW.evr = (select ROW(coalesce(NEW.epoch::numeric,0),\n rpmver_array(coalesce(NEW.version,'empty'))::evr_array_item[],\n rpmver_array(coalesce(NEW.release,'empty'))::evr_array_item[])::evr_t);\n RETURN NEW;\n END;\n$$ language 'plpgsql';\n\ncreate or replace FUNCTION empty(t TEXT)\n\tRETURNS BOOLEAN as $$\n\tBEGIN\n\t\treturn t ~ '^[[:space:]]*$';\n\tEND;\n$$ language 'plpgsql';\n\ncreate or replace FUNCTION isalpha(ch CHAR)\n RETURNS BOOLEAN as $$\n BEGIN\n if ascii(ch) between ascii('a') and ascii('z') or\n ascii(ch) between ascii('A') and ascii('Z')\n then\n return TRUE;\n end if;\n return FALSE;\n END;\n$$ language 'plpgsql';\n\ncreate or replace FUNCTION isalphanum(ch CHAR)\n\tRETURNS BOOLEAN as $$\n\tBEGIN\n\t\tif ascii(ch) between ascii('a') and ascii('z') or\n\t\t\tascii(ch) between ascii('A') and ascii('Z') or\n\t\t\tascii(ch) between ascii('0') and ascii('9')\n\t\tthen\n\t\t\treturn TRUE;\n\t\tend if;\n\t\treturn FALSE;\n\tEND;\n$$ language 'plpgsql';\n\ncreate or replace function isdigit(ch CHAR)\n\tRETURNS BOOLEAN as $$\n\tBEGIN\n\t if ascii(ch) between ascii('0') and ascii('9')\n\t then\n\t\treturn TRUE;\n\t end if;\n\t return FALSE;\n\tEND ;\n$$ language 'plpgsql';\n\ncreate or replace FUNCTION rpmver_array (string1 IN VARCHAR)\n\tRETURNS evr_array_item[] as $$\n\tdeclare\n\t\tstr1 VARCHAR := string1;\n\t\tdigits VARCHAR(10) := '0123456789';\n\t\tlc_alpha VARCHAR(27) := 'abcdefghijklmnopqrstuvwxyz';\n\t\tuc_alpha VARCHAR(27) := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';\n\t\talpha VARCHAR(54) := lc_alpha || uc_alpha;\n\t\tone VARCHAR;\n\t\tisnum BOOLEAN;\n\t\tver_array evr_array_item[] := ARRAY[]::evr_array_item[];\n\tBEGIN\n\t\tif str1 is NULL\n\t\tthen\n\t\t\tRAISE EXCEPTION 'VALUE_ERROR.';\n\t\tend if;\n\n\t\tone := str1;\n\t\t<>\n\t\twhile one <> ''\n\t\tloop\n\t\t\tdeclare\n\t\t\t\tsegm1 VARCHAR;\n\t\t\t\tsegm1_n NUMERIC := 0;\n\t\t\tbegin\n\t\t\t\t-- Throw out all non-alphanum characters\n\t\t\t\twhile one <> '' and not isalphanum(one)\n\t\t\t\tloop\n\t\t\t\t\tone := substr(one, 2);\n\t\t\t\tend loop;\n\t\t\t\tstr1 := one;\n\t\t\t\tif str1 <> '' and isdigit(str1)\n\t\t\t\tthen\n\t\t\t\t\tstr1 := ltrim(str1, digits);\n\t\t\t\t\tisnum := true;\n\t\t\t\telse\n\t\t\t\t\tstr1 := ltrim(str1, alpha);\n\t\t\t\t\tisnum := false;\n\t\t\t\tend if;\n\t\t\t\tif str1 <> ''\n\t\t\t\tthen segm1 := substr(one, 1, length(one) - length(str1));\n\t\t\t\telse segm1 := one;\n\t\t\t\tend if;\n\n\t\t\t\tif segm1 = '' then return ver_array; end if; /* arbitrary */\n\t\t\t\tif isnum\n\t\t\t\tthen\n\t\t\t\t\tsegm1 := ltrim(segm1, '0');\n\t\t\t\t\tif segm1 <> '' then segm1_n := segm1::numeric; end if;\n\t\t\t\t\tsegm1 := NULL;\n\t\t\t\telse\n\t\t\t\tend if;\n\t\t\t\tver_array := array_append(ver_array, (segm1_n, segm1)::evr_array_item);\n\t\t\t\tone := str1;\n\t\t\tend;\n\t\tend loop segment_loop;\n\n\t\treturn ver_array;\n\tEND ;\n$$ language 'plpgsql';\n\n") 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0041s 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_rpms, :evr, :evr_t) 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0010s 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- add_column(:katello_installed_packages, :evr, :evr_t) 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -> 0.0005s 2025-05-15 14:17:27 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: -- execute(" update katello_rpms SET evr = (ROW(coalesce(epoch::numeric,0),\n rpmver_array(coalesce(version,'empty'))::evr_array_item[],\n rpmver_array(coalesce(release,'empty'))::evr_array_item[])::evr_t);\n\n update katello_installed_packages SET evr = (ROW(coalesce(epoch::numeric,0),\n rpmver_array(coalesce(version,'empty'))::evr_array_item[],\n rpmver_array(coalesce(release,'empty'))::evr_array_item[])::evr_t);\n") 2025-05-15 14:17:27 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]: Failed to call refresh: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0] 2025-05-15 14:17:27 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0] 2025-05-15 14:17:27 [DEBUG ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]: Evaluated in 166.89 seconds 2025-05-15 14:17:27 [DEBUG ] [configure] Foreman::Rake[db:migrate]: Starting to evaluate the resource (1789 of 2065) 2025-05-15 14:17:27 [DEBUG ] [configure] Foreman::Rake[db:migrate]: Resource is being skipped, unscheduling all events