Bug 1402931 - [5.6] lock_counts fix has several issues
Summary: [5.6] lock_counts fix has several issues
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 560
Hardware: Unspecified
OS: Unspecified
urgent
high
Target Milestone: ---
Assignee: Grant Gainey
QA Contact: Radovan Drazny
URL:
Whiteboard:
: 1394930 (view as bug list)
Depends On:
Blocks: 465198 1340444 1402933 1402935
TreeView+ depends on / blocked
 
Reported: 2016-12-08 16:31 UTC by Grant Gainey
Modified: 2021-03-11 14:51 UTC (History)
3 users (show)

Fixed In Version: satellite-schema-5.6.0.34-1.el6sat
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1402933 1402935 (view as bug list)
Environment:
Last Closed: 2017-02-22 13:38:47 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2017:0292 0 normal SHIPPED_LIVE Satellite 5.6 bug fix update 2017-02-22 18:37:33 UTC

Description Grant Gainey 2016-12-08 16:31:52 UTC 
Description of problem:

The Oracle version of lock_counts.pkb fails to lock the server-row 'for update', which kind of defeats the whole purpose iof the proc.  Fix this.
Comment 3 Grant Gainey 2016-12-16 21:04:33 UTC 
There is a further hole in the erratum that released lock_counts - specifically, the unsubscribe_server path WAS NOT COVERED, in either postgresql or oracle.

This is fixed in rhn_channel.pkb in both dialects.
Comment 5 Radovan Drazny 2017-02-15 08:54:38 UTC 
This bug is in fact part of BZ1385099. Check the comments for verification info.
Comment 6 Grant Gainey 2017-02-17 18:43:53 UTC 
*** Bug 1394930 has been marked as a duplicate of this bug. ***
Comment 8 errata-xmlrpc 2017-02-22 13:38:47 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://rhn.redhat.com/errata/RHBA-2017-0292.html
Note You need to log in before you can comment on or make changes to this bug.