Bug 479950 - spacewalk 0.4: new and upgraded schemas do not match
spacewalk 0.4: new and upgraded schemas do not match
Status: CLOSED CURRENTRELEASE
Product: Spacewalk
Classification: Community
Component: Server (Show other bugs)
0.4
All Linux
low Severity medium
: ---
: ---
Assigned To: Milan Zázrivec
Red Hat Satellite QA List
:
Depends On:
Blocks: space04
  Show dependency treegraph
 
Reported: 2009-01-14 04:21 EST by Milan Zázrivec
Modified: 2009-01-22 11:31 EST (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2009-01-22 11:31:42 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 Milan Zázrivec 2009-01-14 04:21:49 EST
Description of problem:
* New Spacewalk 0.4 installation (spacewalk-schema-0.4.15-1)
* Spacewalk 0.3 upgraded to Spacewalk 0.4

Comparing these two schemas I get following differences:

* rhnKSData table, new installation puts "not null" restriction on ks_type
column, upgraded schema does not.

* rhnPackage table, new installation says number(1) for column compat,
upgraded schema says number(38).
Comment 1 Milan Zázrivec 2009-01-14 08:05:50 EST
Fixes in:
56960dc72bb4130eeb1b40023a031d817cca5962
45e87b034e0f10fb26dd1d3983ca0fe76e7d38b4

New schema version: spacewalk-schema-0.4.16-1
Comment 2 Miroslav Suchý 2009-01-15 09:20:27 EST
Upgraded spacewalk:
SQL> desc rhnKSData
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER
 ORG_ID                                    NOT NULL NUMBER
 IS_ORG_DEFAULT                            NOT NULL CHAR(1)
 LABEL                                     NOT NULL VARCHAR2(64)
 COMMENTS                                           VARCHAR2(4000)
 ACTIVE                                    NOT NULL CHAR(1)
 POSTLOG                                   NOT NULL CHAR(1)
 PRE                                                BLOB
 POST                                               BLOB
 NOCHROOT_POST                                      BLOB
 STATIC_DEVICE                                      VARCHAR2(32)
 KERNEL_PARAMS                                      VARCHAR2(128)
 CREATED                                   NOT NULL DATE
 MODIFIED                                  NOT NULL DATE
 PRELOG                                    NOT NULL CHAR(1)
 KSCFG                                     NOT NULL CHAR(1)
 VERBOSEUP2DATE                            NOT NULL CHAR(1)
 NONCHROOTPOST                             NOT NULL CHAR(1)
 COBBLER_ID                                         VARCHAR2(64)
 KS_TYPE                                   NOT NULL VARCHAR2(8)
SQL> desc rhnPackage
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER
 ORG_ID                                             NUMBER
 NAME_ID                                   NOT NULL NUMBER
 EVR_ID                                    NOT NULL NUMBER
 PACKAGE_ARCH_ID                           NOT NULL NUMBER
 PACKAGE_GROUP                                      NUMBER
 RPM_VERSION                                        VARCHAR2(16)
 DESCRIPTION                                        VARCHAR2(4000)
 SUMMARY                                            VARCHAR2(4000)
 PACKAGE_SIZE                              NOT NULL NUMBER
 PAYLOAD_SIZE                                       NUMBER
 BUILD_HOST                                         VARCHAR2(256)
 BUILD_TIME                                         DATE
 SOURCE_RPM_ID                                      NUMBER
 MD5SUM                                    NOT NULL VARCHAR2(64)
 VENDOR                                    NOT NULL VARCHAR2(64)
 PAYLOAD_FORMAT                                     VARCHAR2(32)
 COMPAT                                             NUMBER(1)
 PATH                                               VARCHAR2(1000)
 HEADER_SIG                                         VARCHAR2(64)
 COPYRIGHT                                          VARCHAR2(64)
 COOKIE                                             VARCHAR2(128)
 LAST_MODIFIED                             NOT NULL DATE
 CREATED                                   NOT NULL DATE
 MODIFIED                                  NOT NULL DATE
 HEADER_START                              NOT NULL NUMBER
 HEADER_END                                NOT NULL NUMBER



Brand new spacewalk:
SQL> desc rhnKSData
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER
 KS_TYPE                                   NOT NULL VARCHAR2(8)
 ORG_ID                                    NOT NULL NUMBER
 IS_ORG_DEFAULT                            NOT NULL CHAR(1)
 LABEL                                     NOT NULL VARCHAR2(64)
 COMMENTS                                           VARCHAR2(4000)
 ACTIVE                                    NOT NULL CHAR(1)
 POSTLOG                                   NOT NULL CHAR(1)
 PRELOG                                    NOT NULL CHAR(1)
 KSCFG                                     NOT NULL CHAR(1)
 COBBLER_ID                                         VARCHAR2(64)
 PRE                                                BLOB
 POST                                               BLOB
 NOCHROOT_POST                                      BLOB
 STATIC_DEVICE                                      VARCHAR2(32)
 KERNEL_PARAMS                                      VARCHAR2(128)
 VERBOSEUP2DATE                            NOT NULL CHAR(1)
 NONCHROOTPOST                             NOT NULL CHAR(1)
 CREATED                                   NOT NULL DATE
 MODIFIED                                  NOT NULL DATE

SQL> desc rhnPackage
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER
 ORG_ID                                             NUMBER
 NAME_ID                                   NOT NULL NUMBER
 EVR_ID                                    NOT NULL NUMBER
 PACKAGE_ARCH_ID                           NOT NULL NUMBER
 PACKAGE_GROUP                                      NUMBER
 RPM_VERSION                                        VARCHAR2(16)
 DESCRIPTION                                        VARCHAR2(4000)
 SUMMARY                                            VARCHAR2(4000)
 PACKAGE_SIZE                              NOT NULL NUMBER
 PAYLOAD_SIZE                                       NUMBER
 BUILD_HOST                                         VARCHAR2(256)
 BUILD_TIME                                         DATE
 SOURCE_RPM_ID                                      NUMBER
 MD5SUM                                    NOT NULL VARCHAR2(64)
 VENDOR                                    NOT NULL VARCHAR2(64)
 PAYLOAD_FORMAT                                     VARCHAR2(32)
 COMPAT                                             NUMBER(1)
 PATH                                               VARCHAR2(1000)
 HEADER_SIG                                         VARCHAR2(64)
 COPYRIGHT                                          VARCHAR2(64)
 COOKIE                                             VARCHAR2(128)
 LAST_MODIFIED                             NOT NULL DATE
 CREATED                                   NOT NULL DATE
 MODIFIED                                  NOT NULL DATE
 HEADER_START                              NOT NULL NUMBER
 HEADER_END                                NOT NULL NUMBER

VERIFIED

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