Red Hat Satellite upgrade to version 6.16 fails with PostgreSQL dependency errors

Solution Verified - Updated

Environment

  • Red Hat Satellite 6.16
  • RHEL8

Issue

  • Red Hat Satellite upgrade to 6.16 version is failing due to dependency issue:

        2024-11-11 08:47:58 [NOTICE] [pre] Performing upgrade of PostgreSQL to 13
    2024-11-11 08:47:58 [DEBUG ] [pre] Getting running services
    2024-11-11 08:47:58 [DEBUG ] [pre] Found running services []
    2024-11-11 08:47:58 [NOTICE] [pre] Upgrading PostgreSQL packages
    2024-11-11 08:47:58 [DEBUG ] [root] Executing: dnf module switch-to postgresql:13 -y
    2024-11-11 08:47:59 [DEBUG ] [root] Updating Subscription Management repositories.
    2024-11-11 08:47:59 [DEBUG ] [root] Modular dependency problem:
    2024-11-11 08:47:59 [DEBUG ] [root] 
    2024-11-11 08:47:59 [DEBUG ] [root]  Problem: conflicting requests
    2024-11-11 08:47:59 [DEBUG ] [root]   - nothing provides module(postgresql:13) needed by module satellite:el8:61620241101164956:f539b4f8.x86_64 from @modulefailsafe
    2024-11-11 08:47:59 [DEBUG ] [root] Error: Problems in request:
    2024-11-11 08:47:59 [DEBUG ] [root] missing groups or modules: postgresql:13
    2024-11-11 08:47:59 [DEBUG ] [root] Modular dependency problems:
    2024-11-11 08:47:59 [DEBUG ] [root] 
    2024-11-11 08:47:59 [DEBUG ] [root]  Problem: conflicting requests
    2024-11-11 08:47:59 [DEBUG ] [root]   - nothing provides module(postgresql:13) needed by module satellite:el8:61620241101164956:f539b4f8.x86_64 from @modulefailsafe
    2024-11-11 08:47:59 [ERROR ] [root] dnf module switch-to postgresql:13 -y failed! Check the output for error!
    2024-11-11 08:47:59 [DEBUG ] [pre_exit] Hook /usr/share/foreman-installer/hooks/pre_exit/20-certs_regenerate.rb returned nil
    2024-11-11 08:47:59 [DEBUG ] [root] Exit with status code: 1 (signal was 1)
    2024-11-11 08:47:59 [DEBUG ] [root] Cleaning /tmp/kafo_installation20241111-3876392-ntyoqu
    2024-11-11 08:47:59 [DEBUG ] [root] Cleaning /tmp/default_values.yaml
    2024-11-11 08:47:59 [DEBUG ] [root] Installer finished in 3.43525348 seconds
    

Resolution

  • Satellite 6.15 uses postgresql 12. Enable right module and execute satellite-installer to confirm 6.15 is correctly configured:

    # dnf module disable postgresql:13
    # dnf module enable postgresql:12
    # satellite-installer
    
  • Then retry the upgrade to 6.16. The upgrade will modify the postgresql dnf module accordingly to its requirements.

  • Restore the satellite backup/snapshot on the working state 6.15 and then try to upgrade back to 6.16 latest

Refer to know more about Satellite 6 Component Versions which upstream versions of these projects are delivered with Satellite 6.

For more KB articles/solutions related to Red Hat Satellite 6.x Installation/Upgrade/Update Issues, please refer to the Red Hat Satellite Consolidated Troubleshooting Article for Red Hat Satellite 6.x Installation/Upgrade/Update Issues.

Root Cause

  • Satellite 6.15 installed on RHEL uses postgresql 12. Need to enable right module and execute satellite-installer to confirm 6.15 is correctly configured.

Diagnostic Steps

  • Manually updated postgresql:13 on satellite, Error message shows:

        # dnf history 
          Updating Subscription Management repositories.
          Modular dependency problem:
    
          Problem: conflicting requests
          - nothing provides module(postgresql:13) needed by module satellite:el8:61620241101164956:f539b4f8.x86_64 
          from @modulefailsafe
          ID     | Command line                                                    | Date and time    | Action(s)      
          | Altered
          ------------------------------------------------------------------------------------------------------------ 
          ----------
          31 | localinstall ./postgresql-12.20-1.module+el8.10.0+22214+9beb89d | 2024-11-11 08:19 | Downgrade      |    
          3   
          30 | install ./postgresql-13.16-1.module+el8.10.0+22213+5adc94fe.x86 | 2024-11-11 07:36 | Upgrade        |    
          3   
          29 | install ./postgresql-12.20-1.module+el8.10.0+22214+9beb89d6.x86 | 2024-11-08 13:52 | Downgrade      |    
          3   
          28 | --disableplugin=foreman-protector update                        | 2024-11-08 13:36 | I, O, U        |  
          428 EE
    
SBR
Product(s)
Components
Category

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.