Bug 1027735 - Error generated in DB logs during client registration.
Summary: Error generated in DB logs during client registration.
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 560
Hardware: Unspecified
OS: Unspecified
low
low
Target Milestone: ---
Assignee: Jan Dobes
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: sat560-triage
TreeView+ depends on / blocked
 
Reported: 2013-11-07 11:00 UTC by Dimitar Yordanov
Modified: 2018-04-09 10:59 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-04-09 10:59:58 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Dimitar Yordanov 2013-11-07 11:00:34 UTC
Description of problem:
client registation to RH Satellite Organization generates Error log in  /var/lib/pgsql/data/pg_log/postgresql-*.log.

Version-Release number of selected component (if applicable):
spacewalk-java-2.0.2-46
Satellite 5.6 EL6

How reproducible:
100%

Steps to Reproduce:
1. Create new organization.
2. Give one (1) "Management (Base)" entitlement to this organization.
3. Log in to the new organization.

4. Create Custom Software channel with arch x86_64 and name "test_chann".
    Channels -> Manage Software channels -> Create new channel

5. Create Activation Key and set "Base Channels:" to "test_chann".
    Systems -> Activation Keys -> Create new Key

6. Register el6 x86-64 cleint to Satellite:
  #rhnreg_ks --activationkey=4-520d191f0048d2a39d1ae77b87989f4b --serverUrl=http://$(hostname)/XMLRPC 

Actual results:
The following error log generated in /var/lib/pgsql/data/pg_log/postgresql-Thu.log.

2013-11-07 05:21:00.260 EST ERROR:  -20263 : (no_subscribe_permissions) - Insufficient permissions for subscription
2013-11-07 05:21:00.260 EST CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception('no_subscribe_permissions')"
	PL/pgSQL function "base_channel_rel_archid" line 64 at PERFORM
	PL/pgSQL function "base_channel_for_release_arch" line 14 at RETURN
2013-11-07 05:21:00.260 EST STATEMENT:  
	        select ca.label arch,
	               c.id,
	               c.parent_channel,
	               c.org_id,
	               c.label,
	               c.name,
	               c.summary,
	               c.description,
	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
	               rhn_channel.available_chan_subscriptions(c.id, E'4') available_subscriptions
	          from rhnChannel c,
	               rhnChannelArch ca
	        where c.channel_arch_id = ca.id
	          and c.id = rhn_channel.base_channel_for_release_arch(
	                E'6Server', E'x86_64', E'4', 10)



Expected results:
No Error logs are generated.

Additional info:

Comment 2 Tomas Lestach 2018-04-09 10:59:58 UTC
We have re-reviewed this bug, as part of an ongoing effort to improve Satellite/Proxy feature and bug updates, review and backlog.

This is a low priority bug and has no currently open customer cases. While this bug may still valid, we do not see it being implemented prior to the EOL of the Satellite 5.x product. As such, this is being CLOSED DEFERRED. 

Closing now to help set customer expectations as early as possible. You are welcome to re-open this bug if needed.


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