Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 603258

Summary:	rhnServerNeededCache & server applicable errata/pkgs do not update when using the API (mergeErrata / mergePackage) to merge channel data
Product:	Red Hat Satellite 5	Reporter:	Xixi <xdmoon>
Component:	Server	Assignee:	Jan Pazdziora (Red Hat) <jpazdziora>
Status:	CLOSED ERRATA	QA Contact:	Šimon Lukašík <slukasik>
Severity:	high	Docs Contact:
Priority:	urgent
Version:	530	CC:	slukasik, tao, xdmoon
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-11-18 08:27:35 UTC	Type:	---
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:
Bug Blocks:	518253

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