Bug 1483283
| Summary: | On uploading a manifest: Failed Candlepin Event: PG::Error: ERROR: null value in column "virt_who" violates not-null constraint | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Sachin Ghai <sghai> | ||||||
| Component: | Subscription Management | Assignee: | Justin Sherrill <jsherril> | ||||||
| Status: | CLOSED ERRATA | QA Contact: | Brad Buckingham <bbuckingham> | ||||||
| Severity: | medium | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 6.3.0 | CC: | bbuckingham, ehelms, smane | ||||||
| Target Milestone: | Unspecified | Keywords: | Triaged | ||||||
| Target Release: | Unused | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | rubygem-katello-3.4.5 | Doc Type: | If docs needed, set a value | ||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2018-02-21 16:51:07 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: |
|
||||||||
Created attachment 1315880 [details]
foreman-debug
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20395 has been resolved. Verified with Satellite 6.3 SNAP 14: satellite-6.3.0-17.0.beta.el7sat.noarch, tfm-rubygem-katello-3.4.5-1.el7sat.noarch - performed new Satellite install - imported manifest - no errors - refreshed manifest - no errors - enabled/synced repos - no errors 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, 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-2018:0336
|
Created attachment 1315879 [details] complete traceback Description of problem: On uploading a manifest on fresh sat6.3 snap12 install, following error raised: 2017-08-19 23:57:19 [foreman-tasks/action] [E] Failed Candlepin Event: PG::Error: ERROR: null value in column "virt_who" violates not-null constraint | DETAIL: Failing row contains (6, 8a93a29d5dfdb710015dfdc99e90042f, 2017-08-20 03:57:19.154421, 2017-08-20 03:57:19.224847, null, 477931, 11045754, null, 50, 2016-08-04 04:00:00, NORMAL, 2022-01-01 04:59:59, null, t, 0, f, f, null). | : UPDATE "katello_pools" SET "multi_entitlement" = $1, "account_number" = $2, "contract_number" = $3, "quantity" = $4, "start_date" = $5, "end_date" = $6, "consumed" = $7, "pool_type" = $8, "virt_who" = $9, "updated_at" = $10 WHERE "katello_pools"."id" = $11 Version-Release number of selected component (if applicable): sat6.3 snap12 How reproducible: Steps to Reproduce: 1. upload a manifest 2. monitor /var/log/foreman/production.log 3. Actual results: [E] Failed Candlepin Event: PG::Error: ERROR: null value in column "virt_who" violates not-null constraint | DETAIL: Failing row contains (2, 8a93a29d5dfdb710015dfdc99cdd0421, 2017-08-20 03:57:17.538129, 2017-08-20 03:57:17.683711, null, 477931, 11045754, null, 50, 2016-08-04 04:00:00, NORMAL, 2022-01-01 04:59:59, null, null, 0, f, f, null). | : UPDATE "katello_pools" SET "account_number" = $1, "contract_number" = $2, "quantity" = $3, "start_date" = $4, "end_date" = $5, "consumed" = $6, "pool_type" = $7, "virt_who" = $8, "updated_at" = $9 WHERE "katello_pools"."id" = $10 Expected results: no error should appear Additional info: