Bug 451640 - The demo_log table and demo entitlement related code should go away from Satellite.
The demo_log table and demo entitlement related code should go away from Sate...
Status: CLOSED CURRENTRELEASE
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server (Show other bugs)
510
All Linux
low Severity low
: ---
: ---
Assigned To: Jan Pazdziora
Red Hat Satellite QA List
: Triaged
Depends On:
Blocks: 462714 479461
  Show dependency treegraph
 
Reported: 2008-06-16 08:38 EDT by Jan Pazdziora
Modified: 2010-09-09 16:33 EDT (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2010-09-09 16:33:57 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Jan Pazdziora 2008-06-16 08:38:26 EDT
Description of problem:

I've tried to remove the demo_log table as Cliff suggested that it is not needed
by Satellite. However, subsequent generation of the universe.satellite.sql using

   make -f ../build/Makefile SCHEMA=satellite schema-clean schema-release

(in Spacewalk's git checkout) said that demo_log is needed by rhnDemoOrgs. When
investigating further, I found out that rhnDemoOrgs is used by rhnPaidOrgs,
which is used by package rhn_bel, which is used (at least) by
backend/server/rhnServer/server_lib.py in its throttle function / method; also,
rhnPaidOrgs is used by autoupdate_servers_for_errata which seems to be used by
web/modules/rhn/RHN/Task/ErrataQueue.pm in its schedule_autoupdates function /
method.

We might want to remove demo_log and other stuff which depends on it but I did
not want to destabilize Spacewalk one day before going public.

Version-Release number of selected component (if applicable):

Satellite 5.1.0.

How reproducible:

Deterministic.

Steps to Reproduce:
1. sqlplus rhnsat/rhnsat@rhnsat
2. SQL> desc demo_log
  
Actual results:

SQL> desc demo_log
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ORG_ID                                             NUMBER
 SERVER_ID                                          NUMBER

SQL> 

Expected results:

SQL> desc demo_log
ERROR:
ORA-04043: object demo_log does not exist

and the rest of the Satellite continues to work.

Additional info:
Comment 4 Jan Pazdziora 2010-07-14 02:52:47 EDT
Taking.
Comment 5 Jan Pazdziora 2010-09-09 16:33:57 EDT
The cleanup has been done by Partha in Spacewalk master in commit 10c8a7dbca8a825639979f5dcb701472dd6b1d55.

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