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 |