Bug 473082 - Satellite Installer Always Thinks Database Schema is Populated
Satellite Installer Always Thinks Database Schema is Populated
Status: CLOSED CURRENTRELEASE
Product: Spacewalk
Classification: Community
Component: Server (Show other bugs)
0.4
All Linux
medium Severity medium
: ---
: ---
Assigned To: Jesus M. Rodriguez
Red Hat Satellite QA List
:
Depends On:
Blocks: space04
  Show dependency treegraph
 
Reported: 2008-11-26 09:51 EST by Devan Goodwin
Modified: 2009-01-22 11:48 EST (History)
2 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2009-01-22 11:48:45 EST
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 Devan Goodwin 2008-11-26 09:51:52 EST
On a clean system installing Satellite 530 always asks:

** Database: Populating database.

The Database has schema.  Would you like to clear the database [Y]? 

The database does not yet have any schema.

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

Discovered in spacewalk-setup-0.4.4 on Satellite 530, but problem may exist in spacewalk as well.


Steps to Reproduce:
1. Use install.pl from Satellite.

Can also run /usr/share/spacewalk/setup/oracle/remove-db.sh and re-install to repeat the error.

Issue results from changes in git commit 56066cb7 to the file satellite/install/Spacewalk-Setup/lib/Spacewalk/Setup.pm. The query was changed to:

+ WHERE object_name <> 'PLAN_TABLE'
+   and object_name not like 'BIN$%'
+   and rownum = 1

Which is now always triggering.
Comment 2 Michael Mráka 2008-11-27 08:59:40 EST
Plan table contains CLOB which was triggering non-empty schema.

Fixed in git repo
Created commit ee6051d: 473082 - fixed $% expansion
 1 files changed, 1 insertions(+), 1 deletions(-)
Created commit a09f65b: 473082 - PLAN_TABLE contains CLOB so ignore also LOBs here
 1 files changed, 1 insertions(+), 0 deletions(-)

Package spacewalk-setup-0.4.5-1.
Comment 3 Brandon Perkins 2008-12-04 11:22:21 EST
Moving from Satellite to Spacewalk.

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