Bug 1469564

Summary: Error importing manifest.PG::Error: ERROR: null value in column "virt_who" violates not-null constraint
Product: Red Hat Satellite Reporter: Barnaby Court <bcourt>
Component: CandlepinAssignee: Michael Stead <mstead>
Status: CLOSED ERRATA QA Contact: jcallaha
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.3.0CC: bkearney, cwelton, ehelms, fgarciad, jcallaha, katello-qa-list, mmccune, mstead, orabin
Target Milestone: UnspecifiedKeywords: FieldEngineering, Regression, Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: candlepin-2.1.5-1 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1465781
: 1469575 (view as bug list) Environment:
Last Closed: 2018-02-21 16:59:26 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:
Bug Depends On: 1469575    
Bug Blocks:    
Attachments:
Description Flags
bad import
none
good import
none
before.txt
none
after.txt
none
upgrade log none

Comment 7 jcallaha 2017-11-02 16:06:43 UTC 
Verified in Satellite 6.3 Snap 22.

With mstead's help, we created a 6.2.8 satellite and restored the reproducer db on it. 
Then ran the script mentioned in comment 6 and captured the output in before.txt (attached). 
After that, I verified that we were in the correct state by attempting to import a manifest, which failed with the desired error (see attached screenshot).
Next was an upgrade straight from 6.2.8 to the latest 6.3 snap, which went smoothly (see attached upgrade log).
After cleaning up an old default capsule, and incorrect repositories, I was then able to successfully import my manifest (see attached screenshot).
Finally, I re-ran the script from comment #6 and captured the output in after.txt (attached). Everything looks great.
Comment 8 jcallaha 2017-11-02 16:07:33 UTC 
Created attachment 1347061 [details]
bad import
Comment 9 jcallaha 2017-11-02 16:07:50 UTC 
Created attachment 1347062 [details]
good import
Comment 10 jcallaha 2017-11-02 16:08:26 UTC 
Created attachment 1347063 [details]
before.txt
Comment 11 jcallaha 2017-11-02 16:08:45 UTC 
Created attachment 1347064 [details]
after.txt
Comment 12 jcallaha 2017-11-02 16:09:05 UTC 
Created attachment 1347065 [details]
upgrade log
Comment 13 Bryan Kearney 2018-02-21 16:59:26 UTC 
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