Bug 1354623
| Summary: | Missing ueber cert errors after upgrade | |||
|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Justin Sherrill <jsherril> | |
| Component: | Candlepin | Assignee: | Michael Stead <mstead> | |
| Status: | CLOSED ERRATA | QA Contact: | jcallaha | |
| Severity: | high | Docs Contact: | ||
| Priority: | unspecified | |||
| Version: | 6.2.0 | CC: | anerurka, aperotti, bbuckingham, bkearney, brubisch, cduryee, cwelton, egolov, ehelms, jcallaha, mmccune, mstead, vdhande, xdmoon, zhunting | |
| Target Milestone: | Unspecified | Keywords: | Reopened, Triaged | |
| Target Release: | Unused | |||
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | ||||
| Fixed In Version: | candlepin-0.9.54.15-1 | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1370206 1405518 (view as bug list) | Environment: | ||
| Last Closed: | 2017-01-26 15:54:49 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: | 1354633 | |||
| Bug Blocks: | 1353215, 1385841, 1405518 | |||
|
Description
Justin Sherrill
2016-07-11 18:28:06 UTC
Note that this isn't seeking to prevent the original issue, but instead make it easier to resolve or possibly be resolved automatically The fix for BZ #1259248 prevents this BZ from re-occurring, but systems already affected by the bug will require some data cleanup in order to put the system back in the correct state. The following patch will clean up the bad data via a liquibase changeset and will allow certs to be generated again. The fix will be applied once candlepin's DB upgrade script is run. FIXED BY: https://github.com/candlepin/candlepin/pull/1303 MANUALLY APPLYING THE PATCH =========================== If upgrading candlepin is not an option, this patch can be applied manually by running the following DB queries against the candlepin database. POSTGRES: delete from cp_consumer where id IN (select c.id from cp_consumer c left outer join cp_entitlement e on e.consumer_id = c.id where c.name = ueber_cert_consumer' and e.id is null); delete from cp_subscription where id in (select s.id from cp_subscription s inner join cp_product p on s.product_id = p.id left outer join cp_pool pool on pool.productid = p.id where p.name LIKE '%_ueber_product' and pool.id is null); delete from cp_content where id in (select c.id from cp_content c inner join cp_product_content pc on pc.content_id=c.id inner join cp_product p on p.id=pc.product_id left outer join cp_pool pool on pool.productid = p.id where p.name LIKE '%_ueber_product' and pool.id is null); delete from cp_product where id in (select p.id from cp_product p left outer join cp_pool pool on pool.productid = p.id where p.name LIKE '%ueber%' and pool.id is null); What build of Candlepin has the fix to this issue? *** Bug 1367874 has been marked as a duplicate of this bug. *** Verified in Satellite 6.2.2 Async Unable to reproduce this issue with the latest version of satellite. Started with two systems, one using default, the other using custom certs. Upgraded the systems and had no issues retrieving the ueber certificates. Fixed in: candlepin-0.9.54.8+ 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/RHBA-2016:1993 Please open a new bug report for this. (In reply to Bryan Kearney from comment #12) > Please open a new bug report for this. I have opened a new Bugzilla for the same [https://bugzilla.redhat.com/show_bug.cgi?id=1397924] Regards, Ameya Nerurkar Will try this again. Please pull in candlepin-0.9.54.15-1 for this bug. Before capsule syncs kicked off
ueber_subs | ueber_ent_certs | ueber_ents | ueber_pools | ueber_content | ueber_products | ueber_consumer
------------+-----------------+------------+-------------+---------------+----------------+----------------
0 | 0 | 0 | 0 | 0 | 0 | 0
(1 row)
During and after capsule syncs
ueber_subs | ueber_ent_certs | ueber_ents | ueber_pools | ueber_content | ueber_products | ueber_consumer
------------+-----------------+------------+-------------+---------------+----------------+----------------
1 | 1 | 1 | 1 | 1 | 1 | 1
(1 row)
Verified in Satellite 6.2.7 Snap 2, based on the results in #22 This was delivered in satellite 6.2.7 (https://access.redhat.com/errata/RHBA-2017:0197) |