-
Bug
-
Resolution: Unresolved
-
Undefined
-
None
-
None
-
None
-
False
-
sat-rocket
-
None
-
None
-
None
-
None
Description of problem:
Seeing an issue occur in Satellite 6.17 during upgrades from 6.16, or during updates in 6.17 where the satellite-installer is complaing about the evr column not being found.
The 20240924161240_katello_recreate_evr_constructs.rb migration script is failing and showing this error:
2026-02-03 07:26:48 [DEBUG ] [configure] Exec[foreman-rake-db:migrate](provider=posix): Executing '/usr/sbin/foreman-rake db:migrate' 2026-02-03 07:26:48 [DEBUG ] [configure] Executing with uid=foreman: '/usr/sbin/foreman-rake db:migrate' 2026-02-03 07:27:02 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: rake aborted! 2026-02-03 07:27:02 [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: 2026-02-03 07:27:02 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: 2026-02-03 07:27:02 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: PG::UndefinedColumn: ERROR: column "evr" does not exist
Checking the database, we see the routines, extensions and data types for evr are missing. Running this:
su - postgres -c "psql -d foreman" SELECT routine_name FROM information_schema.routines WHERE routine_type = 'FUNCTION' AND routine_schema = 'public'; \dT \dx \q
Shows:
routine_name
------------------------
deb_version_cmp
deb_version_cmp_al
deb_version_cmp_num
deb_version_cmp_string
(4 rows)
List of data types
Schema | Name | Description
--------+------+-------------
(0 rows)
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)
How reproducible:
only seen by a small amount of users
Is this issue a regression from an earlier version:
Seems like it could be related to this Jira https://issues.redhat.com/browse/SAT-28288
Steps to Reproduce:
1. Not applicable, it has not been reproduced, only seen in the field
Actual behavior:
[Describe the issue in detail, including what is happening and where]
The satellite-maintain upgrade/update is failing during the db:migrate task for the script 20240924161240_katello_recreate_evr_constructs.rb
Expected behavior:
[Describe what should be happening instead]
The 20240924161240_katello_recreate_evr_constructs.rb shouldn't fail, and/or the evr contents in the database should be there
Business Impact / Additional info:
Prevents upgrading/updating to 6.17
This kcs was created as a work around to get the evr data types, routines and extension added back:
