Bug 2203499

Summary: Postgresql 15 module missing default on "server" profile from CentOS Stream 9
Product: Red Hat Enterprise Linux 9 Reporter: Louis Abel <tucklesepk>
Component: postgresql-15-moduleAssignee: Filip Januš <fjanus>
Status: CLOSED MIGRATED QA Contact: RHEL CS Apps Subsystem QE <rhel-cs-apps-subsystem-qe>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 9.2CC: neil
Target Milestone: rcKeywords: MigratedToJIRA
Target Release: ---Flags: pm-rhel: mirror+
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2023-09-20 17:08:00 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
CentOS Stream 9 Module Installation
none
RHEL 9.2 Module List
none
RHEL 9.2 Module Install none

Description Louis Abel 2023-05-13 08:20:42 UTC
Created attachment 1964335 [details]
CentOS Stream 9 Module Installation

Description of problem:
The release notes for RHEL 9.2 [1] as well as the information found in the bugzilla RFE [2] state that to install postgresql 15, to run the command `dnf module install postgresql:15`. This unfortunately fails with an error about broken groups and modules.

The "server" profile of postgresql:15 is not set to the default, as it is in CentOS Stream 9. This default was set in October 17, 2022[3].

The aforementioned command works in CentOS Stream 9.

Version-Release number of selected component (if applicable):
postgresql:15 module

How reproducible:
Always.


Steps to Reproduce:
1. install rhel 9.2
2. run `dnf module install postgresql:15`

Actual results:
Error: Problems in request:
broken groups or modules: postgresql:15

Expected results:
postgresql-server listed as installation option with the module being enabled as part of the dnf transaction.

Additional info:

[1] https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html/9.2_release_notes/new-features#new-features-dynamic-programming-languages-web-and-database-servers

[2] Bugzilla RFE: https://bugzilla.redhat.com/show_bug.cgi?id=2128410

[3] https://gitlab.com/redhat/centos-stream/release-engineering/module-defaults/-/blob/c9s/postgresql.yaml

Comment 1 Louis Abel 2023-05-13 08:21:08 UTC
Created attachment 1964336 [details]
RHEL 9.2 Module List

Comment 2 Louis Abel 2023-05-13 08:21:31 UTC
Created attachment 1964337 [details]
RHEL 9.2 Module Install

Comment 3 Filip Januš 2023-05-15 08:50:36 UTC
Hi Louis,
Thanks for your report. But unfortunately, I am not able to reproduce your issue. My steps were the following:

Install RHEL9.2
# cat /etc/redhat-release 
Red Hat Enterprise Linux release 9.2 (Plow)

# dnf module enable postgresql:15
Dependencies resolved.
====================================================================================================================================================
 Package                            Architecture                      Version                              Repository                          Size
====================================================================================================================================================
Enabling module streams:
 postgresql                                                           15                                                                           

Transaction Summary
====================================================================================================================================================

Is this ok [y/N]: y
Complete!

It seems to be working. Are you sure you are running the latest RHEL version?

Comment 4 Louis Abel 2023-05-15 10:04:30 UTC
Hello!

Yes, I am running the latest, RHEL 9.2. See below...

[root@rh92-1-dev ~]# date; dnf clean all; dnf module install postgresql:15
Mon May 15 11:18:59 AM CEST 2023
Updating Subscription Management repositories.
26 files removed
Updating Subscription Management repositories.
Red Hat Enterprise Linux 9 f 7.6 MB/s |  12 MB     00:01    
Red Hat CodeReady Linux Buil 5.9 MB/s | 5.6 MB     00:00    
Red Hat Enterprise Linux 9 f  12 MB/s |  21 MB     00:01    
Last metadata expiration check: 0:00:01 ago on Mon 15 May 2023 11:19:08 AM CEST.
No default profiles for module postgresql:15. Available profiles: client, server
Error: Problems in request:
broken groups or modules: postgresql:15

[root@rh92-1-dev ~]# cat /etc/os-release
NAME="Red Hat Enterprise Linux"
VERSION="9.2 (Plow)"
ID="rhel"
ID_LIKE="fedora"
VERSION_ID="9.2"
PLATFORM_ID="platform:el9"
PRETTY_NAME="Red Hat Enterprise Linux 9.2 (Plow)"
ANSI_COLOR="0;31"
LOGO="fedora-logo-icon"
CPE_NAME="cpe:/o:redhat:enterprise_linux:9::baseos"
HOME_URL="https://www.redhat.com/"
DOCUMENTATION_URL="https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 9"
REDHAT_BUGZILLA_PRODUCT_VERSION=9.2
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="9.2"

I see you're running `dnf module enable postgresql:15`, which I guess just enables the module but doesn't install any packages. This is what I understand about `dnf module install`...

