Hide Forgot
Observed a installation where Subscriptions that existed in Candlepin's subscription pool data did not show up when querying the /subscriptions index method. There were 5 subscriptions in CP's database yet the index call only returned 2 items. Running foreman-rake katello:reindex resolved the mismatch in data but this is not an acceptable workaround. data: ### HAMMER ### hammer subscription list --organization-id 1 ----------------------------------------|----------|---------|--------------|----------|----------|------------------------------|----|-----------------------------------------|----------|--------- NAME | CONTRACT | ACCOUNT | SUPPORT | QUANTITY | CONSUMED | END DATE | ID | PRODUCT | QUANTITY | ATTACHED ----------------------------------------|----------|---------|--------------|----------|----------|------------------------------|----|-----------------------------------------|----------|--------- Red Hat Satellite Employee Subscription | 10845203 | 1212729 | Self-Support | 100 | 0 | 2022-01-01T04:59:59.000+0000 | 3 | Red Hat Satellite Employee Subscription | 100 | 0 Employee SKU | 10913844 | 1212729 | Self-Support | 20 | 0 | 2022-01-01T04:59:59.000+0000 | 2 | Employee SKU | 20 | 0 ----------------------------------------|----------|---------|--------------|----------|----------|------------------------------|----|-----------------------------------------|----------|--------- [root@cloud-qe-21 /]# ### CP DATABASE ### candlepin=# select * from cp_pool; id | created | updated | accountnumber | activesubscription | contractnumber | e nddate | productid | productname | quantity | restrictedtousername | startdate | subscriptionid | s ubscriptionsubkey | version | owner_id | sourceentitlement_id | ordernumber | derivedproductid | derivedproductname | type ----------------------------------+----------------------------+----------------------------+---------------+--------------------+----------------+----------- -----------------+---------------+-----------------------------------------+----------+----------------------+----------------------------+----------------+-- ------------------+---------+----------------------------------+----------------------+-------------+------------------+--------------------+---------------- 8a90e00c53f7e26e0153f7f3edde020e | 2016-04-08 18:17:51.838-04 | 2016-04-08 18:17:51.838-04 | 1212729 | t | 10845203 | 2021-12-31 23:59:59-05 | SER0232US | Red Hat Satellite Employee Subscription | 100 | | 2015-12-15 00:00:00-05 | | | 0 | 8a90e00c53f7de330153f7deabdc0001 | | 40185580 | | | NORMAL 8a90e00c53f7e26e0153f7f3ef54022e | 2016-04-08 18:17:52.212-04 | 2016-04-08 18:17:52.212-04 | 1212729 | t | 10913844 | 2021-12-31 23:59:59-05 | ES0113909 | Employee SKU | 20 | | 2016-03-24 00:00:00-04 | | | 0 | 8a90e00c53f7de330153f7deabdc0001 | | 40202637 | | | NORMAL 8a90e00c53f7e26e0153f7f3efd402d3 | 2016-04-08 18:17:52.34-04 | 2016-04-08 18:17:52.34-04 | 1212729 | t | 10913844 | 2021-12-31 23:59:59-05 | ES0113909 | Employee SKU | -1 | | 2016-03-24 00:00:00-04 | | | 0 | 8a90e00c53f7de330153f7deabdc0001 | | 40202637 | | | UNMAPPED_GUEST 8a90e00c53f7e26e0153f7f49323038a | 2016-04-08 18:18:34.147-04 | 2016-04-08 18:18:34.147-04 | | t | | 2046-04-01 18:18:33.782-04 | 1460153913746 | Satellite Tools | -1 | | 2016-04-08 18:18:33.782-04 | | | 0 | 8a90e00c53f7de330153f7deabdc0001 | | | | | NORMAL 8a90e00c53f7e26e0153f7f49c5f0390 | 2016-04-08 18:18:36.511-04 | 2016-04-08 18:18:36.511-04 | | t | | 2046-04-01 18:18:36.165-04 | 1460153916131 | Satellite Capsule | -1 | | 2016-04-08 18:18:36.165-04 | | | 0 | 8a90e00c53f7de330153f7deabdc0001 | | | | | NORMAL (5 rows)
Note to QE - This bug is likely a duplicate of https://bugzilla.redhat.com/show_bug.cgi?id=1328409 which is fixed in the latest snap. Can we verify that subscriptions are being created for custom products and mark this as a duplicate if so?
*** This bug has been marked as a duplicate of bug 1328409 ***