2203499 – Postgresql 15 module missing default on "server" profile from CentOS Stream 9

This bug has been migrated to another issue tracking site. It has been closed here and may no longer be being monitored.

If you would like to get updates for this issue, or to participate in it, you may do so at Red Hat Issue Tracker .

RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 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 "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". 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 "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-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 2203499 - Postgresql 15 module missing default on "server" profile from CentOS Stream 9

Summary: Postgresql 15 module missing default on "server" profile from CentOS Stream 9

Keywords:
Status:	CLOSED MIGRATED
Alias:	None
Product:	Red Hat Enterprise Linux 9
Classification:	Red Hat
Component:	postgresql-15-module
Sub Component:
Version:	9.2
Hardware:	Unspecified
OS:	Unspecified
Priority:	unspecified
Severity:	unspecified
Target Milestone:	rc
Target Release:	---
Assignee:	Filip Januš
QA Contact:	RHEL CS Apps Subsystem QE
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+	depends on / blocked

Reported:	2023-05-13 08:20 UTC by Louis Abel
Modified:	2023-09-20 17:08 UTC (History)
CC List:	1 user (show)
Fixed In Version:
Doc Type:	If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed:	2023-09-20 17:08:00 UTC
Type:	Bug
Target Upstream Version:
Embargoed:
Dependent Products:
Flags:	pm-rhel: mirror+

Attachments	(Terms of Use)
CentOS Stream 9 Module Installation (32.08 KB, image/png) 2023-05-13 08:20 UTC, Louis Abel	no flags	Details
RHEL 9.2 Module List (58.89 KB, image/png) 2023-05-13 08:21 UTC, Louis Abel	no flags	Details
RHEL 9.2 Module Install (24.91 KB, image/png) 2023-05-13 08:21 UTC, Louis Abel	no flags	Details
View All

Links
System	ID	Private	Priority	Status	Summary	Last Updated
Red Hat Issue Tracker	RHEL-5564	0	None	Migrated	None	2023-09-20 17:07:56 UTC
Red Hat Issue Tracker	RHELPLAN-157130	0	None	None	None	2023-05-13 08:21:46 UTC

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.

Note You need to log in before you can comment on or make changes to this bug.