Bug 2266147
| Summary: | Postgresql logs contain PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "katello_available_module_streams_name_stream_context" | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Odilon Sousa <osousa> |
| Component: | Hosts - Content | Assignee: | Jeremy Lenz <jlenz> |
| Status: | CLOSED ERRATA | QA Contact: | visawant |
| Severity: | unspecified | Docs Contact: | |
| Priority: | high | ||
| Version: | 6.13.2 | CC: | ahumbe, chrobert, iballou, jbhatia, jlenz, jsenkyri, kurathod, rlavi, satellite6-bugs, visawant, zhunting |
| Target Milestone: | 6.14.3 | Keywords: | PrioBumpGSS, Reopened, Triaged |
| Target Release: | Unused | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | rubygem-katello-4.9.0.23-1 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | 2223567 | Environment: | |
| Last Closed: | 2024-03-27 13:19:21 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
|
Comment 1
Bryan Kearney
2024-02-28 20:03:50 UTC
Verified
Tested on 6.14.3 snap 1.0
Steps performed:
1. re-register RHEL8 host
#tail -f /var/log/foreman/production.log
...
2024-03-06T07:04:08 [I|app|222d4012] Started PUT "/rhsm/consumers/abfcbf52-abdc-437c-94fa-4c678fd18a34/profiles" for 10.0.168.31 at 2024-03-06 07:04:08 -0500
2024-03-06T07:04:08 [I|app|222d4012] Processing by Katello::Api::Rhsm::CandlepinDynflowProxyController#upload_profiles as JSON
2024-03-06T07:04:08 [I|app|222d4012] Parameters: {"id"=>"abfcbf52-abdc-437c-94fa-4c678fd18a34"}
2024-03-06T07:04:08 [I|app|222d4012] Completed 200 OK in 128ms (Views: 1.4ms | ActiveRecord: 42.7ms | Allocations: 49922)
2024-03-06T07:04:08 [I|app|f221f864] Started GET "/rhsm/consumers/abfcbf52-abdc-437c-94fa-4c678fd18a34/compliance" for 10.0.168.31 at 2024-03-06 07:04:08 -0500
...
# grep -ri "duplicate key value violates unique constraint \"katello_available_module_streams_name_stream_context\"" /var/lib/pgsql/data/log/
# tail -f /var/lib/pgsql/data/log/postgresql-Wed.log
^C
#
Observation: Don't see any log inside /var/lib/pgsql/data/log/ related to index violation.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (Moderate: Satellite 6.14.3 Async Security Update), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2024:1536 |