* `dnf module install someModuleName:version` is supposed to enable and install a module from its default profile
  * If there's no default, it fails saying there's broken groups or modules (as shown in screenshot 3: "RHEL 9.2 Module Install")
  * afaict, most if not all modules should have a default set, like php:8.1 has "common" as its default profile[1], so in theory this shouldn't happen
* `dnf module install someModuleName:version/profile` is supposed to enable the module and install packages from the chosen profile
* `dnf module enable someModuleName:version` enables a module, but does not install packages

As an example of the above, if I run `dnf module install postgresql:15/server`, it does work, which I believe would be the intended result of just running `dnf module install postgresql:15` as noted in the RFE and red hat documentation. This enables postgresql:15 and attempts to install the packages in that module profile (in this case, "server").

[root@rh92-1-dev ~]# date; dnf clean all; dnf module install postgresql:15/server
Mon May 15 11:30:01 AM CEST 2023
Updating Subscription Management repositories.
26 files removed
Updating Subscription Management repositories.
Red Hat Enterprise Linux 9 f 9.0 MB/s |  12 MB     00:01    
Red Hat CodeReady Linux Buil 6.6 MB/s | 5.6 MB     00:00    
Red Hat Enterprise Linux 9 f  13 MB/s |  21 MB     00:01    
Last metadata expiration check: 0:00:01 ago on Mon 15 May 2023 11:30:10 AM CEST.
Dependencies resolved.
=============================================================
 Package    Arch   Version
                      Repository                        Size
=============================================================
Installing group/module packages:
 postgresql-server
            x86_64 15.2-1.module+el9.2.0+18159+266a3926
                      rhel-9-for-x86_64-appstream-rpms 6.1 M
Installing dependencies:
 libicu     x86_64 67.1-9.el9
                      rhel-9-for-x86_64-baseos-rpms    9.6 M
 postgresql x86_64 15.2-1.module+el9.2.0+18159+266a3926
                      rhel-9-for-x86_64-appstream-rpms 1.7 M
 postgresql-private-libs
            x86_64 15.2-1.module+el9.2.0+18159+266a3926
                      rhel-9-for-x86_64-appstream-rpms 139 k
Installing module profiles:
 postgresql/server
                                                            
Enabling module streams:
 postgresql        15                                       

Transaction Summary
=============================================================
Install  4 Packages

Total download size: 18 M
Installed size: 64 M
Is this ok [y/N]: 

But this unfortunately differs from the documentation and the RFE bugzilla too... Any ideas on what might be causing `dnf module install postgresql:15` to not work for my case?

Thank you for taking the time to look at this!

[1] https://gitlab.com/redhat/centos-stream/release-engineering/module-defaults/-/blob/c9s/php.yaml

Comment 5 Filip Januš 2023-05-15 10:45:31 UTC
Sorry, you are right. There is a missing default profile. It can be seen in the following. There is a missing "[d]" in the case of PostgreSQL module.

# dnf module list
Updating Subscription Management repositories.
Unable to read consumer identity

This system is not registered with an entitlement server. You can use subscription-manager to register.

Last metadata expiration check: 1:24:52 ago on Mon 15 May 2023 05:18:01 AM EDT.
rhel-AppStream
Name                 Stream           Profiles                                       Summary                                                        
maven                3.8              common [d]                                     Java project management and project comprehension tool         
nginx                1.22             common [d]                                     nginx webserver                                                
nodejs               18               common [d], development, minimal, s2i          Javascript runtime                                             
php                  8.1              common [d], devel, minimal                     PHP scripting language                                         
postgresql           15               client, server                                 PostgreSQL server and client module                            
ruby                 3.1              common [d]                                     An interpreter of object-oriented scripting language           

Hint: [d]efault, [e]nabled, [x]disabled, [i]nstalled

Comment 7 RHEL Program Management 2023-09-20 17:05:57 UTC
Issue migration from Bugzilla to Jira is in process at this time. This will be the last message in Jira copied from the Bugzilla bug.

Comment 8 RHEL Program Management 2023-09-20 17:08:00 UTC
This BZ has been automatically migrated to the issues.redhat.com Red Hat Issue Tracker. All future work related to this report will be managed there.

Due to differences in account names between systems, some fields were not replicated.  Be sure to add yourself to Jira issue's "Watchers" field to continue receiving updates and add others to the "Need Info From" field to continue requesting information.

To find the migrated issue, look in the "Links" section for a direct link to the new issue location. The issue key will have an icon of 2 footprints next to it, and begin with "RHEL-" followed by an integer.  You can also find this issue by visiting https://issues.redhat.com/issues/?jql= and searching the "Bugzilla Bug" field for this BZ's number, e.g. a search like:

"Bugzilla Bug" = 1234567

In the event you have trouble locating or viewing this issue, you can file an issue by sending mail to rh-issues. You can also visit https://access.redhat.com/articles/7032570 for general account information.