Bug #25366
closedhttp_proxy code does not return db connection to pool quickly enough
Description
It seems a change in Satellite 6.3.3 introduced a strange issue with regards to incomplete/missing repositories from a repository-set. This does not appear to be an issue with the manifest itself.
As an example, in the WebUI this would translate to [Content]->[Red Hat Repositories]->[RPMs]->[Red Hat Enterprise Linux 6 Server (RPMs)]
Once expanded, there are repositories which are missing. To better illustrate this, hammer output shows something like the following:
$ hammer repository-set available-repositories --product-id 148 --id 168
-----------------------------------------|--------|---------|---------------|--------
NAME | ARCH | RELEASE | REGISTRY NAME | ENABLED
-----------------------------------------|--------|---------|---------------|--------
Red Hat Enterprise Linux 6 Server (RPMs) | i386 | 6.1 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | x86_64 | 6.1 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | x86_64 | 6.10 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | i386 | 6.10 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | i386 | 6.4 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | x86_64 | 6.4 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | i386 | 6.5 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | x86_64 | 6.5 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | i386 | 6.6 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | x86_64 | 6.6 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | i386 | 6.7 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | x86_64 | 6.7 | | no
Red Hat Enterprise Linux 6 Server (RPMs) | x86_64 | 6Server | | no
Red Hat Enterprise Linux 6 Server (RPMs) | i386 | 6Server | | no
-----------------------------------------|--------|---------|---------------|--------
Notice the missing releases 6.2, 6.3, 6.8, 6.9...
Subsequent requests at refreshing the available repositories may show that releases that were missing appear, while those that previously appeared disappear and vice versa. In any case, one can imagine that this is a huge inconvenience to say the least.
Version-Release number of selected component (if applicable):
Satellite 6.3.3
How reproducible:
Always.
Steps to Reproduce:
1. Import the attached manifest (or any manifest really)
2. List available repositories to be enabled via WebUI or hammer:
$ hammer repository-set available-repositories --product-id 148 --id 168
3. Observe incomplete/missing repositories
Actual results:
Incomplete/missing repositories.
Expected results:
No incomplete/missing repositories.
Additional info:
Tentative workaround available in the comments.
Updated by The Foreman Bot about 6 years ago
- Status changed from New to Ready For Testing
- Assignee set to Stephen Benjamin
- Pull request https://github.com/theforeman/foreman/pull/6196 added
Updated by Tomer Brisker about 6 years ago
- Subject changed from http_proxy code does not return db connection to pool quickly enough to http_proxy code does not return db connection to pool quickly enough
- Fixed in Releases 1.21.0 added
Updated by Stephen Benjamin about 6 years ago
- Status changed from Ready For Testing to Closed
Applied in changeset ed5adda4e712934c227a4071bb00fce15ae00844.