Bug 603258 - rhnServerNeededCache & server applicable errata/pkgs do not update when using the API (mergeErrata / mergePackage) to merge channel data
Summary: rhnServerNeededCache & server applicable errata/pkgs do not update when using...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 530
Hardware: All
OS: Linux
urgent
high
Target Milestone: ---
Assignee: Jan Pazdziora
QA Contact: Šimon Lukašík
URL:
Whiteboard:
Depends On:
Blocks: sat531-triage
TreeView+ depends on / blocked
 
Reported: 2010-06-12 03:56 UTC by Xixi
Modified: 2018-10-27 12:01 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-11-18 08:27:35 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2010:0897 0 normal SHIPPED_LIVE Red Hat Network Satellite bug fix update 2010-11-18 08:27:31 UTC

Description Xixi 2010-06-12 03:56:16 UTC
Description of problem:
Customer noticed some issues with mergeErrata/mergePackage API calls.  One of them being rhnserverneededcache doesn't update.

Version-Release number of selected component (if applicable):
Red Hat Network (RHN) Satellite 5.3.0

How reproducible:
Always.

Steps to Reproduce:
1. Have an original channel and a cloned channel and a server subscribed to latter.
2. Query via sqlplus and note down # of rows: select count (*) from rhnServerNeededCache;
3. mergeErrata and mergePackages to copy errata & packages from original to cloned channel.
4. step 2 again.

Actual results:
rhnServerNeededCache has same # of rows before and after even though more errata/pkgs will now apply to server, if you look via UI server has same # of applicable errata & pkgs before & after.

Expected results:
rhnServerNeededCache is updated and server status reflects change.

Additional info:
Engineering is aware -
10:17 <jsherrill> looks like a bug
10:19 <jsherrill> i'm guessing the api might be missing a 'trigger' to repopulate that cache
10:20 <jsherrill> should be simple to fix

Comment 1 Xixi 2010-06-12 03:58:24 UTC
Other mergeErrata / mergePackages bugs: bug 568962 and bug 591291

Comment 3 Justin Sherrill 2010-06-30 21:09:29 UTC
Quick question.  Has this customer increased their timeout from apache -> tomcat?  While testing a fix I'm hitting the timeout.  I don't think we can fix that issue in this bug, as it requires much greater changes.  But if this customer is hitting that issue as well, we may be able to.

Thanks,

-Justin Sherrill

Comment 7 Šimon Lukašík 2010-09-08 14:37:34 UTC
Changing to VERIFIED:

Testing procedure:
Automated reproducer from comment 0. Only the mergePackages scenario is tested as the mergeErrata should not affect packages.

Please note, that rhnServerNeededCache is not updated immediately. It took approximately 5 minutes on my machines to update rhnServerNeededCache after the mergePackages api call.

Verified against:
spacewalk-java*-0.5.44-9

Comment 9 errata-xmlrpc 2010-11-18 08:27:35 UTC
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.

http://rhn.redhat.com/errata/RHBA-2010-0897.html


Note You need to log in before you can comment on or make changes to this bug.